The exact SQL syntax depends on your Teradata version. Consult your Teradata administrator or the official Teradata documentation for the correct syntax for your specific environment.
For reference, here are common syntax patterns (verify with your Teradata documentation):
CREATE AUTHORIZATION s3_private_access
AS DEFINER TRUSTED
USER 'your-aws-access-key-id'
PASSWORD 'your-aws-secret-access-key';
IMPORTANT: Test the CREATE AUTHORIZATION syntax in your environment before using it in production. If you encounter syntax errors, consult:
- Your Teradata administrator
- Teradata Native Object Store Getting Started Guide
- Teradata NOS Documentation