Fixed Flow Component
Fixed Flow Component
Allows you to generate lines of fixed input, or input from variables. Useful for simple static mappings
|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...
|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
Generates series of static select statements that return the entered values.
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.