Incubator-superset: Can Snowflake be used as metadata database in Superset?
Can Snowflake be used as metadata database in Superset?
sarithapodali
All 2 comments
Issue-Label Bot is automatically applying the label #question to this issue, with a confidence of 0.66. Please mark this comment with :thumbsup: or :thumbsdown: to give our bot feedback!
Links: app homepage, dashboard and code for this bot.
![issue-label-bot[bot] picture](https://avatars2.githubusercontent.com/in/27079?v=4&s=40)
issue-label-bot[bot]
on 17 Dec 2019
👍1
The short answer is no. Snowflake is very limited in functionality found in typical OLTP databases (e.g. only supports constraints and primary/foreign keys for documentation purposes), and in general performs poorly (high latency) for high frequency queries. You're best off keeping your metadata in Postgres or MySQL, and using Snowflake for analytical workloads.
villebro
on 17 Dec 2019
👍3
Was this page helpful?
0 / 5 - 0 ratings
Related issues
ghost
路
3Comments
josephtyler
路
3Comments
gbrian
路
3Comments
shyam2794
路
3Comments
ylkjick532428
路
3Comments
Most helpful comment
The short answer is no. Snowflake is very limited in functionality found in typical OLTP databases (e.g. only supports constraints and primary/foreign keys for documentation purposes), and in general performs poorly (high latency) for high frequency queries. You're best off keeping your metadata in Postgres or MySQL, and using Snowflake for analytical workloads.