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
- 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)
- Generate a Service Account with JSON keys
- Go to IAM & Admin → Service Accounts → Create Service Account
- Set any name for the Service Account
- Grant the roles of "Storage Object Creator", "Project Viewer" and a custom role with the "object.delete" permission.
- 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
- Open the JSON file that was downloaded in any text/code editor.
- Enable and setup Google Cloud Storage actions in Looker
- In your Looker instance go to Admin → Platform → Actions. Scroll to find the Google Cloud Storage section and click on "Enable"
- Fill the settings form with the help of the JSON file:
- Client Email: Use client_email from JSON
- Private Key: Use private_key from JSON
- Example:
-----BEGIN PRIVATE KEY-----\nPRIVATE_KEY_DATA\n——END PRIVATE KEY-----\n
- Project ID: Use project_id from JSON
- Example:
project9skd34j5b2cj
- You can click on “Test” to confirm the configuration is correct and then save it.
Usage
- In Looker, open a View, Dashboard or Explore data that you would like to send.
- Open the Schedule delivery modal, set the desired occurrence.
- For destination select "Google Cloud Storage"
- Select the destination bucket, then optionally set the filename.
- Select the desired format and click Send/Save.