Skip to main content
Artie can add columns prefixed with __artie_ to your destination tables. These columns track how and when each row was changed. You can configure them in your pipeline’s destination Advanced settings or under table settings.

​
Artie operation column

In normal mode, enable Add ‘Artie operation’ column in your pipeline’s destination Advanced settings to add __artie_operation to the destination table. The column identifies the operation that most recently produced the row. In history mode, __artie_operation is included in each history record and identifies the operation that produced that record.

​
History mode columns

These columns are automatically added to tables using history mode. They provide a full audit trail of every change.

​
Soft delete columns

These columns are added when soft deletes are enabled. Instead of removing deleted rows, Artie flags them so you can retain the data.
Both columns indicate a deletion, but they serve different purposes:
  • __artie_delete is set to true whenever a row is deleted.
  • __artie_only_set_delete is set to true when the delete event carries no additional column values - meaning there is nothing to update in the destination besides the delete flag.
For example, if a row is updated and then deleted within the same flush cycle, the event contains both the updated values and the deletion. In that case, __artie_delete = true and __artie_only_set_delete = false.

​
Static columns

Static columns let you add custom key-value pairs to every row written to your destination table. Each static column has a fixed name and value that you define - the value does not change per row. This is useful when you need to tag rows with metadata that isn’t present in the source, such as an environment label, a data source identifier, or a tenant ID. You can configure static columns under your table settings.

​
Source metadata columns

These columns provide context about where each row originated and the underlying database event that produced it. You can enable them under your table settings.