PowerExchange for Snowflake User Guide

10.5
- 10.5.6
- 10.5.4
- 10.4.1
- 10.4.0

Back Next

Snowflake Dynamic Mapping Example

Your organization has a large amount of data that keeps changing. Your organization needs to incorporate all the updated data in a short span of time. Create a dynamic mapping, where you can refresh the source schema dynamically to fetch the updated data. Add all the dynamic ports to the target to override the metadata of the existing ports.

Import the Snowflake read and write data objects.

Select a project or folder in the

Object Explorer

view.

Click

File

New

Mapping

The

Mapping

dialog box appears.

Enter the name of the mapping in the

Name

field.

Click

Finish

Drag the data object into a mapping.

The

Snowflake Data Object Access

dialog box appears.

Select the

Read

option and click

In the

Data Object

tab, select the

At runtime, get data object columns from the data source

check box.

The following image shows the

Data Object

tab:

Drag the data object into a mapping.

The

Snowflake Data Object Acess

dialog box appears.

Select the

Write

option and click

In the

Ports

tab, select the value of the

Columns defined by

Mapping Flow

The following image shows the

Ports

tab:

Select all the source incoming ports and add the ports to the target.

Save and run the mapping.

PowerExchange for Snowflake Dynamic Mappings

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal

0 COMMENTS

We’d like to hear from you! Log in to comment.

Rename Saved Search

Table of Contents

PowerExchange for Snowflake User Guide

PowerExchange for Snowflake User Guide

Snowflake Dynamic Mapping Example

Snowflake Dynamic Mapping Example