Launch Week 2022 | Data Views

Amol Patel
January 20, 2022

Operations teams have made big strides in leveraging data to make critical decisions. The first major change came with the implementation of new reporting and analytics tools that allow teams to make data-driven decision making. The next change was moving the data from those disparate tools into a data warehouse. However, the setup of the data warehouse has made the data almost always inaccessible for ops teams. They have to rely on one-off requests to data engineers or analysts to obtain this data for them. This dependance has surfaced inefficiencies for organizations and has limited their ability to act quickly during mission critical incidences or monitoring workflows.

At Avenue, we believe operations teams and data engineers should be able to work independently of each other. This is why we have launched Data Views.

Data Views makes it easy for data engineers to set up SQL queries that output data sets for specific business requirements. Ops teams can then use these data sets to create all the alerts that are relevant to common workflows or monitors within their company.

With Data Views, teams will be empowered to:

  • Explore: Data engineers can easily view, edit, and access data. They can view database schemas and run complex queries in the live SQL editor. Once the data engineer sets up the SQL query, they “hand off” the freedom to set up alerts over to the ops team.

  • Activate: After the initial setup, Ops Teams can create notifications, set up monitoring, and view reports - whenever they want.

  • Import: Various data sources can be used to create data views. If an organization has multiple data warehouses, data views can be generated for each specific use case.

Data views are created on a new page that features a live SQL editor. Data engineers will be able to switch between different data sources and view schemas. Complex SQL queries can be formatted and run in the editor to ensure the resulting rows are as expected. Engineers can select the columns in order to identify what makes the resulting rows unique.

After the one-time initial setup by the data engineers, Ops teams can set up monitors over the available data views to alert on specific changes and conditions in the data set. This functionality lives in the existing monitor creation page. Avenue’s Data View is the third leg of the data stool.

Happy alerting :)

How do I get access to start using Avenue at my company?

Sign-up today here!

Senior Software Engineer