cube-js/cube

Automatically adding Joins using Primary/Foreign keys within Data Sources

Open

#1,179 opened on Oct 6, 2020

View on GitHub
 (6 comments) (1 reaction) (0 assignees)Rust (1,965 forks)batch import
Roadmap: 2021 Q1help wanted

Repository metrics

Stars
 (19,563 stars)
PR merge metrics
 (Avg merge 5d 16h) (138 merged PRs in 30d)

Description

Would it be possible within the automatic schema generation to create joins as well using the Primary/Foreign keys within SQL DB's? This would enable developers to quickly engage with their data without having to define the joins when they should already be defined at a db schema level.

This could also be expanded to include a range of 'default' optional pre-aggregations on data, e.g. automatically inserting a pre-aggregation on data types such as boolean creates a count, within the same process.

Contributor guide

Research direction
Explore the schema generation module in the Cube core repository. Look for how data source metadata (tables, columns, primary/foreign keys) is extracted and used in the 'cube' queries. Then implement logic to automatically create join definitions based on foreign key relationships. Alternatively, propose a configuration option to enable this feature.
Tech stack
rustsql
Domain
backend
Issue type
Feature
DifficultyEstimated implementation difficulty for a new contributor, from 1 for very small changes to 5 for expert-level work.
2
Estimated timeA rough time range for an experienced contributor to investigate, implement, test, and prepare a pull request.
Half day
Activity statusHow available the issue appears right now: fresh, active, stale, blocked, or waiting on maintainer input.
Active
ClarityHow clearly the issue explains the expected change, acceptance criteria, and next step.
Clear
Prerequisites
RustSQL
Newbie friendlinessA 1-100 score estimating how approachable this issue is for first-time contributors.
65