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

![](https://3574406564-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MB_fx7PCUqvFEdrucJC%2Fuploads%2FR3csO7z5TpjG6ONV3AEA%2Fimage.png?alt=media\&token=a9f70a98-d227-477a-8ab9-cdc880db18bc)

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

![](https://3574406564-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MB_fx7PCUqvFEdrucJC%2Fuploads%2FyZIf94sKKfeE6MNaezBB%2Fimage.png?alt=media\&token=31fa9bbf-d5f2-42e0-90e7-7a49c178c852)

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

![](https://3574406564-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MB_fx7PCUqvFEdrucJC%2Fuploads%2FdmAPqtqZ4wYbcmvJ23Ro%2Fimage.png?alt=media\&token=7eb3f979-4895-4a52-99a9-f61d1450f69c)

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.

![](https://3574406564-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MB_fx7PCUqvFEdrucJC%2Fuploads%2FvZfFp756h0wZiAMZGJtS%2Fimage.png?alt=media\&token=49e11c24-20cc-44bf-a99c-fe1bc3e57393)

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.