Set the following environment variables for your pipeline:
Run in PowerShell:
$env:TERADATA_HOST="<your-teradata-host>"
$env:TERADATA_USER="<your-teradata-user>"
$env:TERADATA_PASSWORD="<your-teradata-password>"
$env:TERADATA_DATABASE="<target-database>"
$env:AWS_S3_LOCATION="/s3/your-bucket.s3.<region>.amazonaws.com/data/sample_data.csv"
export TERADATA_HOST=<your-teradata-host>
export TERADATA_USER=<your-teradata-user>
export TERADATA_PASSWORD=<your-teradata-password>
export TERADATA_DATABASE=<target-database>
export AWS_S3_LOCATION=/s3/your-bucket.s3.<region>.amazonaws.com/data/sample_data.csv
Note on AWS Credentials: Since this guide uses a public S3 bucket (public_bucket=True), AWS credentials are not required. The pipeline accesses the public bucket directly from Teradata. (AWS credentials become required when using private buckets — see "Public vs Private S3 Buckets" section.)
Important:
- Do NOT repeat the bucket name in the path
- The path component starts directly after .amazonaws.com/
- While region is optional for public buckets, including it is a best practice