search

dbt-labs / dbt-labs-experimental-features

dbt support for database features which are not yet supported natively in dbt-core
Apache License 2.0
147 stars 43 forks source link

Add Trino support for insert_by_period #49

Open gulivan opened 5 months ago

gulivan commented 5 months ago

Currently Trino isn't supported for "insert_by_period" materialisation. Running any model will produce this error

Database Error in model my_sample_model (models/model.sql)
  TrinoUserError(type=USER_ERROR, name=SYNTAX_ERROR, message="line 70:1: mismatched input 'false'. Expecting: ')', ',', '.', 'AS', 'CROSS', 'EXCEPT', 'FETCH', 'FOR', 'FULL', 'GROUP', 'HAVING', 'INNER', 'INTERSECT', 'JOIN', 'LEFT', 'LIMIT', 'MATCH_RECOGNIZE', 'NATURAL', 'OFFSET', 'ORDER', 'RIGHT', 'TABLESAMPLE', 'UNION', 'WHERE', 'WINDOW', <identifier>", query_id=34242341243124)