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

Connect multiple tables only possible with joins? #82

Open
DominikRoB opened this issue Feb 6, 2023 · 1 comment
Open

Connect multiple tables only possible with joins? #82

DominikRoB opened this issue Feb 6, 2023 · 1 comment

Comments

@DominikRoB
Copy link

Is it possible to connect tables via relationships when creating a hyper file?
I couldn't find anything on that topic in the documentation (Or I'm looking for the wrong keywords..)
I'd expect it to be possible, as the extracts contain the relationships.

Hope it's not a trivial thing.
Thank you!

@DominikRoB DominikRoB changed the title Connect multiple tables with joins? Connect multiple tables only possible with joins? Feb 6, 2023
@vogelsgesang
Copy link
Contributor

You can add "assumed constraints", i.e. the usual "unique" or "foreign key" constraints which you are used to from other databases. However, "assumed" means, we will not check that you are actually following those constraints. We will just assume that your data actually fulfills those specified constraints. If it in fact does not satisfy the constraints, queries on the data may return unexpected results...

See https://help.tableau.com/current/api/hyper_api/en-us/reference/sql/sql-createtable.html and https://help.tableau.com/current/api/hyper_api/en-us/reference/sql/sql-altertable.html for documentation

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants