snowflake-semanticview

Build and validate Snowflake semantic views using Snowflake CLI with guided DDL creation and testing. If the CLI uses a different connection flag in your version, run: - Handles the complete semantic view lifecycle: drafting DDL, populating synonyms and comments from Snowflake table metadata, validating against Snowflake via CLI, and executing final CREATE or ALTER statements - Requires one-time Snowflake CLI installation and connection setup; confirms prerequisites before proceeding with validation - Validates all DDL against Snowflake using temporary view names before applying final definitions, then runs sample queries to confirm functionality - Guides discovery of fact-dimension relationships and column metadata through SELECT statements, and manages synonyms and comments as required semantic view components - Verify Snowflake CLI installation by opening a new terminal and running snow --help . - If Snowflake CLI is missing or the user cannot install it, direct them to . - Configure a Snowflake connection with snow connection add per . - Use the configured connection for all validation and execution steps. - Confirm the target database, schema, role, warehouse, and final semantic view name. - Confirm the model follows a star schema (facts with conformed dimensions). - Draft the semantic view DDL using the official syntax: - - Populate synonyms and comments for each...