You must load data before you can design your report. Data can be in a flat file (CSV, XLS, or XLSX) or in a database table (or view). You load your data by either uploading the file or, if your data is in a database, selecting the schema and table (or view) to connect to.

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.

After you load data, you can view your columns in the data preview and configure charts using dimensions and measures.

Replace uploaded data

To update uploaded data, click the Replace file button. If there is more than one data table in your report, select the data table that you want to update. (Alternatively, select the data table you want to update, click the gear icon, and select Replace file from the menu.) Then, select the new data file (CSV, XLS, or XLSX).

Once the upload process finishes, refresh the page. The report will then display the updated data.

Clear the data cache

To improve performance, charts display cached data. The cache is cleared periodically (by default, every 2 hours), but the cache can be cleared manually by clicking the Clear Data Cache button and selecting Yes, clear it. The cache will be cleared for all data tables used in the report.

The caching period is set at the database connection level and the current options are: no caching, cleared after 2 hours, cleared after 1 day, or cleared after 1 year. If you would like the caching period adjusted for a particular database connection, .

Delete a data table

If you have a data table that you don't plan to use in your report, you may want to delete the data table to declutter the data drawer. To do this, open the data drawer, select the data table you want to delete, click the gear icon, and select Delete.

If you are sure you want to delete the data table, click Yes, delete it.

Download data

For uploaded data tables, you can download the data by opening the data drawer, selecting the data table you want to download, clicking the gear icon, and selecting Download. The data will download as a CSV.

From the data preview you can see the data table columns, each column's data type, and the first 100 rows in the data table. You can also open the by clicking on the pill at the top of each column.

To open the data preview, first open the data drawer and then select the data table you want to view. To exit the data preview, close the data drawer.

Data types

From the data preview, you can see each column in your data and the data types for each column.

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, . The following databases are supported:

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.