Collections

Data collections and schema definitions from Customer.io

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	String	True		Collection identifier
Name	String	False		Collection name
Bytes	Integer	True		Collection size in bytes
Rows	Integer	True		Number of rows in collection
Schema	String	True		Collection schema structure
CreatedAt	Datetime	True		Creation timestamp (Unix timestamp)
UpdatedAt	Datetime	True		Last update timestamp (Unix timestamp)

Pseudocolumns

Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.

Name	Type	Description
Data	String	Data objects in the collection
Url	String	Source URL for CSV or JSON data