Use Case: Customer is reading data from a JSON file with a column that has a epoch value. Need to convert that column/value to a date column to run DQ checks against it. Create DatasetClick Settings Configuration Turn On Click Add on bottomSelect Custom, Select Column, Uncheck Override, Add Name for New ColumnAdd Expressiondate_add(‘1970-01-01’, cast((epoch_time/86400) as int)) as epoch_time_convertcolumn Click Build Model, Save and Run, Run Job Verify New Column Created Note: New Column can be...

How to convert epoch column to date column in DQ? | Data Quality & Observability

How to convert epoch column to date column in DQ? | Data Quality & Observability | Collibra Community