snow helpers generate-project-schema

Generates a JSON Schema for the Snowflake CLI project definition file (snowflake.yml). Save the output and reference it from your editor (for example, the YAML extension for VS Code, using a # yaml-language-server: $schema=... modeline or the extension’s schema mapping) or from a CI pipeline to get completion and to catch structural mistakes such as unknown keys, wrong types, or missing required fields before a deploy. The schema is generated from the CLI’s own models, so it stays in sync with the structural rules the CLI enforces. Some cross-field and semantic checks are only applied at load or deploy time.

Syntax

snow helpers generate-project-schema
  --definition-version <version>
  --output-file <output_file>
  --format <format>
  --verbose
  --debug
  --silent
  --enhanced-exit-codes
  --decimal-precision <decimal_precision>

Arguments

None

Options

--definition-version [1%1.1%2]

Project definition version to generate the schema for. Default: 2.

--output-file, -o FILE

Writes the JSON Schema to this file. When omitted, the schema is printed to standard output.

--format [TABLE%JSON%JSON_EXT|CSV]

Specifies the output format. Default: TABLE.

--verbose, -v

Displays log entries for log levels info and higher. Default: False.

--debug

Displays log entries for log levels debug and higher; debug logs contain additional information. Default: False.

--silent

Turns off intermediate output to console. Default: False.

--enhanced-exit-codes

Differentiate exit error codes based on failure type. Default: False.

--decimal-precision INTEGER

Number of decimal places to display for decimal values. Uses Python’s default precision if not specified. [env var: SNOWFLAKE_DECIMAL_PRECISION].

--help

Displays the help text for this command.

Usage notes

The generated schema describes the structure of the snowflake.yml project definition file for the selected definition version. Use the --definition-version option to choose the version (1, 1.1, or 2; the default is 2), and the --output-file (or -o) option to write the schema to a file instead of printing it to standard output.

Because the schema is derived from the CLI’s own models, it validates the structure of the file, for example unknown keys, incorrect types, and missing required fields. Some cross-field and semantic checks are applied only when the project is loaded or deployed, so a file that matches the schema can still fail at deploy time.

Examples

  • Print the schema for the default (version 2) project definition to standard output:

    snow helpers generate-project-schema

  • Write the schema to a file that your editor or CI pipeline can reference:

    snow helpers generate-project-schema --output-file snowflake-schema.json

  • Generate the schema for a version 1.1 project definition:

    snow helpers generate-project-schema --definition-version 1.1