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


---

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