How to 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.

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

    Zoho CRM Training Programs

    Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.

    Zoho CRM Training
      Redefine the way you work
      with Zoho Workplace

        Zoho DataPrep Personalized Demo

        If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.

        Zoho CRM Training

          Create, share, and deliver

          beautiful slides from anywhere.

          Get Started Now


            Zoho Sign now offers specialized one-on-one training for both administrators and developers.

            BOOK A SESSION








                                You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.




                                    Manage your brands on social media

                                      Zoho Desk Resources

                                      • Desk Community Learning Series


                                      • Digest


                                      • Functions


                                      • Meetups


                                      • Kbase


                                      • Resources


                                      • Glossary


                                      • Desk Marketplace


                                      • MVP Corner


                                      • Word of the Day


                                        Zoho Marketing Automation

                                          Zoho Sheet Resources

                                           

                                              Zoho Forms Resources


                                                Secure your business
                                                communication with Zoho Mail


                                                Mail on the move with
                                                Zoho Mail mobile application

                                                  Stay on top of your schedule
                                                  at all times


                                                  Carry your calendar with you
                                                  Anytime, anywhere




                                                        Zoho Sign Resources

                                                          Sign, Paperless!

                                                          Sign and send business documents on the go!

                                                          Get Started Now




                                                                  Zoho TeamInbox Resources



                                                                          Zoho DataPrep Resources



                                                                            Zoho DataPrep Demo

                                                                            Get a personalized demo or POC

                                                                            REGISTER NOW


                                                                              Design. Discuss. Deliver.

                                                                              Create visually engaging stories with Zoho Show.

                                                                              Get Started Now







                                                                                            You are currently viewing the help articles of Sprints 1.0. If you are a user of 2.0, please refer here.

                                                                                            You are currently viewing the help articles of Sprints 2.0. If you are a user of 1.0, please refer here.



                                                                                                  • Related Articles

                                                                                                  • Import data from Google BigQuery

                                                                                                    Zoho DataPrep supports importing data from Google BigQuery. BigQuery is a fully managed enterprise data warehouse that helps you manage organization data. To import data from Google BigQuery 1. Click the Add dataset option to create a new dataset in ...
                                                                                                  • Scheduling data export

                                                                                                    You can schedule data export using different export configurations in DataPrep. To schedule data export Click Export from the top bar in the Studio page and select Schedule export . 2. Click the New schedule button to create a new schedule for ...
                                                                                                  • Export data to Google Drive

                                                                                                    Zoho DataPrep supports exporting data to Google Drive, a file storage and synchronization service developed by Google. Google Drive allows users to store files in the cloud, synchronize files across devices, and share files. To export data to Google ...
                                                                                                  • Export data to Google Cloud SQL - MySQL

                                                                                                    Zoho DataPrep allows you to export data to Google Cloud SQL, a cloud database. It is a fully-managed database service that helps you set up, maintain, manage, and administer your relational databases on Google Cloud Platform. To export data to Google ...
                                                                                                  • Export data to cloud storage services

                                                                                                    You can export data to the following cloud storage services. Google Drive OneDrive Box Storage Dropbox Zoho WorkDrive Amazon S3 To export data to cloud storage services 1. Click the Export now option from the Export menu in the DataPrep Studio page. ...
                                                                                                    Wherever you are is as good as
                                                                                                    your workplace

                                                                                                      Resources

                                                                                                      Videos

                                                                                                      Watch comprehensive videos on features and other important topics that will help you master Zoho CRM.



                                                                                                      eBooks

                                                                                                      Download free eBooks and access a range of topics to get deeper insight on successfully using Zoho CRM.



                                                                                                      Webinars

                                                                                                      Sign up for our webinars and learn the Zoho CRM basics, from customization to sales force automation and more.



                                                                                                      CRM Tips

                                                                                                      Make the most of Zoho CRM with these useful tips.



                                                                                                        Zoho Show Resources