DELIVERIES view
This Information Schema view displays a row for each delivery of your selected project. For every changed instance in a successful build a delivery record will be created. The delivery record will contain information about the number of changes of the instance. This view will display the same information as the Delivery Report inside the Projects section.
Columns
| Column | Data Type | Description |
|---|---|---|
| ID | integer | The unique ID of the delivery record |
| PATTERN | string | The pattern to which the instance belongs |
| FOLDER | string | The folder path to the instance |
| INSTANCE | string | The name of the instance |
| RELEASE | string | The release in which the instance was built |
| USER_NAME | string | The name of the user who created the build |
| BUILD_START | timestamp | The build start time |
| BUILD_ID | integer | The ID of the build |
| COMPARE_TO_BUILD_ID | integer | The ID of the build to which you have to compare against to see the changes |
| MODE | string | The mode of the delivery, either 'CREATION' or 'INST_DELTA' |
| FIELD_COUNT | integer | The total number of fields/rows in the instance |
| CHANGE_COUNT | integer | The number of changed fields/rows for this instance |
| ADDED | integer | The number of added fields/rows |
| CHANGED | integer | The number of changed fields/rows |
| DELETED | integer | The number of deleted fields/rows |
Examples
The following query retrieves all delivery records inside the current project.
sql
SELECT * FROM @INFORMATION_SCHEMA.DELIVERIES;txt
+----+-----------------+------------+--------------+-----------+-----------------+---------------------+----------+---------------------+------------+-------------+--------------+-------+---------+---------+
| ID | PATTERN | FOLDER | INSTANCE | RELEASE | USER_NAME | BUILD_START | BUILD_ID | COMPARE_TO_BUILD_ID | MODE | FIELD_COUNT | CHANGE_COUNT | ADDED | CHANGED | DELETED |
+----+-----------------+------------+--------------+-----------+-----------------+---------------------+----------+---------------------+------------+-------------+--------------+-------+---------+---------+
| 15 | CORE_DATA_VAULT | /RAW_VAULT | ACCOUNT_HUB | R.2025.Q3 | max@muster.com | 2025-08-23 13:11:01 | 4711 | null | CREATION | 67 | 67 | 67 | 0 | 0 |
| 16 | CORE_DATA_VAULT | /RAW_VAULT | CUSTOMER_SAT | R.2025.Q3 | max@muster.com | 2025-08-23 13:11:01 | 4711 | null | CREATION | 53 | 53 | 53 | 0 | 0 |
| 17 | LDG_FLAT_FILE | /SRC_A | Acc_obj_tbl | R.2025.Q3 | johndoe@web.com | 2025-08-23 15:31:54 | 4713 | 4702 | INST_DELTA | 124 | 3 | 1 | 1 | 1 |
| 18 | LDG_FLAT_FILE | /SRC_B | Partners | R.2025.Q3 | johndoe@web.com | 2025-08-23 16:41:21 | 4714 | 4703 | INST_DELTA | 98 | 5 | 2 | 2 | 1 |
+----+-----------------+------------+--------------+-----------+-----------------+---------------------+----------+---------------------+------------+-------------+--------------+-------+---------+---------+