Skip to Main Content
Preset Feature Feedback
Status Gathering Feedback
Categories New feature
Created by Sayya Dushanbieva
Created on Sep 13, 2022

Ability to join tables w/o writing SQL

The average user that visualizes data should be able to join tables from a source without having to write SQL. They want a less-technical approach (e.g., dragging functionality) to achieve their goals, mentioning Tableau's 'Join Your Data' as a user-friendly example that enables users of all backgrounds to do joins without writing SQL.

  • Attach files
  • Matthew Deadman
    Reply
    |
    Feb 12, 2023

    Adding a comment to +1 this.

    This imo should be seen as a critical feature, not even for the ease of use this would grant, but for performance reasons.

    When you create a virtual dataset, and begin to play around with your filters and certain other properties in the chart editor, it will treat the virtual dataset as a sub-query, meaning possibly far worse query performance than a physical dataset.

    This for example, makes dimensional modeling far less performant in Preset, as to do a simple join on a fact and dim table, you are losing a ton of optimizations you get with a physical dataset.

    By allowing users to join physical datasets together in the chart editor, you could alleviate this issue, as well as make working with data for less technical users far more accessible.

  • +6
2 MERGED

Ability to Do Visual Joins on Datasets

Merged
What is the problem or goal the end user is trying to solve or accomplish? Less technical users find it difficult to write SQL from scratch and do adhoc exploration in SQL lab. Filtering, sorting and aggregation are all available in the chart crea...
Juliann Forbes over 1 year ago in New feature 0 Gathering Feedback
2 MERGED

Tables relationship

Merged
What is the problem or goal the end user is trying to solve or accomplish? User is looking for ability to define relationship between tables How are they solving it currently? Manual table joining using SQL Query What is the recommended solution b...
Customer Engagement over 1 year ago in  0 Gathering Feedback