Feast <> dbt integration

[adchia]

Is your feature request related to a problem? Please describe.

• Users commonly want to leverage their existing tables created by dbt models within Feast. Right now, this requires manual creation
• When materializing features to the online store, often, it's desirable to have dbt run first to create the upstream table prior to materializing an interval. This requires manual work today.

Describe the solution you'd like

• A mechanism to import dbt models (e.g. feast dbt-import) that lets users import from a directory of models, or configure a directory and enable individual models

• The above mechanism should generate a data source + feature view with pre-populated tags to track the origin dbt model. Something like

  driver_stats_source = BigQuerySource(
  name="driver_hourly_stats_source",
  table="AUTO-IMPORTED-NAME",
  tags={ 
     "feast.dev/dbt-model-path": "INSERT MODEL PATH" 
     "feast.dev/dbt-model-serialized": "<serialized dbt model to be shown in UI>" 
  }
  )

• Then these models could potentially be shown directly in the Feast Web UI too (there was prior art here e.g. https://github.com/feast-dev/feast/blob/v0.24-branch/ui/src/pages/data-sources/DataSourceDbt.tsx

• Potentially, if configured, materialize can also run dbt run for the upstream model

Describe alternatives you've considered

Additional context Add any other context or screenshots about the feature request here.

[stale[bot]]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.

[Zoltrix]

This is a really cool feature request. I was wondering the exact same thing.

@adchia Do you suppose a workaround for this is to: 1- Create a custom DbtSource and logic of it would be to parse the dbt model .yaml file of a particular model 2- And then register that DbtSource

[Ido-Levi]

Hey, any news on this?

[franciscojavierarceo]

We should open this back up @HaoXuAI.