OwlDQ User Guide
OwlDQ User Guide
OwlDQ
Release Notes
Our Approach
Our Story
What is OwlDQ
Get Started
Start for free
How OwlDQ
Makes your Data Lake better.
Speeds Migrations/Enables Replications
Assists Data Aggregation
Ensures CCPA & GDPR
Builds a Better DQ Dashboard
Security
Owl Security
OwlCheck Examples
OwlCheck
Data Quality Pipelines
Scorecards
Dataset Scorecard
Group Scorecard
List View
Connecting to DBs in Owl Web
Owl DB Connection
Core Components
Overview
Profile
Behaviors
Schema Evolution
Outliers
Shapes
Validate Source
Rules
Duplicates
Explorer
Explorer 2
Pattern Mining
Missing Records
Labeling / Training
Item Labeling
Peak vs Off Peak
Graph
Process Dependency
Dataset Dependency
ARTICLES
Creating a Data Quality Pipeline
APIs
Swagger
Job Server
Custom Configurations
Notebook API
Catalog
Catalog
Cluster Health Report
Use-Cases
Bank Loans
Financial FxRate Data
Intraday Positions
Security Reference Data
Copying or Moving data
Cyber Anomalies in Real-Time
Owl Time
Owl Time Zone API
Alerts
Email Alerts
Troubleshooting
Cloudera CLASSPATH
Performance Tuning
Deploy Mode
Advanced
Add Date Column
Behavioral Dimension
Column Deltas
File Look Back
Filter & Filter Not
Multiple Pattern Relationships
Nulls in Datasets
Reference Checks
Transform Expressions
Prescriptive Personas
Multi-Tenant
Multi-Tenancy
Reports
Owl Summary Reports
Dataset Report
Scheduler
Schedule Management
Schedule Owlchecks
View/Re-Run Scheduled Jobs
API
Notebook
JWT
Cookie
DQ is the difference
Owl's Scorecard and 9 Dimensions of DQ
Best Practices
Healthcare Data Quality
Smart Meter Data
Health Insurance Claims Data
OBSERVATION ASSIGNMENTS
Assignment Queue(s)
Internal Assignment
External Assignment
APIs
ERD
FAQ
Powered by GitBook

Column Deltas

Example

-ds dataset_deltas,
-rd "2019-07-15" \
-q "select * from nyse where run_dt = '2019-07-14'" \
-lib "/opt/owl/drivers/postgres/" \
-cxn postgres \
-record "SYMBOL"

A simple way to see if distinct values in a given column are being added or dropped compared to the previous run

-record "SYMBOL"

In this example, if a new symbol is added or dropped it will appear in the Records section of the hoot page.

Advanced - Previous
Behavioral Dimension
Next - Advanced
File Look Back
Last updated 1 year ago
Edit on GitHub