search

cube-js / cube

📊 Cube — The Semantic Layer for Building Data Applications
https://cube.dev
Other
17.95k stars 1.78k forks source link

Support joins with query pushdown in the SQL API #8483

Open igorlukanin opened 4 months ago

igorlukanin commented 4 months ago

Currently, joins between cubes are not supported in queries to the SQL API if query pushdown is enabled. We would like to support joins and lift that limitations.

It's currently planned for October 2024.

pauldheinrichs commented 2 months ago

Hello!

@igorlukanin Just a thought I had this AM, with the recent release of v36 rollup_joins are unblocked by joining different datasources with different driver Factory syntax. 💚 (thank you all for that)

A feature that i have absolutely no idea the feasibility would be genuinely amazing on the roadmap of this current epic. If cube was capable of auto joining different datasources (providing a rollup existed) IE: removing the need for the rollup_join pre-definitions of which rollups should be referenced when joining.

IE the following query

select user_id from mysql.users
LEFT JOIN user_id from redshift.users

and the understanding that redshift.users has a pre-build pre-aggregation with a dimension on user_id

cube is capable of planning that sql to some capacity? 🤷

Anywho - just a thought.