Support Looker - Githubissues

MaterializeInc / materialize

The Cloud Operational Data Store: use SQL to transform, deliver, and act on fast-changing data.

https://materialize.com

Other

5.72k stars 466 forks source link

Support Looker #9531

Open andrioni opened 2 years ago

andrioni commented 2 years ago

Looker is a popular data visualization/data exploration/BI tool, now owned by Google.

This is an umbrella issue to track the work required to make Looker work out of the box with Materialize, when using the Postgres connector (via pgjdbc).

Open issues

[x] #9181
[x] #9243
[x] #10691
[x] #10693

Note: the list above is not exhaustive.

nmeagan11 commented 2 years ago

For tracking purposes, pasting a request from the Community Slack: https://materializecommunity.slack.com/archives/C031905K62Y/p1645121513398759

ruf-io commented 1 year ago

Checking in on this again in August 2023:

Initial connection test procedure partially fails with Test kill: Cannot cancel queries: Internal Error in Query Killing Test: Java::OrgPostgresqlUtil::PSQLException: ERROR: unknown catalog item 'pg_stat_activity'

But introspecting and querying schemas/views/tables in SQL Runner works fine.