confluentinc / confluentinc/dbt-confluent

Default dbt init template uses SQL incompatible with Flink

Open
#41 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
Python
Stars
8
Forks
2
Avg merge
1d 59m
Merged PRs (30d)
18

Description

When users run `dbt init`, the default example model `my_first_dbt_model.sql` contains `select null as id` which fails in Flink SQL with `Illegal use of 'NULL'`. Flink requires `CAST(NULL AS )`.

### Proposed solution

Ship a custom `dbt init` template with Flink-compatible example models, or at minimum document that users should delete the default example models before running `dbt run`.

Contributor guide

Open the contributing guide

Research direction

Start by locating the template used by `dbt init` and inspect `my_first_dbt_model.sql`, then reproduce the failure with `dbt run` under Flink. Determine whether the template can use Flink-compatible SQL or whether the init documentation should tell users to remove the default examples; done means a fresh init no longer fails for this reason, or the limitation is clearly documented.

Written by the indexing model from the issue text.

Assessment

Tech stack
sql
Domain
stream-processing
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Quiet
Clarity
Mostly clear
Newbie friendliness
68/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.