search

quadratichq / quadratic

Quadratic | Spreadsheet with Python, SQL, and AI
https://QuadraticHQ.com
Other
3.04k stars 155 forks source link

SQL connectors implementation list #1425

Open luke-quadratic opened 5 months ago

luke-quadratic commented 5 months ago

We are shipping PostgreSQL and MySQL as part of our v1 SQL release in July.

For users seeking other connection services (databases, warehouses, etc) please comment on this issue with your connection service you want built - this will help us prioritize what to build next.

Completed PostgreSQL MySQL MS SQL Server Snowflake

Prio for connections not yet getting worked on Tier 1 prio Athena BigQuery Databricks

Tier 2 prio MongoDB MariaDB SQLite Redshift Clickhouse CockroachDB (easy implementation but less popular request)

Tier 3 prio Alloy Dremio GCloud SQL Materialize Minds Motherduck Presto Starburst Teradata Trino

pivotjosiah commented 5 months ago

I use conferences to gauge the current state of things. For what it's worth, I just got back from a Databricks conference and there were 16,000 people in attendance plus another ~30,000 remote attendees. I've used Snowflake in the past and one of the big topics at the conference was how to migrate Snowflake data warehouses to Databricks. A dedicated connector with SSO compatibility would be a game changer for us.

As it stands right now, it sounds like we'd need to write our own python endpoint that takes an SQL query and an SSO token in order to talk to Databricks. That's doable, it's just a bit of overhead for getting people onboarded with Quadratic HQ. We're a startup with ~500 people right now.