This page describes how an Admin user can use the Tetra Data Platform (TDP) to do the following:
- Get AWS credentials to query Amazon Athena SQL tables
- View Athena SQL tables and structure
For instructions on how to integrate Athena tables with third-party tools, see Use Third-Party Tools to Connect to Athena Tables.
- Sign in to the TDP. Make sure that you're in the right organization. Then, in the left navigation menu, select the hamburger menu icon.
- Choose Administration. Then, choose SQL Access. The SQL Access page appears.
- If your SQL User already has AWS credentials (ACCESS KEY and SECRET KEY), the information displays in the ATHENA CREDENTIALS section. Additional connection parameters that are required to connect a third-party tool to the Athena tables are also listed (DRIVERS, URL, S3OUTPUTLOCATION).
- To create new AWS credentials for your SQL User, choose Replace Credentials. A dialog appears that asks you to confirm the change. Choose Create new credentials.
An organization can have one set of credentials active at a time only. If you choose Replace Credentials, the new set of generated credentials will cause the previous set of credentials to become obsolete.
- Open the SQL Access page. (See steps 1-2 in Get AWS Credentials to Query Athena SQL Tables.)
- In the SQL TABLES section, select the SQL table that you want to see. The row expands to show the table's properties, columns, and parameters.
Updated about 1 month ago