Skip to main content
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. 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

​
dynamic_schema_name
string
required
The name of the new dynamic schema.