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.
Advanced Manual Joins: Click on the + sign in the left panel and use the modal to define the join. An advanced manual join is used when the operator between the fields is different from the = sign.
Advanced join is needed, for example, when looking for the intersection between a date list and open and close dates of opportunities.
The join below will allow users to find the open opportunities by selecting a range of dates from the date_field.
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.
AI-Assisted Field Renaming
Field Names in data sources tend to be technical and not business Friendly,
This is a good reason for simplifying the data engineering team's work with the fields in the data source, but these field names might be difficult for end users to understand.
With the AI-Field suggestions in Astrato, suggest business-friendly names for fields and tables that the user can apply.
With this feature, both the Data Engineering Team and the Business users can be happy with the field names.
Applying AI-suggested Field Names
click the View AI Suggestion button at the bottom right corner.
The AI- Engine is going to come with a suggestion from user-friendly field names
Set the scope for change and apply
