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!✨