CSV and Parquet files in GCS storage are able to be used as an external data source.
GCS 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 gcs OPTIONS ( service_account_key = '<service-account-key>', bucket = '<bucket>', location = '<location>' );
S3 external table options
| ||A Service Account with access to the bucket|
| ||The name of the bucket|
| ||The path to the file, relative to the bucket root|