Analytics Team Workflows

Contains workflows, prompts, and automations for the Analytics Team to use across projects.

Cursor Rules

The .cursor/ directory contains rules for directing Cursor when using an LLM to generate models or documentation. The current rules are:

• dbt-documentation-standards: Contains general standards for documenting a dbt model, including table-level and column-level requirements.
• dbt-overview-standards: Contains guidance on maintaining the __overview__.md for a dbt project, including keeping the list of quicklinks up to date and adding a set of XML tags for LLM use.
• general-coding-standards: Contains general coding standards for dbt models, including naming conventions, documentation requirements, and code structure.
• review-dbt-documentation: A process-based rule for use in reviewing and updating out of date model documentation. Specifically geared towards modernizing a project's documentation for the AI platform.

Claude Subagents

Claude subagents are extremely useful for automating tasks and workflows when the process can be easily defined and described. Read more here. The defined subagents, at the moment, are:

• dbt-job-failure-investigator: This subagent is designed to identify the cause of and suggest solutions to failed github actions workflows. The gh cli tool is required for the agent to properly find the failed workflow and read the logs. The snow cli tool allows the agent to access Snowflake to read recent query logs and replicate the issue for triage.
  • Save this file in ~/.claude/agents/ for global access or simply in the <project>/.claude/agents/ for use in a specific project.
  • Run the agent from the repository root of the target project as that will allow the agent access to read the dbt models to help diagnose the issue.

Snow CLI Quickstart

1. Install

# macOS (Homebrew)
brew tap snowflakedb/snowflake-cli
brew install snowflake-cli

# Any OS (pipx)
pipx install snowflake-cli

2. Add a Connection

snow connection add
# follow prompts: account, user, role, warehouse

3. Test Connection

snow connection test --connection <name>

4. Run SQL

snow sql -c <name> -q "SELECT CURRENT_USER();"

5. Config Location
~/.snowflake/config.toml

GitHub CLI Quickstart

1. Install

# macOS (Homebrew)
brew install gh

# Ubuntu/Debian
sudo apt install gh

# Fedora/RHEL
sudo dnf install gh

2. Authenticate

gh auth login
# follow prompts: GitHub.com, HTTPS, browser login or token

3. Test

gh repo view owner/repo

4. Common Commands

gh repo clone owner/repo
gh pr create
gh issue list