aws_access_key_id
: The AWS access key that identifies the user or IAM role.aws_secret_access_key
: The AWS secret access key that identifies the user or IAM role.aws_session_token
: The AWS session token that identifies the user or IAM role. This becomes necessary when using temporary security credentials.bucket
: The name of the Amazon S3 bucket. If not provided, all available buckets can be queried, however, this can affect performance, especially when listing all of the available objects.CREATE DATABASE
command, querying will be limited to that bucket and the bucket name can be ommitted from the object key as shown in the example above. However, if the bucket name is not provided, the object key must include the bucket name, such as s3_datasource.
my-bucket/my-folder/my-file.csv`.Wrap the object key in backticks (`) to avoid any issues parsing the SQL statements provided. This is especially important when the object key contains spaces, special characters or prefixes, such as my-folder/my-file.csv
.At the moment, the supported file formats are CSV, TSV, JSON, and Parquet.s3_datasource
as the datasource name, which is defined in the CREATE DATABASE
command.files
table can be used to list all objects available in the specified bucket or all buckets if the bucket name is not provided:
content
column. This column is empty by default to avoid unnecessary data transfer:
Database Connection Error
SQL statement cannot be parsed by mindsdb_sql