Automated Regression Testing
Bqurious is the automated regression testing tool. With Bqurious, you can automate your database queries and run them as many times as you want. You can also store the query results so that they can be compared against their previous results to detect any undesired changes.
When you are running a complex data warehouse on a petabyte-scale, it is important to make sure that all the data are processed correctly.
For example, if you have a set of tables that store hourly data, then it is imperative to make sure that each table contains exactly 24 rows for each day. Similarly, if you have a processing pipeline that processes daily data, then it is important to validate that there are no gaps in the output tables. If you want to know more about best practices like test automation best practices then visit our website.
In addition to validating that the data contains no errors, it is also important to keep track of the number of errors in order to identify when the errors suddenly increase or decrease.
Bqurious enables you to write simple SQL statements and automate them easily so that you can quickly answer questions such as "How many rows does this table have today?" or "Does this table have any null values?"