COPY FROM
Importing Data from a ORC file
Overview
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.
Syntax
The syntax for this function is as follows:
COPY table_name FROM ‘cloud_storage_file_path’ WITH (option);
Parameters
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:- Endpoint: provide object-based storage credentials
- FORMAT: format name (e.g. ORC)
Examples
Importing Data from Cloud Storage
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
orGCS_CRED
(depending on your provider)object_storage_credentials
: for accessing your cloud storage
You need to provide Provider-Specific credentials to authenticate access to your files. Use the following authentication parameters to access your cloud storage:
AWS S3 Bucket
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
Google Cloud Storage
<path_to_credentials>
: path to JSON credentials file<json_credentials_string>
: contents of the GCS’s credentials file
For Google Cloud Storage, it’s recommended to use HMAC keys for authentication. You can find more details about that on the HMAC keys - Cloud Storage page.
Azure Blob Storage
tenant_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.