Importing data from an ORC file into Oxla can be accomplished using various commands and tools. This guide explains how to copy data from an ORC file through accessing cloud storage to copy tables, allowing you to migrate data from remote sources.
The syntax for this function is as follows:
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 ORC file stored in cloud storage, used for importing dataoption
: one to be specified:
To import data from an object storage into a table in Oxla, you can use the 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 storageYou need to provide Provider-Specific credentials to authenticate access to your files. Use the following authentication parameters to access your cloud storage:
aws_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.