Project Description:
The main goal of this project is to create a PDF Report using python and store it in the Azure Storage Container and Validate the report by comparing it with the values in the database.
Project Tasks:
Connect to the MS SQL Server database and load the required data into delta tables
Develop python code to create the report in the required layout.
Validate the report by comparing it with the values in the database.
Export the report in PDF format to Azure Storage Container and save it under two folders namely valid and invalid reports.
Project Stack:
Python
SQL
Azure
Databricks
MS SQL Server
✨Get your custom report today!✨
Like this project
0
Posted Feb 24, 2023
Create a paginated report using python & validate the report against the data that is present in the database & save it to azure storage under valid & invalid.
Likes
0
Views
9
Commission Calculation System
Payer Data Load
Migration of Power BI Reports from SQL Server to Databricks