Add columns to a table

Add new columns to a table. You must pass a SQL expression to generate the new columns. This expression can reference existing columns.

For example, you can add a new column new_column that is old_column + 1:

{
  "new_columns": [
    {
      "name": "new_column",
      "expression": "old_column + 1"
    }
  ]
}

If you want to fill with null, you can use a NULL expression with a cast to the correct type:

{
  "new_columns": [
    {
      "name": "new_column",
      "expression": "CAST(NULL AS int64)"
    }
  ]
}

Some example data types:

• int64
• float32
• string