The variables in the examples must be replaced with values that allow access to your external object storage.
authorization_object
Replace authorization_object with the name of the authorization object. You may use any name for the authorization object that conforms to object naming rules, see SQL Fundamentals.
table_name
Replace table_name with a name for your foreign table that conforms to object naming rules, see SQL Fundamentals.
YOUR-OBJECT-STORE-URI
When you run the examples, replace YOUR-OBJECT-STORE-URI with the location of your external object storage.
If you run the examples that use the Teradata-supplied public buckets or containers, the following table lists the paths to use to access the sample USGS river flow data. Replace YOUR-OBJECT-STORE-URI in the examples to read the data from the public buckets and containers:
| Platform | Format | Public Storage Location |
|---|---|---|
| Amazon S3 | CSV | DNS style: /s3/td-usgs-public.s3.amazonaws.com/CSVDATA/ Path style: /S3/s3.amazonaws.com/td-usgs-public/CSVDATA Simple style: s3://td-usgs-public/CSVDATA/ |
| JSON | DNS style: /s3/td-usgs-public.s3.amazonaws.com/JSONDATA/ Path style: /S3/s3.amazonaws.com/td-usgs-public/JSONDATA Simple style: s3://td-usgs-public/JSONDATA/ |
|
| Parquet | DNS style: /s3/td-usgs-public.s3.amazonaws.com/PARQUETDATA/ Path style: /S3/s3.amazonaws.com/td-usgs-public/PARQUETDATA Simple style: s3://td-usgs-public/PARQUETDATA/ |
|
| Azure Blob Storage | CSV | Original style: /az/akiaxox5jikeotfww4ul.blob.core.windows.net/td-usgs-public/CSVDATA/ Simple style: az://akiaxox5jikeotfww4ul.blob.core.windows.net/td-usgs-public/CSVDATA/ |
| JSON | Original style: /az/akiaxox5jikeotfww4ul.blob.core.windows.net/td-usgs-public/JSONDATA/ Simple style: az://akiaxox5jikeotfww4ul.blob.core.windows.net/td-usgs-public/JSONDATA/ |
|
| Parquet | Original style: /az/akiaxox5jikeotfww4ul.blob.core.windows.net/td-usgs-public/PARQUETDATA/ Simple style: az://akiaxox5jikeotfww4ul.blob.core.windows.net/td-usgs-public/PARQUETDATA/ |
|
| Google Cloud Storage | CSV | Original style: /gs/storage.googleapis.com/td-usgs-public/CSVDATA/ Simple style: gs://td-usgs-public/CSVDATA/ |
| JSON | Original style: /gs/storage.googleapis.com/td-usgs-public/JSONDATA/ Simple style: gs://td-usgs-public/JSONDATA/ |
|
| Parquet | Original style: /gs/storage.googleapis.com/td-usgs-public/PARQUETDATA/ Simple style: gs://td-usgs-public/PARQUETDATA/ |
If you downloaded the USGS river flow data to your own external object storage (see Setting Up External Object Storage for River Flow Data), replace YOUR-STORAGE-ACCOUNT with the path to your data, which is unique, but similar to the following:
| Object Storage | Format | External Object Storage Location Values |
|---|---|---|
| Amazon S3 The examples in this document use "td-usgs-public" for the bucket name. Your bucket name must be unique.
|
CSV | /s3/YOUR-BUCKET.s3.amazonaws.com/CSVDATA/ Example: /s3/td-usgs-public.s3.amazonaws.com/CSVDATA/ |
| JSON | /S3/YOUR-BUCKET.s3.amazonaws.com/JSONDATA/ Example: /s3/td-usgs-public.s3.amazonaws.com/JSONDATA/ |
|
| Parquet | /S3/YOUR-BUCKET.s3.amazonaws.com/PARQUETDATA/ Example: /s3/td-usgs-public.s3.amazonaws.com/td-usgs/PARQUETDATA/ |
|
| Azure Blob storage Replace YOUR-STORAGE-ACCOUNT with the value for your
account.
|
CSV | /az/YOUR-STORAGE-ACCOUNT.blob.core.windows.net/YOUR-CONTAINER/CSVDATA/ Example: /az/akiaxox5jikeotfww4ul.blob.core.windows.net/td-usgs-public/CSVDATA/ |
| JSON | /az/YOUR-STORAGE-ACCOUNT.blob.core.windows.net/YOUR-CONTAINER/JSONDATA/ Example: /az/akiaxox5jikeotfww4ul.blob.core.windows.net/td-usgs-public/JSONDATA/ |
|
| Parquet | /az/YOUR-STORAGE-ACCOUNT.blob.core.windows.net/YOUR-CONTAINER/PARQUETDATA/ Example: /az/akiaxox5jikeotfww4ul.blob.core.windows.net/td-usgs-public/PARQUETDATA/ |
|
| Google Cloud Storage | CSV | /gs/storage.googleapis.com/YOUR-BUCKET/CSVDATA/ Example: /gs/storage.googleapis.com/td-usgs-public/CSVDATA/ |
| JSON | /gs/storage.googleapis.com/YOUR-BUCKET/JSONDATA/ Example: /gs/storage.googleapis.com/td-usgs-public/JSONDATA/ |
|
| Parquet | /gs/storage.googleapis.com/YOUR-BUCKET/PARQUETDATA/ Example: /gs/storage.googleapis.com/td-usgs-public/PARQUETDATA/ |
- Amazon S3 bucket location must begin with /S3 or /s3
- Google Cloud Storage bucket location must begin with /GS or /gs
- Azure Blob Storage location (including Azure Data Lake Storage Gen2 in Blob Interop Mode) must begin with /AZ or /az
YOUR-ACCESS-KEY-ID and YOUR-SECRET-ACCESS-KEY
Your external object storage must be configured to allow Analytics Database to access it.
The USER and PASSWORD keywords (used in the CREATE AUTHORIZATION command) and ACCESS_ID and ACCESS_KEY (used by READ_NOS and WRITE_NOS) correspond to the values shown in the following table:
| Keyword | Access Variables Values |
|---|---|
| USER or ACCESS_ID | Replace YOUR-ACCESS-KEY-ID with the access ID to your external object storage. |
| PASSWORD or ACCESS_KEY | Replace YOUR-SECRET-ACCESS-KEY with the secret key value to your external object storage. |
Public buckets or containers in external object storage do not require credentials for access. To access a public bucket or container, put an empty string between the straight quotes for USER and PASSWORD.