Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Snowflake Regex Collate error #1987

Open
Schujungron opened this issue Jan 13, 2024 · 1 comment
Open

Snowflake Regex Collate error #1987

Schujungron opened this issue Jan 13, 2024 · 1 comment

Comments

@Schujungron
Copy link

It seems like this issue was discovered previously and also fixed #sodadata/soda-sql#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:

  • invalid_count(conversion_rate) = 0:
    valid format: positive decimal
@tools-soda
Copy link

SAS-2696

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants