Connecting to a Data Source

#PostgreSQL, MySQL/MariaDB, Microsoft SQL Server, PlanetScale #Amazon Athena #Snowflake #Google Sheets #CSV #Airtable #Sample Data

Athenic AI connects to a variety of data sources including Files and Sheets, Data Warehouses, and SQL Database.

SQL Databases

PostgreSQL, MySQL / MariaDB, Microsoft SQL Server, PlanetScale

‍

Data Warehouses

Amazon Athena

1. Fill the Data source name with the name that you'll identify your data source with in Athenic AI
2. To learn how to obtain your AWS Access Key ID and AWS Secret Access Key, see Access keys on the AWS website
3. 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.
4. If you want to connect with work group, you can find the list of your work group names on the Amazon Athena console.
5. 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

1. Fill the Data source name with the name that you'll identify your data source with in Athenic AI.
2. Fill in your Snowflake username and password in the user and password fields provided.
3. To find your account ID, visit How to find Account ID on the Snowflake site

‍

Files & Sheets

Google Sheets

1. From your Google Sheets workbook, navigate to the top right corner and click on the Share button, then copy the URL link.
2. On the same popup, under General access, set it to "Anyone with the link".
3. Transition to the Athenic AI application and navigate to the datasource page, where you can select Google Sheets.
4. Fill the Data source name with the name that you'll identify your data source with in Athenic AI.
5. Insert the copied URL into the Workbook URL field.
6. Fill in the name of your Google Sheets name that you wish to connect.
7. Proceed by clicking the Connect button.

CSV

1. Fill the Data source name with the name that you'll identify your data source with in Athenic AI.
2. Upload your file. It must be in CSV format.
3. You can add as many files as you like up to 100 MB altogether.

Airtable

1. Open the Airtable API page,. and click the Airtable base that you want to use.
2. The base ID can be found in the URL of the API page of the base. In the URL, the base ID is immediately after https://airtable.com/ and starts with app.
3. Fill the Data source name with the name that you'll identify your data source with in Athenic AI.
4. Fill the base ID field with the base ID found in step 2
5. Fill in the name with the name of the Airtable that you wish the connect.
6. To learn how to obtain your Airtable API key, see How do I get my API key? on the Airtable site. A valid Airtable API key must always start with key.

‍

Next Step

Once we have connected to our data source, the next step will be selecting what tables and columns we want to include in our project. Configure Data Source page.

‍