AWS_CRED
with AZURE_CRED
or GCS_CRED
when copying from the Azure Blob Storage or Google Cloud Storage.table_name
: table that will receive data from the filefile_path
: link to the file location accessible from the serverAWS_CRED
:
aws_region
: AWS region associated with the storage service (e.g. ‘region1’)key_id
: key identifier for authenticationaccess_key
: access key for authenticationendpoint_url
: URL endpoint for the storage serviceGCS_CRED
:
<path_to_credentials>
: path to JSON credentials file<json_credentials_string>
: contents of the GCS’s credentials fileAZURE_CRED
:
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.students_file
and the endpoint is s3.us-east-2.amazonaws.com
.
students_file
is copied into the students
table
COPY FROM
statement to import data, but this time, the data is stored on Google Cloud Storage;
credentials.json
file, you can also pass its contents as a string in the following way:
AWS_CRED
like below, with the following endpoint https://storage.googleapis.com
.
project_file
is copied into the project
table.
your_blob
is copied into the taxi_data
.