doris
doris copied to clipboard
[fix](dbt-doris) avoid the restriction of having to add label_id when…
Avoid the restriction of having to add label_id when sql is insert into + CTE
When building a dbt project, the "with ... as(select)" sql expression model is often used. However, due to the syntax limitation of Doris here, label_id or column_list must be given. The original dbt-doris code is not very compatible with this. Special SQL. Therefore, I added the "label_id" macro function to the config. When the user gives his own label_id, the user's own "label_id" is used. If not given, a time-related "label_id" is automatically generated, prefixed with: "dbt_doris_label_".
Checklist(Required)
- Does it affect the original behavior:
- [✔️] Yes
- [ ] No
- [ ] I don't know
- Has unit tests been added:
- [ ] Yes
- [✔️] No
- [ ] No Need
- Has document been added or modified:
- [ ] Yes
- [ ] No
- [✔️] No Need
- Does it need to update dependencies:
- [ ] Yes
- [✔️] No
- Are there any changes that cannot be rolled back:
- [ ] Yes (If Yes, please explain WHY)
- [✔️] No