Client had a legacy sql server and there were lot of performance issues. Developed a new data model along with migration of database from on-premise to cloud.
Solution
- Automated the process of loading valid data from files to synapse tables without any manual intervention
- Used dbt to validate business logics accordingly
- Understood client’s legacy data model and reports by reverse engineering to implement the same business logic in synapse to fill the gaps in data model and update the stored procedures in synapse to sync with the latest data model
- Created stored procedures in synapse to output the same legacy report data
Key Features
- Automated the process of migrating the tables and data from On-Premise SQL Server to Azure Synapse.
- Configured Workload management efficiently in Synapse.
Key Metrics
75%
REDUCED MANUAL EFFORT TO 75%
2X
QUERY RESPONE TIME FASTER
Technology Stack
