> ## 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.

# January 10, 2025

> Snowflake Cortex Columns, Sub-Folders (Early), Editing dbt Models, and Much More

<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>

## Snowflake Cortex columns (AI columns)

*Colin Zima, Arielle Strong · `Modeling` `Workbook`*

We show how to take advantage of Snowflake Cortex to enrich data in Omni using modern LLMs. We show several examples of enriching marketing data, even layering interactive UI for selecting models or tuning prompts.

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

## Sub-folders

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

An early look at nested folders.  Coming soon!

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

## Editing dbt models

*Buck Ryan · `Dbt` `Workbook` `Modeling`*

Continuing to enrich our dbt workflows, now layering in direct model editing (via pull request) in the Omni UI. Also layering in file search for the dbt viewer.

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

## Custom joins from the workbook

*Steven Talbot · `Modeling` `Workbook`*

New support for complex joins (inequality, multi-condition, etc) in the UI. Continuing to lift as much of the modeling experience as we can into the UI.

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

## URL rebuild (don't move tiles on save)

*Luke Bowerman · `Workbook` `Dashboards`*

Putting the finishing touches on a URL rebuild for workbooks to stamp out the issue of dashboard tiles rearranging after workbook edits. This was a bigger lift than we expected, but excited to put it in the past.

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

## Vertical reference lines

*Jamie Davidson · `Visualization`*

An early look at vertical reference lines on charts. Still work to do, but more actionable, clear charts coming soon.

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

## Controls in scheduler

*Jamie Davidson · `Scheduler` `Dashboards`*

Now schedules can take advantage of dashboard controls for field swapping in delivered content.

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

## Field color for measures in the model

*Rob Miller · `Modeling` `Visualization`*

Continuing the build out of color controls in the model - now supporting measures (especially useful with filtered measures)

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

## Dashboard filter descriptions

*Jamie Davidson · `Dashboards` `Filtering`*

Filter settings on the dashboard now allow for tooltips to add more metadata to dashboard filters

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

## Subtotals in pivots

*Steven Talbot · `Workbook`*

Bit of tuning to subtotals to allow subtotaling over pivots as well.

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

## Model API

*Conrad Slimmer · `Api` `Modeling`*

Unveiling a new API for model building

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

## More concurrency improvements

*Jonathan Swenson · `Performance` `Administration`*

Speed is a first class category of work for Omni. Continuing the focus on keeping the app speedy through high concurrency, and hammering out hotspots.

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

## Trusted certificates for MSSQL

*Chris Merrick · `Administration`*

New toggle to trust certificates in MSSQL - supporting a default configuration for Microsoft customers

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