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/AzureP...
SQL Setup
github.com/RussMaxwell/AzureP...
Keyvault Setup
github.com/RussMaxwell/AzureP...
Local Machine Setup
github.com/RussMaxwell/AzureP...
Source Code - Complete
====================
github.com/RussMaxwell/AzureP...
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!
• Python Azure Function ...
5/19/24 - Hands on Lab 3 is now available!
• Python Azure function ...
Негізгі бет Ғылым және технология Python Azure Function (v2) Hands on Lab 1 - Build a Python Azure Function (V2) deep dive.
Пікірлер: 4