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

Copy
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