skills.rest
sfc-gh-samaurer
sfc-gh-samaurerCOMMUNITY
Explore all skills by this author ā†’
GitHub

sd-project-list-setup

Query Snowflake databases to generate project and milestone listings.

1|Updated Apr 8, 2026
Search Tags:#automation#project tracking#database query#snowflake#project list
One-click install
npx skills add https://github.com/sfc-gh-samaurer/Sam-Maurer-s-SnowWork-Skills-and-Files --skill sd-project-list-setup
Or copy as Structured Prompt for Agentā–¼
Please help me install this Agent Skill.
Skill: sd-project-list-setup
Source: https://github.com/sfc-gh-samaurer/Sam-Maurer-s-SnowWork-Skills-and-Files/tree/main/projects/cx-project-tracking-1.8.2/skills/sd-project-list-setup
Command: npx skills add https://github.com/sfc-gh-samaurer/Sam-Maurer-s-SnowWork-Skills-and-Files --skill sd-project-list-setup

SYSTEM DOCUMENTATION & REQUIREMENTS

šŸ’” This Skill requires snowflake-connector-python, and includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill automates the process of querying Snowflake databases to generate an up-to-date list of projects and milestones, reducing manual tracking effort.

Core Features & Use Cases

  • Project Data Retrieval: Connects to Snowflake to fetch current project and milestone information.
  • Automated List Generation: Creates a formatted sd_projects.txt file with project details for tracking or integration.
  • Use Case: When managing multiple Snowflake projects, automate the extraction and documentation of ongoing assignments and internal initiatives to maintain accurate records.

Quick Start

Use the skill to generate the project list by running the script that queries Snowflake and writes the output to ~/.snowflake/cortex/hooks/cx_projects_tracking/sd_projects.txt.

Frequently Asked Questions about sd-project-list-setup

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I automate querying Snowflake for project tracking data?ā–¼

Automating Snowflake database queries for project tracking involves running Python scripts via the Snowflake connector to fetch current project and milestone information, outputting results directly into a formatted text file.

How does automated project list generation work with Snowflake?ā–¼

Automated project list generation connects to Snowflake using Python, executes database queries to retrieve project and milestone listings, and processes the returned data into a formatted text file for tracking.

Do I need the snowflake-connector-python package to generate project lists?ā–¼

Yes, you need the snowflake-connector-python package installed in your Python environment to establish the database connection required for executing queries and retrieving project tracking data.

What is the best way to maintain real-time project listings from a Snowflake database?ā–¼

The best way to maintain real-time project listings is to automate Snowflake database queries using Python scripts, generating an updated formatted text file that captures current project and milestone details automatically.

Can I integrate Snowflake project tracking data into other internal tools?ā–¼

Yes, the process generates a formatted text file containing project and milestone details, which can be used for tracking purposes or integrated into other internal tools and documentation systems.

What format does the automated Snowflake project list output use?ā–¼

The automated project list output is written to a formatted text file named sd_projects.txt, storing the queried Snowflake database data for easy access, tracking, and downstream integration.

Related Skills

Explore More Product & Management Skillsā†’
Shamrock2245Shamrock2245
1

connecting-streamlit-to-snowflake

Establishes Snowflake database connections from Streamlit apps using st.connection and session writes.

Community
Intermediate
jdecamposjdecampos
7

Project History

Display past projects from configs/history.json with import options.

Community
Basic
randoneeringrandoneering

migrating-dbt-project-across-platforms

Migrates a dbt project between Snowflake and Databricks using dbt Fusion's real-time compilation to fix SQL dialect differences.

Community
Advanced
neo4j-contribneo4j-contrib
101

neo4j-kafka-skill

Configure Neo4j Kafka Connect sink and source pipelines with CDC query API options.

Official
Advanced