Add support for Snowflake's date and time literals

databrickslabs / remorph

Cross-compiler and Data Reconciler into Databricks Lakehouse

Other

21 stars 13 forks source link

Add support for Snowflake's date and time literals #536

Closed vil1 closed 1 month ago

vil1 commented 1 month ago

It seems undocumented (maybe it is a deprecated feature), but Snowflake seems to accept date and timestamp literals expressed like DATE'2024-07-08' or TIMESTAMP'2024-07-08 15:50:00' (this has been confirmed by @vijaypavann-db on a real snowflake instance). This PR introduces support for this syntax.

github-actions[bot] commented 1 month ago

Coverage tests results

394 tests ±0 357 :white_check_mark: +4 5s :stopwatch: -1s 2 suites ±0 2 :zzz: ±0 2 files ±0 35 :x: - 4

For more details on these failures, see this check.

Results for commit 511d4293. ± Comparison against base commit 65aef2b9.