Column not found [Snowflake]

[lassebenni]

Hi,

I am trying to diff two tables in Snowflake using data-diff version 0.3.0rc2

data-diff \
"snowflake://<USER>:<PASS>@<ACCOUNT>/<DATABASE>/<SCHEMA>?warehouse=<WAREHOUSER>&role=ACCOUNTADMIN" \
DIM_CUSTOMERS \
  PR.DIM_CUSTOMERS \
  -k CUSTOMER_ID \
  -c LAST_NAME \
  -m test_results_%t \
  --materialize-all-rows \
  --table-write-limit 10000

But getting the error:

ValueError: Column 'LAST_NAME' not found in: <data_diff.databases.snowflake.Snowflake object at 0x10c4a73d0>/DIM_CUSTOMERS, <data_diff.databases.snowflake.Snowflake object at 0x10c4a73d0>/PR.DIM_CUSTOMERS

Eventhough the LAST_NAME customer does exist (in both tables). Same issue with other columns I try to specify. It only works without specifying any additional columns next to the key column.

Any thoughts?

[erezsh]

Can you share the schema of the table? (just the column involved should be fine)

[lassebenni]

Sure! This is the schema

[erezsh]

Thank you for reporting it!

I believe I solved the bug. You can try it from the master branch.

[lassebenni]

I can confirm it works! Thanks for the effort!