Skip to main content Skip to complementary content

Configuring the Snowflake materialized view Job

Procedure

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.
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.
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 – please let us know!

Leave your feedback here