qlty_rowsWithMissingValues
Retrieve rows where a specified column contains NULL or missing values. Returns the actual records for review or further processing.
Instructions
Retrieve the actual data rows where a specific column is NULL or missing. Returns the records themselves, not a column summary. Use when the user wants to SEE or FETCH the rows with missing values in a named column. Do NOT write a SQL query with base_readQuery for this — always use this tool when the request is about rows with null values. Do NOT use for a column-level summary of which columns have nulls — use qlty_missingValues for that.
Arguments: database_name - Name of the database (optional) table_name - Table name to analyze column_name - Column name to analyze for missing values persist - If True, materializes result as a volatile table and returns table name
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| persist | No | If True, materializes result as a volatile table and returns table name | |
| table_name | Yes | Table name to analyze | |
| column_name | Yes | Column name to analyze for missing values | |
| database_name | No | Name of the database (optional) |