​
Properties

The schema for your source is defined a YAML file:

product_catalog.yaml
name: product_catalog
description: catalog of store products
  cols:
  ProductID: String
  Name: String
  Category: String
  Description: String
  Price: Float64
settings:
  engine: MergeTree()
  order_by: "`ProductID`"
  partition_by: tuple()
​
type
string

Type of source: Table or AITable, see more on AI table (Optional)

​
name
string

Name of source

​
description
string

A brief overview of the source’s content or purpose (optional)

​
cols
{name: type}
required

Defines the schema of the source as a list of columns where each column name is a key and its data type is the value (see Data Types)

​
settings
string | {key: value} | array

ClickHouse table configuration for the source, which can include ORDER BY, PARTITION BY, Table Engine, etc. The settings can be a String, a key-value pair, or an array comprising either or both. Optional.