Python Azure Function (v2) Hands on Lab 1 - Build a Python Azure Function (V2) deep dive.

Рет қаралды 3,093

4 ай бұрын

Learn how to securely retrieve secrets from Azure Key Vault and fetch results from an Azure SQL database using the pyodbc library.
In this hands-on lab, you will build a Python based Azure Function (v2). It will retrieve secrets from Azure Keyvault and use them to connect and retrieve results from Azure SQL database. If you want to follow along, you will need an Azure Subscription and setup the prerequisites below:
Prerequisites
=================
Function App Setup
github.com/RussMaxwell/AzurePython/blob/main/Labs/azfunc1/functionappsetup.md
SQL Setup
github.com/RussMaxwell/AzurePython/blob/main/Labs/azfunc1/sqlsetup.md
Keyvault Setup
github.com/RussMaxwell/AzurePython/blob/main/Labs/azfunc1/keyvaultsetup.md
Local Machine Setup
github.com/RussMaxwell/AzurePython/blob/main/Labs/azfunc1/localmachinesetup.md
Source Code - Complete
====================
github.com/RussMaxwell/AzurePython/blob/main/Labs/azfunc1/src/function_app.py
Sample SQL Query to retrieve roles for a user named: funcusr
====================================================
SELECT r.name AS role_name
FROM sys.database_role_members m
JOIN sys.database_principals u ON u.principal_id = m.member_principal_id
JOIN sys.database_principals r ON r.principal_id = m.role_principal_id
WHERE u.name = 'funcusr';
Hands on Lab 2 is now available!
kzfaq.info/get/bejne/pb6TmMh019fLknU.html
5/19/24 - Hands on Lab 3 is now available!
kzfaq.info/get/bejne/a5efqpSer9CWh5s.html
6/19/24 - Hands on Lab4 is now available!
kzfaq.info/get/bejne/mM5kl8J6tN7Llac.html
Timecodes
0:00 - Intro and Setup
2:00 - Validate the Setup
4:27 - Local Machine Setup
5:31 - Create Azure (V2) Function
9:38 - Test vanilla AZ Function runs locally
11:54 - Write code and discuss
28:52 - Run function app locally
32:05 - Deploy solution to Azure Function App

Пікірлер: 10

@rabindrajaiswal5329 Күн бұрын

Thank you. Very clear demo, excellent tutorial

@russmaxwell1794 15 күн бұрын

This video series comprised of 4 videos is complete. Please check the description for links.

@sunrajsharma736 2 ай бұрын

You just did a much better job than microsoft docs or their tutorials💯!! Can you please make an extension to this video that is catered towards edits required to make it a use this in a production environment ?

@venkataramanapotluri1758 3 ай бұрын

Thank you very much for this tutorial. This is really excellent. When I deployed and called the function from ADF it errored out saying no drivers available. Could you please tell me what shall I do

@russmaxwell1794 3 ай бұрын

I haven't tried calling it from ADF? Does it work if you call the AZ Function in the browser?

@ehink2716 8 күн бұрын

Great video was trying this but came across an issue, which maybe something with my setup. When I show a warning with that cnxn.cursor line which it says cnxn is not defined was something else suppose to be installed?

@ehink2716 8 күн бұрын

found the typo on mypart

@russmaxwell1794 8 күн бұрын

Glad it worked out. Let me know if you uncover any new issues!

@russmaxwell1794 2 ай бұрын

Hands on Lab2 is now available. Add logging to Azure Function by integrating Application Insights kzfaq.info/get/bejne/pb6TmMh019fLknU.html

@ehink2716 7 күн бұрын

Is there another way to get logging without app insights?