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. 1.
    Each Acho's account generates only one set of credentials.
  2. 2.
    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.

Step 1: Generate database credentials

1. Click the export button on the top right of the table.
2. Select Looker and click Generate Credentials.
3. Acho generates Dataset ID and a JSON key file automatically.
Notice that:
  • 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.

Step 2: 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.
  • 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.
  • Service Account JSON: Upload the JSON key file generated from Step 1.
Last modified 1mo ago