Export data to Google BigQuery

Export data to Google BigQuery


Zoho DataPrep supports exporting data to Google BigQuery. BigQuery is a fully managed enterprise data warehouse that helps you manage organization data.

To export data to Google BigQuery

1. Click the Export now option from the Export menu in the Studio page.



2. Choose Google BigQuery under the All destinations tab or from the Cloud databases category.



3.  Select an account from the saved connections or add a new account using the Add new  option.



4. Enter the Project ID and click the Sign in with Google button.



4.  After signing in with your google account, you can click Continue to allow Zoho DataPrep to access data from your Google BigQuery project for the first time.

Notes
Note: The connection configuration will be saved for exporting to Google BigQuery project in the future. Credentials are securely encrypted and stored.
 
5. Click Connect.

6. Once you have successfully connected to your Google BigQuery project, you can choose when and where to export the data.

7. Choose Existing table if you want to export data to an existing table and select one from the list of tables available in the database. There are two ways in which you can choose how to add the new rows to the table. 
  1. If the new rows are to be added to the table, choose Append .
  2. If the newly added rows are to replace the existing rows, select Overwrite from the dropdown.


8. If you want to create a new table, select the New table option and give a name to your table in the field below.



9. Click Export .

10. Once the export is complete, you can choose to schedule this export by clicking the C onfigure Schedule> link below.




SEE ALSO