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

Parameter
Description
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.