There are many ways to load data into BQ but using Python gives us the most control. Below I’m going to demonstrate loading files into BQ in parallel. My test scenario is: 191 csv files, sizing from 10Mb – 1Gb
Running a Django application on IIS
Django is a popular Python web framework, below is how to use IIS(Internet Information Service) to host Django application on Windows. Install Python on Windows https://python.org Create a python virtual environment so your future development won’t rely on existing Python executables
Deploy pgAdmin as a web service under venv environment
pgAdmin can be deployed as a web server therefore user doesn’t need to install any client to access DB. This also provides a securer way of accessing your database: suppose your web server is on the same network as your