# 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](/files/-Mj_z1JJJVOZDSDBux8u)

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

![Click the button to enable](/files/-Mj_zELK9imqE_WiK5--)

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](/files/-Mj_zXPgvhE4oaWbYC_n)

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


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.phiona.com/sharing-data/expose-as-database.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.