Get hands-on experience with 20+ free Google Cloud products and $300 in free credit for new customers.

Looker Connection using PostgreSQL 9.5+

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?

0 0 63
0 REPLIES 0