dynamic_schemas - Model files

Creates 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. When generating SQL against dynamic schema views, the user_attribute assigned to the user running the query is used to scope table references. If you’re using embedding, you can use this setting to partition customer data into separate, but identical schemas.

If from_schema references a Redshift datashare-backed external schema, that schema must be created and the Omni user must be granted access to it before running a schema refresh. Omni will not discover datashare-backed schemas that haven’t been explicitly created and permissioned in the connected database. See Connecting to Redshift datashares.

All modeling will reference views in the dynamic schema with this naming convention: dynamic_schema_name__view_name

Syntax

dynamic_schemas:
  <dynamic_schema_name>:
    from_schema: <canonical_schema_name>
    user_attribute: <user_attribute_name>

Properties

object

required

A map of dynamic schema objects where each key is the name of the new dynamic schema.

Hide dynamic_schemas properties

string

required

The name of the new dynamic schema.

Hide dynamic_schema_name properties

string

required

The name of the schema to copy.

string

required

The reference of the user attribute to use to scope table references.

⌘I

Getting started

Manage content

Analyze & build

Visualize & present

Deliver content

Model data

Manage integrations

dynamic_schemas - Model files

Syntax

Properties

​Syntax

​Properties

Syntax

Properties