With this feature, users will be able to utilize multiple data sources within Avenue monitors. This means that users can access and make use of data from different sources. This feature is particularly useful in scenarios where you require additional columns to be appended to your query from data that lives in a separate database.
To use Data Enrichment, navigate to the Enrich Data tab when creating a monitor and select the database you would like to pull data from.
In order to Join the data you will need to chose the matching fields and the Join type. There are two types of joins:
Left Outer Join: Merges two tables and includes all rows from the left table, filling in null values for non-matching rows from the right table.
Inner Join: Combines rows from two tables, including only those rows that have matching values in both tables.
Here's a nice visual to help:
Here is what it looks like in the app:
Example Use Cases:
A business collects data from a wifi device that is stored in their data warehouse, while their onboarding and customer data are saved in a separate database. By utilizing the multi-data source feature, they can seamlessly merge data from both sources and gain deeper insights.
Another organization has real-time data stored in their postgres microservices, but broader store information is saved in Snowflake. By integrating data from both sources, they can gain a more complete view of their business operations and make informed decisions.
A ride-sharing company stores device data in Presto and driver information in Hive. By leveraging the multi-data source feature, they can merge data from both sources to obtain a more comprehensive picture of their business.
Pro Tip 💡: You can use columns from both the tables to customize the Signal message!
⛑️ If you need any help or have any questions please contact support by email, or click on the button in the bottom right corner.