data-diff icon indicating copy to clipboard operation
data-diff copied to clipboard

Support quoted identifier dbt_project.yml config

Open dlawin opened this issue 2 years ago • 1 comments

Parse the setting here and utilize it when constructing comparison paths: https://docs.getdbt.com/reference/project-configs/quoting

If I set that to true and use lowercase table names with Snowflake for example, none of my tables are diffed appropriately.

dlawin avatar Jul 10 '23 18:07 dlawin

I have the same problem. From debug:

15:47:56 DEBUG    Running SQL (Snowflake): SELECT column_name, data_type, datetime_precision, numeric_precision,    base.py:354
                  numeric_scale FROM DATABASE.information_schema.columns WHERE table_name = 'DIMCARD' AND
                  table_schema = 'DBT'
15:47:57 DEBUG    Snowflake: Table 'DATABASE.DBT.DIMCARD' does not exist, or has no columns

We use quotations for table names and the table is called "DimUser"

michelr avatar Jul 12 '23 14:07 michelr

Hi @dlawin and @michelr,

I'm sorry for the delay in following up on this. Thank you for taking the time to raise this issue!

We made a hard decision to sunset the data-diff package and won't provide further development or support.

If that's of any help, quoted table names are supported when diffing in Datafold Cloud.

-Gleb

glebmezh avatar May 17 '24 13:05 glebmezh