LogoLogo
  • Datawisp Documentation
  • Datawisp Overview
  • Adding your data
    • Connect to a database
      • Snowflake
      • BigQuery
      • Google Analytics via BigQuery
      • MotherDuck
    • Tips for Success
    • Troubleshooting
    • Reloading the database schema
    • Data Dictionaries
  • Analyzing Data
    • Datawisp Blocks
      • Data Source
      • Summarize & Group
      • Combine
      • Order and Select Rows
      • Table
      • Filter
      • Add Column
      • Cleanup
      • JSON
      • Chart
      • Reshape
    • Wispy
      • The SQL View
  • Deployment
  • Security
  • Privacy
  • Data processing
  • Contact Info
  • Additional Resources
    • Tutorials
Powered by GitBook
LogoLogo

Datawisp

  • Main Site
  • App

Social

  • X
  • Linkedin

Legal

  • Privacy Policy
  • Terms of Use

Copyright 2023 Datawisp, Inc.

On this page
  • Supported data sources
  • Overview
  • Data Dictionaries
  • Security

Adding your data

Datawisp can

  • Connect to your existing infrastructure (databases, data warehouses, data lakes, ...) If you already have your data stored in some form of database, this is the recommended approach. Data is processed on your infrastructure. The full dataset is never copied.

  • Work with files uploaded to Datawisp (Excel, CSV, JSON, ...) Alternatively, you can upload documents to Datawisp. In that case, the Datawisp servers will store and process the data.

Supported data sources

Data warehouse platforms

  • Snowflake

  • Google BigQuery

  • AWS Redshift

  • MotherDuck

  • PlanetScale

Databases

  • MariaDB

  • MySQL

  • MariaDB

  • Microsoft SQL Server

  • PostgreSQL

Note: databases are supported regardless of your provider. Datawisp supports EC2, Google Cloud databases, Azure Database, PlanetScale, ...)

Files

  • Excel (xlsx)

  • JSON

  • CSV

  • Google Sheets

Note: to import a Google Sheet, link sharing must be enabled ("Anyone with the link can see").

Other Applications, CRMS, Analytics Tools, ...

Datawisp supports other tools, such as:

  • Google Analytics

  • Firebase

  • Honeycomb

  • AppsFlyer

  • ...

Many applications like those allow Datawisp to connect directly to them via a data platform (e.g. Google Analytics / Firebase data can be accessed via BigQuery) with a little setup. In most other cases, our onboarding team will help you connect the data to Datawisp.

Overview

Typically, our team will help you add your data to Datawisp. This is included in every Datawisp subscription, including free trials.

To add data, you can use the "Add Data" button. For some data sources, you can find additional help on one of the subpages. And if you have any trouble, please don't hesitate to ask.

Data Dictionaries

Security

Datawisp always connects to your database via an encrypted connection.

TLS Certificates

Many cloud providers unfortunately do not deploy valid certificates for their databases. In this case, Datawisp will offer you to pin the certificate it receives at import time. After a certificate is pinned, Datawisp will refuse to connect if your database sends a different certificate.

Whitelisting

To allow Datawisp to connect to your database, you may need to whitelist Datawisp's IP in the respective firewall. The current IP is always shown in the add data view.

Please refer to the documentation of your firewall if Datawisp is unable to connect to your database. If you still need help, don't hesitate to reach out to our team.

Private Networks, NATs, Gateways, VPNs, Private Clouds, ...

If your setup requires additional authentication to connect to the database, please reach out to our team.

PreviousDatawisp OverviewNextConnect to a database

Last updated 27 days ago

Data is always added to Datawisp via the , which you can access on the left sidebar.

After adding your data to Datawisp, we recommend .

data page
adding a Data Dictionary
The Data Page
Add Data View