- Fixed cli installation and demo (#177). In this release, changes have been made to adjust the dashboard name, ensuring compliance with new API naming rules. The dashboard name now only contains alphanumeric characters, hyphens, or underscores, and the reference section has been split for clarity. In addition, demo for the tool has been updated to work regardless if a path or UC table is provided in the config. Furthermore, documentation has been refactored and udpated to improve clarity. The following issue have been closed: #171 and #198.
- [Feature] Update is_(not)_in_range (#87) to support max/min limits from col (#153). In this release, the
is_in_range
andis_not_in_range
quality rule functions have been updated to support a column as the minimum or maximum limit, in addition to a literal value. This change is accomplished through the introduction of optionalmin_limit_col_expr
andmax_limit_col_expr
arguments, allowing users to specify a column expression as the minimum or maximum limit. Extensive testing, including unit tests and integration tests, has been conducted to ensure the correct behavior of the new functionality. These enhancements offer increased flexibility when defining quality rules, catering to a broader range of use cases and scenarios.
- Fixed installation process for Serverless (#150). This commit removes the pyspark dependency from the library to avoid spark version conflicts in Serverless and future DBR versions. CLI has been updated to install pyspark for local command execution.
- Updated demos and documentation (#169). In this release, the quality checks in the demos have been updated to better showcase the capabilities of DQX. Documentation has been updated in various places for increased clarity. Additional contributing guides have been added.
- Provided option to customize reporting column names (#127). In this release, the DQEngine library has been enhanced to allow for customizable reporting column names. A new constructor has been added to DQEngine, which accepts an optional ExtraParams object for extra configurations. A new Enum class, DefaultColumnNames, has been added to represent the columns used for error and warning reporting. New tests have been added to verify the application of checks with custom column naming. These changes aim to improve the customizability, flexibility, and user experience of DQEngine by providing more control over the reporting columns and resolving issue #46.
- Fixed parsing error when loading checks from a file (#165). In this release, we have addressed a parsing error that occurred when loading checks (data quality rules) from a file, fixing issue #162. The specific issue being resolved is a SQL expression parsing error. The changes include refactoring tests to eliminate code duplication and improve maintainability, as well as updating method and variable names to use
filepath
instead of "path". Additionally, new unit and integration tests have been added and manually tested to ensure the correct functionality of the updated code. - Removed usage of try_cast spark function from the checks to make sure DQX can be run on more runtimes (#163). In this release, we have refactored the code to remove the usage of the
try_cast
Spark function and replace it withcast
andisNull
checks to improve code compatibility, particularly for runtimes wheretry_cast
is not available. The affected functionality includes null and empty column checks, checking if a column value is in a list, and checking if a column value is a valid date or timestamp. We have added unit and integration tests to ensure functionality is working as intended. - Added filter to rules so that you can make conditional checks (#141). The filter serves as a condition that data must meet to be evaluated by the check function. The filters restrict the evaluation of checks to only apply to rows that meet the specified conditions. This feature enhances the flexibility and customizability of data quality checks in the DQEngine.
- Support datetime arguments for column range functions (#142) View
- DQX engine refactor and docs update (#138) View
- Add column functions to check for valid date strings (#144) View
- Generate rules for DLT as Python dictionary (#148) View
- Make DQX compatible with Serverless (#147) View
- New dashboard query, Update to demos and docs #133
- Patch user agent to enable tracking #121
- Added docs build on push #129
- Add Dashboard as Code, DQX Data Quality Summmary Dashboard #86
- Updated profiling documentation with cost consideration #126
- Improve docs styling #118
- Added search for docs #119
- Updated docs #117
- Bug fixed profiler
- Released docs at https://databrickslabs.github.io/dqx/
- Updated README
- Added new check: is_not_null_and_not_empty_array
- Fixed links to image for pypi
- Minor documentation updates
- Updated release process
- Updated README
- Updated release process
- Bug fixed cli installation
- Fixed Github release process
- Updated demos
Initial release of the project
Initial dqx commit