I’ve scoured Looker Discourse for the answer to my question, but it doesn’t appear that this question has been asked yet:
- Does looker SQL Runner have a limit to how many rows or characters a query can be? Not the limit in the results (which I know is 5,000 rows max), but rather a limit of rows/characters for an SQL query?
I have a piece of code that is approx. 670 rows (about 74K characters with spaces) - mostly due to syntax of how I typically write SQL.
Syntax example (this is just easier for me to read in case I need to revisit this code months in the future):
- With this piece of code, I get an error that states that the SQL came to an unexpected end:
However, if I condense the select all in the bottom code that references the master_aggregated table, to the following; the query runs perfectly fine:
If you look at both screen shots, the only literal differences between the two is that the select all at the bottom has been reduced to 1 line instead of 3 and the “from” and “join” conditions above the select all has been reduced to 1 line instead of 4.
Not entirely sure if this is a Google Bigquery issue or a Looker issue (or both), but any advice or insight would be appreciated.