Connecting Looker to TimescaleDB

[moligslagers]

Hey there,

I was wondering if anyone has experience with connecting a TimescaleDB (https://www.timescale.com) to Looker and can help me out with an experience report or any resources on that matter. Some questions I have:

• Is a connection possible at all? I know that its not in the sql dialects listed by looker, but its basically a postgres database optimized for time series
• If a connection is possible, are there any limitations to what queries you can run against it?
• Can you use timescale specific functions like time buckets when defining views?

I will take it for a test drive anyway, but I though maybe someone already did that before me and is willing to share some insights. If not, I’m happy to share my learnings from it.