> 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/looker.md).

# Looker

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 Looker. The process includes three steps:

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

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

   Use the credentials generated from Step 1 to configure the connection in Looker. 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 **Looker** and click **Export in Workflow**.

![](/files/2VVbgat9NfdxaqUXe8dq)

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

![](/files/V8ygoWuvjAmNKaUed4Hl)

4\. 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-looker) in Looker.

![](/files/c2VWNeNfBh8OFqn4Jjyg)

Note:

* Each Acho's account has a unique set of credentials for Looker.  
* 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 Looker.

## Set up a connection in Looker

1\. In the **Admin** section of Looker, select **Connections**, and then select **New Connection**.

2\. Follow the instructions below to complete the configuration: 

* **Dialect**: Select **Google BigQuery Standard SQL** or **Google BigQuery Legacy SQL**.
* **Project Name**: Fill in the Dataset ID generated from [Step 1](#step-1-generate-database-credentials).
* **Dataset**: Specify the name of the dataset that you plan to use. 
* **Service Account Email**: Fill in the **Service Account Email** generated from [Step 1](#step-1-generate-database-credentials).
* **Service Account JSON**: Upload the JSON key file generated from [Step 1](#step-1-generate-database-credentials).