Data Contract
orders-unit-test
Info
Information about the data contract
- Title
- Orders Unit Test
- Version
- 1.0.0
- Status
- active
- Description
- The orders data contract
- Owner
- checkout
- otherField
- otherValue
Servers
Servers of the data contract
-
- Server
- production
- Environment
- production
- Type
- snowflake
- Account
- my-account
- Database
- my-database
- Schema
- my-schema
Terms
Terms and conditions of the data contract
- Usage
- This data contract serves to demo datacontract CLI export.
- Limitations
- Not intended to use in production
- Billing
- free
- Notice Period
- P3M
Data Model
The logical data model
Webshop Orders
orders
table
The orders model
customModelProperty1: customModelProperty1Value
|
|||
---|---|---|---|
Order ID
order_id |
varchar |
No description
Examples:
B12345678,
B12345679
required
unique
minLength:8
maxLength:10
pattern:^B[0-9]+$
sensitive
PII
customFieldProperty1:customFieldProperty1Value
|
|
order_total
|
bigint |
The order_total field
required
maximum:1000000
Quality | SQL: 95% of all order total values are expected to be between 10 and 499 EUR.
Query:
Must Be Between: 1000 and 49900
|
|
order_status
|
text |
No description
Enum:
pending,
shipped,
delivered
required
|
|
Quality | SQL: Row Count
Query:
Must Be Greater Than: 1000
|
|||
Primary Key: ['order_id', 'order_status'] |
Definitions
Domain specific definitions in the data contract
customer_id
Unique identifier for the customer.
|
||
---|---|---|
Customer ID
customer_id |
string |
Unique identifier for the customer.
Examples:
acbd1a47-9dca-4cb8-893e-87aa0aa0f243,
5742637f-bb8b-4f0c-8ed1-afb1a91300a9
format:uuid
|
Created at 02 Feb 2025 18:36:28 UTC with Data Contract CLI v0.10.20