title: Getting Azure SQL Server data into BigQuery
body: <p>Thank you in advance for your patience.  I am writing a lengthy question to attempt to provide as much relevant info as possible.</p>
  
  <p>My data is stored in Azure SQL Server (not by my choice) and I want to work with the data in Google BigQuery.  I would like to update the data in BigQuery from SQL Server periodically (say once an hour or once every few hours for example).  </p>
  
  <p>I have found many ways to pull data from SQL Server and many ways to load data into BigQuery.  What I've landed on as the easiest solution for now is creating a load job in BigQuery that uses the SQL Server URI.  The data in SQL Server has auto modified/created tags that will indicate data that has been updated or added since the last load job.  </p>
  
  <p>But, I needed an IP address for BigQuery that I could add to my SQL Server whitelist to allow access to the SQL Server data.  In Google documentation, the only way I could find to get an IP address was to set up a ComputeEngine VM (which I have done - and I obtained an IP address for the VM).  </p>
  
  <p>My question now is: how do I set up (or is it even possible to set up) the ComputeEngine VM to run the BigQuery load job so that the ComputeEngine IP will be used to request SQL Server?  Or, in the alternative, how do I find the IP that will be used by BigQuery to make the request to SQL Server?</p>
  
  <p>If you have any ideas - or another setup that I have not considered, please spell it out for me step-by-step.  I am rather new to the industry.</p>
  
  <p>Thank you again for your time and consideration.</p>