dbt-labs / dbt-labs/dbt-labs-experimental-features

Add Trino support for insert_by_period

Open
#49 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
Makefile
Stars
163
Forks
43
PR merge metrics
No merged PRs in 30d

Description

Currently Trino isn't supported for "insert_by_period" materialisation. Running any model will produce this error
```bash
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', ", query_id=34242341243124)
```

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.