Automate a Jira to Snowflake workflow with Claude Code

Watch one Claude Code prompt take a Jira ticket to a finished Snowflake analysis in a live meetup demo.

Who it's for: Data teams who work from tickets and want Claude Code to handle the execution.

The problem: Without business context, AI performs like a new hire who does not know your databases or workflows.

At the Arizona AI & Emerging Technology Meetup, a CLAUDE.md file, ticket folders and command line tools give Claude Code that context. One prompt loads a CO2 dataset into S3 and Snowflake and finds the top 10 emitting countries, with Q&A on security, compaction and plan mode.

Takeaways:

  • Context is everything, so keep adding rules to CLAUDE.md.
  • Have Claude Code output its SQL and results for auditing.
  • Add QC checks, like matching CSV and table row counts.

Resources