'Check date with Soda-Spark
I am trying to test data using soda-spark. I am trying to test whether the format of a date is valid or not. Now I am stuck in defining the test.
This is what I have at the moment:
scan definition = ("""
table_name: demo
metrics:
-row_count
columns:
date:
Valid_format: ??????
tests:
- invalid_percentage == 0
""")
Can anyone help me what to fill in on the '??????' to check if it is a valid Date. what it should be is 'dd/mm/yyyy hh:mm
thanks in advance!
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
