Good morning,
I’m having trouble downloading the CSV or XLS file when I create a merged query.
Does anyone have any idea how I can solve this?
In Looker, merged results are built client-side in the browser rather than server-side in the database, so the export options are limited compared to standard queries. When you merge queries, Looker can’t always regenerate a single SQL statement to run on the backend, which means large merged result sets or certain visualizations may disable the Download button for CSV or XLS exports. This is by design to prevent incomplete or inconsistent exports.
To work around it, first check that each underlying query runs and can be downloaded individually. If they can, you can export those results separately and combine them outside Looker, or use a derived table or LookML model to join the data at the database level so Looker treats it as a single query. In cases where you must export merged results, switch to the Explore view for a smaller subset of data or use the Schedule feature to send results to Google Sheets or BigQuery, which supports larger merged exports.
—Taz
1 Like
Oops I accidentally deleted my previous reply, when I meant to edit it to clarify a point…
Save the merged query as a new dashboard / as a tile on an existing dashboard. Then open the dashboard and select the download option from the dashboard action menu. This is how I download the results from merged queries.