Skip to main content Skip to complementary content

Configuring the Snowflake materialized view Job

Procedure

  1. Configure tDBRow_4 to create a materialized view. In the Basic settings view of the component:
    1. Select Snowflake from the Database list and click Apply.
    2. Enter the following code in double quotation marks in the Query field. 
      CREATE OR REPLACE MATERIALIZED VIEW mv1 AS
	SELECT Name, City FROM logs;
    3. Leave other options as they are.
  2. Configure tDBInput_1 to query the external table through the materialized view. In the Basic settings view of the component:
    1. Select Snowflake from the Database list and click Apply;
    2. Select tDBConnection_1 from the Connection Component list;
    3. Enter the following code in double quotation marks in the Query field. 
      SELECT name,city FROM mv1;
    4. Click the [...] button next to Edit schema. Add the following columns and click OK to propagate the schema.
      • Name, type String and Db Column NAME
      • City, type String and Db Column CITY
    5. Leave other options as they are.
  3. Press Ctrl + S to save the Job.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!

Leave your feedback here