Whiskeys Data Contract

Data Contract Specification Version: 0.9.3
ID: whiskeys

---

Information

• Title: Whiskeys
• Version: 0.0.1
• Description: List of whiskies
• Links:
  • Blog

---

Servers

Production Server

Type	Catalog	Schema
Databricks	main	whiskey

Note: This will default to the context running in. See the data contract spec for remote configurations.

---

Models

Whiskeys Table

Field	Type	Required	Primary	Unique	Description	Example
whiskey_name	string	Yes	Yes	Yes	Name of the whiskey	Talisker
country	string Details Ireland, USA, Scotland, Wales	Yes	No	No	Country whiskey originates from	Ireland
last_updated	timestamp	Yes	No	No	When the whiskey was last updated	2024-01-01 12:00:00

Distilleries Table

Field	Type	Required	Primary	Unique	Description	Example
distillery_name	string	Yes	Yes	Yes	Name of the distillery	Penderyn
last_updated	timestamp	Yes	No	No	When the distillery was last updated	2024-01-01 12:00:00

---

Examples

Whiskeys Example

View Example Data (CSV)

whiskey_name,country,last_updated
Jamesons,Ireland,2024-01-01 12:00:00
Jack Daniels,USA,2024-01-01 12:00:00
Glenfiddich,Scotland,2024-01-01 12:00:00
Bushmills,Ireland,2024-01-01 12:00:00
Penderyn,Wales,2024-01-01 12:00:00

Distilleries Example

View Example Data (CSV)

distillery_name,last_updated
Penderyn,2024-01-01 12:00:00
Glenmorangie,2024-01-01 12:00:00

---

Quality Checks

SodaCL Specification

• Freshness: last_updated::timestamp < 1m
• Row Count: row_count > 5

---

Service Levels

Latency

• Description: Data is available within 25 hours after the order was placed.
• Threshold: 1 minute
• Source Timestamp Field: whiskeys.last_updated
• Processed Timestamp Field: whiskeys.last_updated

Freshness

• Description: The most recent data in the whiskeys list.
• Threshold: 1 minute
• Timestamp Field: whiskeys.last_updated

---