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

 1 year ago
source link: https://www.youtube.com/watch?v=5DDeSb-mHP0
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
#AzureDataStudio #JupyterNotebooks #AzureSQL

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

•Apr 22, 2021

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.

0:00​ Introduction 0:58​ Notebooks overview 2:54​ Create a Parameterized Notebook- Demo 3:51​ SQL-on-Linux instance in a Docker container - Demo 9:00​ Export Power BI Workspace Assets with PowerShell - Demo 12:22​ Getting started

✔️ Resources: Parameterization of Notebooks in Azure Data Studio - Azure Data Studio | Microsoft Docs: https://docs.microsoft.com/en-us/sql/...​ Use Invoke-ExecuteNotebook to build a SQL-on-Linux instance in a Docker container, by calling Invoke-ExecuteNotebook to execute the Notebook, and passing in the sa_password & digits for the name/port number to the Notebook as a parameter: https://gist.github.com/SQLvariant/47...​ SQL Best Practices and Performance checks: https://aka.ms/BPCheck?WT.mc_id=datae...

📌 Let's connect: Twitter: Aaron Nelson, https://twitter.com/SQLvariant​ Twitter: Anna Hoffman, https://twitter.com/AnalyticAnna​​ Twitter: AzureSQL, https://aka.ms/azuresqltw​

🔴 To check out even more Data Exposed episodes, see our playlist: https://aka.ms/dataexposedyt​

🔔 Subscribe to our channels for even more SQL tips: Microsoft Azure SQL: https://aka.ms/msazuresqlyt​​ Microsoft SQL Server: https://aka.ms/mssqlserveryt​​ Microsoft Developer: https://aka.ms/microsoftdeveloperyt


About Joyk

Aggregate valuable and interesting links.
Joyk means Joy of geeK