COPY table_name FROM ‘cloud_storage_file_path’ WITH (option);
table_name
: existing table where the data will be importedcloud_storage_file_path
: complete path to the parquet file stored in cloud storage, used for importing dataoption
: to be specified:
COPY FROM
command with object storage credentials. This command allows you to transfer data from cloud storage services like AWS S3, Google Cloud Storage or Azure Blob Storage directly into your Oxla instance.
object storage
: AWS_CRED
,AZURE_CRED
or GCS_CRED
(depending on your provider)object_storage_credentials
: for accessing your cloud storageaws_region
: AWS region associated with the storage servicekey_id
: key identifier for authenticationaccess_key
: access key for authenticationendpoint_url
: URL endpoint for the storage service<path_to_credentials>
: path to JSON credentials file<json_credentials_string>
: contents of the GCS’s credentials filetenant_id
: tenant identifier representing your organization’s identity in Azureclient_id
: client identifier used for authenticationclient_secret
: secret identifier acting as a password for authentication.