Joins and Constraints Image

Managing joins & constraints

Buster needs to understand how your tables and columns relate to each other in order to generate accurate and syntactically correct queries.

If you are connecting a relational database, we pulled any foreign key relationships that you’ve pre-defined in your database. However, there may be relationships that you haven’t explicitly defined in the database. You would need to specify those here.

If you are connecting a warehouse, you will need to define all relationships for the tables you connected to Buster.

Adding joins & constraints

You can use the search bar to search for a Primary Key. You can then add the associated Foreign Keys by searching for other columns in the associated drop-down menu titled “Select columns”.

Adding a join