Fixed Flow Component

Fixed Flow Component

Allows you to generate lines of fixed input, or input from variables. Useful for simple static mappings

Properties

Property Setting Description
Name Text The descriptive name for the component.
Columns Name 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 with 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...
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.
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 components. See Variables

Strategy

Generates 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 a row at a time for the set columns.

The Sample tab shows the table that has been created.