Loading data

You must load data before you can configure charts. There are three ways to load data:

1. Upload a data file

2. Connect to a database table

3. Connect to sample data

The data drawer is where you set up your data. To open the data drawer, click the bar at the bottom of the editing panel. Click the bar again to close the data drawer.

Upload a data file

To upload the report's first data file, open the data drawer and drag a flat file (CSV, XLS, or XLSX) containing your data onto the data upload box or click Upload CSV or Excel and select the file to be uploaded. The file will be loaded to a BigQuery table and connected to the report.

To load additional data files, first click the + and then drag-and-drop or select your CSV or Excel file.

Connect to a database table or view

If your report is connected to a database, you can select the schema and table (or view) to use as the data source. To set up a database connection, reach out to us. The following databases are supported:

• BigQuery

• Databricks

• Postgres

• Redshift

• Snowflake

• SQL Server

For databases that are not maintained on a cloud platform, we support the latest two release versions. Earlier versions may work with Juicebox, but are not supported.

Connect to sample data

Juicebox also provides a selection of sample data tables if you want to start exploring before you have your own data. To load sample data, open the data drawer, select the Sample Data button, and choose one of the available datasets.

Choose a sample data table and select Add Table.

The sample data includes the following tables.