Skip to content

Find Broken Views in Snowflake

Click-through Demo

In this example we create a workspace called "Sprint Work Agent" that integrates Snowflake, dbt, and Jira into GitHub Copilot to find empty Snowflake views, their dbt models and filing a ticket to JIRA all within the VS Code IDE.

This walkthrough was recorded before Datamates became Workspaces, so it shows the old names. Today, the flow starts at Workspaces → New workspace in the web app.

Walkthrough

The process begins by adding these tools to the workspace as integrations. Once set up, a user can prompt GitHub Copilot to perform a series of actions. In the demo, the prompt asks Copilot to:

Query Snowflake tables in a specified schema (JAFFLE_CASTLE_20250521.DEV) to identify empty views in the mart layer. Find the associated dbt model if an empty view is found. Determine the root cause of the empty tables. Create a Jira ticket in the "AI" project, categorizing the issue as a "Task".

GitHub Copilot then outlines its steps to address the request:

  • List available Snowflake connections.
  • Query the mart layer views.
  • Check for empty tables.
  • Review corresponding dbt models.
  • Create Jira tickets for any issues discovered.

During this process, the workspace gives GitHub Copilot the tools it needs to connect to Snowflake and execute queries. Copilot successfully identifies that the MART_STORE_LIFETIME_VALUE view in Snowflake is empty. It then investigates the corresponding dbt model (mart_store_lifetime_value.sql) and discovers that a WHERE store_id IS NULL condition in a CTE (store_orders) is filtering out all records, noting that this was a test condition left in the code.

Finally, Copilot uses the workspace's Jira "Create Issue" tool to file a ticket for this issue. In essence, the demonstration highlights how AI agents, powered by Altimate Workspaces, can automate complex data engineering tasks, from identifying issues in a data warehouse (Snowflake) and debugging code (dbt) to creating project management tickets (Jira), all within a single integrated development environment (VS Code).