How to load transactions data into Google BigQuery?

You can use libraries and applications to automate data transfer from CRM to Google BigQuery:

  1. SDK for .NET, .Java, PHP, Python
  2. Upload files in CSV and JSON format using command line
  3. ODBC-driver from CDATA
  4. ETL applications
  5. Google Sheets data upload using OWOX BI BigQuery Reports add-on

Consider character encodings and delimitersCurrently your data must be UTF-8 (by default) or ISO-8859-1 encoded. More details in Google BigQuery documentation
As a delimiter Google BigQuery recognizes comma or a tab separator. More details in Google BigQuery documentation

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.