Where applicable the Hippobyte platform creates additional columns on managed tables within your warehouse. Metadata columns provide you visibility into how data is managed within your warehouse.
Depending on connector, a table in your warehouse may contain some, or all of the following columns.
| Column Name | Type | Description |
|---|---|---|
| `hkey | Big Integer | Utilized internally by Hippobyte to prevent duplicate records in your table | ||
| `hindex | Big Integer | Utilized internally by Hippobyte to keep track of order of records | ||
| `hvalue | Text/JSON | Utilized internally by Hippobyte to keep track of row’s metadata | ||
| `hstatus | Integer | Indicates status of row, see below table for translation | ||
| `hcreated_at | Timestamp | Indicates UTC timestamp of initial data row replication between Hippobyte and your data warehouse | ||
| `hupdated_at | Timestamp | Indicates UTC timestamp of latest data row replication event between Hippobyte and your data warehouse |
The following status values refer to the `hstatus field defined above.
| Key | Status | Description |
|---|---|---|
| 0 | Current | Indicates record is current. |
| 10 | Trended | Indicates record is a previous version of a trended data record. |
| 30 | Expired | Indicates record is expired and pending deletion. Not for use by data consumers |
| 50 | Pending | Indicates record is pending replication. Not for use by data consumers |