How can I configure the Google Cloud Storage Actions in Looker?

With Google Cloud Storage actions the user can send data from Looker (Looks, Dashboards, Explore) to a specific Storage bucket in a GCP account.

Customer-hosted instances: Make sure the instance fulfills these requirements to be able to use actions from the Looker Action Hub. More considerations for actions in customer-hosted instances can be found here.

Setup

  1. In your Google Cloud Console enable the Google Cloud Storage API and Google Cloud Storage JSON API. (Use the search bar from the console to find them)
  2. Generate a Service Account with JSON keys
    1. Go to IAM & Admin → Service Accounts → Create Service Account
    2. Set any name for the Service Account
    3. Grant the roles of "Storage Object Creator", "Project Viewer" and a custom role with the "object.delete" permission.
    4. Once the Service Account is created, click on its name to open the details page. Go to the Keys tab → Add Key → Create new key → JSON format
    5. Open the JSON file that was downloaded in any text/code editor.
  3. Enable and setup Google Cloud Storage actions in Looker
    1. In your Looker instance go to Admin → Platform → Actions. Scroll to find the Google Cloud Storage section and click on "Enable"
    2. Fill the settings form with the help of the JSON file:
    3. Client Email: Use client_email from JSON
    4. Private Key: Use private_key from JSON
      • Example: -----BEGIN PRIVATE KEY-----\nPRIVATE_KEY_DATA\n——END PRIVATE KEY-----\n
    5. Project ID: Use project_id from JSON
      • Example: project9skd34j5b2cj
    6. You can click on “Test” to confirm the configuration is correct and then save it.

 

Usage

  1. In Looker, open a View, Dashboard or Explore data that you would like to send.
  2. Open the Schedule delivery modal, set the desired occurrence.
  3. For destination select "Google Cloud Storage"
  4. Select the destination bucket, then optionally set the filename.
  5. Select the desired format and click Send/Save.
2 0 1,252
0 REPLIES 0