Real time modeling with new materialization options

[leonard-henriquez]

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

It's hard to have always update to date data with low latency (<1 minute) with this package.
This package doesn't provide a solution or documentation how to achieve this.

Describe the solution you'd like

Would it be possible to add support for other materialization option in the snowplow-web dbt package to achieve real-time transformation ?
In Snowflake Dynamic tables could provide a more efficient way to maintain near-real-time data, avoiding the need for frequently running the models.

Additional context

Data Warehouse: Snowflake (but similar concepts exist in other data warehouse)

Are you interested in contributing towards this feature?

While I'm relatively new to dbt, I'd be open to contributing towards this feature with some guidance to get started.

[rlh1994]

For anyone landing here - here is a thread on the issue: https://discourse.snowplow.io/t/data-modeling-in-real-time/8978

This is something we will likely look into but it's not currently on the immediate road map.

[rlh1994]

Also linked to this issue snowplow/dbt-snowplow-utils#136

[miike]

Moving this issue to the unified repo as the web model is in maintenance mode.