Migration of a database for gas storage management from Microsoft SQL Server to Snowflake on Azure

The MS SQL Server hosted on Azure is replaced by the Snowflake database on Azure. The stored procedures in the MS SQL Server are replaced by Python scripts, which are running on an Azure Batch Account. The ETL tool Talend is used to move data from an external database system to the gas storage database. Furthermore, Talend starts the now the Python scripts instead of the stored procedures on the MS SQL Server. The Talend jobs are starting the Python scripts via an Azure Batch Account. The Python scripts are mainly executing SQL statements for data transformation on Snowflake. The existing reports in Tableau and Power BI are adjusted to use the prepared clean data on Snowflake as data source.