Using Snowflake Cortex CLI to Build Scripts and find data in Snowflake via Datacoves

Описание: Snowflake Cortex CLI isn't just for querying Snowflake. It's a general-purpose AI coding assistant, similar to Claude Code, and can run directly inside Datacoves.

In this demo, I show how Cortex CLI can:
→ Build a Python script to query an external API (Datacoves billing)
→ Iterate on the script with natural language prompts
→ Query your Snowflake environment to find specific data (like geo tables)

If you're already using Snowflake and want AI-assisted development without leaving your data platform, Cortex CLI is worth a look.

⏱️ TIMESTAMPS
0:00 - Intro
0:36 - Creating a script to query Datacoves billing API
2:08 - Running and testing the script
2:24 - Updating the script to show monthly totals
3:02 - Test the updated script
3:17 - Using Cortex to find geo data in Snowflake
3:17 - Conclusion Cortex CLI can be used to do Snowflake and non-Snoflake tasks

KEY TAKEAWAYS
Cortex CLI works for Snowflake AND non-Snowflake tasks
It's like Claude Code but integrated with your Snowflake environment
No need for additional GenAI service
Simple to run inside Datacoves with no extra setup

Getting Started with Cortex CLI
https://docs.snowflake.com/en/user-gu...

---
About Datacoves
Datacoves is an enterprise-grade dbt Cloud alternative with managed dbt Core, Airflow orchestration, and VS Code in the browser. Integrate your preferred AI tools, including Snowflake Cortex, directly into your development workflow. Deploy in your private cloud or use our SaaS.

🔗 Learn more: https://datacoves.com
📚 Documentation: https://docs.datacoves.com
💼 Book a demo: https://datacoves.com/book-demo

#snowflake #cortex #dbt #dataengineering #aiassistant #claudecode #moderndatastack #datacoves