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.

Select SQL Warehouse tab

From there, click the slider button to enable the project as a SQL warehouse.

Click the button to enable

From there, you'll see your connection details for the SQL warehouse to plug in to your analytics programs (listed in the following sections).

Your SQL Warehouse details

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/