Snowflake · Schema

Constraint

Constraints define integrity and consistency rules for data stored in tables.

Data LakesData SharingData WarehousingDatabaseSQL

Properties

Name Type Description
name string Name of the Constraint
column_names array
constraint_type string Type of the constraint
View JSON Schema on GitHub

JSON Schema

iceberg-table-constraint-schema.json Raw ↑ 
{
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "title": "Constraint",
  "type": "object",
  "description": "Constraints define integrity and consistency rules for data stored in tables.",
  "properties": {
    "name": {
      "type": "string",
      "description": "Name of the Constraint"
    },
    "column_names": {
      "type": "array"
    },
    "constraint_type": {
      "type": "string",
      "description": "Type of the constraint"
    }
  }
}