Tables
Artie Columns
In addition to the source table columns, you can configure Artie to add additional columns to your tables.
Columns
| Column | Data Type | Description |
|---|---|---|
__artie_operation* | STRING | The type of change that was made to the row. Possible values: CREATE, UPDATE, DELETE. |
__artie_updated_at* | TIMESTAMP_TZ | The timestamp of when Artie processed the change. |
__artie_db_updated_at* | TIMESTAMP_TZ | The timestamp of when the change occurred in your source database. |
__artie_delete | BOOLEAN | True if the row was deleted. |
__artie_only_set_delete | BOOLEAN | This column only exists if you are using S3 as your destination. This flag means that there is no additional values in the row that we need to update the destination with aside from the delete flag. |
__artie_source_table | STRING | 🚧 Coming soon. The name of the source table. |
__artie_source_schema | STRING | 🚧 Coming soon. The schema of the source table. Knowing the source table and schema may be useful if your source table is partitioned as this will contain the partition name. |
* These columns are automatically added to history tables.