Semaine 64 – Hard

Bienvenue à tous, it’s a pleasure to announce that on 5th October, at the Data Cloud World Tour Paris, thanks to the amazing hard work of Jade Le Van & Maxime Simon we’ll be launching Jeudis Givrés !

All of the Frosty Friday challenges will be translated into French and released on the following Thursday (for the sake of alliteration), followed by lots of community events to help boost those Parisian (and wider French) Snowflake skills!

To celebrate, we’re revisiting our Week 4 challenge on Spanish monarchs, but this time, in XML (which was partly invented by a Frenchman). Can you parse out the French monarchs?

create or replace file format frosty_parquet
type = 'parquet';

create or replace stage s3_stage
    url = 's3://frostyfridaychallenges'

create or replace table week64 as
select parse_xml($1:"DATA") as data
from @s3_stage/challenge_64/french_monarchs.parquet
    (file_format => frosty_parquet);

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.