TidierOrg / TidierDB.jl

Tidier database analysis in Julia, modeled after the dbplyr R package.
MIT License
35 stars 3 forks source link

Snowflake is case insensitive but TidierDB metadata is case sensitive #31

Closed drizk1 closed 3 weeks ago

drizk1 commented 3 weeks ago

This creates mismatches periodically where the metadata won't update because it there's a difference in case, or it causes issues around joining.

Solution is probably to make it so if sql mode is :snowflake change the col_names to uppercase so that way TidierDB can stay case sensitive.

This would mainly apply to select, mutate, summarize, and group_by and any place parse_tidy_db is used.

This should be straightforward to fix