Oh, dear diver, did you get stuck under a submerged arch, and can’t find your way out? Don’t despair, look below and find the help!
If you’re reading this page in disbelief, as you have no idea what we are talking about, well, you may want to visit THIS PAGE to find out.
In order to play the game, you need to get a fresh Keboola Connection project that is part of the game organization. In order to create the sandbox project, go to https://get.keboola.com and use the Promo Code “KASSANDRA”.
You will receive an invitation via email, and after registration, you will get access to your new project. After opening it, you will arrive to this page (will look slightly differently on mobile or based on your screen size, but you get the gist):
The red rectangle marks the “Applications” menu item. Click on that and on the next screen, find and engage the “Sunken Data Temple” application:
The next screen lets you create a configuration of this application and start playing:
Give it a (arbitrary) name, confirm and you’re good to go:
That’s it. You’re ready for your first dive.
Each “dive” is a run of the game application. Based on how many “secrets” are entered, the application knows how far in the game you are.
The first dive is “free” — no secret needs to be entered. Just click the “RUN COMPONENT” button on the right (or below if you’re on mobile):
Once the run completes, a job record appears in the “Last runs” section:
Click on it to get to the Job Detail page. Scrolling down you’ll see the journal of your dive (eh, job event log) and in it the key message:
That’s it. There you see the clue and instructions how to obtain the secret needed to unlock your next dive.
While you were under water searching for the first clue, the game application created a configuration of a MySQL extractor. To check it out, go to the “Extractors” section, which will show you the configuration and you can click on it to open:
While the description on the next screen also provides guidance, here it is too to save you time. All you need to do is select the tables to pull from the dropdown in the middle of the screen. The tables you want are:
Then click the “Create” button and you’re done:
Then just run the extractor (same as the game application, the “RUN EXTRACTION” button on the right):
And wait briefly for the job to finish. As soon as it’s done, the links to tables in the center of the screen will spring to life, and you can click on the first one:
Click on “Data Sample” on the next screen, and find the secret in the table preview in the column aptly named “secret”. Grab it and head back to the game application, enter it there, save the config and onto your next dive:
(In case you were wondering — yes, we KNOW we’ve ‘accidentally’ left the secret in the screenshot. However, this is the LAST time we’re going to make it this easy for you - plus, if you skipped this step and didn’t actually run the extractor, it will bite you later. Just sayin’…)
Now, this is an easy one. Not sure why you are on the help page for this, but anyway… All we are asking you to do is to go read a blog… Once you do, the secret should be pretty obvious. It actually says “This is the secret for the Sunken Data Temple game…”. The link is here. Scroll almost all the way down. There you go. Easy, right?
OK, transformations. Similar to the first puzzle, you will need to use your Keboola device to retrieve the secret from data.
This time you are using the Transformations engine to join two tables and get the secret from the result.
The puzzle itself is a broken SQL code that you need to fix. Here is how to go about it. Go to Transformations,
then select the
The description of the transformation will give you further hints, but here it goes as well. Scroll down on the next page to see the SQL query:
The query is the culprit, it’s not doing what it is supposed to.
Once you fix it, just save and run the transformation:
Then you need to find the output table (just click on it in the “output mapping” section), go to Data Sample and read the secret. No, we won’t just write it here. If you can’t get it out of the transformation, you can go into Google Translate and type the word “spisovatel”. It should recognize it as a Czech word and its English translation just happens to be the 3rd secret. So back to the Sunken Data Temple app, enter the secret and run it again!
Not sure how to help here. The task is pretty straightforward — you can either scan this QR code:
or go to https://get.keboola.com/join-looker-2019, and you’ll find a “Get The Keboola JOIN 2019 App” button on it. Get the app on your phone or tablet:
Find a “Freebies” section:
Once in there, the secret should be pretty obvious.
In case you ran into any trouble and you need to get the secret without the app, well… Google the text “is the study or practice of writing music for an orchestra”:
The title of the Wikipedia page that pops up is the secret.
For this puzzle you’ll need to use Keboola again — this time its “bucket sharing” feature. Its job is to simplify sharing data between different projects or teams within the organization. It’s pretty straightforward. Go to the “Data Catalog” section, and click on the “USE THIS” button:
From the selection of buckets, pick the one called “sunken-data-temple”. There is a table “room_number_5” in it. Check its content and there is the secret!
Trouble still? Well, it’s a synonym of the word “pail”, which is frequently used together with the word “list”. There’s even a great movie with that title. Morgan Freeman and Jack Nicholson are in it. Enough hints?
Here we come! The Last Dive! Come on, you got this far and NOW you need help? OK. When you sign up for our webinar, the confirmation email will have the secret in it. To sign up, use the link HERE or scan this QR code:
Does that not work for you for whatever reason? Don’t despair. There was a lady, famous for French cooking (wrote a book and had a TV show!). Last name? Child. First name? That’s the secret. Also a programming language, getting more and more popular with data scientists. A new transformation backend in Keboola. Good now?
Now for something completely different! We’re in a Looker dashboard now. The task is still pretty simple though — just pick the last three secrets from the game correctly from the filters on top of the dashboard, click on RUN and you’re off to the races! Then scroll down for your prize code. See you at JOIN2019! And if you are not coming, just e-mail us with your code and we’ll find a way to get it to you.
Thanks for playing!