Learn, collaborate and solve problems with like-minded data quality enthusiasts.
Hi, I have come across something rather infuriating this afternoon whilst creating a number of validation rules within the same rule group. Having spent the best part of 2 hours creating around 20 rules I briefly lost connection, after reconnecting I had to navigate back to the validate step. … all my rules were gone…. Can…
Summary Returns the approximate distance in kilometres between a pair of geographical co-ordinates. Input latitude1, longitude1, latitude2, longitude2, output value is distance between each set of co-ordinates while considering the spherical nature of earth using the law of haversines. Example Buckingham Palace, London is…
Evening all, We're looking at implementing pushdown with Snowflake and have hit a couple of functions where we've had to workaround to avoid blocking the pushdown process. However, this advanced function mapping (as per documentation screenshot below) may help us fill some of those gaps and keep our workflows simpler. 3…
My data includes a column containing JSON values - I've made a dummy example below: Example JSON value: { "magenta": "#f0f", "yellow": "#ff0", "black": "#000", "usageList": [ "giraffe", "lion", "axolotl" ], "properties": { "cost": 99, "difficulty": { "part_a": "hard", "part_b": "easy" } } } I have a couple of requirements:…
Recently developed a function based on the Haversine Formula to generate the distance between two coordinates (in meters). It's useful for comparing distance approximations between different address points. Simply copy the below text into the function script editor: param Point 1: Latitude; param Point 2: Latitude; param…
