December 2023 Summaries

Foundational has announced its new integration with Tableau, a leading business intelligence platform, aimed at enhancing code development and data lifecycle management. This integration provides organizations using Tableau with pre-merge analysis for pull requests affecting dashboards, automated column-level lineage tracking, and on-premise support to bolster security. By addressing common vulnerabilities and governance issues in business intelligence systems, such as broken dashboards and dashboard sprawl, Foundational's support enables better change management and data contract enforcement. The integration helps users understand the impact of code changes on Tableau dashboards, promoting a more cohesive and efficient data management process, ultimately connecting data producers and consumers more effectively.

Foundational aims to prevent data issues by validating code changes that could negatively impact data, particularly in data engineering frameworks like dbt, by maintaining an accurate data lineage graph. This is crucial for identifying issues such as field type mismatches, which occur when changes in upstream field types are not reflected in dependent fields, potentially causing undetected errors. The blog post highlights challenges in SQL analysis, including ambiguities in queries without schema information, differences in SQL dialects across data warehouses, and the difficulty of analyzing advanced SQL functions like CASE statements and PIVOT operations. Foundational addresses these challenges by enhancing code validation processes to ensure data teams can confidently deploy changes, despite limitations in standard lineage information and open-source parsers.