Backup Status
Displays the current last backup status for a device, the last 5 backs and the last 28 backups
Methodology: Kimball Star Schema.
Fact Type: Transactional
Grain: Device and backup product.
Backup Status schema
Backup Status table joins
FACT: FACT_BACKUP_STATUS
Dimension | Dimension key | Fact key | Cardinality |
DIM_TENANT |
TENANT_DK |
TENANT_DK |
1:N |
DIM_DEVICE_SUMMARY_LATEST |
DEVICE_DK |
DEVICE_DK |
1:N |
DIM_BACKUP_PRODUCT |
BACKUP_PRODUCT_SK |
BACKUP_PRODUCT_SK |
1:N |
Boilerplate for Backup Status joins
Select
-- enter columns here
From "Snowflake Instance"."Schema"."FACT_BACKUP_STATUS" f
join "Snowflake Instance"."Schema"."DIM_DEVICE_SUMMARY_LATEST" dl on f.Device_DK = dl.Device_DK
join "Snowflake Instance"."Schema"."DIM_BACKUP_PRODUCT" b on f.Backup_Product_SK = b.Backup_Product_SK
-- Where clauses here
-- Group By columns here
-- Having clauses here
-- Order by columns here