Fixed Flow Component

Fixed Flow Component



Fixed Flow Component

This component allows you to generate lines of fixed input, or input from variables. This component is useful for simple static mappings


Redshift Properties

Property Setting Description
Name String Input the descriptive name for the component.
Columns The name of the input column.
Type Text: This type can hold any type of data, subject to a maximum size. More...
Integer: This type is suitable for whole-number types (no decimals). More...
Numeric: This type is suitable for numeric types, with or without decimals. More...
Boolean: This type is suitable for data that is either 'true' or 'false'. More...
Date: This type is suitable for dates without times. More...
DateTime: This type is suitable for dates, times, or timestamps (both date and time). More...
Values Text, Numeric, or DateTime A dynamic table of values with one column for each column created above.
Note: Variables can be used in this component. See Variables for additional help.

Snowflake Properties

Property Setting Description
Name String Input the descriptive name for the component.
Columns The name of the input column.
Type VARCHAR: This type is suitable for strings and text. More...
NUMBER: This type is suitable for whole-number types (no decimals). More...
FLOAT: This type is suitable for numeric types, with or without decimals. More...
BOOLEAN: This type is suitable for data that is either 'true' or 'false'. More...
DATE: This type is suitable for dates without times. More...
TIMESTAMP: This type is a timestamp left unformatted (exists as Unix/Epoch Time). More...
TIME: A formatted time object without date. More...
VARIANT: A flexible type that can be used for any purpose.
Values Text, Numeric, or DateTime A dynamic table of values with one column for each column created above.
Note: Variables can be used in this component. See Variables for additional help.

BigQuery Properties

Property Setting Description
Name String Input the descriptive name for the component.
Columns The name of the input column.
Data Type For more information on available BQ datatypes please refer to the Google Cloud documentation.
String: This type can hold any type of data, subject to a maximum size.
Integer: This type is suitable for whole-number types (no decimals).
Float: This type is suitable for numeric types, with or without decimals.
Boolean: This type is suitable for data that is either "true" or "false".
Date: A formatted date object without time. See the Official GCP documentation
Time: A formatted time object without date. See the Official GCP documentation
DateTime: A formatted timestamp containing both date and time that is easily readable by the user. See the Official GCP documentation
Timestamp: This type is a timestamp left unformatted (exists as Unix/Epoch Time).
Values Text, Numeric, or DateTime A dynamic table of values with one column for each column created above.
Note: Variables can be used in this component. See Variables for additional help.

Strategy

Generates a series of static select statements that return the entered values.

Example

This job uses a Fixed Flow Component to embellish the name and country of the airport onto the raw flights data.

Note: The Map Values component should also be considered in this scenario and is likely to be more efficient.

The table name is set first. Then, the user is prompted to set at least one Column, then the values are set of those columns.

Columns are added with an appropriate data type.

Data is then entered, one row at a time, for the set columns.

The Sample tab shows the table that has been created.