Connect multiple tables only possible with joins?

[DominikRoB]

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!

[vogelsgesang]

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