Week 74 - Data Loading & Staging

We all know about Snowflake's great care for applications (native or not). So let's imagine the scenario where we have developed an app. It allows customers of FrostyFriday Inc. to upload files to a database, in a raw Snowflake schema and to initiate all the needed transformations to have a final view (into another schema) ready to be presented, just by clicking a button in the app.

File management is the total responsibility of the client. In this specific case, in the 'birthdate' column, we notice that some rows are in the format 'YYYY-MM-DD', some in 'DD/MM/YYYY', and even in some lines there are values like '453921' that are completely wrong.

The goal of this challenge is to have all the dates in the right format in the final view. How would you do it?

P.S: there is a clue about the type of function to use, it's up to you to find it!

Intended solution

Remember if you want to participate:

1. Sign up as a member of Frosty Friday. You can do this by clicking on the sidebar, and then going to ‘REGISTER‘ (note joining our mailing list does not give you a Frosty Friday account)
2. Post your code to GitHub and make it publicly available (Check out our guide if you don't know how to here)
3. Post the URL in the comments of the challenge.