How to Parameterize Notebooks for Automation in Azure Data Studio | Data Exposed

Published 04-22-2021 09:00 AM 771 Views
Microsoft

Jupyter Notebooks bring a wonderful capability to hand someone a single file that contains both code, and instructions on how to run that code. This is great and can be used in many different ways, one of which is to help new team members get up to speed. But what happens when you need to do the same thing as one of your existing Notebooks, but now you need to do it at scale? What if you could take your existing Notebook and add parameters for things like Server name & Database? In this episode with Aaron Nelson, take a look at how new features in Azure Data Studio can help you take your Notebooks to the next level of re-usability.

 

Watch on Data Exposed


Resources:

 

View/share our latest episodes on Channel 9 and YouTube!

%3CLINGO-SUB%20id%3D%22lingo-sub-2280766%22%20slang%3D%22en-US%22%3EHow%20to%20Parameterize%20Notebooks%20for%20Automation%20in%20Azure%20Data%20Studio%20%7C%20Data%20Exposed%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2280766%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EJupyter%20Notebooks%20bring%20a%20wonderful%20capability%20to%20hand%20someone%20a%20single%20file%20that%20contains%20both%20code%2C%20and%20instructions%20on%20how%20to%20run%20that%20code.%20This%20is%20great%20and%20can%20be%20used%20in%20many%20different%20ways%2C%20one%20of%20which%20is%20to%20help%20new%20team%20members%20get%20up%20to%20speed.%20But%20what%20happens%20when%20you%20need%20to%20do%20the%20same%20thing%20as%20one%20of%20your%20existing%20Notebooks%2C%20but%20now%20you%20need%20to%20do%20it%20at%20scale%3F%20What%20if%20you%20could%20take%20your%20existing%20Notebook%20and%20add%20parameters%20for%20things%20like%20Server%20name%20%26amp%3B%20Database%3F%20In%20this%20episode%20with%20Aaron%20Nelson%2C%20take%20a%20look%20at%20how%20new%20features%20in%20Azure%20Data%20Studio%20can%20help%20you%20take%20your%20Notebooks%20to%20the%20next%20level%20of%20re-usability.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%3E%3CFONT%20size%3D%225%22%3E%3CA%20href%3D%22https%3A%2F%2Fyoutu.be%2F5DDeSb-mHP0%3FWT.mc_id%3Ddataexposed-c9-niner%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3EWatch%20on%20Data%20Exposed%3C%2FA%3E%3C%2FFONT%3E%3CBR%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CDIV%3E%3CEM%3E%3CBR%20%2F%3EResources%3A%3C%2FEM%3E%3C%2FDIV%3E%0A%3CDIV%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsql%2Fazure-data-studio%2Fnotebooks%2Fnotebooks-parameterization%3Fview%3Dsql-server-ver15%26amp%3BWT.mc_id%3Ddataexposed-c9-niner%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EParameterization%20of%20Notebooks%20in%20Azure%20Data%20Studio%20-%20Azure%20Data%20Studio%20%7C%20Microsoft%20Docs%3CBR%20%2F%3E%3C%2FA%3E%3CA%20href%3D%22https%3A%2F%2Fgist.github.com%2FSQLvariant%2F472021981475d1cd917ac07205a2bcc3%3FWT.mc_id%3Ddataexposed-c9-niner%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EUse%20Invoke-ExecuteNotebook%20to%20build%20a%20SQL-on-Linux%20instance%20in%20a%20Docker%20container%2C%20by%20calling%20Invoke-ExecuteNotebook%20to%20execute%20the%20Notebook%2C%20and%20passing%20in%20the%20sa_password%20%26amp%3B%20digits%20for%20the%20name%2Fport%20number%20to%20the%20Notebook%20as%20a%20parameter%3C%2FA%3E%3C%2FP%3E%0A%3C%2FDIV%3E%0A%3CP%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%3EView%2Fshare%20our%20latest%26nbsp%3Bepisodes%20on%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fchannel9.msdn.com%2FShows%2FData-Exposed%3FWT.mc_id%3Ddataexposed-c9-niner%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EChannel%209%3C%2FA%3E%26nbsp%3Band%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fplaylist%3Flist%3DPLlrxD0HtieHieV7Jls72yFPSKyGqycbZR%26amp%3BWT.mc_id%3Ddataexposed-c9-niner%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3EYouTube%3C%2FA%3E!%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-2280766%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22MSDataExposed.jpg%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F202729i490928FF0C962B7B%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22MSDataExposed.jpg%22%20alt%3D%22MSDataExposed.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3ELearn%20how%20to%20take%20your%20notebooks%20to%20the%20next%20level%20in%20Azure%20Data%20Studio.%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2280766%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAzure%20SQL%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Co-Authors
Version history
Last update:
‎Apr 21 2021 02:09 PM
Updated by: