Import data from a CSV file into an S3 table. This tool reads data from a CSV file stored in S3 and imports it into an S3 table. If the table doesn't exist, it will be created with a schema inferred from the CSV file. If the table exists, the CSV file schema must be compatible with the table's s...
Accepts URL/endpoint input (uri); High parameter count (10 properties)
Part of the AWS S3 Tables MCP Server MCP server. Enforce policies on this tool with Intercept, the open-source MCP proxy.
AI agents use import_csv_to_table to create or modify resources in AWS S3 Tables MCP Server. Write operations carry medium risk because an autonomous agent could trigger bulk unintended modifications. Rate limits prevent a single agent session from making hundreds of changes in rapid succession. Argument validation ensures the agent passes expected values.
Without a policy, an AI agent could call import_csv_to_table repeatedly, creating or modifying resources faster than any human could review. Intercept's rate limiting ensures write operations happen at a controlled pace, and argument validation catches malformed or unexpected inputs before they reach AWS S3 Tables MCP Server.
Write tools can modify data. A rate limit prevents runaway bulk operations from AI agents.
tools:
import_csv_to_table:
rules:
- action: allow
rate_limit:
max: 30
window: 60See the full AWS S3 Tables MCP Server policy for all 16 tools.
Agents calling write-class tools like import_csv_to_table have been implicated in these attack patterns. Read the full case and prevention policy for each:
Other tools in the Write risk category across the catalogue. The same policy patterns (rate-limit, validate) apply to each.
Import data from a CSV file into an S3 table. This tool reads data from a CSV file stored in S3 and imports it into an S3 table. If the table doesn't exist, it will be created with a schema inferred from the CSV file. If the table exists, the CSV 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 CSV file - File cannot be accessed - Table does not exist - CSV headers don't match table schema - Any other error occurs 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.csv' 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 CSV file - s3tables:GetTable and s3tables:GetTables permissions to access table information - s3tables:PutTableData permission to write to the table. It is categorised as a Write tool in the AWS S3 Tables MCP Server MCP Server, which means it can create or modify data. Consider rate limits to prevent runaway writes.
Add a rule in your Intercept YAML policy under the tools section for import_csv_to_table. You can allow, deny, rate-limit, or validate arguments. Then run Intercept as a proxy in front of the AWS S3 Tables MCP Server MCP server.
import_csv_to_table is a Write tool with medium risk. Write tools should be rate-limited to prevent accidental bulk modifications.
Yes. Add a rate_limit block to the import_csv_to_table rule in your Intercept policy. For example, setting max: 10 and window: 60 limits the tool to 10 calls per minute. Rate limits are tracked per agent session and reset automatically.
Set action: deny in the Intercept policy for import_csv_to_table. The AI agent will receive a policy violation error and cannot call the tool. You can also include a reason field to explain why the tool is blocked.
import_csv_to_table is provided by the AWS S3 Tables MCP Server MCP server (awslabs.s3-tables-mcp-server). Intercept sits as a proxy in front of this server to enforce policies before tool calls reach the server.
Deterministic policy on every MCP tool call. Per-identity grants. Full audit log.