Use TDP to Connect to Athena SQL Tables

This page describes how an Admin user can use the TetraScience Data Platform (TDP) to:

  • Connect to Athena SQL tables from a third-party application or integrated development environment (IDE)
  • Obtain AWS credentials to query Athena SQL tables
  • View Athena SQL tables and structure

To connect to Athena SQL tables:

  1. In the TDP, click the Hamburger icon at the top left corner of the page to expand the TDP menu options (or hover over the list of icons to display the menu options).
4747

Hamburger icon

After clicking the Hamburger Menu icon, the icon changes to an X.

  1. Select Account -> SQL Access from the list of menu options that appears on the left side of the page.
10231023

SQL access page showing SQL tables

  1. From the SQL access page, you can:
  • Obtain AWS credentials to query Athena SQL tables
  • View Athena SQL tables and structure
  1. In the SQL access section, you can generate AWS credentials by clicking Replace Credentials.

📘

Organization's Credentials

An organization can have only one set of credentials active at a given time. If you click Replace Credentials, the new set of generated credentials will cause the previous set of credentials to become obsolete.

  1. To view additional connection parameters required to connect a third-party tool to the Athena tables or to view S3 output, click Show additional connection parameters.
  2. From the SQL tables section, a list of available SQL tables display. You can click a specific SQL table to expand and view its table structure (columns and parameters).
19341934

SQL Table structure


Did this page help you?