Building your data model
Use Astrato's smart joins features to connect your tables and build your data model effectively.
Defining a data model in Astrato is easy and intuitive, with a simple method to define joins between the different tables in the data model. The different methods range from one click to create all joins to manual multi-field joins between tables.
Focusing on the right data is also easy by using static filters to focus only on the relevant data in your dataset.
Creating Joins using Joins Suggestions
After selecting your tables in the Data View, no joins are defined. There are three options to create a new join:
Join Suggestions: Accept the join suggestions in the Joins dialog that displays. Our “suggested joins” process is based on “string similarity.” This works well in some cases but not all.
User-Selected Pair: Drag and Drop one table on top of another. Astrato will show a list of options to Join the tables.
Click on your selected option to apply the join.
Manual Drag and Drop- Select a field from one table and drag and drop it on a field in another table.
Astrato will check your join direction and might offer to switch the direction to optimize the join between the tables.
Manual Join: Click on the + sign in the left panel, and use the modal to define the Join. Manual join is needed when the join includes multiple fields.
Check out this article to learn more about Join Quality and direction.
Defining a Static Filter View
Static filter view is a filter defined in a table, which will be part of any query using this table.
This filter allows for building an efficient and right data model that only includes the data needed to answer the business questions for which the app was built.
With a static filter view, there is no longer a need to rely on the data team to create a partition of the whole dataset. Every user can easily build a data app with the data needed.
Defining a new Static filter is easy.
In the data model screen, click on the three-dot icon in a view.
Select the View\Edit table option.
Click on the filter icon on the right-hand side of the header
Define your filter and click submit.
A filter icon is added to the table header to indicate the table now includes a filter.
To edit a filter, click on the filter icon in the table header and edit the existing filter.
