Phiona Documentation
  • 👋Introduction
  • 🛣️The Basics
    • How Phiona Works
    • Scheduling & Automation
    • API Documentation
  • 🔗Data Sources
    • Airtable
    • Amazon S3
    • BigCommerce
    • BigQuery
    • Dropbox
    • Firebase
    • Google Analytics v4
    • Google Drive
    • Google Search Console
    • Google Sheets
    • Hubspot
    • Import from API (Beta)
    • Local Files
    • MongoDB
    • MySQL
    • PostgreSQL
    • Redshift (Beta)
    • Shopify
    • Snowflake (Beta)
    • WooCommerce
    • Wordpress
  • 📈Sharing Data
    • Share Project with Collaborators
    • Share Public Project Link
    • Share Serverless SQL Warehouse
    • Build API Endpoint From Single Dataset
    • Share Dataset via Email
  • 🛠️Clean & Transform
    • Supported Data Types & Column Header Functions
    • Supported Clean Functions
    • Supported Transformations
    • Applying Existing or Shared Blueprints
  • 🌆Export Destinations
    • Airtable
    • Amazon S3
    • Dropbox
    • Google Drive
    • Google Sheets
    • MongoDB
    • MySQL
    • PostgreSQL
    • Redshift (Beta)
    • Snowflake (Beta)
  • Changelog
Powered by GitBook
On this page
  • Exposing a Project as a Database
  • Analytics Programs With Native Support
  • Analytics Programs Requiring External Connector

Was this helpful?

  1. Sharing Data

Share Serverless SQL Warehouse

PreviousShare Public Project LinkNextBuild API Endpoint From Single Dataset

Last updated 2 years ago

Was this helpful?

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

Analytics Programs Requiring External Connector

AWS Quicksight -

Cumul.io -

Domo -

Holistics -

Looker -

Mode -

PopSQL -

PowerBI -

Redash -

Retool -

Tableau -

Zoho -

Apache Superset -

Google Data Studio -

Grafana -

Jupyter Notebooks -

Metabase -

R Studio -

📈
https://docs.aws.amazon.com/quicksight/latest/user/create-a-data-set-athena.html
https://academy.cumul.io/article/vn7p4988
https://www.domo.com/appstore/connector/amazon-athena-advanced-connector/overview
https://docs.holistics.io/docs/connect/databases/amazon-athena
https://docs.looker.com/setup-and-management/database-config/amazon-athena
https://mode.com/help/articles/supported-databases/#amazon-athena
https://popsql.com/docs/connection-guides/connecting-to-athena
https://docs.aws.amazon.com/athena/latest/ug/connect-with-odbc-and-power-bi.html
https://redash.io/help/data-sources/querying/amazon-athena
https://docs.retool.com/docs/aws-athena
https://help.tableau.com/current/pro/desktop/en-us/examples_amazonathena.htm
https://www.zoho.com/analytics/help/cloud-database/amazonathena.html
https://superset.apache.org/docs/databases/athena
https://github.com/canyousayyes/datastudio-aws-athena-connector
https://github.com/mtanda/grafana-aws-athena-datasource
https://pypi.org/project/jupyter-athena-sql/
https://github.com/dacort/metabase-athena-driver
https://db.rstudio.com/databases/athena/
Select SQL Warehouse tab
Click the button to enable
Your SQL Warehouse details