Version 4.43 or later needs to be installed to add the server automatically
Tools
| Name | Description |
|---|---|
import_parquet_to_table | Import data from a Parquet file into an existing S3 table. This tool reads data from a Parquet file stored in S3 and imports it into an existing S3 table. The table must already exist. The Parquet file schema must be compatible with the table's schema. The tool will validate the schema before attempting to import the data. If preserve_case is True, the column names will not be converted to snake_case. Otherwise, the column names will be converted to snake_case. Returns error dictionary with status and error message if: - URL is not a valid S3 URL - File is not a Parquet file - File cannot be accessed - Table does not exist - Parquet schema is incompatible with existing table schema - Any other error occurs Returns success dictionary with: - status: 'success' - message: Success message with row count - rows_processed: Number of rows imported - file_processed: Name of the processed file Example input values: warehouse: 'arn:aws:s3tables:<Region>:<accountID>:bucket/<bucketname>' region: 'us-west-2' namespace: 'retail_data' table_name: 'customers' s3_url: 's3://bucket-name/path/to/file.parquet' uri: 'https://s3tables.us-west-2.amazonaws.com/iceberg' catalog_name: 's3tablescatalog' rest_signing_name: 's3tables' rest_sigv4_enabled: 'true' preserve_case: False Permissions: You must have: - s3:GetObject permission for the Parquet file - s3tables:GetTable and s3tables:GetTables permissions to access table information - s3tables:PutTableData permission to write to the table |