<jupyter_start><jupyter_text>Main Notebook This notebook is for orchestration purposes. We wil be calling following notebooks:- Day20_NB1.ipynb- Day20_NB2.ipynb- Day20_functions.ipynb- Day20_NB3_Widget.ipynb- Day20_Main.ipynb (this document) Run notebook 1 - Day20_NB1And get the results back<jupyter_code>%run /Users/tomaz.kastrun@gmail.com/Day20/Day20_NB1<jupyter_output><empty_output><jupyter_text>Load functions from notebook Day20_functions<jupyter_code>%run /Users/<EMAIL>/Day20/Day20_functions<jupyter_output><empty_output><jupyter_text>Consume loaded functions from notebook: Day20_functions in this notebook: Day20_Main<jupyter_code>num1 = 100
num2 = 400

print("The sum is", add_numbers(num1, num2))
current_time()<jupyter_output><empty_output><jupyter_text>Now let's also create Table to store results of notebook runOnly Daily20_NB2 has a SQL INSERT Command<jupyter_code>%sql
DROP TABLE IF EXISTS day10.day20_NB_run;
CREATE TABLE day10.day20_NB_run (id INT, NB_Name STRING, Run_time TIMESTAMP)
%sql
INSERT INTO day10.day20_NB_run VALUES (10, "Running from day20_Main notebook", CAST(current_timestamp() AS TIMESTAMP))

%sql SELECT * FROM day10.day20_NB_run 
%run /Users/tomaz.kastrun@gmail.com/Day20/Day20_NB2<jupyter_output><empty_output><jupyter_text>Check the results of insert statement from notebook2<jupyter_code>%sql SELECT * FROM day10.day20_NB_run<jupyter_output><empty_output><jupyter_text>Passing the arguments with values from this notebook (Day20_Main)  to notebook Day20_NB3_Widget<jupyter_code>dbutils.notebook.run("Day20_NB3_Widget", 60, {"Wid_arg": "5"})<jupyter_output><empty_output><jupyter_text>Check if the previous execution of running notebooks have been succesful<jupyter_code>%sql SELECT * FROM day10.day20_NB_run<jupyter_output><empty_output>
{'fraction_non_alphanumeric': 0.08820224719101123, 'fraction_numerical': 0.05056179775280899, 'mean_word_length': 8.627027027027028, 'pattern_counts': {'":': 1, '<': 30, '<?xml version=': 0, '>': 30, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 2, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'chain_length': '7', 'dir': 'jupyter-structured-clean-dedup', 'id': '597370', 'license': 'MIT', 'n_tokens_mistral': 705, 'n_tokens_neox': 639, 'n_words': 139, 'path': 'notebooks/Day20/Day20_Main.ipynb', 'repo_name': 'tomaztk/Azure-Databricks', 'size': '1796'}