[Bug]: Merge 'when not matched' not wrapping values sources with quotes #247

alanspires · 2024-11-30T01:57:05Z

Is there an existing issue for this?

I have searched the existing issues

Current Behavior

In dremio I have the support key 'dremio.store.file.file-field-enabled' enabled which appends a column named '$file' to queries. This column lets me see the file source the data is coming from when querying object storage. After updating this package to 1.8.0 I now get an error when running incremental updates related to a special character within a column name

 ERROR: Encountered "( DBT_INTERNAL_SOURCE.$file" at line 25, column 9.

Expected Behavior

Quotes around the column names.

Steps To Reproduce

No response

Environment

- OS:Ubuntu 22.04
- dbt-dremio:1.8.0
- dbt-core: 1.8.7
- Dremio Cloud: N/A

Relevant log output

merge into "unified"."test" as DBT_INTERNAL_DEST
        using "unified"."test__dbt_tmp" as DBT_INTERNAL_SOURCE
        on (
                DBT_INTERNAL_SOURCE.id = DBT_INTERNAL_DEST.id
            )

    
    when matched then update set
        "$file" = DBT_INTERNAL_SOURCE."$file","author" = DBT_INTERNAL_SOURCE."author","content" = DBT_INTERNAL_SOURCE."content","created_at" = DBT_INTERNAL_SOURCE."created_at","id" = DBT_INTERNAL_SOURCE."id"
    

    when not matched then insert
        ("$file", "author", "content", "created_at", "id")
    values
        (DBT_INTERNAL_SOURCE.$file,DBT_INTERNAL_SOURCE.author,DBT_INTERNAL_SOURCE.content,DBT_INTERNAL_SOURCE.created_at,DBT_INTERNAL_SOURCE.id)

The text was updated successfully, but these errors were encountered:

bcmeireles · 2025-01-15T16:20:14Z

Can you share the logs obtained when running in debug mode, please?

alanspires · 2025-03-09T23:25:16Z

The below log snippet shows an error that happens because the word 'hold' is a reserved word and also a column name. Thanks.

�[0m17:04:01.144040 [debug] [Thread-1 (]: dremio adapter: Job State = PLANNING
�[0m17:04:01.407426 [debug] [Thread-1 (]: dremio adapter: Job State = RUNNING
�[0m17:04:01.936491 [debug] [Thread-1 (]: dremio adapter: Job State = COMPLETED
�[0m17:04:01.937733 [debug] [Thread-1 (]: dremio adapter: SQL status: 0 in 1.12 seconds
�[0m17:04:02.003249 [debug] [Thread-1 (]: dremio adapter: Using dremio connection "model.dremio.raw__test_pm20000". fetch=True
�[0m17:04:02.004247 [debug] [Thread-1 (]: dremio adapter: On model.dremio.raw__test_pm20000: /* {"app": "dbt", "dbt_version": "1.9.1", "profile_name": "dremio", "target_name": "dev", "node_id": "model.dremio.raw__test_pm20000"} */

    select column_name as column_name
        ,lower(data_type) as data_type
        ,character_maximum_length
        ,numeric_precision
        ,numeric_scale
    from information_schema.columns
    where ilike(table_schema, 'unified')
    and ilike(table_name, 'raw__test_pm20000__dbt_tmp')
    order by ordinal_position
  
�[0m17:04:02.330870 [debug] [Thread-1 (]: dremio adapter: Job State = RUNNING
�[0m17:04:02.594504 [debug] [Thread-1 (]: dremio adapter: Job State = COMPLETED
�[0m17:04:02.664193 [debug] [Thread-1 (]: dremio adapter: SQL status: 82 in 0.66 seconds
�[0m17:04:02.668193 [debug] [Thread-1 (]: dremio adapter: Using dremio connection "model.dremio.raw__test_pm20000". fetch=True
�[0m17:04:02.668193 [debug] [Thread-1 (]: dremio adapter: On model.dremio.raw__test_pm20000: /* {"app": "dbt", "dbt_version": "1.9.1", "profile_name": "dremio", "target_name": "dev", "node_id": "model.dremio.raw__test_pm20000"} */

    select column_name as column_name
        ,lower(data_type) as data_type
        ,character_maximum_length
        ,numeric_precision
        ,numeric_scale
    from information_schema.columns
    where ilike(table_schema, 'unified')
    and ilike(table_name, 'raw__test_pm20000')
    order by ordinal_position
  
�[0m17:04:02.994783 [debug] [Thread-1 (]: dremio adapter: Job State = RUNNING
�[0m17:04:03.260357 [debug] [Thread-1 (]: dremio adapter: Job State = COMPLETED
�[0m17:04:03.333156 [debug] [Thread-1 (]: dremio adapter: SQL status: 82 in 0.66 seconds
�[0m17:04:03.340156 [debug] [Thread-1 (]: dremio adapter: Using dremio connection "model.dremio.raw__test_pm20000". fetch=True
�[0m17:04:03.340156 [debug] [Thread-1 (]: dremio adapter: On model.dremio.raw__test_pm20000: /* {"app": "dbt", "dbt_version": "1.9.1", "profile_name": "dremio", "target_name": "dev", "node_id": "model.dremio.raw__test_pm20000"} */

    select column_name as column_name
        ,lower(data_type) as data_type
        ,character_maximum_length
        ,numeric_precision
        ,numeric_scale
    from information_schema.columns
    where ilike(table_schema, 'unified')
    and ilike(table_name, 'raw__test_pm20000')
    order by ordinal_position
  
�[0m17:04:03.666652 [debug] [Thread-1 (]: dremio adapter: Job State = RUNNING
�[0m17:04:03.932283 [debug] [Thread-1 (]: dremio adapter: Job State = COMPLETED
�[0m17:04:04.004238 [debug] [Thread-1 (]: dremio adapter: SQL status: 82 in 0.66 seconds
�[0m17:04:04.036239 [debug] [Thread-1 (]: Writing runtime sql for node "model.dremio.raw__test_pm20000"
�[0m17:04:04.037238 [debug] [Thread-1 (]: dremio adapter: Using dremio connection "model.dremio.raw__test_pm20000". fetch=False
�[0m17:04:04.038241 [debug] [Thread-1 (]: dremio adapter: On model.dremio.raw__test_pm20000: /* {"app": "dbt", "dbt_version": "1.9.1", "profile_name": "dremio", "target_name": "dev", "node_id": "model.dremio.raw__test_pm20000"} */

        
    

    

    merge into "unified"."raw__test_pm20000" as DBT_INTERNAL_DEST
        using "unified"."raw__test_pm20000__dbt_tmp" as DBT_INTERNAL_SOURCE
        on (FALSE)

    

    when not matched then insert
        ("vchrnmbr", "vendorid", "doctype", "docdate", "docnumbr", "docamnt", "curtrxam", "distknam", "discamnt", "dscdlram", "bachnumb", "trxsorce", "bchsourc", "discdate", "duedate", "pordnmbr", "ten99amnt", "wrofamnt", "disamtav", "trxdscrn", "un1099am", "bktpuram", "bktfrtam", "bktmscam", "voided", "hold", "chekbkid", "dinvpdof", "ppsamded", "ppstaxrt", "pgramsbj", "gstdsamt", "posteddt", "ptdusrid", "mdfusrid", "pyenttyp", "cardname", "prchamnt", "trdisamt", "mscchamt", "frtamnt", "taxamnt", "ttlpymts", "curncyid", "pymtrmid", "shipmthd", "taxschid", "pchschid", "frtschid", "mscschid", "pstgdate", "disavtkn", "cntrltyp", "noteindx", "prctdisc", "retnagam", "ictrx", "tax_date", "prchdate", "corrctn", "simplifd", "bnkrcamt", "aplywith", "electronic", "ectrx", "docprinted", "taxinvreqd", "vndchknm", "backouttradedisc", "cbvat", "vadcdtro", "ten99type", "ten99boxnumber", "ponumber", "workflow_status", "invoicereceiptdate", "lngdesc", "dex_row_id", "lastmodified", "deleted_on", "pkey", "ingested_at")
    values
        (DBT_INTERNAL_SOURCE.vchrnmbr,DBT_INTERNAL_SOURCE.vendorid,DBT_INTERNAL_SOURCE.doctype,DBT_INTERNAL_SOURCE.docdate,DBT_INTERNAL_SOURCE.docnumbr,DBT_INTERNAL_SOURCE.docamnt,DBT_INTERNAL_SOURCE.curtrxam,DBT_INTERNAL_SOURCE.distknam,DBT_INTERNAL_SOURCE.discamnt,DBT_INTERNAL_SOURCE.dscdlram,DBT_INTERNAL_SOURCE.bachnumb,DBT_INTERNAL_SOURCE.trxsorce,DBT_INTERNAL_SOURCE.bchsourc,DBT_INTERNAL_SOURCE.discdate,DBT_INTERNAL_SOURCE.duedate,DBT_INTERNAL_SOURCE.pordnmbr,DBT_INTERNAL_SOURCE.ten99amnt,DBT_INTERNAL_SOURCE.wrofamnt,DBT_INTERNAL_SOURCE.disamtav,DBT_INTERNAL_SOURCE.trxdscrn,DBT_INTERNAL_SOURCE.un1099am,DBT_INTERNAL_SOURCE.bktpuram,DBT_INTERNAL_SOURCE.bktfrtam,DBT_INTERNAL_SOURCE.bktmscam,DBT_INTERNAL_SOURCE.voided,DBT_INTERNAL_SOURCE.hold,DBT_INTERNAL_SOURCE.chekbkid,DBT_INTERNAL_SOURCE.dinvpdof,DBT_INTERNAL_SOURCE.ppsamded,DBT_INTERNAL_SOURCE.ppstaxrt,DBT_INTERNAL_SOURCE.pgramsbj,DBT_INTERNAL_SOURCE.gstdsamt,DBT_INTERNAL_SOURCE.posteddt,DBT_INTERNAL_SOURCE.ptdusrid,DBT_INTERNAL_SOURCE.mdfusrid,DBT_INTERNAL_SOURCE.pyenttyp,DBT_INTERNAL_SOURCE.cardname,DBT_INTERNAL_SOURCE.prchamnt,DBT_INTERNAL_SOURCE.trdisamt,DBT_INTERNAL_SOURCE.mscchamt,DBT_INTERNAL_SOURCE.frtamnt,DBT_INTERNAL_SOURCE.taxamnt,DBT_INTERNAL_SOURCE.ttlpymts,DBT_INTERNAL_SOURCE.curncyid,DBT_INTERNAL_SOURCE.pymtrmid,DBT_INTERNAL_SOURCE.shipmthd,DBT_INTERNAL_SOURCE.taxschid,DBT_INTERNAL_SOURCE.pchschid,DBT_INTERNAL_SOURCE.frtschid,DBT_INTERNAL_SOURCE.mscschid,DBT_INTERNAL_SOURCE.pstgdate,DBT_INTERNAL_SOURCE.disavtkn,DBT_INTERNAL_SOURCE.cntrltyp,DBT_INTERNAL_SOURCE.noteindx,DBT_INTERNAL_SOURCE.prctdisc,DBT_INTERNAL_SOURCE.retnagam,DBT_INTERNAL_SOURCE.ictrx,DBT_INTERNAL_SOURCE.tax_date,DBT_INTERNAL_SOURCE.prchdate,DBT_INTERNAL_SOURCE.corrctn,DBT_INTERNAL_SOURCE.simplifd,DBT_INTERNAL_SOURCE.bnkrcamt,DBT_INTERNAL_SOURCE.aplywith,DBT_INTERNAL_SOURCE.electronic,DBT_INTERNAL_SOURCE.ectrx,DBT_INTERNAL_SOURCE.docprinted,DBT_INTERNAL_SOURCE.taxinvreqd,DBT_INTERNAL_SOURCE.vndchknm,DBT_INTERNAL_SOURCE.backouttradedisc,DBT_INTERNAL_SOURCE.cbvat,DBT_INTERNAL_SOURCE.vadcdtro,DBT_INTERNAL_SOURCE.ten99type,DBT_INTERNAL_SOURCE.ten99boxnumber,DBT_INTERNAL_SOURCE.ponumber,DBT_INTERNAL_SOURCE.workflow_status,DBT_INTERNAL_SOURCE.invoicereceiptdate,DBT_INTERNAL_SOURCE.lngdesc,DBT_INTERNAL_SOURCE.dex_row_id,DBT_INTERNAL_SOURCE.lastmodified,DBT_INTERNAL_SOURCE.deleted_on,DBT_INTERNAL_SOURCE.pkey,DBT_INTERNAL_SOURCE.ingested_at)


�[0m17:04:04.369466 [debug] [Thread-1 (]: dremio adapter: Job State = FAILED
�[0m17:04:04.370475 [debug] [Thread-1 (]: dremio adapter: Error running SQL: /* {"app": "dbt", "dbt_version": "1.9.1", "profile_name": "dremio", "target_name": "dev", "node_id": "model.dremio.raw__test_pm20000"} */

        
    

    

    merge into "unified"."raw__test_pm20000" as DBT_INTERNAL_DEST
        using "unified"."raw__test_pm20000__dbt_tmp" as DBT_INTERNAL_SOURCE
        on (FALSE)

    

    when not matched then insert
        ("vchrnmbr", "vendorid", "doctype", "docdate", "docnumbr", "docamnt", "curtrxam", "distknam", "discamnt", "dscdlram", "bachnumb", "trxsorce", "bchsourc", "discdate", "duedate", "pordnmbr", "ten99amnt", "wrofamnt", "disamtav", "trxdscrn", "un1099am", "bktpuram", "bktfrtam", "bktmscam", "voided", "hold", "chekbkid", "dinvpdof", "ppsamded", "ppstaxrt", "pgramsbj", "gstdsamt", "posteddt", "ptdusrid", "mdfusrid", "pyenttyp", "cardname", "prchamnt", "trdisamt", "mscchamt", "frtamnt", "taxamnt", "ttlpymts", "curncyid", "pymtrmid", "shipmthd", "taxschid", "pchschid", "frtschid", "mscschid", "pstgdate", "disavtkn", "cntrltyp", "noteindx", "prctdisc", "retnagam", "ictrx", "tax_date", "prchdate", "corrctn", "simplifd", "bnkrcamt", "aplywith", "electronic", "ectrx", "docprinted", "taxinvreqd", "vndchknm", "backouttradedisc", "cbvat", "vadcdtro", "ten99type", "ten99boxnumber", "ponumber", "workflow_status", "invoicereceiptdate", "lngdesc", "dex_row_id", "lastmodified", "deleted_on", "pkey", "ingested_at")
    values
        (DBT_INTERNAL_SOURCE.vchrnmbr,DBT_INTERNAL_SOURCE.vendorid,DBT_INTERNAL_SOURCE.doctype,DBT_INTERNAL_SOURCE.docdate,DBT_INTERNAL_SOURCE.docnumbr,DBT_INTERNAL_SOURCE.docamnt,DBT_INTERNAL_SOURCE.curtrxam,DBT_INTERNAL_SOURCE.distknam,DBT_INTERNAL_SOURCE.discamnt,DBT_INTERNAL_SOURCE.dscdlram,DBT_INTERNAL_SOURCE.bachnumb,DBT_INTERNAL_SOURCE.trxsorce,DBT_INTERNAL_SOURCE.bchsourc,DBT_INTERNAL_SOURCE.discdate,DBT_INTERNAL_SOURCE.duedate,DBT_INTERNAL_SOURCE.pordnmbr,DBT_INTERNAL_SOURCE.ten99amnt,DBT_INTERNAL_SOURCE.wrofamnt,DBT_INTERNAL_SOURCE.disamtav,DBT_INTERNAL_SOURCE.trxdscrn,DBT_INTERNAL_SOURCE.un1099am,DBT_INTERNAL_SOURCE.bktpuram,DBT_INTERNAL_SOURCE.bktfrtam,DBT_INTERNAL_SOURCE.bktmscam,DBT_INTERNAL_SOURCE.voided,DBT_INTERNAL_SOURCE.hold,DBT_INTERNAL_SOURCE.chekbkid,DBT_INTERNAL_SOURCE.dinvpdof,DBT_INTERNAL_SOURCE.ppsamded,DBT_INTERNAL_SOURCE.ppstaxrt,DBT_INTERNAL_SOURCE.pgramsbj,DBT_INTERNAL_SOURCE.gstdsamt,DBT_INTERNAL_SOURCE.posteddt,DBT_INTERNAL_SOURCE.ptdusrid,DBT_INTERNAL_SOURCE.mdfusrid,DBT_INTERNAL_SOURCE.pyenttyp,DBT_INTERNAL_SOURCE.cardname,DBT_INTERNAL_SOURCE.prchamnt,DBT_INTERNAL_SOURCE.trdisamt,DBT_INTERNAL_SOURCE.mscchamt,DBT_INTERNAL_SOURCE.frtamnt,DBT_INTERNAL_SOURCE.taxamnt,DBT_INTERNAL_SOURCE.ttlpymts,DBT_INTERNAL_SOURCE.curncyid,DBT_INTERNAL_SOURCE.pymtrmid,DBT_INTERNAL_SOURCE.shipmthd,DBT_INTERNAL_SOURCE.taxschid,DBT_INTERNAL_SOURCE.pchschid,DBT_INTERNAL_SOURCE.frtschid,DBT_INTERNAL_SOURCE.mscschid,DBT_INTERNAL_SOURCE.pstgdate,DBT_INTERNAL_SOURCE.disavtkn,DBT_INTERNAL_SOURCE.cntrltyp,DBT_INTERNAL_SOURCE.noteindx,DBT_INTERNAL_SOURCE.prctdisc,DBT_INTERNAL_SOURCE.retnagam,DBT_INTERNAL_SOURCE.ictrx,DBT_INTERNAL_SOURCE.tax_date,DBT_INTERNAL_SOURCE.prchdate,DBT_INTERNAL_SOURCE.corrctn,DBT_INTERNAL_SOURCE.simplifd,DBT_INTERNAL_SOURCE.bnkrcamt,DBT_INTERNAL_SOURCE.aplywith,DBT_INTERNAL_SOURCE.electronic,DBT_INTERNAL_SOURCE.ectrx,DBT_INTERNAL_SOURCE.docprinted,DBT_INTERNAL_SOURCE.taxinvreqd,DBT_INTERNAL_SOURCE.vndchknm,DBT_INTERNAL_SOURCE.backouttradedisc,DBT_INTERNAL_SOURCE.cbvat,DBT_INTERNAL_SOURCE.vadcdtro,DBT_INTERNAL_SOURCE.ten99type,DBT_INTERNAL_SOURCE.ten99boxnumber,DBT_INTERNAL_SOURCE.ponumber,DBT_INTERNAL_SOURCE.workflow_status,DBT_INTERNAL_SOURCE.invoicereceiptdate,DBT_INTERNAL_SOURCE.lngdesc,DBT_INTERNAL_SOURCE.dex_row_id,DBT_INTERNAL_SOURCE.lastmodified,DBT_INTERNAL_SOURCE.deleted_on,DBT_INTERNAL_SOURCE.pkey,DBT_INTERNAL_SOURCE.ingested_at)


�[0m17:04:04.371471 [debug] [Thread-1 (]: On model.dremio.raw__test_pm20000: ROLLBACK
�[0m17:04:04.372472 [debug] [Thread-1 (]: dremio adapter: Handle rollback not implemented.
�[0m17:04:04.372472 [debug] [Thread-1 (]: On model.dremio.raw__test_pm20000: Close
�[0m17:04:04.377473 [debug] [Thread-1 (]: Runtime Error in model raw__test_pm20000 (models\raw\sks\raw__test_pm20000.sql)
  ERROR: Encountered ". hold" at line 17, column 749.
  Was expecting one of:
      ")" ...
      "," ...
      "." ...
      "." <IDENTIFIER> ...
      "." <QUOTED_IDENTIFIER> ...
      "." <BACK_QUOTED_IDENTIFIER> ...
      "." <BRACKET_QUOTED_IDENTIFIER> ...
      "." <UNICODE_QUOTED_IDENTIFIER> ...
      "NOT" ...
      "IN" ...
      "<" ...
      "<=" ...
      ">" ...
      ">=" ...
      "=" ...
      "<>" ...
      "!=" ...
      "BETWEEN" ...
      "LIKE" ...
      "SIMILAR" ...
      "+" ...
      "-" ...
      "*" ...
      "/" ...
      "%" ...
      "||" ...
      "AND" ...
      "OR" ...
      "IS" ...
      "MEMBER" ...
      "SUBMULTISET" ...
      "CONTAINS" ...
      "OVERLAPS" ...
      "EQUALS" ...
      "PRECEDES" ...
      "SUCCEEDS" ...
      "IMMEDIATELY" ...
      "MULTISET" ...
      "[" ...
      "FORMAT" ...
      "." "*" ...
      "(" ...
      
�[0m17:04:04.379476 [debug] [Thread-1 (]: Sending event: {'category': 'dbt', 'action': 'run_model', 'label': '8197a003-586f-41a9-b76b-4c2dc758c823', 'context': [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x000001C7739503E0>]}
�[0m17:04:04.380475 [error] [Thread-1 (]: 1 of 1 ERROR creating sql incremental model unified.raw__test_pm20000 ........... [�[31mERROR�[0m in 6.62s]
�[0m17:04:04.381481 [debug] [Thread-1 (]: Finished running node model.dremio.raw__test_pm20000
�[0m17:04:04.382482 [debug] [Thread-11 ]: Marking all children of 'model.dremio.raw__test_pm20000' to be skipped because of status 'error'.  Reason: Runtime Error in model raw__test_pm20000 (models\raw\sks\raw__test_pm20000.sql)
  ERROR: Encountered ". hold" at line 17, column 749.
  Was expecting one of:
      ")" ...
      "," ...
      "." ...
      "." <IDENTIFIER> ...
      "." <QUOTED_IDENTIFIER> ...
      "." <BACK_QUOTED_IDENTIFIER> ...
      "." <BRACKET_QUOTED_IDENTIFIER> ...
      "." <UNICODE_QUOTED_IDENTIFIER> ...
      "NOT" ...
      "IN" ...
      "<" ...
      "<=" ...
      ">" ...
      ">=" ...
      "=" ...
      "<>" ...
      "!=" ...
      "BETWEEN" ...
      "LIKE" ...
      "SIMILAR" ...
      "+" ...
      "-" ...
      "*" ...
      "/" ...
      "%" ...
      "||" ...
      "AND" ...
      "OR" ...
      "IS" ...
      "MEMBER" ...
      "SUBMULTISET" ...
      "CONTAINS" ...
      "OVERLAPS" ...
      "EQUALS" ...
      "PRECEDES" ...
      "SUCCEEDS" ...
      "IMMEDIATELY" ...
      "MULTISET" ...
      "[" ...
      "FORMAT" ...
      "." "*" ...
      "(" ...
      .
�[0m17:04:04.385479 [debug] [MainThread]: On master: ROLLBACK
�[0m17:04:04.386484 [debug] [MainThread]: Opening a new connection, currently in state init
�[0m17:04:04.529688 [debug] [MainThread]: dremio adapter: Connected to db: sk
�[0m17:04:04.529688 [debug] [MainThread]: dremio adapter: Handle rollback not implemented.
�[0m17:04:04.530686 [debug] [MainThread]: On master: ROLLBACK
�[0m17:04:04.531685 [debug] [MainThread]: dremio adapter: Handle rollback not implemented.
�[0m17:04:04.531685 [debug] [MainThread]: On master: Close
�[0m17:04:04.716829 [error] [MainThread]:   Runtime Error in model raw__test_pm20000 (models\raw\sks\raw__test_pm20000.sql)
  ERROR: Encountered ". hold" at line 17, column 749.
  Was expecting one of:
      ")" ...
      "," ...
      "." ...
      "." <IDENTIFIER> ...
      "." <QUOTED_IDENTIFIER> ...
      "." <BACK_QUOTED_IDENTIFIER> ...
      "." <BRACKET_QUOTED_IDENTIFIER> ...
      "." <UNICODE_QUOTED_IDENTIFIER> ...
      "NOT" ...
      "IN" ...
      "<" ...
      "<=" ...
      ">" ...
      ">=" ...
      "=" ...
      "<>" ...
      "!=" ...
      "BETWEEN" ...
      "LIKE" ...
      "SIMILAR" ...
      "+" ...
      "-" ...
      "*" ...
      "/" ...
      "%" ...
      "||" ...
      "AND" ...
      "OR" ...
      "IS" ...
      "MEMBER" ...
      "SUBMULTISET" ...
      "CONTAINS" ...
      "OVERLAPS" ...
      "EQUALS" ...
      "PRECEDES" ...
      "SUCCEEDS" ...
      "IMMEDIATELY" ...
      "MULTISET" ...
      "[" ...
      "FORMAT" ...
      "." "*" ...
      "(" ...
      
�[0m17:04:04.717833 [info ] [MainThread]: 
�[0m17:04:04.718831 [info ] [MainThread]: Done. PASS=0 WARN=0 ERROR=1 SKIP=0 TOTAL=1
�[0m17:04:04.720829 [debug] [MainThread]: Command `dbt run` failed at 17:04:04.719830 after 11.08 seconds
�[0m17:04:04.720829 [debug] [MainThread]: Sending event: {'category': 'dbt', 'action': 'invocation', 'label': 'end', 'context': [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x000001C77143C9E0>, <snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x000001C7742DA9C0>, <snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x000001C775EC97F0>]}
�[0m17:04:04.721832 [debug] [MainThread]: Flushing usage events
�[0m17:04:04.928071 [debug] [MainThread]: An error was encountered while trying to flush usage events
�[0m17:07:42.084080 [debug] [MainThread]: Sending event: {'category': 'dbt', 'action': 'invocation', 'label': 'start', 'context': [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x00000260D56A8F50>, <snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x00000260D9122960>, <snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x00000260D91A0B90>]}

alanspires added the bug Something isn't working label Nov 30, 2024

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

[Bug]: Merge 'when not matched' not wrapping values sources with quotes #247

[Bug]: Merge 'when not matched' not wrapping values sources with quotes #247

alanspires commented Nov 30, 2024

bcmeireles commented Jan 15, 2025

alanspires commented Mar 9, 2025

[Bug]: Merge 'when not matched' not wrapping values sources with quotes #247

[Bug]: Merge 'when not matched' not wrapping values sources with quotes #247

Comments

alanspires commented Nov 30, 2024

Is there an existing issue for this?

Current Behavior

Expected Behavior

Steps To Reproduce

Environment

Relevant log output

bcmeireles commented Jan 15, 2025

alanspires commented Mar 9, 2025