Skip to main content

Create Data Contract

Data contracts are currently available for tables ingested into Collate. The following guide shows how a data contract was created for a snowflake.DEMO_STAGE.JAFFLE_SHOP.CUSTOMERS table. To create a Data Contract for a Table in Collate:
  • Go to the Table’s page, select Contract, then + Add Contract
Adding a Data Contract to an Collate Table
  • In Contract Details, be sure to give your new data contract a name. Optionally, you can assign Owners and provide a description of your data contract. Then select Schema.
Adding Contract Details
  • Select the columns of your table that you would like to add to your new data contract, or select all columns by checking the box at the top right. Then select Semantics
Selecting a schema for an Collate Data Contract
  • Add the business rules you would like to enforce in Semantics. For Collate Tables, rules can be created for:
    • Service
    • Owners
    • Display Name
    • Name
    • Description
    • Tags
    • Domain
    • Data Product
    • Tier
Adding rules to an Collate Data Contract
  • Once a rule is created, you can + Add New Rule to create more, or select Quality
Adding more rules to an Collate Data Contract
  • Select + Add Test to add a Data Quality Test or tests to your new contract, then select Save
Adding data quality tests to an Collate Data Contract
  • Once your new data contract has been created successfully, you can run it by selecting > Run now
Running an Collate Data Contract