Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[Question] Can I join tables from different databases? #7187

Closed
tar-xzvff opened this issue Apr 1, 2019 · 7 comments
Closed

[Question] Can I join tables from different databases? #7187

tar-xzvff opened this issue Apr 1, 2019 · 7 comments
Labels
inactive Inactive for >= 30 days

Comments

@tar-xzvff
Copy link

I use redash, a data visualization tool for OSS.
redash has the ability to join tables from different databases.
For example, you can join any Oracle and Postgres table.

Does superset have the same functionality as this feature?

@zhaoyongjie
Copy link
Member

You can modeling from SQLLab join tables, and then export this model to explore page

image

@kingo55
Copy link
Contributor

kingo55 commented Apr 9, 2019

@tar-xzvff - pretty sure you can't.

You can only join tables within the same database, through SQL Lab.

@stale
Copy link

stale bot commented Jun 9, 2019

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions. For admin, please label this issue .pinned to prevent stale bot from closing the issue.

@stale stale bot added the inactive Inactive for >= 30 days label Jun 9, 2019
@stale stale bot closed this as completed Jun 16, 2019
@foolosopher
Copy link

In superset 1.1 you can join tables using Trino - https://www.youtube.com/watch?v=Dw_al_26F6o

@cozajeden
Copy link

Work around that I found is to link servers.
You can set up views that link data from different servers. Superset will not complain.

@avnav0
Copy link

avnav0 commented Aug 4, 2023

tableau has this, so does access...this should be a big deal

@saeedhmt
Copy link

saeedhmt commented Dec 9, 2023

Work around that I found is to link servers. You can set up views that link data from different servers. Superset will not complain.

How to link servers?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
inactive Inactive for >= 30 days
Projects
None yet
Development

No branches or pull requests

7 participants