# How to create near real-time models with just dbt + SQL

**URL:** <https://discourse.getdbt.com/t/how-to-create-near-real-time-models-with-just-dbt-sql/1457>\
**Category:** Archive\
**Created:** [July 23, 2020, 10:54pm UTC](https://discourse.getdbt.com/t/how-to-create-near-real-time-models-with-just-dbt-sql/1457 "2020-07-23T22:54:25Z")\
**Posts on this page:** 1\
**Showing post:** 3

<div class="post-metadata">

**Author:** ![claire](https://sea2.discourse-cdn.com/flex020/user_avatar/discourse.getdbt.com/claire/32/522_2.png) [@claire](https://discourse.getdbt.com/u/claire)\
**Post date:** [July 28, 2020, 4:07pm UTC](https://discourse.getdbt.com/t/how-to-create-near-real-time-models-with-just-dbt-sql/1457/3 "2020-07-28T16:07:38Z")

</div>

Aw yeah @amy— thanks for taking the time to write this up!

As Amy noted, we’ve been playing around with a custom materialization to make the implementation of this easier. dbt, in its current form, assumes that one model will produce only one relation (table/view) in a warehouse, and we suspect that if we try to use one materialization to create both a view and a table, some weird things might end up breaking!

But we’re going to try it out at some point just to see what happens 😉

---

_[View the full topic](https://discourse.getdbt.com/t/how-to-create-near-real-time-models-with-just-dbt-sql/1457)._