Changelog 3.3
Validio 3.3 includes a new Custom SQL Validator syntax, support for Snowflake key-pair authentication, and updates to Webhook payloads.
New Custom SQL Validator Syntax
Validio 3.3 introduces a new SQL query syntax for configuring Custom SQL validators. If you configure a Custom SQL validator with tumbling windows, you can use template functions to reference source, segmentations, and windows. The new syntax also supports reference windows to compare data between windows.
For more information about the new Custom SQL syntax and migration guidelines between the syntax versions, see Custom SQL and Migrating Custom SQL Syntax in the product documentation.
Support for Snowflake Key-pair Authentication
Validio 3.3 supports using key pair authentication to configure your Snowflake credential. Key pair authentication provides a more secure alternative to the existing username and password authentication.
For more information, see Snowflake in the product documentation.
Updates to Webhook Payloads
Validio 3.3 includes updates to Webhook payloads for notifications related to source errors. The source information has been moved to the root of the payload, and only the minimal information about the source is now included. A type
property has also been added to all payloads to indicate which type of notification it is. The type
property can have one of the following values: GenericSourceError
, SchemaChangeSourceError
, SegmentLimitExceededSourceError
, or ValidatorIncident
.
For more information, see Webhooks in the product documentation.
3.3.0
Validio 3.3.0 was released on September 2, 2024.
API Updates
Enhancements
- Made query optional in SqlValidatorUpdate (UI-3772)
- Made site parameter optional for Tableau credentials (UI-3770)
User Interface Updates
Enhancements
- Changed the allowed time range for minute windows (UI-3680)
- Added SQLFilter validation for streaming sources (UI-3813)
- Support verification of SQL filters with Test Query button (UI-3766)
- Added warning when using deprecated SQL v1 syntax (UI-3816)
- Added support for Snowflake key pair authentication to configure credentials (UI-3683)
- Updated the placeholder text for the custom SQL to be v2 syntax (UI-3410)
Fixed Issues
- Fixed relative time validator zero input and presentation (UI-3745)
- Improved rendering of search matching highlights in listings (UI-3658)
- Capped the sensitivity setting of Dynamic threshold (UI-3651)
- Fixed the link to validator in Validator wizard (UI-3751)
Platform Updates
Enhancements
- Replaced notification progressing in Pigeon (UI-3714)
- Updated how schema inference works for BigQuery data and changed the data type for boolean fields from BOOLEAN to BOOL. As a result, you may see a lot of "schema changed" events (VR-3652)
Fixed Issues
- Updated incident group priority when group is extended (VR-3604)
- Added checkExistsByResourceName on validator creation (UI-3765)