Data Type Converter

In this article

Overview

This snap is used to Convert/Map data and metadata from source database to target cloud data warehouse

Snap Type

Data Type Converter Snap is a Write type Snap.

Prerequisites

  • None.

Limitations and Known Issues

None.

Accounts

This Snap dose not require any account.

Snap Views

Type

Description

Type

Description

Input 

This Snap has at most two document input views. Each document contains data in the form of json..

Output

This Snap has at most two document output views. Each document contains corresponding response in the form of json.

Error

This Snap has at most one document error view and produces zero or more documents in the view. Each document contains the corresponding error record if snap is not able to process data.

Snap Settings

Field Name

Description

Field Name

Description

Label

required

The name for the Snap. You can modify this to be more specific, especially if you have more than one of the same Snap in your pipeline.

Convert

required

Contains the dropdown list of supported conversions by the snap.

Values: SQL Server to Snowflake and Postgres to Snowflake

 

Case Handling

Contains the dropdown list of case conversions when converting source to target filed definitions.

Values: UnChanged, UPPERCASE,lowercase

Snap Execution

optional

Specifies the execution type:

  • Validate & Execute: Performs limited execution of the Snap (up to 2000 records based on Preview doc count, default is  50 records) during Pipeline validation; performs full execution of the Snap (unlimited records) during Pipeline execution.

  • Execute only: Performs full execution of the Snap during Pipeline execution; does not execute the Snap during Pipeline validation.

  • Disabled: Disables the Snap and, by extension, its downstream Snaps.

Default value: Execute only

Snap Pack History