> ## Documentation Index
> Fetch the complete documentation index at: https://docs.omni.co/llms.txt
> Use this file to discover all available pages before exploring further.

# October 4, 2024

> dbt SQL mode, schema refresh via git, and new content permissions

<Note>
  **Stay in the loop!** Subscribe to the [demo RSS feed](/demos/rss.xml) to be notified when we post new demos.

  Demos highlight what we are working on or experimenting with, but are not a guarantee of release. Let us know your thoughts at [support@omni.co](mailto:support@omni.co).
</Note>

## dbt SQL mode (very soon)

*Buck Ryan · `dbt` `sql`*

A new UI mode for writing dbt SQL (ie. Jinja + refs).  Now for handwritten SQL folks can toggle into dbt SQL mode for confirming well composed SQL and results before pushing to dbt.

<Frame>
  <iframe src="https://www.youtube.com/embed/F-lo0GJ5WHs" width="100%" height="400" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture" allowFullScreen />
</Frame>

## Git schema refresh (very soon)

*Conrad Slimmer · `Modeling`*

An early look at a new always-git mode for schema refresh.  Soon development team will have the option to also force schema refreshes through a pull request workflow.

<Frame>
  <iframe src="https://www.youtube.com/embed/IbghFy8gFIQ" width="100%" height="400" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture" allowFullScreen />
</Frame>

## More draft work for dashboards plus new content permission (soon)

*Luke Bowerman · `Workbook` `Dashboards` `Administration`*

Continuing work on drafts in Omni, this also offers content-level and global toggles for dashboard permissions, like blocking download or scheduling.

<Frame>
  <iframe src="https://www.youtube.com/embed/IaVFgvO_RsI" width="100%" height="400" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture" allowFullScreen />
</Frame>

## Richer tables (experimental)

*Nate Agrin · `Visualization` `Table`*

Some experimental work + conversation about adding more visual types to the data model.  Here we show some special handlers for hex colors that enable a more visual experience for end users.  This also sets up the groundwork for more style controls in the UI like pills for categorical fields, modeled conditional formatting, checkboxes, etc.

<Frame>
  <iframe src="https://www.youtube.com/embed/JsCPWClOgnE" width="100%" height="400" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture" allowFullScreen />
</Frame>

## Global color palette launch plus rendering (launched)

*Gustav Staprans · `Administration` `Workbook` `Dashboards` `Visualization`*

The launch of global color palettes for everyone.  A bit of final cleanup to make sure these palettes carry to the renderer, and we show off a nice example in production.

<Frame>
  <iframe src="https://www.youtube.com/embed/tgcEf-o6e0Y" width="100%" height="400" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture" allowFullScreen />
</Frame>

## Overlapping time period-over-period (launched)

*Steven Talbot · `Workbook`*

A quick demo of the live experience for period-over-period with time controls, so now even time dimensions can flexibly pull offsetting time periods with a couple clicks.

<Frame>
  <iframe src="https://www.youtube.com/embed/IUk0RJUoUHI" width="100%" height="400" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture" allowFullScreen />
</Frame>