Databricks Field Guide by TechFabric

{
  "type": "object",
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "required": [
    "workload"
  ],
  "properties": {
    "size": {
      "type": "string",
      "maxLength": 20,
      "description": "apps: medium (the default), large or xlarge; sql_warehouse: the t-shirt size, 2x-small, x-small, small, medium, large, x-large, 2x-large, 3x-large, 4x-large (DBUs an hour per cluster, from the guide); model_serving with serving gpu: t4, a10g, a10g-4, a10g-8, l40s, rtx-pro-6000, a100-40gb-8, a100-80gb-8, h100, h100-8"
    },
    "model": {
      "type": "string",
      "maxLength": 80,
      "description": "model_serving, pay_per_token or provisioned_throughput: the model, as in 'Llama 3.3 70B' or 'claude-sonnet-5.5'"
    },
    "users": {
      "type": "integer",
      "maximum": 1000000,
      "minimum": 0,
      "description": "genie: the people using it"
    },
    "compute": {
      "enum": [
        "serverless",
        "classic",
        "pro"
      ],
      "type": "string",
      "description": "jobs and all_purpose: serverless or classic; sql_warehouse: serverless, pro, classic"
    },
    "serving": {
      "enum": [
        "pay_per_token",
        "provisioned_throughput",
        "gpu",
        "cpu"
      ],
      "type": "string",
      "description": "model_serving: pay_per_token, provisioned_throughput, gpu or cpu (omit for every price the guide states)"
    },
    "clusters": {
      "type": "integer",
      "maximum": 1000,
      "minimum": 1,
      "description": "sql_warehouse: clusters running (default 1)"
    },
    "workload": {
      "enum": [
        "jobs",
        "all_purpose",
        "sql_warehouse",
        "apps",
        "genie",
        "lakebase",
        "model_serving",
        "storage"
      ],
      "type": "string",
      "description": "jobs, all_purpose (interactive notebooks), sql_warehouse, apps, genie, lakebase, model_serving or storage"
    },
    "always_on": {
      "type": "boolean",
      "description": "lakebase: an always-on 0.5 CU floor (the one Lakebase figure the guide quotes)"
    },
    "instances": {
      "type": "integer",
      "maximum": 10000,
      "minimum": 1,
      "description": "jobs or all_purpose, classic: instances in the cluster, the driver counted as one; model_serving cpu: Medium configurations"
    },
    "storage_gb": {
      "type": "number",
      "maximum": 1000000000,
      "minimum": 0,
      "description": "storage: GB held"
    },
    "model_units": {
      "type": "integer",
      "maximum": 100000,
      "minimum": 1,
      "description": "model_serving, provisioned_throughput: model units (default 50, the block the rates are quoted for; a reservation takes multiples of 50 and bills every hour of its term)"
    },
    "reservation": {
      "enum": [
        "on_demand",
        "1_month",
        "3_month"
      ],
      "type": "string",
      "description": "model_serving, provisioned_throughput: on_demand, 1_month or 3_month"
    },
    "max_clusters": {
      "type": "integer",
      "maximum": 1000,
      "minimum": 1,
      "description": "sql_warehouse: the most clusters it scales out to; the estimate ranges from clusters to max_clusters"
    },
    "dbus_per_hour": {
      "type": "number",
      "maximum": 100000,
      "minimum": 0,
      "description": "DBUs the compute uses an hour, when the guide has no figure for its shape (a serverless job, an instance type it does not list): from system.billing.usage or Databricks' pricing calculator"
    },
    "dbus_per_user": {
      "type": "number",
      "maximum": 1000000,
      "minimum": 0,
      "description": "genie: each user's Genie DBUs a month"
    },
    "hours_per_day": {
      "type": "number",
      "maximum": 24,
      "minimum": 0
    },
    "instance_type": {
      "type": "string",
      "maxLength": 40,
      "description": "jobs or all_purpose, classic: the AWS instance type (m5.xlarge, m5.2xlarge, m6i.xlarge, m7i.xlarge, r5.xlarge, c5.2xlarge, i3.xlarge, i3.2xlarge are in the guide)"
    },
    "days_per_month": {
      "type": "number",
      "maximum": 31,
      "minimum": 1,
      "description": "Days it runs a month (default 30 with hours_per_day)"
    },
    "dbus_per_month": {
      "type": "number",
      "maximum": 100000000,
      "minimum": 0,
      "description": "Or the DBUs a month outright"
    },
    "hours_per_month": {
      "type": "number",
      "maximum": 744,
      "minimum": 0
    },
    "input_tokens_millions": {
      "type": "number",
      "maximum": 10000000,
      "minimum": 0,
      "description": "model_serving, pay_per_token: input tokens a month, in millions"
    },
    "output_tokens_millions": {
      "type": "number",
      "maximum": 10000000,
      "minimum": 0,
      "description": "model_serving, pay_per_token: output tokens a month, in millions"
    }
  },
  "additionalProperties": false
}

{
  "type": "object",
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "required": [
    "slug"
  ],
  "properties": {
    "slug": {
      "type": "string",
      "maxLength": 500,
      "minLength": 1,
      "description": "A chapter's slug (lakebase, unity-catalog, start-here), a note's slug, or a guide URL or path. list_chapters has them; the field-guide-chapter prompt completes them."
    },
    "section": {
      "type": "string",
      "maxLength": 200,
      "description": "One section only: its anchor (from search_guide, list_chapters or the outline) or its heading. Omit for the whole chapter."
    }
  },
  "additionalProperties": false
}

{
  "type": "object",
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "required": [
    "topic"
  ],
  "properties": {
    "lang": {
      "type": "string",
      "maxLength": 20,
      "description": "Only this language: sql, python, bash, yaml, json, hcl ..."
    },
    "limit": {
      "type": "integer",
      "maximum": 25,
      "minimum": 1,
      "description": "How many examples (default 8)"
    },
    "topic": {
      "type": "string",
      "maxLength": 200,
      "minLength": 1,
      "description": "What the code should do or touch, e.g. 'lakebase branch', 'auto loader', 'row filter'"
    },
    "chapter": {
      "type": "string",
      "maxLength": 500,
      "description": "Only examples from this chapter or note: its slug (lakebase, unity-catalog), path or URL. list_chapters has them; the field-guide-code prompt completes them."
    }
  },
  "additionalProperties": false
}

{
  "type": "object",
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "properties": {},
  "additionalProperties": false
}

{
  "type": "object",
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "required": [
    "code"
  ],
  "properties": {
    "code": {
      "type": "string",
      "maxLength": 48000,
      "minLength": 1,
      "description": "The file's contents: SQL, Python (PySpark, a notebook's source) or YAML (a Databricks Asset Bundle, job, cluster or warehouse config). At most 48000 characters; review a larger file in parts."
    },
    "lang": {
      "enum": [
        "sql",
        "python",
        "yaml"
      ],
      "type": "string",
      "description": "sql, python or yaml. Omit to detect it from the filename or the code."
    },
    "filename": {
      "type": "string",
      "maxLength": 300,
      "description": "The file's path in the repository, e.g. resources/nightly.job.yml: used to detect the language and echoed back"
    }
  },
  "additionalProperties": false
}

{
  "type": "object",
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "required": [
    "query"
  ],
  "properties": {
    "kind": {
      "enum": [
        "chapter",
        "note",
        "feature",
        "event"
      ],
      "type": "string",
      "description": "Only chapters, margin notes (dated news with our position), feature pages or events"
    },
    "limit": {
      "type": "integer",
      "maximum": 25,
      "minimum": 1,
      "description": "How many results (default 10)"
    },
    "query": {
      "type": "string",
      "maxLength": 200,
      "minLength": 1,
      "description": "The question or topic in plain words, e.g. 'lakebase branch' or 'unity catalog row filters'"
    }
  },
  "additionalProperties": false
}

{
  "type": "object",
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "properties": {
    "limit": {
      "type": "integer",
      "maximum": 200,
      "minimum": 1,
      "description": "How many items (default 30)"
    },
    "since": {
      "type": "string",
      "pattern": "^\\d{4}-\\d{2}-\\d{2}$",
      "description": "Changes on or after this day, YYYY-MM-DD (default: the last 30 days)"
    }
  },
  "additionalProperties": false
}