Supported Databases (Data Sources)

SQL-supported databases

Holistics currently support the following SQL databases/ data sources:

• Amazon Athena
• Amazon Redshift
• Clickhouse
• Databricks
• Google BigQuery
• Microsoft SQL Server
• Azure DB via Microsoft SQL Server
• MySQL
• PostgreSQL (version 9.3 or above recommended)
• Presto
• Snowflake

info

Please note that while you can connect to PostgreSQL versions older than 9.3, we cannot guarantee full backward compatibility in those cases.

Since each database has their own unique features, not all functionalities in Holistics are supported across all databases. Below is the matrix table of what we support for each database.

Feature		PostgreSQL	MSSQL	MySQL	Presto	BigQuery	Redshift	Snowflake	AWS Athena	Clickhouse	Databricks
Table Model: Create		Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes
SQL Model: Create		Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes
Import Model: Full import mode		Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No
Import Model: Append import mode		Yes	Yes	No	Yes	Yes	Yes	Yes	Yes	Yes	No
Import Model: Incremental import mode		Yes	Yes	Yes	Yes	Yes	Yes	On the Roadmap	On the Roadmap	Yes	No
Import Model: Upsert import mode		Yes	Yes	Yes	Yes	Yes	Yes	On the Roadmap	On the Roadmap	Yes	No
Persistence: Full mode		Yes	On the Roadmap	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No
Persistence: Append mode		No	No	No	No	No	No	No	No	No	No
Persistence: Incremental mode		Yes	On the Roadmap	Yes	Yes	Yes	Yes	On the Roadmap	On the Roadmap	Yes	No
Persistence: Upsert mode		Yes	On the Roadmap	Yes	Yes	Yes	Yes	On the Roadmap	On the Roadmap	Yes	No
Persistence: Delete persistence		Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No
Modeling: Define Relationship		Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes
Modeling: Create Custom Dimension		Yes	On the Roadmap	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes
Modeling: Create Measure		Yes	On the Roadmap	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes
Dataset: Single-model Dataset		Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes
Dataset: Dynamic models Dataset		Yes	Yes	On the Roadmap	Yes	Yes	Yes	Yes	Yes	Yes	Yes
Create Dataset-based report		Yes	Yes	On the Roadmap	Yes	Yes	Yes	Yes	Yes	Yes	Yes
Create SQL-based report		Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes
Use 3.0 filters (all data types)		Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes

Support for spreadsheets sources

Besides the SQL connectors, Holistics also support a few non-SQL data sources: CSV/Excel files, Google Spreadsheets.

To work with these sources, please use our Import Model to load them into your SQL database.

Support for other data sources

For NoSQL data sources (MongoDB, CouchDB, etc) and application data sources (Salesforce, Hubspot, Facebook Ads), we recommend you use a dedicated ETL/EL tool, load the data into your data warehouse, and use Holistics to visualize them.