# 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](https://1051325660-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-MfY8WPfaF1OHmiC1YaW%2F-Mj_Elhw92yAg-SmXlVQ%2F-Mj_z1JJJVOZDSDBux8u%2Fimage.png?alt=media\&token=3d508137-b47f-4cbf-9421-f0fce04ac2d0)

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

![Click the button to enable](https://1051325660-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-MfY8WPfaF1OHmiC1YaW%2F-Mj_Elhw92yAg-SmXlVQ%2F-Mj_zELK9imqE_WiK5--%2Fimage.png?alt=media\&token=72f5170e-dd49-4f9d-8bff-ca0d133698eb)

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](https://1051325660-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-MfY8WPfaF1OHmiC1YaW%2F-Mj_Elhw92yAg-SmXlVQ%2F-Mj_zXPgvhE4oaWbYC_n%2Fimage.png?alt=media\&token=f05ca0bc-f512-410d-bec8-26eb1402a3b0)

### 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/>