Migration of Data storage of the gas storage management from Excel to Snowflake database

The Excel VBA application is replaces by a Snowflake database on Azure. Data from different data sources are integrated in Snowflake as data warehouse using different services (Azure Function App, Azure Webjobs, Sharepoint API). The ETL tool Talend is used to start an Azure Batch Account, which is calling Python scripts. The Python scripts are running SQL statements to transform the data on Snowflake and also insert the transformed data back into Snowflake. The transformed data on Snowflake can be used for reporting on Power BI.