spectacles-ci
SQL returned by the Looker API differs from executed
I've identified an issue with Looker where the SQL query string returned by the Query API is not the same as the query actually executed against the data warehouse.
Looker prepends a comment in the first line, and I've identified cases where a few extra newlines are added in spots. This means that the error line number returned by the warehouse (and subsequently by Looker) doesn't match up with the error-causing line in the SQL returned by Looker.
Because of the arbitrary newlines, I can't account for this by assuming an extra line at the start, so this effectively breaks the ability to preview the SQL line that caused the error.
I'll update this issue once I have the bug reference number back from Looker.
Oof. That's annoying. Have they indicated that this is something they hope to resolve?
On Snowflake customers, I'm now seeing these comments at the bottom of the SQL, not the top. I've asked Looker if that's the case for all warehouses. If so, this might now be resolved.