Tools, YAML and JSON

YAML to JSON, and a dbt properties check.

Paste YAML or JSON to convert between them and, for a dbt properties file such as schema.yml, see whether its resources and columns have names and descriptions, and whether a resource sets both tests and data_tests.

Check as a dbt properties file

YAML input

version: 2

models:
  - name: orders
    description: One row per customer order.
    columns:
      - name: order_id
        description: The order's primary key.
        data_tests:
          - unique
          - not_null
      - name: customer_id
        data_tests:
          - not_null

JSON output

{
  "version": 2,
  "models": [
    {
      "name": "orders",
      "description": "One row per customer order.",
      "columns": [
        {
          "name": "order_id",
          "description": "The order's primary key.",
          "data_tests": [
            "unique",
            "not_null"
          ]
        },
        {
          "name": "customer_id",
          "data_tests": [
            "not_null"
          ]
        }
      ]
    }
  ]
}

dbt properties check

1 advice, 0 warnings, 0 errors

Advicemodels[0].columns[1].description$.models[0].columns[1] has no description. dbt accepts one on every resource and column, and it appears in generated documentation (docs.getdbt.com/reference/resource-properties/description).

What it checks and does not

What YAML to JSON checks and does not, one row per area
Area	Checks	Does not
Conversion	Converts valid YAML to JSON, and JSON back to YAML.	—
dbt properties shape	Checks `version`, `models`, `sources`, `seeds`, `snapshots`, `macros` and `exposures`.	Not a full dbt parse: no run, refs, sources, macros or config check.
Findings levels	Groups findings as `Error`, `Warning` or `Advice`, and links each citation to the dbt documentation it cites.	Does not fail or block conversion; `Error` findings are informational only.
Limits	Refuses input over 200 KB and a YAML alias bomb.	—

Conversion
Converts valid YAML to JSON, and JSON back to YAML.
dbt properties shape
Checks version, models, sources, seeds, snapshots, macros and exposures.
Not a full dbt parse: no run, refs, sources, macros or config check.
Findings levels
Groups findings as Error, Warning or Advice, and links each citation to the dbt documentation it cites.
Does not fail or block conversion; Error findings are informational only.
Limits
Refuses input over 200 KB and a YAML alias bomb.

Rules this check applies

Rule	Level
Name requiredEvery model, source, table, seed, snapshot, macro, exposure and column needs a name.	Errordbt docs
Exposure type requiredAn exposure needs a type: dashboard, notebook, analysis, ml or application.	Errordbt docs
tests and data_tests togetherA resource cannot set both tests and data_tests at the same time.	Errordbt docs
version valueThe version key is optional; when present, only version: 2 is supported.	Errordbt docs
Unknown top-level keyA key outside version, models, sources, seeds, snapshots, macros and exposures.	Warningdbt docs
Missing descriptionA resource or column has no description; dbt accepts one and shows it in docs.	Advicedbt docs

Not affiliated with dbt Labs.

dbt properties check

What it checks and does not

Rules this check applies

Sources