Looker Actions - Google Cloud Storage
Looker is launching a Google Cloud Storage action, allowing customers to send data to Google Cloud Storage from within Looker. This action will allow Looker customers ti send Looker data to Google Cloud Storage on a one-off or scheduled basis.
Enable the Google Cloud Storage Action
Note: Your Looker instance must be on Looker 5.6+.
Customer-hosted instances may be unable to enable actions from the Looker Action Hub, especially actions that support streamed results or that use OAuth, if the customer-hosted Looker instance does not fulfill these requirements.
See the Sharing Data Through an Action Hub documentation page for suggested solutions to this potential issue.
To enable the action in Looker, go to your Admin panel and the Actions Tab under the Platform header [your-instance.looker.com/admin/actions]. (Admin > Platform > Actions)
Select “Enable” on the Action you would like to enable.
In your Google Cloud console [https://console.cloud.google.com]:
Enable the Google Cloud Storage API and Google Cloud Storage JSON API.
Generate a Service Account with permissions to create objects in GCS.
Create a Service Account Key (with Storage Admin role) and download the JSON key file. [https://console.cloud.google.com/apis/credentials]
Note the Project Id, Client Email, Private Key (everything inside the quotation mark, including the comment and “/n” ) in the key file.
Copy your Google Cloud Storage API key and paste into the Looker Actions Page.
Send data to Google Cloud Storage
Great, now you’ve setup your API keys so that Looker can communicate with Google Cloud!
Create and Send or Schedule a Report
In the Send or Schedule window’s Destination field, select “Google Cloud Storage”.
In the Bucket field, specify the Google Cloud Bucket location for the data file.
Optionally, in the Filename field, type the name for the data file. Include the appropriate file extension.
Your data will be in your Google Cloud Storage bucket!