References → Save MV Recipe

The Save MV recipe is the final step of any data flow. The save MV recipe will take all the upstream logic of the data flow and deploy it into a physical schema as Materialized View (MV) written in PySpark.

Important: Incremental Mode

For the releases of 2024.1.5, 2024.7.0, 2024.7.1, activating the Incremental Mode toggle on this Recipe will result in failure to deploy the Dataflow to publish to the target Schema. Turn off Incremental Mode, deploy, then edit the incremental logic in the Physical Schema.

This issue has been resolved in 2024.7.2.

Configuration

ConfigurationDescription
InputSelect a previously constructed recipe as an input
SchemaSelect a schema to save the data flow logic to
MV NameGive a name to the MV to be created

Previewing the Code

To review the code generated in the data flow, select the desired recipe and select Preview Code

Deploying the Data Flow

Now that you have saved the Save MV recipe, you have two options for deployment.

  1. With the Save MV recipe highlighted, select deploy from the data studio banner header.

  2. With the Save MV recipe highlighted, select deploy from the toolbar

Note

Deploying an MV will overwrite any existing MV with the same name in the same physical schema.