Direct query with snowflake

Hi Deepanshu_46 ,

The error message you provided indicates that there is an issue with the local evaluation of Table.Join or Table.NestedJoin with key equality compares. This error message can occur when the key columns in the tables being joined do not match, or when the data types of the key columns are different.

Here are some possible solutions to this error message:
- Ensure that the key columns in the tables being joined match.
- Ensure that the data types of the key columns are the same.
- Check if there are any null values in the key columns of the tables being joined.
- Try cleaning the data load cache by going to File -> Options and Settings -> Options -> Data Load -> Clear cache and Save the file and Load again.
- Check if there are any table/column names that do not match in your data source.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.