Import CSV & Google Sheets
This feature is under development and will be released soon!
Upon release, only Admins and Data Analysts can import CSV and Google Sheets data in the Development workspace.
We will work to support such a capability for Viewers and Explorers later.
Introduction
You might often need to quickly analyze data from CSV files or Google Sheets for temporary reporting needs. It can be a customer survey analysis, or an ad-hoc exploration on some CRM export.
This typically include waiting for data engineers, navigating complex ETL setups, and dealing with access issues — resulting in hours or even days of waiting for what should be simple, temporary data analysis.
Holistics will soon support a seamless way to load CSV files or Google Sheets directly into your existing data warehouse. From there, Holistics will create data models against these warehouse tables.
Note: CSV and Google Sheets import is designed for you to quickly get started with your reporting needs, and do not intend to replace full-fledged data integration solutions.
How It Works
- Simply drag and drop your CSV file, and you’ll have a new data model ready for exploration within seconds.
- Under the hood, your CSV files or Google Sheets are loaded directly into your existing data warehouse through Holistics.
- Admins can designate which database schema for your files to be imported from Holistics, too.
Supported Data Sources
Holistics currently supports the following data warehouses as CSV and Google Sheets import destination:
- PostgreSQL
- Amazon Redshift
- MySQL
- Google BigQuery
- Microsoft SQL Server
- PrestoDB
- Amazon AWS Athena
- Snowflake
- Clickhouse
This feature is not yet available for other data warehouses, such as Databricks or MotherDuck.