CSV and Parquet files in S3 storage are able to be used as an external data source.
S3 file as an external table
CSV and Parquet files can be added as an external table through the CREATE EXTERNAL TABLE command.
table-namewill be the name of the database inside GlareDB.
table-namemay optionally be qualified with a schema name.
CREATE EXTERNAL TABLE <table-name> FROM s3 OPTIONS ( access_key_id = '<access-key-id>', secret_access_key = '<secret-access-key>', region = '<region>', bucket = '<bucket>', location = '<location>' );
S3 external table options
| ||AWS access key id (associated to |
| ||AWS access key secret (associated to |
| ||AWS Region of your bucket|
| ||The name of the bucket|
| ||The path to the file, relative to the bucket root|