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

# March 8, 2024

> ETL Freshness, Dynamic dbt schema switching, Period-Over-Period, & 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>

## ETL freshness update hooks

*Chris Merrick · `performance` `dashboard`*

A nice first-step towards the vision of more inter-connected ETL, transformation, and BI. Now you can kick-off ETL updates in Fivetran directly from the dashboard. This will be tied into dbt and other services down the line for transformation, but now developers can request fresh data directly from the dashboard.

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

## Dynamic dbt schemas (schema switching)

*Buck Ryan · `dbt` `modeling`*

Dynamic dbt schemas: Often developers are working across one or many dbt schemas for new transformations. Omni can now gracefully move developers between schemas in branches to test changes on content or topics.

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

## Period-over-period

*Steven Talbot · `workbook` `analysis-pattern`*

More period-over-period work, this time polishing the front-end user experience to select dynamic time offsets.

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

## Dynamic SQL templating

*Steven Talbot · `workbook` `modeling`*

Templated SQL for ad hoc use cases where users may want to map raw SQL to filter blocks.

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

## Vanity embed URLs (no more third party cookies)

*Gustav Staprans · `embed` `administration`*

Vanity embed URLs: now the embedded Omni app can share the same URL structure as the parent app, side-stepping third party cookies for a cleaner end-user experience.

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

## In-app helpers (empty schemas, Slack API downtime, new topics)

*Eli Cohen · `design`*

Polish throughout the app for understanding totals (ungrouped aggregates) and dashboard filter mapping (no more long lists); also lots of helper text to get you unstuck (schema permissions blocking data to Omni, Slack downtime, etc).

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