Which data warehouse platforms can be used with the BigQuery & Data Warehouse export tool?






The new BigQuery & Data Warehouse Export Feature is now available! Contact us here to access it.

The BigQuery and Data Warehouse Export feature allows Matomo cloud customers to export raw data to specific data warehouse platforms. After the export to Amazon S3 is set up in Matomo, data can then be imported into a data warehouse platform that supports JSONL.

Supported data warehouse platforms

Amazon Redshift

Supports importing JSONL files using the COPY command. Integrates well with AWS S3 for seamless data import.
Resources: Redshift Connections; Amazon AWS loading data

Apache Hive

Supports importing JSONL files. Works with HDFS and other distributed storage systems.
Resources: Apache Hive Developer Guide

Azure Synapse Analytics

Supports importing JSONL files. Integrates with Azure Blob Storage and Azure Data Lake Storage for data import.
Resources: Copy and ingest data from Amazon S3

ClickHouse

Supports importing JSON and JSONL files using the INSERT INTO command. Provides integration with various data sources.
Resources: Integrate S3 with ClickHouse

Databricks (on Apache Spark)

Supports importing JSON and JSONL files using Spark's read functions. Integrates with various cloud storage services for data import.
Resources: Apache Spark JSON Files

Google BigQuery

Supports importing JSONL files directly. Allows loading data from Google Cloud Storage and other sources.
Resources: How to setup Google BigQuery

Greenplum

Supports importing JSON and JSONL files. Works with various ETL tools and cloud storage services for data import.
Resources: Load data from S3 into Greenplum

PostgreSQL

Supports importing JSONL files using the COPY command and JSON functions. Can work with various ETL tools for data import.
Resources: Import data into PostgreSQL

Snowflake

Supports importing JSONL files using the COPY INTO command. Can import data from various cloud storage services like AWS S3, Google Cloud Storage, and Azure Blob Storage.
Resources: Snowflake Connections; Copy into table from Amazon S3

Teradata

Supports importing JSON data through its native JSON functions and tools. Can handle JSONL files by parsing the lines individually.
Resources: Teradata Connections; Transfer data from S3 to Teradata

Vertica

Supports importing JSON and JSONL files using the COPY command. Integrates with cloud storage services and various data sources for data import.
Resources: Vertica connections; Load data using Copy

Previous FAQ: How far back can raw data be exported using the BigQuery & Data Warehouse feature?