Hevo-generated Metadata

In the process of ingesting Events from a database Source or a SaaS Source and uploading them to the Destination, Hevo may add metadata columns to the Destination tables. This depends on the options you specify during Pipeline creation for the ingestion and uploading of the data, and on the nature of the Destination system itself. Some of these columns are transient, while some are permanent.

The following table describes the metadata columns that Hevo generates:

Metadata Column	Description
__hevo_id	A field added to Events in Sources which do not provide any primary key by default to load unique Events to the Destination. Read __hevo_id.
__hevo_database_name	A field used to identify the database from which a particular row in the Destination originated, when data is being loaded from multiple databases. Read __hevo_database_name.
__hevo_ingested_at	A timestamp that helps to verify that the ingested Event is more current than what already exists in the Destination. This field is not visible in the Schema Mapper. Read Additions to the Destination Schema.
__hevo_loaded_at	A timestamp that indicates when data was inserted, updated, or deleted (delete flag updated) in the Destination table. This field is not visible in the Schema Mapper. Read Additions to the Destination Schema.
__hevo__marked_deleted	A column that logically represents a deleted Event. This field is not visible in the Schema Mapper. Read Additions to the Destination Schema.
__hevo_report_date	A column that indicates the date(s) for which a report is generated by Hevo. Refer to the respective Source document to know more about the availability of this field for your Source.
__hevo_source_modified_at	A timestamp that indicates when the Event was created, updated, or deleted in the Source. This field is not visible in the Schema Mapper. Read __hevo_source_modified_at.
is_row_deleted	A column that logically represents a deleted Event in a Stripe Source. This field is visible in the Schema Mapper. Read Additions to the Destination Schema.
deleted_timestamp	A timestamp that indicates when the Event was deleted in a Stripe Source. This field is visible in the Schema Mapper. Read Additions to the Destination Schema.

---

• Articles in this section
  • Metadata Column __hevo_database_name
  • Metadata Column __hevo_id
  • Metadata Column __hevo_source_modified_at