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.