BI and visualization with AWS AthenaC#
This program creates three AWS resources using the Python language: an Athena Database, a Named Query, and a Repository to store our query results.
First, we create an
AthenaDatabaseresource. This resource instance represents the AWS Athena database, which will store the tables and their metadata in this Athena application. Second, a named query is created using
AthenaNamedQueryresource which represents the SQL query to execute on this database later. Finally, an
S3Bucketresource is created to store the results of the Athena query. Athena will write the results of each query execution to this S3 bucket.
Find the complete program below:
This program gives you an Athena Database that you can run queries on, by using AthenaNamedQuery and an S3 Bucket that received the query results.
Remember to replace
"my_table"with the name of your table.
For visualizing Athena query results, you might want to look into AWS services like QuickSight, or third party tools like Tableau, Looker, etc. However, setting up these services is beyond the scope of this Pulumi program.