MiguelElGallo

Create, alter, validate, audit, debug, and optimize Snowflake semantic views using Snowflake CLI (`snow`), SQL DDL, YAML semantic view specs, Cortex Analyst verified queries, and Snowflake validation procedures. Use when asked to build semantic views, troubleshoot CREATE/ALTER SEMANTIC VIEW or SYSTEM$CREATE_SEMANTIC_VIEW_FROM_YAML failures, enrich comments/synonyms/metrics/filters/relationships, add or validate AI_VERIFIED_QUERIES, or test semantic views against Snowflake.

Create, alter, validate, audit, debug, and optimize Snowflake semantic views using Snowflake CLI (`snow`), SQL DDL, YAML semantic view specs, Cortex Analyst verified queries, and Snowflake validation procedures. Use when asked to build semantic views, troubleshoot CREATE/ALTER SEMANTIC VIEW or SYSTEM$CREATE_SEMANTIC_VIEW_FROM_YAML failures, enrich comments/synonyms/metrics/filters/relationships, add or validate AI_VERIFIED_QUERIES, or test semantic views against Snowflake.

Inspect Parquet file metadata with the iParq CLI, including compression, encodings, physical and logical types, row groups, statistics, dictionary pages, page indexes, Bloom filters, and storage sizes. Use when an agent needs to explain how one or more .parquet files were written, compare their storage-level features, diagnose missing Parquet optimizations, or obtain machine-readable Parquet metadata without reading the row data.

Deploy and validate the AzQuack repo on Azure, then run the local DuckDB samples that attach to the Azure-hosted DuckDB over Quack and write/read DuckLake data. Use when working in the azquack repo for azd provisioning, live deployment checks, Quack/DuckLake sample runs, troubleshooting failed revisions, or cleanup.

Fresh-install or safely resume dbtobsb v0.5.0 in Azure Databricks, run the approved installed dbt Core weather or qualification workload, prove model results, structured logs, collection state, and dashboard trends in customer-local evidence views, and finish with compute stopped. Use when a user asks an agent to install dbtobsb, run the demo or qualification project, make a first observed run, execute the v0.5 live qualification matrix, test capture end to end, or verify dbt observability after cloning this repository.

Use when a user is enabling, configuring, optimizing, or debugging dbt State (the server-backed reuse mechanism that clones or skips nodes instead of rebuilding them). Use when they conflate dbt State with the `state:modified` selector or `--state` deferral. Use when asked about models rebuilding unexpectedly, views with `select *` rebuilding, volatile SQL (`current_timestamp()`, `random()`) rebuilding or not, cross-developer cloning, lag_tolerance.