You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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
The text was updated successfully, but these errors were encountered:
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
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
The text was updated successfully, but these errors were encountered: