# Chartio

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 Chartio. The process includes two steps:

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

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

   Use the credentials generated from Step 1 to configure the connection in Chartio. The configuration only needs to be set up for the first time.

## Generate database credentials

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

![](/files/xJYy0eLxYZMWOEatWQdL)

2\. Select **Chartio** and click **Export in Workflow**.

![](/files/t0iK8rkWwyuXJ5tEyZyW)

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

![](/files/pU0izoONszHzc9M5sktQ)

3\. Acho generates **Dataset ID** and a **JSON key file** automatically. Please use these credentials to [set up the connection](#step-2-set-up-a-connection-in-chartio) in Chartio.

![](/files/iUElQ6iHVWJ8mxQfVFny)

Note:

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

## Set up a connection in Chartio

1\. Go to your Chartio account, and navigate to **Data** > **Add Data Source** > **Google BigQuery**.

2\. Upload the JSON key file that you downloaded from [Step 1](#step-1-generate-database-credentials). (***Note**: It may take a few minutes for Google to accept the JSON key. If you get an error uploading the JSON file to Chartio, wait a few minutes and try again.)*

![Drag and drop or click to select your service account key](https://chartio.com/images/uploads/upload-google-bigquery-key-to-chartio.png)

3\. Provide an **Alias** for your data source, verify the Project ID, and specify the **Maximum Bytes Billed**, which limits queries over the specified size for billing purposes.


---

# Agent Instructions: 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 current page URL with the `ask` query parameter:

```
GET https://docs.acho.io/acho-studio/data-flow/export-data/chartio.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
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.