Data inputs now available! New workbook and dbt enhancements, color modeling updates, StarRocks, M2M auth for Databricks, and tons of new APIs,
March 31, 2025
Data inputs now available! #
The wait is over! You can now upload CSV and XLSX files or manually enter data into Omni to create source tables. This highly requested feature makes it easier than ever to bring external data into your analyses - database optional.

Once created, data input tables tables can be queried and modeled just like any other table in your database. Check out the docs to learn more.
New workbook starter now in beta #
As part of our mission to eliminate analysis paralysis, we’re developing a new query tab experience that makes it easier to get started with your data.
Now, when you create a new workbook or query tab, you can browse database views and topics, write a SQL query, or add a data input table.

Reach out to us if you want to try out the new experience.
dbt tooling enhancements #
The new dbt environment health dialog, accessible by clicking Health in the footer of the IDE, can help you monitor issues in your dbt environment:

Additionally, you can now bring your dbt metadata in Omni up to date with just a few clicks. In the dbt IDE, navigate to Model > Sync dbt metadata and Omni will kick off a metadata sync.
Promote color modeling from the workbook #
Color modeling is now complete for both dimensions and measures! In the Color options for charts, you can set colors for multiple measures, including those that already have a color defined in the model:

Once set, you can then promote the colors to the workbook model, which will apply the colors across the entire workbook:

Connect to StarRocks #
If you’re using StarRocks, you can now connect it to Omni! Check out the StarRocks setup guide for more information.
M2M authentication for Databricks #
We’ve added another authentication option, machine-to-machine (M2M), to the Databricks integration. You also have the option to use a personal access token (PAT). Refer to the Databricks setup guide for more information.
Dashboard control enhancements #
We added a new control type, Field picker, that allows you to select one or more fields to include in the control:

Additionally, dashboard controls are now accessible in text tiles using Mustache syntax. Check out the docs for more info and examples.
All the APIs! #
We’ve expanded our library of APIs over the last few weeks with a bunch of new endpoints:
Reset a cache (docs coming soon!)
Documentation #
Revised AI data security guide now includes information about AWS Bedrock and recently-added AI features
New guide for connecting databases using Amazon Web Services (AWS) PrivateLink
New guide about working with dbt models in Omni
Updated dbt setup guide
New and improved videos in the Model IDE developer guide
Revised database setup guides, now with info about user permission requirements
New visualization examples!
Honorable mentions #
New heatmap projection type for point maps
New NOT() formula
Expanded options for copying values in a workbook: