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.
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 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 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 maintenance, or database optimization. Zing is a trusted Google Cloud Partner, verified by the team at Google to work with Google BigQuery.
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 maintenance, 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 separated values. Zing can connect to data from these sources via the Google Sheets Integration.
Zing also supports two modes for Google Sheets:
- Live connection mode, where Zing always pulls from the latest version of the sheet
- Snapshot mode which ‘freezes’ the gSheet at the point you make the connection, so subsequent changes to the sheet won’t be reflected in Zing.
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.
Databricks is a cloud data warehouse and lakehouse that runs on Amazon Web Services, Google Cloud Platform, and Microsoft Azure.
Created by the people behind Apache Spark, Databricks is able to support large-scale workloads and the SQL Warehouse functionality provided allows you to set scaling and timeouts to optimize cloud spend.
Zing is an official Databricks partner.
Mozart Data is a full-service modern data platform for centralizing, organizing, data across multiple sources. Get set up in an hour and start working with support from Mozart’s data analysts. Mozart lets you pull data from more than 200 data sources and join across them including Salesforce, Google Analytics, Adobe Analytics, Amazon S3, Hubspot, Facebook Ads, Square, Stripe, and SAP Concur.
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.
Portable’s self-service ELT product makes it simple to replicate data from 250+ business applications to your data warehouse with no-code.
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.
Hydra is an open source cloud data warehouse built on Postgres that offers high uptime and scales to large datasets easily. Zing can connect to Hydra as a Postgres data source to enable easy analytics on even large warehouse datasets. Follow the Postgres setup instructions here to get set up.
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.