System Columns
This article explains the system columns that are automatically appended to your tables.
When you ingest your data into Upsolver, your table is enriched with various system columns that are generated by Upsolver based on your data.
The specific columns and what they describe are detailed below:
General
These columns are applicable to all staging tables:
Storage
These columns are applicable to staging tables with data ingested from storage connections, for example Amazon S3:
Streaming
These columns are applicable to staging tables with data ingested from streaming sources:
Amazon Kinesis
These columns are applicable to staging tables with data ingested from Kinesis:
Apache Kafka
These columns are applicable to staging tables with data ingested from Kafka:
Databases (CDC)
These columns apply to staging tables with data ingested from database (CDC) sources:
Microsoft SQL Server
These columns apply to staging tables with data ingested from Microsoft SQL Server:
MongoDB
These columns apply to staging tables with data ingested from MongoDB:
MySQL
These columns apply to staging tables with data ingested from MySQL:
PostgreSQL
These columns apply to staging tables with data ingested from PostgreSQL:
Last updated