New features and enhancements
The July 2024 release of Data Validation includes the following new features and enhancements.
Support for saved SQL queries
You can use an SQL query to compare data from the following databases:
- •Amazon Redshift v2
- •Databricks Delta
- •DB2
- •Google BigQuery V2
- •Microsoft Azure Synapse SQL
- •MySQL
- •Oracle
- •PostgreSQL
- •Snowflake Data Cloud
- •SQL Server
You can then save the SQL query and reuse the saved SQL query in multiple test cases.
Using SQL queries, you can use combine multiple data sets and filter data.
For more information about using saved SQL queries, see Saved SQL Queries.
REST APIs for saved SQL queries
You can use REST APIs to perform the following tasks:
- •Create a saved SQL query.
- •Update a saved SQL query.
- •Get the supported database types for a saved SQL query.
- •Get information about a saved SQL query.
- •Create a test case using a saved SQL query as one or both of the sources.
For more information about using REST APIs for saved SQL queries, see REST API Reference.