> For the complete documentation index, see [llms.txt](https://docs.acho.io/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.acho.io/acho-studio/data-flow/export-data/apache-superset.md).

# Apache Superset

Acho can help you import data from spreadsheets or apps and host a database on our server, so you can export any type of data to Apache Superset. The process includes three steps:

1. [Generate database credentials](#generate-database-credentials)

   Each Acho's account generates **only** **one** set of credentials.
2. [Set up a connection in Apache Superset](#set-up-a-connection-in-apache-superset)

   Use the credentials generated from Step 1 to configure the connection in Apache Superset. The configuration only needs to be set up for the first time.
3. [Update tables in Apache Superset](#update-tables-in-apache-superset)

   Whenever you export a new table from Acho, you have to complete this step to add the table in Apache Superset.

## Generate database credentials

1\. Click the export button on the top right of the table. 

![](/files/xJYy0eLxYZMWOEatWQdL)

2\. Select **Apache Superset** and click **Export in Workflow**.

![](/files/Vrza9dazFUMMsh9m78e8)

3\. In Workflow, drag **Apache Superset** from the right sidebar to the canvas. Then, link it to the table that you want to export.

![](/files/68y4SUbpeO4aD68xzlH7)

4\. Acho generates **Dataset ID** and a **JSON key file** automatically. Please use these credentials to [set up the connection](#set-up-a-connection-in-apache-superset) in Apache Superset.

![](/files/qc6Vx4RvEj04TH8laYY8)

Note:

* Each Acho's account has a unique set of credentials for Apache Superset.  
* Every time you export data to Apache Superset, you can find the credentials. However, you **only need these credentials for the first time** to build the connection in Apache Superset.

## Set up a connection in Apache Superset

Superset requires a Python DB-API database driver and a SQLAlchemy dialect to be installed for BigQuery.

### 2-1. Install BigQuery driver

1\. Create `requirements-local.txt`

```git
# From the repo root...
touch ./docker/requirements-local.tx:
```

2\. Add the driver selected in the step above.

```
echo "pybigquery" >> ./docker/requirements-local.txt
```

3\. Rebuild your local image with the new driver baked in:

```
docker-compose build --force-rm
```

4\. After the rebuild of the Docker images is complete (which make take a few minutes) you can relaunch using the following command:

```
docker-compose up
```

The other option is to start Superset via Docker Compose is using the recipe in `docker-compose-non-dev.yml`, which will use pre-built frontend assets and skip the building of front-end assets:

```
docker-compose -f docker-compose-non-dev.yml up
```

### 2-2. Add a database 

1\. Open your Apache Superset and navigate to **Data > Databases**. Then, click the **+ DATABASE** button.navigate to **Data > Databases**. Then, click the **+ DATABASE** button.navigate to **Data > Databases**. Then, click the **+ DATABASE** button.

![](/files/OeHRiBiyvaHVZzZLeC7D)

2\. Choose **Google BigQuery** under the dropdown of other databases

![](/files/BNV3ruPe4Ifo3s8JaPUt)

3\. Upload the JSON key file generated from [Step 1](#step-1-generate-database-credentials) and click **CONNECT**.

![](/files/wyBNTxHY4PzXOA0ZF53e)

4\. Once the connection is set up, click **FINISH**.

![](/files/QF6gnNvBwmmIUcwmSUxQ)

## Update tables in Apache Superset

1. Navigate to **Data > Datasets**. Then, click the **+ DATASET** button.

![](/files/g4lOyulWiGasrzba8HtL)

2\. Specify the fields below:

* **`DATABASE`**: Choose the BigQuery database that you just connected in [Step 2](#set-up-a-connection-in-apache-superset).
* **`SCHEMA`**: Select **apache\_supset\_dataset\_XXX** (XXX is your unique account id on Acho.)
* **`SEE TABLE SCHEMA`**: Select a table that you want to import. You can see a list of tables that you already exported from Acho here. 

![](/files/gJpga6WXc3RPZLLgfQGO)