Hands-On Essentials – Web User Interface Course

Project Video Submission Details

IMPORTANT: We are now restricting submissions to 2 and a half minutes. Anything longer than 2 and a half
minutes is automatically rejected. Please watch the TOP SUBMISSIONS available in the upper-right corner of
the screen for example submissions that meet these criteria. If you are having trouble keeping the video short,
please go to the last section of this document for tips on shortening your video.

LANGUAGE: Feel free to speak in English, French, Spanish, or German.

Task 1: State Your First & Last Name.

Task 2: PICK ONE – State your favorite color, favorite animal, or favorite food.
Just one. Not one of each. This is to give you a chance to prove you read the instructions and for us to
encourage you to take an informal tone. This is not a job interview. Relax.

Task 3: Tell us ONE thing about Snowflake that you like.

There is no need to parrot Snowflake marketing materials. “I like stages” is sufficient. You can elaborate, but
only if you can still get the video done in less than 2 1/2 minutes. Again, this is not a job interview. After this
task, we may continue our grading using the fast forward button. If you have anything vital to tell us, tell us
before task 4.

Task 4: Show Your Report Card from Mindtickle

Click your picture in the upper right

corner of the screen.

We need to see this area.

We also need to see this.

Task 5: Show Credits Used on the Account

1) Click Account in the Navigation Ribbon and, if needed,

2) Go to the Usage tab.
This tab sometimes allows us to see evidence of cheating. If you can’t show us this tab, tell us why.

Task 6: Run Scripts Live During Video Recording to Show Your Work
• The next two pages contain three scripts you must run during your video.
o The first script checks to see that you’ve created the objects (you’ll need to have your
worksheet context set to Account Admin for this one)
o The second script checks to see that your tables have data loaded into them.
o The third script checks to see that you have a working connection to the AWS bucket.

Load the scripts into worksheets in advance, test them in advance, then, run them LIVE for the
video and MAKE SURE YOU SHOW ALL THE RESULTS ROWS BY USING THE POP-OUT
(“Maximize Results”).

***************
USE THE
POP OUT PANE TO SHOW
YOUR FULL RESULT SETS
QUICKLY AND EASILY
*************
Script 1: The objects exist and are named as expected
//check for all 3 databases
//The SNOWFLAKE database will only be visible if your worksheet role context is set to ACCOUNTADMIN
// or if you have modified privileges to that database
Select 'databases' as category,count(*) as found, '3' as expected
from SNOWFLAKE.INFORMATION_SCHEMA.DATABASES
where DATABASE_NAME IN
('USDA_NUTRIENT_STDREF','LIBRARY_CARD_CATALOG','SOCIAL_MEDIA_FLOODGATES')
UNION
//Check for necessary tables in USDA database
Select 'usda tables' as category,count(*) as found, '5' as expected
FROM USDA_NUTRIENT_STDREF.INFORMATION_SCHEMA.TABLES
WHERE TABLE_NAME IN ('FD_GROUP_INGEST', 'FD_GROUP', 'WEIGHT_INGEST','WEIGHT','LANGDESC')
AND TABLE_SCHEMA = 'PUBLIC'
UNION
//Check for necessary tables in LIBRARY CARD CATALOG database
Select 'library card catalog tables' as category,count(*) as found, '6' as expected
FROM LIBRARY_CARD_CATALOG.INFORMATION_SCHEMA.TABLES
WHERE TABLE_NAME IN
('BOOK','AUTHOR','BOOK_TO_AUTHOR','AUTHOR_INGEST_XML','AUTHOR_INGEST_JSON','NESTED_INGEST_JSON')
AND TABLE_SCHEMA = 'PUBLIC'
UNION
Select 'social media floodgates tables' as category,count(*) as found, '1' as expected
FROM SOCIAL_MEDIA_FLOODGATES.INFORMATION_SCHEMA.TABLES
WHERE TABLE_NAME IN ('TWEET_INGEST')
AND TABLE_SCHEMA = 'PUBLIC'
UNION
Select 'stages' as category, COUNT(*) as found, '1' as expected
from"USDA_NUTRIENT_STDREF"."INFORMATION_SCHEMA"."STAGES"
WHERE STAGE_NAME = 'MY_S3_BUCKET'
AND STAGE_SCHEMA = 'PUBLIC'
UNION
Select 'usda file formats' as category, COUNT(*) as found, '1' as expected
from"USDA_NUTRIENT_STDREF"."INFORMATION_SCHEMA"."FILE_FORMATS"
WHERE FILE_FORMAT_NAME in ('USDA_FILE_FORMAT')
AND FILE_FORMAT_SCHEMA = 'PUBLIC'
union
Select 'library file formats' as category, COUNT(*) as found, '2' as expected
from"LIBRARY_CARD_CATALOG"."INFORMATION_SCHEMA"."FILE_FORMATS"
WHERE FILE_FORMAT_NAME in ('JSON_FILE_FORMAT','XML_FILE_FORMAT')
AND FILE_FORMAT_SCHEMA = 'PUBLIC'
union
Select 'stages' as category, COUNT(*) as found, '1' as expected
from"USDA_NUTRIENT_STDREF"."INFORMATION_SCHEMA"."STAGES"
WHERE STAGE_NAME ='MY_S3_BUCKET'
AND STAGE_SCHEMA = 'PUBLIC'
UNION
Select 'sequences' as category, COUNT(*) as found, '2' as expected
from"LIBRARY_CARD_CATALOG"."INFORMATION_SCHEMA"."SEQUENCES"
WHERE SEQUENCE_NAME IN ('SEQ_AUTHOR_UID','SEQ_BOOK_UID')
AND SEQUENCE_SCHEMA = 'PUBLIC'
UNION
Select 'views' as category, COUNT(*) as found, '1' as expected
from"SOCIAL_MEDIA_FLOODGATES"."INFORMATION_SCHEMA"."VIEWS"
WHERE TABLE_NAME IN ('HASHTAGS_NORMALIZED')
AND TABLE_SCHEMA = 'PUBLIC'
Script 2: Records have been loaded into various tables as expected
(don’t worry if a few of these are off by some, as long as the majority are correct).

//CHECKING DATA
SELECT 'Data-FD_GROUP_INGEST' as data_confirmed, COUNT(*) AS ROWS_FOUND, '25' AS
ROWS_EXPECTED
FROM "USDA_NUTRIENT_STDREF"."PUBLIC"."FD_GROUP_INGEST"
WHERE FDGRP_DESC like '%~%'
UNION
SELECT 'Data-WEIGHT' as data_confirmed, COUNT(*) AS FOUND, '14449' AS EXPECTED
FROM "USDA_NUTRIENT_STDREF"."PUBLIC"."WEIGHT"
WHERE NDB_NO not like '%~%'
UNION
SELECT 'Data-WEIGHT_INGEST' as data_confirmed, COUNT(*) AS FOUND, '14449' AS EXPECTED
FROM "USDA_NUTRIENT_STDREF"."PUBLIC"."WEIGHT_INGEST"
WHERE NDB_NO like '%~%'
UNION
SELECT 'Data-LANGDESC' as data_confirmed, COUNT(*) AS FOUND, '773' AS EXPECTED
FROM "USDA_NUTRIENT_STDREF"."PUBLIC"."LANGDESC"
WHERE FACTOR_CODE NOT like '%~%'
UNION
SELECT 'Data-BOOK' as data_confirmed, COUNT(*) AS FOUND, '5' AS EXPECTED
FROM "LIBRARY_CARD_CATALOG"."PUBLIC"."BOOK"
UNION
SELECT 'Data-AUTHOR' as data_confirmed, COUNT(*) AS FOUND, '6' AS EXPECTED
FROM "LIBRARY_CARD_CATALOG"."PUBLIC"."AUTHOR"
UNION
SELECT 'Data-BOOK_TO_AUTHOR' as data_confirmed, COUNT(*) AS FOUND, '6' AS EXPECTED
FROM "LIBRARY_CARD_CATALOG"."PUBLIC"."BOOK_TO_AUTHOR"
UNION
SELECT 'Data-AUTHOR_INGEST_XML' as data_confirmed, COUNT(*) AS FOUND, '12' AS EXPECTED
FROM "LIBRARY_CARD_CATALOG"."PUBLIC"."AUTHOR_INGEST_XML"
UNION
SELECT 'Data-AUTHOR_INGEST_JSON' as data_confirmed, COUNT(*) AS FOUND, '6' AS EXPECTED
FROM "LIBRARY_CARD_CATALOG"."PUBLIC"."AUTHOR_INGEST_JSON"
UNION
SELECT 'Data-NESTED_INGEST_JSON' as data_confirmed, COUNT(*) AS FOUND, '5' AS EXPECTED
FROM "LIBRARY_CARD_CATALOG"."PUBLIC"."NESTED_INGEST_JSON"
UNION
SELECT 'Data-TWEET_INGEST' as data_confirmed, COUNT(*) AS FOUND, '9' AS EXPECTED
FROM "SOCIAL_MEDIA_FLOODGATES"."PUBLIC"."TWEET_INGEST"
UNION
SELECT 'Data-HASHTAGS_NORMALIZED' as data_confirmed, COUNT(*) AS FOUND, '14' AS EXPECTED
FROM "SOCIAL_MEDIA_FLOODGATES"."PUBLIC"."HASHTAGS_NORMALIZED"

Script 3: The AWS S3 Stage exists and its contents can be listed.
// You may want to check the “All Queries” box next to the RUN button for this one
use database usda_nutrient_stdref;
use schema public;
LIST @MY_S3_BUCKET;
TIPS FOR KEEPING YOUR VIDEO SHORT AND EFFICIENT

Watch the Top Submissions to see

how you can be quick and efficient
to keep your video short.

Open the grading

questions so you
can refer to them
as a guide while
you speak.

1) Open four tabs total:

a. Video Submission Tab in Mindtickle
b. Report Card in Mindtickle
c. Usage Tab in Snowflake
d. Worksheets page in Snowflake

2) When describing what you like about Snowflake, list only one reason and don’t spend too much time
explaining your reasoning for it. Some people are able to explain their reason succinctly, and we enjoy
hearing it, but if you can’t keep it short, don’t explain why.

3) Don’t show yourself copying the scripts from this document and pasting them into your worksheets.
Have them pasted there already and run them at least once advance so that when you run them live,
they come from the results cache and load much more quickly.

4) Do not drill into the Mindtickle Report card to show every lesson.

5) Do not talk about each row in your script results.

We offer free training and manual grading because we think hands-on content is an important alternative to
certification exams. The longer your video is, the more it costs us to grade it. When you don’t read the
instructions, you cost us even more money because then we have to grade your work more than once. We
prioritize first submissions and promise to grade them within 7 days. For second submissions, we are willing to
take a look sometime within a 21-day period. Third submissions may wait up to 60 days before they are
graded.