dbt-databricks icon indicating copy to clipboard operation
dbt-databricks copied to clipboard

Delta Live Tables

Open dwolfeu opened this issue 2 years ago • 9 comments

Describe the feature

Create and orchestrate Delta Live Tables using dbt-databricks

Describe alternatives you've considered

Delta Live Tables can be set up using the Databricks UI, but this misses all the excellent features of dbt.

Additional context

I do not know whether this idea is feasible, since Delta Live Tables function only in tandem with Databricks pipelines, which goes beyond CREATE TABLE.

Who will this benefit?

Anyone who likes both dbt and Delta Live Tables, in particular teams with existing dbt-databricks projects who want to migrate to Delta Live Tables.

Are you interested in contributing this feature?

Potentially, but I am a complete newbie to this repo.

dwolfeu avatar Apr 22 '22 15:04 dwolfeu

dbt + DLT sounds like very powerful combination. I don't know how feasible this is, but I ❤️ the idea.

dcaribou avatar Jul 28 '22 13:07 dcaribou

Is there an update on this enhancement? I am curious!

JCZuurmond avatar Oct 07 '22 14:10 JCZuurmond

@JCZuurmond please tell me more ... what all would you like to be able to do?

bilalaslamseattle avatar Oct 09 '22 08:10 bilalaslamseattle

@bilalaslamseattle the ideia is to use all the power of dbt framework, like tests, models, code structure, jinja, dbt utils, etc.. and combine with the power of DLT using streaming data easily. As @dwolfeu said, its a good integration for teams that already work with dbt

Angelo-Baruffi avatar Oct 18 '22 21:10 Angelo-Baruffi

@Angelo-Baruffi makes a lot of sense. Thank you!

bilalaslamseattle avatar Oct 19 '22 21:10 bilalaslamseattle

Plus one to what Angelo mentionned so far!

jc-ludia avatar Jan 05 '23 23:01 jc-ludia

Would also love to see this.

followingell avatar Jul 03 '23 07:07 followingell

DLT becomes the mainstream of Spark nowadays, and adding support to DLT in dbt is one of the most want features from our organization.

yang6n avatar Jul 03 '23 13:07 yang6n

We added initial support in 1.6.0, but significant improvements are coming during the 1.7.x timeframe.

benc-db avatar Jan 12 '24 17:01 benc-db