Recommendations to others considering Google BigQuery Data Transfer Service:
If you are coming from a traditional SQL database mindset, understand that BigQuery is NOT a standard database and may include "features" that you have to workaround. For example, if you have a table and a column in that table with the same name, then when importing to BigQuery it will nest the whole table instead of just importing that column in your results. Review collected by and hosted on G2.com.
What problems is Google BigQuery Data Transfer Service solving and how is that benefiting you?
We're using BigQuery as a warehouse for Fivetran. Data is imported and transformed along the way, so we are also using BigQuery to check and test those transforms. when satisfied, we move Data from BigQuery into a PostGRES database using Node.js and an SDK from NPM. From the standpoint of connecting from custom sources like Node, we find that BigQuery is, again, easy to use and work with. Review collected by and hosted on G2.com.