> For the complete documentation index, see [llms.txt](https://docs.myjuicebox.io/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.myjuicebox.io/building-reports/data-sources/loading-data.md).

# 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.

<figure><img src="https://872636700-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LmfYn9Ab4YpIl0ZZFm-%2Fuploads%2F4czMAPwKiXHUCeSaN8kC%2Fimage.png?alt=media&amp;token=2ed3e39b-462a-49f4-9800-730812c80d7a" alt=""><figcaption><p>Click the bar at the bottom to open the data drawer</p></figcaption></figure>

## 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.

<figure><img src="https://872636700-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LmfYn9Ab4YpIl0ZZFm-%2Fuploads%2F8XuSk7JBcJLDeoVwcaUQ%2Fimage.png?alt=media&amp;token=13738789-8216-44bb-856d-d136edcd04df" alt=""><figcaption><p>Add data by uploading a CSV or Excel file</p></figcaption></figure>

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

<figure><img src="https://872636700-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LmfYn9Ab4YpIl0ZZFm-%2Fuploads%2FGcwiKy59XEJ4HoOZb8QY%2Fimage.png?alt=media&amp;token=db8b1b13-02e9-4258-ae64-fae5a6f591c2" alt=""><figcaption><p>Click the "+" in the data drawer to add additional data files</p></figcaption></figure>

{% hint style="warning" %}
When loading data files, it is important that your data be nice and clean. Here are some tips for [preparing your data](/building-reports/design-tips/preparing-your-data.md).
{% endhint %}

## Connect to a database table or view

{% hint style="warning" %}
This feature is not available on all plans.
{% endhint %}

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](/getting-started/reach-out-to-us.md). The following databases are supported:

* [BigQuery](/building-reports/data-sources/loading-data/connecting-to-bigquery.md)
* [Databricks](/building-reports/data-sources/loading-data/connecting-to-databricks.md)
* [Postgres](/building-reports/data-sources/loading-data/connecting-to-postgres.md)
* [Redshift](/building-reports/data-sources/loading-data/connecting-to-redshift.md)
* [Snowflake](/building-reports/data-sources/loading-data/connecting-to-snowflake.md)
* [SQL Server](/building-reports/data-sources/loading-data/connecting-to-sql-server.md)

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.

<figure><img src="https://872636700-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LmfYn9Ab4YpIl0ZZFm-%2Fuploads%2FnGKPChY9JK0VF9aFpNpH%2Fimage.png?alt=media&amp;token=5ecd5aaf-7921-4727-8204-16025c1672fc" alt=""><figcaption><p>Load sample data</p></figcaption></figure>

Choose a sample data table and select **Add Table**.

The sample data includes the following tables.

| Sample Data                    | Description                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              |
| ------------------------------ | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| lego\_sets                     | **🎛 LEGO sets** ([CSV download](https://docs.google.com/spreadsheets/d/10lJ-WWUvI8A1ezdzK0NWvGp5hjKT73Nj2N9eccLQIqY/export?format=csv\&gid=0) or see the data in a [Google Sheet](https://docs.google.com/spreadsheets/d/10lJ-WWUvI8A1ezdzK0NWvGp5hjKT73Nj2N9eccLQIqY/edit#gid=0)). Source: [Kaggle](https://www.kaggle.com/mterzolo/lego-sets)                                                                                                                                                                         |
| movie\_trends                  | **🎬 Movie Trends** ([CSV download](https://docs.google.com/spreadsheets/d/1FyPKMdoHskUyDLJzo66fq5LBZxwIcot-JWGakXz9D_o/export?format=csv) or see the data in a [Google Sheet](https://docs.google.com/spreadsheets/d/1FyPKMdoHskUyDLJzo66fq5LBZxwIcot-JWGakXz9D_o/)). Source: [Kaggle](https://www.kaggle.com/)                                                                                                                                                                                                         |
| olympic\_medals                | **🥇Olympic Medals 1896-2012** ([CSV download](https://docs.google.com/spreadsheets/d/1t5VH3Psl2O-ooo8vYPLkDplIWvUiYcQNeyJzVyiun98/export?format=csv\&gid=0) or see the data in a [Google Sheet](https://docs.google.com/spreadsheets/d/1t5VH3Psl2O-ooo8vYPLkDplIWvUiYcQNeyJzVyiun98/edit#gid=0)). Source: International Olympic Committee, The Guardian Datablog, and [Kaggle](https://www.kaggle.com/the-guardian/olympic-games)                                                                                       |
| video\_game\_sales             | **🎮 Video Game Sales** ([CSV download](https://docs.google.com/spreadsheets/d/1HGTdSQF62dQMwyTCq71XcN5lO4cI9WzNIRthT1Uh_eE/export?format=csv) or see the data in a [Google Sheet](https://docs.google.com/spreadsheets/d/1HGTdSQF62dQMwyTCq71XcN5lO4cI9WzNIRthT1Uh_eE)). Source: [Kaggle](https://www.kaggle.com/gregorut/videogamesales). A helpful getting started [article and video](https://intercom.help/juiceboxdata/en/articles/4720121-simple-apps-dynamic-bar-chart-and-table) to create a dynamic bar chart. |
| world\_happiness\_report\_2020 | **😀 World Happiness Report 2020** ([CSV download](https://docs.google.com/spreadsheets/d/1UuRe1YL79gi8eeNDBM_oHMFiXUDvw4F2IJ6p9SNtZXI/export?format=csv\&gid=6513579) or see the data in a [Google Sheet](https://docs.google.com/spreadsheets/d/1UuRe1YL79gi8eeNDBM_oHMFiXUDvw4F2IJ6p9SNtZXI/edit#gid=6513579)). Source: [World Happiness Report](https://worldhappiness.report/ed/2020/) and [Data.World](https://data.world/makeovermonday)                                                                          |


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the following URL with the `ask` and `goal` query parameters:

```
GET https://docs.myjuicebox.io/building-reports/data-sources/loading-data.md?ask=<question>&goal=<user_goal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is what the user is ultimately trying to achieve, the reason they need the answer. Sharing it helps GitBook give you a better, more relevant answer. A goal is most helpful when it describes the outcome the user wants rather than restating the question. For example, with `ask=how do I create an API token`, a goal like `build a script that syncs our docs to a CMS` lets GitBook tailor the answer to that use case.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.