# Modeling **URL:** https://community.omni.co/c/modeling/5.md?page=2 [Latest](https://community.omni.co/latest.md) · [Categories](https://community.omni.co/categories.md) · [Tags](https://community.omni.co/tags.md) **Page:** 3 --- ## [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)
**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")
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… --- ## [How do I control caching policies?](https://community.omni.co/t/how-do-i-control-caching-policies/95)
**Author:** [@conner](https://community.omni.co/u/conner)\ **Replies:** 0\ **Last updated:** [June 3, 2024, 11:01pm UTC](https://community.omni.co/t/how-do-i-control-caching-policies/95 "2024-06-03T23:01:16Z")
Query results are cached for 6 hours by default, but this can be configured at the model and/or topic level using the cache parameters outlined here. --- ## [What is the square icon that's not a date/number/string/boolean in the field picker?](https://community.omni.co/t/what-is-the-square-icon-thats-not-a-date-number-string-boolean-in-the-field-picker/94)
**Author:** [@conner](https://community.omni.co/u/conner)\ **Replies:** 0\ **Last updated:** [June 3, 2024, 10:59pm UTC](https://community.omni.co/t/what-is-the-square-icon-thats-not-a-date-number-string-boolean-in-the-field-picker/94 "2024-06-03T22:59:07Z")
If you see the square icon next to a field in the field picker, it means that Omni doesn’t recognize the data type of that field. You’ll still be able to select that field and view it in the table, but to interact wi… --- ## [If I save a query as a view, will the row limit of that query get applied to that view?](https://community.omni.co/t/if-i-save-a-query-as-a-view-will-the-row-limit-of-that-query-get-applied-to-that-view/91)
**Author:** [@conner](https://community.omni.co/u/conner)\ **Replies:** 0\ **Last updated:** [June 3, 2024, 7:06pm UTC](https://community.omni.co/t/if-i-save-a-query-as-a-view-will-the-row-limit-of-that-query-get-applied-to-that-view/91 "2024-06-03T19:06:07Z")
When you create a Query View, Omni will strip the row limit that you’ve defined in the UI. If you’d like to include that row limit, you can edit the definition in the YAML model directly by adding the parameter limit: \[r… --- ## [Can I drill into measures/aggregations to see the underlying data?](https://community.omni.co/t/can-i-drill-into-measures-aggregations-to-see-the-underlying-data/90)
**Author:** [@conner](https://community.omni.co/u/conner)\ **Replies:** 0\ **Last updated:** [June 3, 2024, 6:57pm UTC](https://community.omni.co/t/can-i-drill-into-measures-aggregations-to-see-the-underlying-data/90 "2024-06-03T18:57:23Z")
Yup! If you click on a measure in your data table or visualization, you’ll see the option to drill to see the underlying rows. By default, Omni will show some fields from the view that the measure is defined in, but you … --- ## [Why is my numerical column only showing 0 or 1?](https://community.omni.co/t/why-is-my-numerical-column-only-showing-0-or-1/85)
**Author:** [@conner](https://community.omni.co/u/conner)\ **Replies:** 0\ **Last updated:** [May 31, 2024, 7:04pm UTC](https://community.omni.co/t/why-is-my-numerical-column-only-showing-0-or-1/85 "2024-05-31T19:04:48Z")
This is a frequent problem with integer math (e.g. dividing two whole numbers). We’re looking to add helpers for these in the model, but this can also be avoided by multiplying by 1.0 to cast the result to a decimal. For… --- ## [How to troubleshoot \`TIMESTAMP\_TZ\` datetime confusion in Snowflake](https://community.omni.co/t/how-to-troubleshoot-timestamp-tz-datetime-confusion-in-snowflake/80)
**Author:** [@conner](https://community.omni.co/u/conner)\ **Replies:** 0\ **Last updated:** [May 30, 2024, 7:59pm UTC](https://community.omni.co/t/how-to-troubleshoot-timestamp-tz-datetime-confusion-in-snowflake/80 "2024-05-30T19:59:33Z")
Snowflake has a data type called TIMESTAMP\_TZ, which stores timestamps in UTC alongside a timezone offset. When querying this datatype in Omni, this data type lead to confusion and seemingly inconsistent behavior when qu… --- ## [Why don't I see the aggregate option I want when creating a new aggregation field?](https://community.omni.co/t/why-dont-i-see-the-aggregate-option-i-want-when-creating-a-new-aggregation-field/77)
**Author:** [@aklance](https://community.omni.co/u/aklance)\ **Replies:** 0\ **Last updated:** [May 29, 2024, 11:43pm UTC](https://community.omni.co/t/why-dont-i-see-the-aggregate-option-i-want-when-creating-a-new-aggregation-field/77 "2024-05-29T23:43:36Z")
Sometimes we don’t aggregate a specific field when we generate the view. This is often because we don’t recognize the type (for example, we think it’s a string or some unknown type rather than a number or a date). Examp… --- ## [How do I reference a filter value? (Filters as parameters)](https://community.omni.co/t/how-do-i-reference-a-filter-value-filters-as-parameters/74)
**Author:** [@conner](https://community.omni.co/u/conner)\ **Replies:** 0\ **Last updated:** [May 29, 2024, 7:17pm UTC](https://community.omni.co/t/how-do-i-reference-a-filter-value-filters-as-parameters/74 "2024-05-29T19:17:59Z")
Referencing a filter value in your query or dashboard can be a great way to improve interactivity within Omni. For example: Explicitly highlight filter values on a dashboard: Highlight how dashboard filters are intera… --- ## [How do I automatically construct a filter URL for passing through fields to a dashboard](https://community.omni.co/t/how-do-i-automatically-construct-a-filter-url-for-passing-through-fields-to-a-dashboard/71)
**Author:** [@jack](https://community.omni.co/u/jack)\ **Replies:** 0\ **Last updated:** [May 21, 2024, 2:51pm UTC](https://community.omni.co/t/how-do-i-automatically-construct-a-filter-url-for-passing-through-fields-to-a-dashboard/71 "2024-05-21T14:51:30Z")
Omni’s filter URL structure is built off of JSON. Because of this, we can use a JSON structure to create the filter parameters in the URL, which are later encoded and passed through to link to a dashboard in Omni. Depen… --- ## [How do I add a count(\*) measure to a view?](https://community.omni.co/t/how-do-i-add-a-count-measure-to-a-view/65)
**Author:** [@conner](https://community.omni.co/u/conner)\ **Replies:** 0\ **Last updated:** [May 15, 2024, 8:46pm UTC](https://community.omni.co/t/how-do-i-add-a-count-measure-to-a-view/65 "2024-05-15T20:46:54Z")
For every view in Omni, we automatically generate a COUNT(\*) measure for you. You’ll find this measure in your field picker, with the name \[View Name\] Count, e.g. Users Count. Since COUNT(\*) doesn’t depend on a parti… --- ## [How do I connect to BigQuery public datasets?](https://community.omni.co/t/how-do-i-connect-to-bigquery-public-datasets/59)
**Author:** [@conor](https://community.omni.co/u/conor)\ **Replies:** 0\ **Last updated:** [May 10, 2024, 2:39pm UTC](https://community.omni.co/t/how-do-i-connect-to-bigquery-public-datasets/59 "2024-05-10T14:39:29Z")
The BigQuery public datasets provides a helpful repository of open access datasets to connect to if you don’t have your own data available to connect yet. In Omni we can create connections to and query these datasets if… --- ## [Why isn't my view showing up in "All views & fields"?](https://community.omni.co/t/why-isnt-my-view-showing-up-in-all-views-fields/56)
**Author:** [@conner](https://community.omni.co/u/conner)\ **Replies:** 0\ **Last updated:** [May 9, 2024, 8:34pm UTC](https://community.omni.co/t/why-isnt-my-view-showing-up-in-all-views-fields/56 "2024-05-09T20:34:04Z")
How to access the view In “All views & fields”, you can filter for the schema of the view you’re not seeing by hitting the “Schema” button. You can also hit the Settings icon and click the toggle on the bottom to search… --- ## [I want to promote some workbook changes to the shared model. Why do I get the warning: "Incremental changes require a branch"?](https://community.omni.co/t/i-want-to-promote-some-workbook-changes-to-the-shared-model-why-do-i-get-the-warning-incremental-changes-require-a-branch/55)
**Author:** [@conner](https://community.omni.co/u/conner)\ **Replies:** 0\ **Last updated:** [May 7, 2024, 8:09pm UTC](https://community.omni.co/t/i-want-to-promote-some-workbook-changes-to-the-shared-model-why-do-i-get-the-warning-incremental-changes-require-a-branch/55 "2024-05-07T20:09:46Z")
How to resolve the warning Check out our documentation to learn more about branch mode. Once you’ve entered a branch, you can freely promote incremental workbook changes, see how that impacts the shared model, and then … --- ## [Why doesn't my filter show all possible values as suggestions?](https://community.omni.co/t/why-doesnt-my-filter-show-all-possible-values-as-suggestions/54)
**Author:** [@conner](https://community.omni.co/u/conner)\ **Replies:** 0\ **Last updated:** [May 6, 2024, 6:48pm UTC](https://community.omni.co/t/why-doesnt-my-filter-show-all-possible-values-as-suggestions/54 "2024-05-06T18:48:31Z")
Likely Causes If you’re not seeing some values pop up as suggestions on a filter, the two most likely causes are that the suggestions are being filtered due to faceted filtering, or that the value is new and your suggest… --- ## [How do I get my query to load faster?](https://community.omni.co/t/how-do-i-get-my-query-to-load-faster/47)
**Author:** [@conner](https://community.omni.co/u/conner)\ **Replies:** 0\ **Last updated:** [April 23, 2024, 8:35pm UTC](https://community.omni.co/t/how-do-i-get-my-query-to-load-faster/47 "2024-04-23T20:35:07Z")
Omni is built with performance in mind at every step of the way, including our intelligent cache. At its core, though, Omni is writing SQL down to your database and returning the results. If you’re seeing slowness, the u… --- ## [How do I rename the base view within a Topic?](https://community.omni.co/t/how-do-i-rename-the-base-view-within-a-topic/38)
**Author:** [@conner](https://community.omni.co/u/conner)\ **Replies:** 0\ **Last updated:** [April 15, 2024, 10:11pm UTC](https://community.omni.co/t/how-do-i-rename-the-base-view-within-a-topic/38 "2024-04-15T22:11:21Z")
While it often makes sense for a Topic to have the same name as its base view, you sometimes want the base view to have a different label. For example, if the base\_view of your Revenue topic is order\_items, then you migh… --- ## [Why does drilling into a measure lead to a different value than the value in the aggregated table?](https://community.omni.co/t/why-does-drilling-into-a-measure-lead-to-a-different-value-than-the-value-in-the-aggregated-table/27)
**Author:** [@conner](https://community.omni.co/u/conner)\ **Replies:** 0\ **Last updated:** [April 2, 2024, 12:16am UTC](https://community.omni.co/t/why-does-drilling-into-a-measure-lead-to-a-different-value-than-the-value-in-the-aggregated-table/27 "2024-04-02T00:16:59Z")
A common workflow when modeling is defining a “filtered measure”, i.e. a measure with a filter. For example: Count of Non-Returned Orders: Counts the number of orders that are not returned Sum of Revenue from non-churn… --- ## [I added a new table to my data warehouse, but I don’t see it in Omni. How do I get it to appear?](https://community.omni.co/t/i-added-a-new-table-to-my-data-warehouse-but-i-don-t-see-it-in-omni-how-do-i-get-it-to-appear/20)
**Author:** [@conner](https://community.omni.co/u/conner)\ **Replies:** 0\ **Last updated:** [March 27, 2024, 10:42pm UTC](https://community.omni.co/t/i-added-a-new-table-to-my-data-warehouse-but-i-don-t-see-it-in-omni-how-do-i-get-it-to-appear/20 "2024-03-27T22:42:32Z")
If you’ve added a new table to your data warehouse, there are a few things you’ll need to get that table to show up in Omni. First, you’ll want to refresh your schema to make sure Omni’s pulling in the most recent data… [Previous page](https://community.omni.co/c/modeling/5.md?page=1)