Hi all, In package 0.15.2 I am getting some syntax...
# community-support
a
Hi all, In package 0.15.2 I am getting some syntax errors when running tests on Redshift (1.0.67305): • When configuring tests without a timestamp I get
[42601] ERROR: syntax error at or near "from"
. The culprit seems to be a misplaced
,
in
dbt_packages/elementary/macros/edr/data_monitoring/monitors_query/column_monitoring_query.sql
at the end of line 36:
{{ elementary.null_timestamp() }} as start_bucket_in_data,
• When configuring volume or column anomaly tests with dimensions that are boolean I get
[42846] ERROR: cannot cast type boolean to character varying
. The same sql code is trying to cast from boolean to varchar, something Redshift isn't liking one bit.