I'm trying to create a Connection between Looker and Supabase (uses PostgreSQL 9.5+), and after creating a schema and selecting the PostgreSQL 9.5+ dialect, Testing the Connection seemed to go alright.
However, when selecting fields in an Explore, the queries that Looker produces don't seem to be written in PostgreSQL; they include backticks and the pivot() function which aren't valid PostgreSQL syntax. These queries also throw errors when run. Is this a bug?
LinkedIn
Twitter
