I can not understand this problem. Help!!!
If I am doing dbt compile code and try to debeaver in trino - it works properly , but after dbt run I get error
TrinoUserError(type=USER_ERROR, name=SYNTAX_ERROR, message="line 1:145: mismatched input '
WITH params AS (
SELECT DATE '{{ var("dm_date") }}' AS target_date
),
-- Сырые ивенты
events_all AS (
SELECT
event_date,
event_datetime,
os_name,
event_name,
adv_uid,
app_version_name,
CAST(CASE WHEN source_category_id IS NOT NULL THEN 1 ELSE 0 END AS TINYINT) AS cat_nesting_lvl,
magnit_id AS magnit_id_s,
CASE
WHEN event_name LIKE '%\_click' ESCAPE '\\' THEN 'post_click'
WHEN event_name LIKE '%\_view' ESCAPE '\\' THEN 'post_view'
ELSE 'unknown'
END AS attr_type_action
FROM (
SELECT
e.event_date,
e.event_datetime,
e.os_name,
e.event_name,
adv_uid,
e.app_version_name,
e.source_category_id,
e.magnit_id
FROM {{ source('object_storage_raw_loyalty', 'loyalty_events') }} AS e
INNER JOIN (
SELECT DISTINCT adv_uid
FROM (
SELECT adv_uid
FROM {{ source('prod_clickhouse_sql', 'adtech_media_raw_data_banad') }}
WHERE date_from <= (SELECT target_date FROM params)
AND date_to >= (SELECT target_date FROM params)
AND replace(replace(replace(scu_list, '[', ''), ']', ''), '''', '') <> ''
UNION ALL
SELECT adv_uid
FROM {{ source('prod_clickhouse_sql', 'adtech_media_raw_data_modalwindow') }}
WHERE date_from <= (SELECT target_date FROM params)
AND date_to >= (SELECT target_date FROM params)
AND replace(replace(replace(scu_list, '[', ''), ']', ''), '''', '') <> ''
UNION ALL
SELECT adv_uid
FROM {{ source('prod_clickhouse_sql', 'adtech_media_raw_data_pins') }}
WHERE date_from <= (SELECT target_date FROM params)
AND date_to >= (SELECT target_date FROM params)
AND replace(replace(replace(scu_list, '[', ''), ']', ''), '''', '') <> ''
)
) u USING (adv_uid)
WHERE event_date_partition = (SELECT CAST(target_date AS VARCHAR) FROM params)
AND (
e.event_name LIKE '%\_view' ESCAPE '\\'
OR e.event_name LIKE '%\_click' ESCAPE '\\'
)
AND (
e.event_name LIKE '%embedded_bannerItem%'
OR e.event_name LIKE '%advModalWindow_productCarousel_item%'
OR e.event_name LIKE '%item_view%'
OR e.event_name LIKE '%item_click%'
)
AND adv_uid NOT IN ('', 'null', 'unknown')
AND e.magnit_id NOT IN ('', 'null', 'unknown')
)
)
SELECT * FROM events_all