Database Integrations

Zing Data works with Postgres, MySQL, Google BigQuery, Snowflake, Cube, Bit.io

Zing Data has tested and verified connections with trusted partners.

Set up multiple data sources to seamlessly view tables and questions from across all your database sources all in one screen.


PostgreSQL

Postgres is one of the most commonly used databases in the world, is open source, and has around for 30+ years. Zing Data connects to any PostgreSQL database and has been tested with thousands of tables and for long-running queries. Zing also supports multiple schema within a Postgres database.


MySQL

MySQL is one of the world’s most popular databases, now owned by Oracle. Zing Data connects to any MySQL database, tested to thousands of tables and for long-running queries


Google BigQuery

Google BigQuery is a powerful, cloud-hosted database that scales to huge data volumes easily. Available with a free-to-try version, BigQuery is an easy way to get up data in the cloud without having to deal with hosting, database maintinence, or database optimization. Zing is a trusted Google Cloud Partner, verified by the team at Google to work with Google BigQuery.


Snowflake

Snowflake is a cloud-based data warehouse that is popular for ingesting, transforming, and querying data from many sources. Available with a free-to-try version, Snowflake is an easy way to get up data in the cloud without having to deal with hosting, database maintinence, or database optimization.


Google Sheets, Microsoft Excel, and CSV files

Google Sheets and Microsoft Excel are commonly used spreadsheets. Other common data analysis tools and spreadsheet programs allow saving files as comma seperated values. Zing can ingest data from these sources via the Google Sheets Integration.


Trino, Presto, And Starburst

Trino is a fast, distributed query engine that can support large queries and heavy analytics workloads. It is free and open source, and is a successor to the open source Presto query engine.

A hosted and well-supported version of Trino is available from Starburst.io. Zing has been tested to work with all three variants.



Agile Data

Agile Data is a data automation tool which provides data to Zing so you can easily take action. Agile Data supports business analyst and data analyst teams to translate business questions into repeatable data.


Bit.io

Bit.io is an easy-to-get-started, cloud-hosted PostgreSQL database provider that makes adding a database as easy as dropping in a CSV file. Tested for compatibility with Zing Data, Bit.io is a simple, fast way to get started with Zing by leveraging seamless database creation and hosting. This video walks you through how to use Bit.io with Zing.


Cube JS

Cube is a cloud infrastructure layer that lets you connect to MongoDB, Postgres, Athena, Bigquery, mySQL, Hive, Snowflake, and other databases to transform underlying data sources into more easily queryable and visualizable data. They have a free tier, and are a great way to get started with Zing for data sources that Zing doesn’t yet natively support, or where data transformation is needed. This video walks you through how to use Cube’s SQL API with Zing..