Azure Blob Storage

GlareDB can use CSV, ndjson, or Parquet files in Azure Blob Storage as external data sources.

Azure File as an External Table

Add CSV, ndjson, or Parquet files as an external table with the CREATE EXTERNAL TABLE command.

table-name becomes the name of the database inside GlareDB. table-name can be qualified with a schema name.

 FROM azure
  account_name = '<azure-account>',
  access_key = '<access-key>'
  location = 'azure://<storage-container>/<object-path>'

Table options

Field Description
account_name Name of the Azure account containing the storage container
access_key Access key for the storage container
storage-container Storage container containing the object
object-path Path to the object inside the storage container