Welcome
Please read these before using scripts in this repository:
- The Support Team does NOT support these scripts. These are scripts written, collected, or adapted by me personally and are not guaranteed or waranteed by Looker / GCP in any way. Please do not contact Looker Support about these scripts. Instead consider posting in the community or open an issue on this repository
- These scripts are not regularly tested, and may be out of date with later versions of Looker.
- Python scripts heavily use the
looker_sdkandpandas - Unless explicitely mentioned in a script's README, download scripts do not support dashboards that use merged results tiles.
Python Scripts
DownloadMultiTileTabbed- Downloads a singular dashboard with any number of tiles as a Tabbed Excel fileDownloadMultiLookTabbed- Downloads any number of Looks as a single Tabbed Excel fileDownloadDashboardUnlimited- Downloads unlimited results from a singular dashboard with any number of tiles as a Tabbed Excel file.DownloadDifferentDelimiter- Downloadscsvs with a custom delimiterDownloadCSVorExcel- Downloads a dashboard as a series of eithercsvorxlsxfiles instead of the defaultcsv_zipDownloadUnlimitedMergedv1- Downloads unlimited results from a merged results dashboard tile, as a set ofcsvfiles (one for each merged query).DownloadUnlimitedMergedv2- Downloads unlimited results from a merged results dashboard tile, as a single CSV with merged queries joined. This has limitations, see notes in script.FetchDashboardType- Checks thepreferred_viewerparameter of all dashboards on an instance and outputs lists of dashboard ids and their types.
JS / Sheet Scripts
GoogleSheets_AutoRefresh- Similar to the Sheets Looker Action. Imports data from a Look into a Google Sheet and pulls new data each time the sheet is opened. Note: Last tested 12/2019