Storage to Tables DDL files

This is the description of the DDL files used for a Storage to Tables data operation.

You need to provide one DDL file for each database table that will be created. Each DDL file should be associated with a Markdown file for documentation purposes.

👁️‍🗨️ Example

{
  "schema": [
    {
      "name": "COMPANYCODE",
      "type": "STRING",
      "description": "Company code."
    },
    {
      "name": "STOREID",
      "type": "STRING",
      "description": "ID of the store. Foreign key to stores table."
    },
    {
      "name": "STOREDESC",
      "type": "STRING",
      "description": "Store name."
    },
    {
      "name": "STORETYPE",
      "type": "STRING",
      "description": "Store type."
    }
  ]
}

⚙️ Parameters

ParameterDescription

schema

type: array

mandatory

GBQ table schema. It contains a list of fields corresponding to the number of columns found in the CSV.

Each field described has three attributes:

  • name: Name of the field. Keep column names as in the input file.

  • type: Use only the STRING type at this stage to avoid cast errors. The type can modified with a transformation operation later on.

  • description: Text describing the meaning of the data.

Last updated