Skip to main content
ParameterDescription
cache_policiesDefines cache policies for the model. Each policy must have a max_cache_age parameter that defines the time limit for the policy.
default_numeric_localeDefines global number formatting in the model.
default_topic_access_filtersDefines a default access filter for all topics contained in the model. Access filters limit row-level access to data based on user attributes.
default_topic_required_access_grantsDefines a default required access grant for all topics contained in a model, unless other grants are applied at the topic level.
dynamic_schemasCreates a copy of the specified schema as a virtual schema. The views in the dynamic schema are generated from the schema specified in from_schema.
extendsEnables extending a model.
facet_workbook_filtersFacets all filter suggestions in the workbook to the current filter selections.
fiscal_month_offsetSets a fiscal calendar in Omni and enables adding fiscal time metrics to time dimension groups and filters in the UI.
ignored_schemasExcludes a list of schemas from workbooks.
ignored_viewsExcludes specific views from use in workbooks. Wildcard syntax may be used to match multiple views within a schema.
included_schemasIncludes only the listed schemas for use in workbooks.
included_viewsDefines a list of views from the database schema to include in the model.
sample_queriesDefines a list of sample queries that could be performed using the topics in the model.
setsDefines a list of fields that can be referenced in parameters that accept lists of fields.
slot_reservationSpecifies a dedicated slot for queries in the model to use.
templateDisables the content validator. This is useful because abstract models are logical constructs that aren’t tied to data.
topicsDefine topics within model files.
warehouse_overrideSpecifies a different warehouse to use for a given workbook or branch.
week_start_dayDefines the day that all weeks start on. Defaults to Monday.