TrinoUserError(type=USER_ERROR, name=SYNTAX_ERROR, message="line 1:145: mismatched input '<EOF>'
12:04 07 Dec 2025

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 ''. Expecting: 'ALTER', 'ANALYZE', 'CALL', 'COMMENT', 'COMMIT', 'CREATE', 'DEALLOCATE', 'DELETE', 'DENY', 'DESC', 'DESCRIBE', 'DROP', 'EXECUTE', 'EXPLAIN', 'GRANT', 'INSERT', 'MERGE', 'PREPARE', 'REFRESH', 'RESET', 'REVOKE', 'ROLLBACK', 'SET', 'SHOW', 'START', 'TRUNCATE', 'UPDATE', 'USE', 'WITH', ",

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
dbt trino