Data Warehouses
Amazon Athena
Fill the Data source name with the name that you'll identify your data source with in Athenic AI
To learn how to obtain your AWS Access Key ID and AWS Secret Access Key, see Access keys on the AWS website
The server name is often the endpoint URL which is formed like "athena.[region].amazonaws.com". You replace [region] with your actual AWS region that Athena is running in. You can find a full list of Athena endpoints in the Amazon Athena Documentation.
If you want to connect with work group, you can find the list of your work group names on the Amazon Athena console.
If you want to connect with S3 result path, you can find the list of your bucks in the AWS S3 service. To construct your S3 bucket path, start with s3:// followed by the bucket name.
Snowflake
Fill the Data source name with the name that you'll identify your data source with in Athenic AI.
Fill in your Snowflake username and password in the user and password fields provided.
To find your account ID, visit How to find Account ID on the Snowflake site
Google BigQuery
Fill the Data source name with the name that you'll identify your data source with in Athenic AI.
To connect to Google BigQuery, you will need the service account credentials associated with your BigQuery project. You can obtain all required fields by creating or viewing an existing service account key in the Google Cloud Console. This service account must have at least the BigQuery Data Viewer permission.
Project ID - This is the Google Cloud Project ID where your BigQuery datasets are stored. You can find your Project ID on the Google Cloud Console home page or in the downloaded service account key JSON under "project_id".
Private Key ID - This value is included in your service account key file JSON. After downloading the JSON key, locate the field labeled "private_key_id".
Private Key - This is the full private key string from your service account key JSON. It appears under the "private_key" field. Make sure to copy the entire key exactly as provided, including the “BEGIN PRIVATE KEY” and “END PRIVATE KEY” lines.
Client Email - This is the service account email associated with your BigQuery project. You can find it in the JSON key file under "client_email" or in the Google Cloud Console under IAM & Admin > Service Accounts.
Client ID - This is the numeric client ID for your service account. It appears in the JSON key file under the field "client_id".
Last updated