Notebook in Snowflake database

 Notebook in Snowflake database

Step 1 : Go to the projects section from the sidebar and select the notebook.

Click on New Notebook.

Add Details as shown in the image below.

Step 2 : Click +markdown to add a Markdown cell.

Step 3: Add the markdown cell title and details. After adding details, click on the Done editing button.

Step 4 : Delete the example cells.

Step 5 : Add one SQL cell. And add name.

Step 6 : Add below given query. And click run button.

Step 7 : Create a new SQL cell and name it and write select query.

Step 8 : Create 3 more SQL cells.

Step 9 : Rearrange the cells.

Step 10 : Add queries and details in cells and run them.

Notebooks can be used to share process flows with others.

Step 11 : Add extra rows in the table.

If you make a mistake,

Step 12 : Send report.

--Set your worksheet drop list role to ACCOUNTADMIN
--Set your worksheet drop list database and schema to the location of your GRADER function

-- DO NOT EDIT ANYTHING BELOW THIS LINE. THE CODE MUST BE RUN EXACTLY AS IT IS WRITTEN

select GRADER(step, (actual = expected), actual, expected, description) as graded_results from ( 
   SELECT 'DWW08' as step 
   ,( select iff(count(*)=0, 0, count(*)/count(*))
      from table(information_schema.query_history())
      where query_text like 'execute NOTEBOOK%Uncle Yer%') as actual 
   , 1 as expected 
   , 'Notebook success!' as description 
);