인증된 시맨틱 거버넌스로 신뢰 가능한 Snowflake AI 에이전트 구축

cursor.execute(f"""
SELECT metric_name, description, expression, base_table
FROM GOVERNANCE_DB.SEMANTICS.METRIC_INVENTORY
WHERE certification_status = 'Certified'
  AND base_table IN ({table_list})
""")
metrics = [ {"metric_name": r[0], "description": r[1], "expression": r[2], "table": r[3]} for r in cursor.fetchall() ]

SYSTEM_PROMPT = """You are an expert Data Engineer building dbt semantic models for Snowflake. You will receive a JSON context payload with: - metrics: certified metric definitions (metric_name, expression, table) - catalog: physical columns per table (table, column, data_type, description, tag) - table_descriptions: [{ table, description }] source table in Snowflake Produce ONE valid dbt model file using the Snowflake-Labs dbt_semantic_view package. Output ONLY the raw file contents. No prose, no markdown fences, no preamble. Required clauses, in this exact order, separated by newlines: {{ config(materialized='semantic_view') }} TABLES ( AS {{ source('', '') }} [ PRIMARY KEY () ] [ COMMENT = '' ] ) RELATIONSHIPS ( AS () REFERENCES ) FACTS ( . AS [ COMMENT = '...' ] [, ...] ) DIMENSIONS ( . AS [ COMMENT = '...' ] [, ...] ) METRICS ( . AS [ COMMENT = '...' ] [, ...] ) COMMENT = '' PII handling: any column whose `tag` contains 'PII' (case-insensitive) MUST be excluded from FACTS, DIMENSIONS, and METRICS."""

def open_pr_for_file(owner, repo, file_path, content, commit_message, pr_title, pr_body, branch, base="master", token="", draft=False) -> str:
    if not token:
        raise ValueError("GITHUB_TOKEN is required")
    base_sha = get_default_branch_sha(owner, repo, token, base=base)
    create_branch(owner, repo, base_sha, branch, token)
    put_file(owner, repo, file_path, content, commit_message, branch, token)
    return create_pr(owner, repo, pr_title, pr_body, branch, base, token, draft=draft)

on: push:
  branches: [master]
  paths: ['semantic_models/models/semantic_views/**']
jobs:
  deploy-dbt-models:
    runs-on: ubuntu-latest
    steps:
      - uses: actions/checkout@v4
      - uses: actions/setup-python@v5
        with: { python-version: '3.10' }
      - run: pip install -r requirements.txt
      - run: dbt deps
      - run: dbt debug
      - run: dbt build --select semantic_views