Define Extra Order Fields

Add extra fields (columns) to the order table in BigQuery.

Each row connects:

• a Field name, and

• a Data Type.

Data types you can choose

• BOOLEAN (true/false)

• INT64 (number no decimals)

• NUMERIC (number with decimals)

• STRING (text)

• TIMESTAMP (2020-01-01 00:00:00)

Good to know

• Write the field name like FieldName, field_name or fieldName. Use only a–z, with no spaces or special characters.

• This only creates the fields. You map data to them in another step.

• Adding or removing fields here after the table has been created doesn't work. The table must then be deleted and the Setup Order Table in Bigquery job run again.

• This is an advanced setting.