Skip to main content

Supported Databases (Data Sources)

SQL-supported databases

Holistics currently support the following SQL databases/ data sources:

  • PostgreSQL
  • MySQL
  • Microsoft SQL Server
    • Azure DB via Microsoft SQL Server
  • Google BigQuery
  • Amazon Redshift
  • Snowflake
  • Presto
  • Clickhouse
  • Amazon Athena

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.

FeaturePostgreSQLMSSQLMySQLPrestoBigQueryRedshiftSnowflakeAWS AthenaClickhouse
Table Model: CreateYesYesYesYesYesYesYesYesYes
SQL Model: CreateYesYesYesYesYesYesYesYesYes
Import Model: Full import modeYesYesYesYesYesYesYesYesYes
Import Model: Append import modeYesYesNoYesYesYesYesYesYes
Import Model: Incremental import modeYesYesYesYesYesYesOn the RoadmapOn the RoadmapYes
Import Model: Upsert import modeYesYesYesYesYesYesOn the RoadmapOn the RoadmapYes
Persistence: Full modeYesOn the RoadmapYesYesYesYesYesYesYes
Persistence: Append modeNoNoNoNoNoNoNoNoNo
Persistence: Incremental modeYesOn the RoadmapYesYesYesYesOn the RoadmapOn the RoadmapYes
Persistence: Upsert modeYesOn the RoadmapYesYesYesYesOn the RoadmapOn the RoadmapYes
Persistence: Delete persistenceYesYesYesYesYesYesYesYesYes
Modeling: Define RelationshipYesYesYesYesYesYesYesYesYes
Modeling: Create Custom DimensionYesOn the RoadmapYesYesYesYesYesYesYes
Modeling: Create MeasureYesOn the RoadmapYesYesYesYesYesYesYes
Dataset: Single-model DatasetYesYesYesYesYesYesYesYesYes
Dataset: Dynamic models DatasetYesYesOn the RoadmapYesYesYesYesYesYes
Create Dataset-based reportYesYesOn the RoadmapYesYesYesYesYesYes
Create SQL-based reportYesYesYesYesYesYesYesYesYes
Use 3.0 filters (all data types)YesYesYesYesYesYesYesYesYes

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.

Let us know what you think about this document :)