sodadata / soda-core

:zap: Data quality testing for the modern data stack (SQL, Spark, and Pandas) https://www.soda.io
https://go.soda.io/core-docs
Apache License 2.0
1.93k stars 211 forks source link

Snowflake Regex Collate error #1987

Open Schujungron opened 10 months ago

Schujungron commented 10 months ago

It seems like this issue was discovered previously and also fixed #https://github.com/sodadata/soda-sql/issues/201 but i still get this error:

001045 (22023): SQL compilation error: | argument needs to be a string: 'RATES.CONVERSION_RATE'

It is created by Soda including COLLATE('column', '') into the SQL Statement. When i execute the statement manually in Snowflake without COLLATE, it works fine.

This is my checks.yml:

checks for RATES:

tools-soda commented 10 months ago

SAS-2696