Promotion Activity (2.12)
Introduction
A promotion activity copies data from staging tables to their final tables or files, where they can be used by downstream consumers. A promotion activity consists of one or more promotion items, which are to be performed in a specific order. Each promotion item copies data to a final table or file. The data copied can use data from multiple staging tables.
Masked Data and Promotion Activities
When promoting data that includes columns masked at the data model level, masking behavior during promotion depends on the promotion type.
For internal promotion activities, data is promoted using the underlying values stored in the database. Data-model level masking that is applied at query time is not preserved during internal promotion. To ensure that sensitive data remains masked in the target table, the target data model must define masking rules for the corresponding columns.
For external promotion activities, including promotion to external databases or files, masked values are promoted by default. Masking behavior is preserved unless explicitly overridden as part of the promotion logic.
Options
For each promotion item, the following options apply:
-
Promotion Type —Specifies whether the data is to be promoted to a table within this database (that is, the database native to Data Studio) or to an external data target. External targets include other databases, file systems, or supported third-party platforms. The choices are as follows:
-
Internal —This option loads data into a table within this database.
-
External —This option loads data into an external data target. This may be another database, an external file, or a supported platform such as Salesforce.
After you create an item in a promotion activity, you cannot change this setting, and this option is no longer displayed.
-
-
Target Connection — Applies if target is external. Specifies the database or external file system to promote the data into.
After you create an item in a promotion activity, you cannot change this setting.
-
Run Order —Specifies the order in which this item should be executed, relative to other items in the same promotion activity. Select an integer.
-
Description —Specifies an optional description of this item, as an aid to yourself and others reviewing this recipe later.
-
Operation Type Applies if target is external. —Choose one of the following:
-
Insert
-
Insert or Update on Primary Key
-
(Salesforce Only)Upsert
-
-
SQL Expression —Specifies an SQL UPDATE, INSERT, or DELETE statement.
-
Target subfolder Applies if target is a file. —Specifies the subfolder into which the target file should be written. This option is optional. If you omit this value, the file is written to the main directory.
-
Target Filename Pattern Applies if target is a file. —Specifies the name of the file to create. The filename can include the %RUNDATE token, which is replaced with the date and time when the file is created.
-
Target Schema Applies if target is a database, or a structure external schema. —Specifies the name of previously imported data schema, such as a database table definition or a Salesforce object definition.
-
Column Mappings Applies if target is a database. —Maps source columns to fields in the target schema, including database columns or Salesforce object fields. For Salesforce Upsert operations, you must map the object’s external ID field.
-
Delimiter Applies if target is a file. —Specifies the field delimiter. This must be a single ASCII character. To specify a control character, wrap the name of the control character in angle brackets.
-
Line Terminator Applies if target is a file. —Specifies the line terminator to use when creating this file. Use a value appropriate for the target operating system.
