Variable Substitutions for Examples - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Native Object Store Getting Started Guide
Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Published
September 2020
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
jjn1567647976698.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1214
lifecycle
previous
Product Category
Software
Teradata Vantage

The variables in the examples must be replaced with values that allow access to your external object store.

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 Teradata Vantage™ - SQL Fundamentals, B035-1141.

For example:
  • CREATE AUTHORIZATION InvAuth
  • CREATE AUTHORIZATION DefAuth

foreign_table_name

Replace foreign_table_name with the name you want to call your foreign table. You may use any name that conforms to object naming rules, see Teradata Vantage™ - SQL Fundamentals, B035-1141.

YOUR-STORAGE-ACCOUNT

To run the examples using the river flow data, replace YOUR-STORAGE-ACCOUNT with the location shown in the table. Note, the locations shown in the table will only work if you have kept the folder structure from the downloaded ZIP file.

Object Store External Storage Location Values
Amazon S3
The examples in this document use "td-usgs" for the bucket name. Your bucket name must be unique.
 CSV: /s3/YOUR-BUCKET.s3.amazonaws.com/CSVDATA/

For example: /s3/td-usgs.s3.amazonaws.com/CSVDATA/

JSON: /S3/YOUR-BUCKET.s3.amazonaws.com/JSONDATA/

For example: /s3/td-usgs.s3.amazonaws.com/JSONDATA/

Parquet: /S3/YOUR-BUCKET.s3.amazonaws.com/PARQUETDATA/

For example: /s3/td-usgs.s3.amazonaws.com/PARQUETDATA/

Azure storage
Replace YOUR-STORAGE-ACCOUNT with the value for your account.
 CSV: /az/YOUR-STORAGE-ACCOUNT.blob.core.windows.net/td-usgs/CSVDATA/
JSON: /az/YOUR-STORAGE-ACCOUNT.blob.core.windows.net/td-usgs/JSONDATA/
Parquet: 
/az/YOUR-STORAGE-ACCOUNT.blob.core.windows.net/td-usgs/PARQUETDATA/
Google Cloud Storage CSV: /gs/storage.googleapis.com/YOUR-BUCKET/CSVDATA

For example: /gs/storage.googleapis.com/td-usgs/CSVDATA

JSON: /gs/storage.googleapis.com/YOUR-BUCKET/JSONDATA

For example: /gs/storage.googleapis.com/td-usgs/JSONDATA

Parquet: /gs/storage.googleapis.com/YOUR-BUCKET/PARQUETDATA

For example: /gs/storage.googleapis.com/td-usgs/PARQUETDATA

Teradata requires the storage location to start with the following:
  • Amazon S3 bucket location must begin with /S3 or /s3
  • GCS 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 store must be configured to allow Advanced SQL Engine to access it.

The USER and PASSWORD keywords (used in the CREATE AUTHORIZATION command) correspond to the values shown in the following table:

Keyword Access Variables Values
USER Replace YOUR-ACCESS-KEY-ID with the access ID to your external storage.
PASSWORD Replace YOUR-SECRET-ACCESS-KEY with the secret key value to your external storage.