Looker Scheduled Export to GCS

[lautarodb]

Hello! I'm in need of exporting a table from Looker to an external Google Cloud Storage bucket.

I've searched for documentation, but the only resources I've found date back to 2018 (https://www.googlecloudcommunity.com/gc/Administering-Looker/Looker-Actions-Google-Cloud-Storage/m-p...). Additionally, there's this marketplace action (https://marketplace.looker.com/marketplace/action/send-to-google-cloud-storage), which states: "The Google Cloud Storage Action allows users to send Looker-generated results into your organization’s Google Cloud Storage account."

My aim is to export the scheduled report to another organization's cloud project. Has anyone accomplished something similar in the past?

Thank you!

[jclooker]

This should be possible as long as they can create a service account with access to the GCS bucket and provide you the 

• Service account email
• Key
• Project ID where the GCS bucket resides

You can then restrict access to users with this ability to send data via actions by giving only certain users the "send_to_integration" permission.

[z_k]

@lautarodb were you able to successfully implement this? Insofar as I can tell - the service account would basically need read / write access to the full project they create? That feels very broad for this purpose.