Building Stored Procedure Actions: The Long Road To Doing More With Your Data

Sigma has introduced Stored Procedure Actions, allowing users to initiate workflows directly from within Sigma workbooks, eliminating the need to switch platforms for tasks such as triggering workflows or running forecasts. This feature was developed by building on Sigma's Workbook Actions framework, which enables users to trigger logic off elements like buttons or tables and work with stored procedures in a user-friendly interface. A key challenge was handling the variability of stored procedures across different data warehouses, leading to the creation of a compatibility matrix to manage differences such as argument handling. The team prioritized usability and customer feedback throughout the development process, incorporating features like an inode picker and plans to support tabular data. The feature has been well-received, with over 50 organizations using it within the first two months of its launch and experiencing a 50% month-over-month growth in usage. The development process emphasized collaboration across teams and grounding decisions in real customer use cases, resulting in a widely adopted tool that enhances data-driven actions within Sigma.