# \#dynamic-schemas

**URL:** https://community.omni.co/tag/dynamic-schemas/18.md

[Latest](https://community.omni.co/latest.md) · [Categories](https://community.omni.co/categories.md) · [Tags](https://community.omni.co/tags.md)

---

## [Working with dynamic schemas](https://community.omni.co/t/working-with-dynamic-schemas/99)

<div class="topic-metadata">

**Author:** [@conor](https://community.omni.co/u/conor)\
**Replies:** 0\
**Last updated:** [June 7, 2024, 8:09am UTC](https://community.omni.co/t/working-with-dynamic-schemas/99 "2024-06-07T08:09:09Z")

</div>

Dynamic schemas Dynamic schemas are a useful concept to implement when your data is partitioned into separate, but identical schemas. In industry, this is referred to as a single tenant database architecture. Suppose we…

---

## [How to extend views with SQL blocks when using dynamic schemas](https://community.omni.co/t/how-to-extend-views-with-sql-blocks-when-using-dynamic-schemas/113)

<div class="topic-metadata">

**Author:** [@conor](https://community.omni.co/u/conor)\
**Replies:** 0\
**Last updated:** [June 20, 2024, 9:55am UTC](https://community.omni.co/t/how-to-extend-views-with-sql-blocks-when-using-dynamic-schemas/113 "2024-06-20T09:55:44Z")

</div>

In my previous post called Working with dynamic schemas, we discussed how to create dynamic schemas in Omni to work with your database when you have a single-tenant database architecture. There might be some views in th…