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

check-script-has-no-table-name fails with TRIM function #143

Open
emmaauerbach opened this issue Jul 26, 2023 · 0 comments
Open

check-script-has-no-table-name fails with TRIM function #143

emmaauerbach opened this issue Jul 26, 2023 · 0 comments
Labels
bug Something isn't working priority: high

Comments

@emmaauerbach
Copy link

Describe the bug
check-script-has-no-table-name fails when using the redshift TRIM function with the syntax TRIM( [ BOTH ] [trim_chars FROM ] string ] )

To Reproduce

{{ config(materialized='table') }}
WITH cte_name AS (
  SELECT * FROM {{ref('stg_table')}}
)

SELECT TRIM('trim_chars' FROM cte_name.column_name)
FROM cte_name
LIMIT 100

Expected behavior
This should not cause the check to fail, because after the FROM in the TRIM function it is not a table, but a column name.

Version:
v1.0.0

@emmaauerbach emmaauerbach added the bug Something isn't working label Jul 26, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working priority: high
Projects
None yet
Development

No branches or pull requests

2 participants