Automating Database Operations with Cortex Code
summary
Automates Snowflake database DevOps end to end, generating SQL, DBT projects and pipelines from spreadsheets or Git, enforcing role-limited Snowflake account RBAC and cost controls, and running local installs on Mac, Raspberry Pi and Jetson. Demonstrates an embedded video-analytics pipeline that returns structured JSON and reports 25 vehicles detected, exposes 102 skills and more than 121 interactive sessions for agents and CLIs, and produces markdown reports, query optimization, and testable artifacts ready to deploy.
AI-written summary · about
chapters (12)
- 0:00Intro to Database DevOps
- 0:50Why Snowflake for DevOps
- 2:10Setup Standards and Connections
- 4:54Security and RBAC Guardrails
- 7:53What Cortex Code Is
- 9:07DevOps Use Cases and Workflows
- 13:20Install and CLI Basics
- 16:19Skills and Advanced Automation
- 17:16Demo Video Analytics in SQL
- 18:27Interactive CLI Data Exploration
- 25:23Agents Monitoring and Reports
- 27:44Wrap Up and Thanks
related talks
36mImplementing Natural Language Analytics with Snowflake Cortex
21mUsing DBT and Python to Build Production Pipelines in Snowflake
15mFrom Air Quality to Aircraft and Automobiles, Data Is Everywhere
33mIntegrating Serverless LLMs with Data Platforms for Natural Language Analytics
28mUsing Dataops To Build And Manage Data Products On Snowflake
01h 13mBuilding a Semantic AI Layer in Snowflake: From Metrics to AI Insights
23mAcceleratinag Data Science and Machine Learning with Snowflake DataTech
35mData Pipelines for Operational Metrics