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.