Outer joins (preview) - Release notes
An outer join (left, right, full) combines data from two tables, including all matching rows and any unmatched rows from one or both tables, filling in NULL for missing data. Analytical platforms use outer joins to achieve: Broader analytical capabilities: Ensure all relevant data is visible, even if there is no exact match in another table (e.g., view all products, including products with no sales). Identify Gaps: Easily spot data integrity issues and missing information or relationships, which is crucial for analysis and reporting.
Have you heard about Sisense Intelligence?
Sisense Intelligence is a new suite of AI-powered tools that help product managers and developers build smarter, more intuitive analytics experiences. Features like natural language dashboards, automated insights, forecasting, and data explanations accelerate every stage of the analytics journey. Designed for seamless integration, it empowers teams to deliver fast, user-friendly insights at scale.
