Improve `SnowflakeDecode`

estie-inc / snowflake-connector-rs

Snowflake Connector for Rust

MIT License

20 stars 8 forks source link

Open tamaroning opened 4 months ago

tamaroning commented 4 months ago

The current implementation cannot decode some types. For example, only true and false are expected for booleans but API may return true, t, yes, y, on, 1, etc. https://docs.snowflake.com/en/sql-reference/data-types-logical#boolean-conversion

tamaroning commented 3 months ago

Supported Snowflake types and corresponding Rust types

[x] boolean: bool
[x] text: String
[x] fixed, real: f64
[x] time: chrono::NativeTime
[x] date: chrono::NativeDate
[x] timestamp_ntz/ltz/tz: chrono::NativeDateTime
- ltz may not be supported for now. TODO: check
[ ] array: Vec
[ ] object: TBA
[ ] variant: TBA
[ ] map: HashMap<String, f64>
[ ] GEOGRAPHY: TBA
[ ] GEOMETRY: TBA