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