Install PipeRider with the Athena connector and connect to a Athena data source.
pip install 'piperider[athena]'
Run the diagnose command in the dbt project
If you can successfully connect to Athena using dbt, PipeRider can also connect to Athena using the same profile settings. For details, please refer to the dbt Athena adapter documentation.
non-dbt use case is deprecated since v0.25.0
The adapter utilizes AWS CLI/boto3 credential file to connect to Athena. You can provide
[?] What is your data source name?: AthenaProject
[?] Which data source would you like to connect to?:
Follow the prompts entering the required information.
After selecting Athena as your data source, you will be promoted for the following information:
- S3 location to store Athena query results and metadata: Same as the query result location in the query editor.
- AWS region name of your Athena instance: e.g. us-east-1
- Athena data catalog: Same as the data source name in the query editor. Use
awsdatacatalogfor AWS Glue Data Catalog.
After configuring your connection settings, ensure that PipeRider can connect to your Athena data source.