Skip to content

Latest commit

 

History

History
9 lines (7 loc) · 604 Bytes

design.md

File metadata and controls

9 lines (7 loc) · 604 Bytes

Design for the Snowflake Virtual Schema adapter

General design notes

The snowflake virtual schema's capabilities, mapping and query pushdown are mainly based on the existing PostgreSql virtual schema. This is because the PostgreSql database approaches Snowflake the closest, functionality wise. Currently there are few deviations but this is expected to change.

Notes on NUMERIC

The numeric datatype has a higher supported precision in Snowflake (38 vs 36 in Snowflake): If the precision is higher than 36 the column gets mapped to varchar and will display 'Precision not supported' as value.