Create the Output Stage based on Your Logical Data Model

If you upload data from a data warehouse (for example, Snowflake or Redshift) and use (or want to use) the Output Stage as a source for loading data to your workspaces (see Automated Data Distribution v2 for Data Warehouses), you can generate the Output Stage based on the logical date model (LDM). Whenever you update the LDM, recreate the Output Stage so that it matches the LDM.

The GoodData platform scans the LDM and suggests SQL queries that you then execute on your schema to create the Output Stage. The Output Stage follows the naming convention as described in Naming Convention for Output Stage Objects in Automated Data Distribution v2 for Data Warehouses.

Before creating the Output Stage, make sure that your LDM is ready and there are no unpublished changes.

Steps:

  1. On the top navigation bar, select Data. The LDM Modeler opens in view mode.

  2. Click the menu button on the top right, and click Create Output Stage

  3. Select the Data Source that you want to create the Output Stage for, and select the SQL command that you want to generate. You can choose from creating or altering tables and creating views.

  4. Click Create. The creating process starts. When the process completes, the dialog shows the SQL queries that you can use to create the Output Stage.

  5. Review the suggested queries and modify them as needed. Once done, execute the queries on your schema to create the Output Stage. The Output Stage is created.

If you do not have data load processes set up yet, you can now deploy processes for loading data (see Deploy a Data Loading Process for Automated Data Distribution v2) and schedule them to load data regularly (see Schedule a Data Load).