Skip to main content Link Menu Expand (external link) Document Search


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-name will be the name of the database inside GlareDB. table-name may optionally be qualified with a schema name.

 FROM gcs
  service_account_key = '<service-account-key>',
  bucket = '<bucket>',
  location = '<location>'

S3 external table options

Field Description
service_account_key A Service Account with access to the bucket
bucket The name of the bucket
location The path to the file, relative to the bucket root