Collate version 1.11.0

*Struggling to track when your data pipelines last ran or when they'll update next?* Collate 1.11's new pipeline observability feature gives data engineers complete visibility into pipeline execution, scheduling, and performance across your entire data stack. In this demo, we walk through the common challenge of limited pipeline visibility. While lineage views show how data flows between tables, they don't reveal execution frequency, last run times, or the complete transformation picture. The new pipeline observability dashboard solves this by centralizing all pipeline metrics in a single location. *What You'll Learn:* * How to access and navigate the pipeline observability dashboard with customizable date ranges and filters * Ways to monitor execution history, success/failure rates, and duration metrics across all configured pipelines * How to identify which tables are impacted by specific pipelines and track their update schedules *Demo Highlights:* * View comprehensive pipeline metrics, including total pipelines, active/inactive status, and execution history for dbt Cloud, Airflow, Kafka, FiveTran, and other supported platforms * Drill down into individual pipeline schedules to see daily run times, next scheduled executions, and success rates * Access pipeline information directly from table views to instantly see when data was last updated and when the next refresh occurs This feature provides data engineers with the visibility needed to detect anomalies faster, troubleshoot issues more efficiently, and better understand data flow across your organization. Whether you're managing dbt transformations in Redshift or orchestrating complex data pipelines, pipeline observability gives you the complete picture. Learn more about Collate: https://www.getcollate.io/ Try Collate's Managed OpenMetadata Service with Demo Data: https://sandbox.open-metadata.org/ #DataEngineering #PipelineObservability #DataGovernance #DBTCloud #MetadataManagement #DataOps #DataLineage #OpenMetadata #DataQuality #ModernDataStack

Tired of manually searching through data catalogs or writing complex SQL queries? Ask Collate transforms how you discover, analyze, and govern your data using simple conversational AI. In this demo, we show you how to go from a business question to actionable insights in seconds, no coding required. What You'll Learn: How to use natural language to discover tier-1 data assets across your entire data catalog (Snowflake, Redshift, and more) How Ask Collate automatically generates and executes SQL queries from conversational requests How to identify data quality issues and create automated test cases to prevent future anomalies Demo Highlights: Smart Data Discovery: Watch Ask Collate analyze eco-friendly product performance by instantly identifying relevant tables across multiple data warehouses and generating an actionable analysis plan Visual Analytics on Demand: See natural language commands transformed into SQL queries and visualizations—then customize chart types and colors conversationally Intelligent Quality Monitoring: Follow along as Ask Collate investigates a customer dashboard, traces data lineage, detects anomalies (like negative pricing values), and automatically generates 16 test cases across five quality dimensions Ask Collate understands your data context, navigates complex lineage relationships, and proactively suggests governance actions. Whether you're a data analyst trying to speed up insights, a data engineer managing quality, or a business user who needs answers fast, Ask Collate makes data governance conversational and accessible. Version 1.11 brings enterprise-grade AI directly into your data workflow. Stop context-switching between tools and start having natural conversations with your data. Learn more about Collate: https://www.getcollate.io/ Try Collate's Managed OpenMetadata Service with Demo Data: https://sandbox.open-metadata.org/ #DataGovernance #AIforData #OpenMetadata #DataQuality #ConversationalAI #DataCatalog #MLOps #DataEngineering #DataLineage #AskCollate

Tired of switching between tools to check data quality, find asset owners, or verify trusted sources? Ask Collate brings conversational AI-powered data governance right into your Slack workspace, letting your team access critical metadata, run queries, and make data-driven decisions without ever leaving Slack. What You'll Learn: How to query and analyze data using natural language prompts directly in Slack channels Ways to verify data health, check test case results, and ensure you're working with trusted sources Methods to identify asset ownership, trace data lineage, and generate executive summaries in seconds Demo Highlights: Real-world scenario: A data leader analyzes eco-friendly product performance using Snowflake data through simple Slack prompts Live data health checks reveal test case results (9 passing, 1 failing) for the Customer 360 table, helping determine data trustworthiness Instant summary generation for board meetings showcasing how Ask Collate transforms conversations into polished reports in minutes This integration is part of Collate v1.11's suite of tools designed to help teams manage, understand, and govern data more efficiently. By embedding metadata context directly into your daily communication platform, you eliminate context switching, speed up decision-making, and democratize access to data insights across your organization. Whether you're a data leader monitoring KPIs, an analyst verifying data quality, or a team member who needs quick answers about data ownership, Ask Collate in Slack transforms how you interact with your data ecosystem. Watch this demo to see how conversational AI is revolutionizing data governance workflows. Learn more about Collate: https://www.getcollate.io/ Try Collate's Managed OpenMetadata Service with Demo Data: https://sandbox.open-metadata.org/ #DataGovernance #SlackIntegration #ConversationalAI #MetadataManagement #DataQuality #AIAssistant #DataCatalog #OpenMetadata #DataOps #ModernDataStack

Collate version 1.11 introduces SQL Studio, a powerful, permission-based query execution tool that lets your team run SQL queries directly against your data services without compromising security. In this demo, we'll walk you through setup, authentication options, and how SQL Studio integrates seamlessly with Ask Collate for intelligent, AI-powered query assistance. What You'll Learn: How to enable and configure SQL Studio with query runners on your database services The difference between multiple authentication methods (Basic credentials, SSO, and OAuth) and why SQL Studio uses separate credentials from your ingestion agents How to grant controlled, permission-based access to query execution so users only see data they're authorized to access Demo Highlights: Complete walkthrough of setting up query runners with Snowflake authentication, including username, private key, and passphrase configuration Live query execution with automatic safety limits that prevent accidentally returning massive datasets Integration with Ask Collate to generate and execute SQL queries using natural language; compute totals, analyze data, and get results instantly Whether you're a data engineer setting up secure query access or a data analyst who needs self-service SQL capabilities, SQL Studio gives you the flexibility to execute queries safely within your governance framework. Administrators can enable or disable query runners at any time without deleting connection profiles, making it simple to control access as your needs change. Learn more about Collate: https://www.getcollate.io/ Try Collate's Managed OpenMetadata Service with Demo Data: https://sandbox.open-metadata.org/ #SQLStudio #DataGovernance #Collate #OpenMetadata #DataAccess #SelfServiceAnalytics #SnowflakeIntegration #DataSecurity #MetadataManagement #AskCollate

Tired of managing data quality tests in scattered places? Collate's new Data Quality as Code feature in version 1.11 updates how teams handle testing by letting you write, version control, and execute tests directly in your transformation pipelines while maintaining centralized visibility. What You'll Learn: How to decentralize data quality test logic while maintaining a unified view of all test results across your data ecosystem The difference between test runner patterns and runtime validation patterns, including how to implement circuit breakers that prevent bad data from reaching your tables How to integrate data quality testing seamlessly into Python-based transformation pipelines using VS Code, with results automatically syncing back to the Collate platform Demo Highlights: See a real-world implementation using Snowflake, where we transform customer and order data into a lifetime value table with automated quality checks running in code Watch how runtime validation acts as a circuit breaker, catching data issues before they corrupt your product performance tables and automatically triggering rollback procedures Explore how test results, incidents, and failure details appear in the Collate UI in real-time, even when tests are executed entirely outside the platform This walkthrough demonstrates two powerful scenarios: running data quality tests as part of your transformation pipeline and implementing validation to prevent bad data from ever being loaded. You'll see how this approach enables data engineers to treat quality tests as version-controlled libraries that execute within existing workflows. Your entire team gets centralized visibility into test results, incidents, and data quality metrics through the Collate platform, even though the actual test logic lives in your codebase where it belongs. Whether you're working with large datasets that need chunked validation or building transformation pipelines that require quality gates, this demo shows you exactly how to implement data quality as code in your organization. Learn more about Collate: https://www.getcollate.io/ Try Collate's Managed OpenMetadata Service with Demo Data: https://sandbox.open-metadata.org/ #DataQuality #DataEngineering #Collate #OpenMetadata #DataPipelines #PythonDataScience #Snowflake #DataGovernance #DataOps #QualityAssurance

Ready to transform how your team manages data quality and classification? In this detailed walkthrough, we explore Collate version 1.11's powerful custom governance workflow builder, a visual tool that automates data governance tasks without requiring a single line of code. What You'll Learn: How to create sophisticated governance workflows using Collate's intuitive drag-and-drop interface with predefined nodes for triggers, conditions, and actions The difference between event-based triggers (activated by specific changes like glossary term updates) and periodic batch workflows (scheduled automation similar to data ingestion) Advanced conditional logic techniques to evaluate data completeness, custom properties, ownership, and descriptions, then automatically assign tier classifications based on your specific criteria Demo Highlights: Building a complete table tier classification workflow from scratch, including start nodes, check conditions, data completeness evaluations, and action nodes that automatically classify assets into Tiers 1-5 Setting up multi-level scoring thresholds that evaluate column description completeness (25%, 50%, 75%, 100%) and trigger different tier assignments based on data quality metrics Real-world testing across the Post DB schema, demonstrating how the workflow automatically evaluates seven tables and correctly assigns tier levels based on ownership, descriptions, and custom property values This workflow builder puts enterprise-grade data governance automation in your hands. Whether you're managing hundreds or thousands of data assets, you can now standardize classification, enforce data quality standards, and maintain governance at scale, all through visual configuration. Perfect for data engineers, data governance professionals, metadata managers, and anyone responsible for maintaining data quality standards across their organization. No coding required, just powerful automation that works. Learn more about Collate: https://www.getcollate.io/ Try Collate's Managed OpenMetadata Service with Demo Data: https://sandbox.open-metadata.org/ #DataGovernance #MetadataManagement #DataQuality #DataEngineering #OpenMetadata #WorkflowAutomation #DataCatalog #DataOps #EnterpriseData #DataManagement

Tired of writing custom SQL just to understand where your data quality issues are coming from? Collate's new Data Quality Dimensionality feature in version 1.11 lets you test data quality at the dimensional level with just a few clicks. What You'll Learn: How to create column-level tests with dimensions to analyze data quality across different categorical values (like status, region, or product type) The difference between traditional column-level tests and dimensional tests, and why dimensionality gives you crucial insights into where problems actually originate How to use impact scores to quickly identify which dimensions are carrying the most failures, saving you hours of investigation time Demo Highlights: Watch a live walkthrough creating dimensional tests on a Redshift table, comparing gift card amounts across different status values See the new dimensionality tab in action, revealing test results broken down by each dimension value with clear pass/fail indicators Learn how to analyze historical execution patterns for specific dimensions to spot trends and prevent future issues This feature eliminates the need for brittle, custom SQL code that requires constant maintenance. Instead, you get an intuitive interface that provides an additional layer of granularity, exposing problems you might have missed with traditional testing approaches. Whether you're managing data quality for analytics, compliance, or operational systems, dimensional testing helps you understand not just that there's a problem, but exactly where it's happening. Perfect for data engineers, analytics engineers, and anyone responsible for maintaining high-quality data pipelines. Stop guessing where your data quality issues are hiding and start pinpointing them with precision. Learn more about Collate: https://www.getcollate.io/ Try Collate's Managed OpenMetadata Service with Demo Data: https://sandbox.open-metadata.org/ #dataquality #DataObservability #OpenMetadata #Collate #DataEngineering #DataGovernance #Redshift #MetadataManagement #DataTesting #DimensionalTesting

Collate version 1.11 introduces fully customizable notification templates that put you in the driver's seat. Whether you're alerting teams through Slack, email, Google Chat, or other channels, you now have complete control over what your alerts say and how they look. What You'll Learn: How to create reusable notification templates that work across your entire organization, ensuring consistent messaging and branding for critical data events The power of dynamic content insertion using variables, conditional logic, and entity-specific fields to make your notifications intelligent and context-aware Two flexible approaches to template creation: system-wide reusable templates for standardized alerts and ad hoc templates for specific, one-time use cases Demo Highlights: Watch as we navigate the new Templates section in Settings, demonstrating how to edit system default templates and create custom ones from scratch with dynamic variables See real-time template creation in action, including adding emojis, formatting options, conditional logic, and built-in validation to ensure your templates work perfectly every time Follow along as we build a complete alert workflow: setting up a schema change trigger on a customer table, selecting alert destinations, and applying our custom template to deliver actionable notifications to the right people This feature transforms how your team stays informed about critical data changes. No more sifting through cryptic alerts or missing essential updates. With custom notification templates, you can craft messages that include exactly the information your team needs, formatted the way they want it, delivered through their preferred channels. From data engineers monitoring schema changes to business users tracking important metrics, everyone gets notifications that make sense for their role. Perfect for data teams looking to improve their data observability, enhance alert management, and streamline communication around metadata changes and data governance workflows. Learn more about Collate: https://www.getcollate.io/ Try Collate's Managed OpenMetadata Service with Demo Data: https://sandbox.open-metadata.org/ #DataObservability #MetadataManagement #DataGovernance #AlertManagement #DataOps #OpenMetadata #DataEngineering #Collate #NotificationAutomation #SchemaManagement

Managing your data governance just got easier! The new Collate browser extension for Chrome brings your entire data catalog directly into your browser, letting you search, explore, and collaborate on data assets without switching tabs. What You'll Learn: How to install and configure the Collate Chrome extension with your existing authentication setup (Google SSO, or your preferred method) Navigate the extension's interface, including activity feeds, tasks, followed assets, and your personal data catalog, with the same familiar Collate experience Use the powerful right-click search feature to instantly look up any term in your Collate catalog from anywhere on the web Demo Highlights: Real-time search and asset exploration: See how the search bar provides instant access to recent searches and followed items, with direct links to full asset details in Collate Inline data exploration: Browse schema details, lineage diagrams, activity feeds, custom properties, and data contracts without leaving your current browser tab Context-aware workflows: Watch how the extension allows you to verify data information while working in other applications This extension transforms how data teams work by eliminating context switching and bringing data catalog information exactly where it's needed. Whether you're analyzing data in Tableau, reviewing documentation, or collaborating with team members, the Collate extension keeps critical metadata and governance information at your fingertips. Perfect for data analysts, engineers, governance teams, and anyone who needs quick access to their data catalog throughout their workday. Learn more about Collate: https://www.getcollate.io/ Try Collate's Managed OpenMetadata Service with Demo Data: https://sandbox.open-metadata.org/ #DataGovernance #DataCatalog #ChromeExtension #MetadataManagement #DataLineage #OpenMetadata #DataDiscovery #DataEngineering #DataAnalytics #CollateDataCatalog