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
• MotherDuck
• 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	SQL Server	MySQL	Presto	BigQuery	Redshift	Snowflake	AWS Athena	Clickhouse	Databricks	MotherDuck
Table Model: Create		✅Yes	✅Yes	✅Yes	✅Yes	✅Yes	✅Yes	✅Yes	✅Yes	✅Yes	✅Yes	✅Yes
SQL Model: Create		✅Yes	✅Yes	✅Yes	✅Yes	✅Yes	✅Yes	✅Yes	✅Yes	✅Yes	✅Yes	✅Yes
Persistence: Full mode		✅Yes	✅Yes	✅Yes	✅Yes	✅Yes	✅Yes	✅Yes	✅Yes	✅Yes	❌No	❌No
Persistence: Append mode		❌No	❌No	❌No	❌No	❌No	❌No	❌No	❌No	❌No	❌No	❌No
Persistence: Incremental mode		✅Yes	✅Yes	✅Yes	✅Yes	✅Yes	✅Yes	📅On the Roadmap	📅On the Roadmap	✅Yes	❌No	❌No
Persistence: Upsert mode		✅Yes	📅On the Roadmap	✅Yes	✅Yes	✅Yes	✅Yes	📅On the Roadmap	📅On the Roadmap	✅Yes	❌No	❌No
Persistence: Delete persistence		✅Yes	✅Yes	✅Yes	✅Yes	✅Yes	✅Yes	✅Yes	✅Yes	✅Yes	❌No	❌No
Modeling: Define Relationship		✅Yes	✅Yes	✅Yes	✅Yes	✅Yes	✅Yes	✅Yes	✅Yes	✅Yes	✅Yes	✅Yes
Modeling: Create Custom Dimension		✅Yes	✅Yes	✅Yes	✅Yes	✅Yes	✅Yes	✅Yes	✅Yes	✅Yes	✅Yes	✅Yes
Modeling: Create Measure		✅Yes	✅Yes	✅Yes	✅Yes	✅Yes	✅Yes	✅Yes	✅Yes	✅Yes	✅Yes	✅Yes
Dataset: Single-model Dataset		✅Yes	✅Yes	✅Yes	✅Yes	✅Yes	✅Yes	✅Yes	✅Yes	✅Yes	✅Yes	✅Yes
Dataset: Dynamic models Dataset		✅Yes	✅Yes	✅Yes	✅Yes	✅Yes	✅Yes	✅Yes	✅Yes	✅Yes	✅Yes	✅Yes
Create Dataset-based report		✅Yes	✅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	✅Yes

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.