Share Serverless SQL Warehouse
As a data lakehouse, Phiona can expose datasets to external analytics, business intelligence and SQL query tools right out of the box.
Exposing a Project as a Database
To expose the entire project as a set of data tables, you'll click on the "SQL Warehouse" tab on the top of your project page. Exposing all datasets (regardless of whether they're raw or transformed data) makes each dataset available for query or BI connection, and disables the ability to only expose individual SQL datasets within the project.
From there, click the slider button to enable the project as a SQL warehouse.
From there, you'll see your connection details for the SQL warehouse to plug in to your analytics programs (listed in the following sections).
Analytics Programs With Native Support
AWS Quicksight - https://docs.aws.amazon.com/quicksight/latest/user/create-a-data-set-athena.html
Cumul.io - https://academy.cumul.io/article/vn7p4988
Domo - https://www.domo.com/appstore/connector/amazon-athena-advanced-connector/overview
Holistics - https://docs.holistics.io/docs/connect/databases/amazon-athena
Looker - https://docs.looker.com/setup-and-management/database-config/amazon-athena
Mode - https://mode.com/help/articles/supported-databases/#amazon-athena
PopSQL - https://popsql.com/docs/connection-guides/connecting-to-athena
PowerBI - https://docs.aws.amazon.com/athena/latest/ug/connect-with-odbc-and-power-bi.html
Redash - https://redash.io/help/data-sources/querying/amazon-athena
Retool - https://docs.retool.com/docs/aws-athena
Tableau - https://help.tableau.com/current/pro/desktop/en-us/examples_amazonathena.htm
Zoho - https://www.zoho.com/analytics/help/cloud-database/amazonathena.html
Analytics Programs Requiring External Connector
Apache Superset - https://superset.apache.org/docs/databases/athena
Google Data Studio - https://github.com/canyousayyes/datastudio-aws-athena-connector
Grafana - https://github.com/mtanda/grafana-aws-athena-datasource
Jupyter Notebooks - https://pypi.org/project/jupyter-athena-sql/
Metabase - https://github.com/dacort/metabase-athena-driver
R Studio - https://db.rstudio.com/databases/athena/
Last updated