Import data from Google BigQuery

If you have your data stored in Google BigQuery cloud database, you can easily import the data into Zoho Analytics or connect live with the Google BigQuery for advanced reporting and analysis.

Data Import: Data from your database will be imported and stored in Zoho Analytics. Periodic schedules can be set up to fetch the latest data automatically from the cloud database.
Live Connect: In this mode, data will not be imported and stored in Zoho Analytics. Instead, Zoho Analytics will display live data from your database when reports and dashboards are launched. The report loading time will directly depend on the response and performance of Google BigQuery. Live connections offer the convenience of real-time updates.

Data import

1. How do I import data from the Google BigQuery database into Zoho Analytics?

2. How do I edit the data import configuration?

3. How long does it take for the Google BigQuery data to be imported into Zoho Analytics?

After setting up data import from your cloud database, you might have to wait some time for the initial fetch to happen. Depending on the amount of data in your application, the reports and dashboards might take up to 5 minutes to display all the metrics. If you access the workspace before the initial fetch is complete, it will not display any data.

4. Will the foreign keys defined between the tables in the Google BigQuery database be linked in Zoho Analytics as well?

When importing multiple tables, the foreign keys defined between the tables in the cloud database will be linked in Zoho Analytics using lookup columns. However, if you import one table at a time, the foreign keys will not be defined. In such cases, you can link the tables in Zoho Analytics using the lookup column functionality. To learn more about lookup columns, click here.

5. Is it possible to change the data type of the columns imported into Zoho Analytics?

Yes. To learn more about changing the column type in Zoho Analytics, click here.
Note: While changing the column's data type in Zoho Analytics, ensure that it is compatible with the column's data type in the cloud database, for successful data synchronization.

6. How do I schedule data import?

Zoho Analytics allows you to schedule the data import for any existing tables imported from Google BigQuery database. Follow the steps below to do this.

Select the Data Sources option from the side panel, and navigate to the required Google BigQuery data source.
Click the Sync Settings button.
In the pop-up that appears, select the required schedule interval from the Repeat drop down.
Choose the required option from the Notify me after every 'N' Sync Failure (s) drop-down to get notifications on consecutive import failures.
Click Save. The data from your Google BigQuery database will be imported into Zoho Analytics in the specified intervals.

You can also schedule the import during the initial import. Refer this presentation to know more.

7. How do I get notified of import failures?

Zoho Analytics allows you to get notified of consecutive import failures, while setting up data schedules. To do this,

Select the Data Sources option from the side panel, and navigate to the required Google BigQuery data source.
Click the Sync Settings button.
In the pop-up that appears, choose the required option from the Notify me after every 'N' Sync Failure (s) drop-down to get notifications on consecutive import failures.

You can also set up notifications of import failures during the initial data import. Refer this presentation to know more.

8. Can I import data from the Google BigQuery database into an existing workspace in Zoho Analytics?

Yes. Follow the below steps to import data into an existing workspace:

Open the required workspace. Click Create from the side panel, and select the New Table / Import Data option.
Click the Cloud Databases tile, and follow the steps detailed in this presentation.

9. Can I synchronize data from the Google BigQuery database instantly?

Yes. Follow the steps below to do this.

Open the required workspace, and click the Data Sources tab from the side panel.
Navigate to the required Google BigQuery data source and click the Sync Now link.

10. How do I resolve synchronization failure?

To resolve synchronization failure, you need to understand the reason behind the failure. To do this,

Click the Data Sources button from the side panel, and navigate to the required data source.
Click the View Last Import Details icon that appears on mouse over the listed tables. This opens the Import Details page, which provides detailed insight on the reason for the synchronization failure.

You can also view the Import Details page from the table view. Open the required table and click the Import Data > Last Import Details option.

11. How do I remove the Google BigQuery data source?

To remove the setup,

Click the Data Sources button from the side panel, and navigate to the required data source.
Click the Settings icon that appears on mouse over the data source's name, and select Remove Data Source.

Note: Removing the data source does not delete the corresponding tables and reports from Zoho Analytics. However, further synchronization cannot be carried out.

Live connect

1. How do I connect live with the Google BigQuery database?

2. How do I edit the live connection configuration?

3. What are the differences between data imports and live connections?

The various differences are tabulated below.

Data Import	Live Connect
The data from the Google BigQuery database will be imported and stored in Zoho Analytics.	The data from the Google BigQuery database will be fetched live whenever you create or access a report in Zoho Analytics.
Data from other sources can be imported into the same workspace and combined for reporting and advanced analysis.	Data from other sources cannot be imported into a workspace that is created using live connections.
Changes made to the columns in the data source, such as addition or deletion, will be synchronized automatically.	To reflect any changes in data structures from the data source to Zoho Analytics, manual synchronization has to be carried out.
Query tables can be created.	Query tables cannot be created in a workspace set up with live connect.
Report loading time will be fast, as the data is stored locally in Zoho Analytics.	As data from the source database is not stored locally in Zoho Analytics, the loading time will depend on the performance of database, and the amount of data included in the report.

4. How long does it take to visualize data in Zoho Analytics?

As data from the source database is not imported into Zoho Analytics, the loading time depends on the amount of data stored in your Google BigQuery database, and the performance of the database.

5. Will the foreign keys defined between tables in the database be defined in Zoho Analytics?

Look-up relationship will be automatically created for tables linked via foreign keys in the Google BigQuery database. You can also manually link the tables in Zoho Analytics using the lookup column functionality. To learn more about lookup columns, click here.

6. Why am I unable to access a table or a report in Zoho Analytics?

If the tables or columns present in Zoho Analytics have been deleted from the database, you will not be able to access the corresponding views in Zoho Analytics. To overcome this, remap the corresponding table or column. Click here to know more.

7. What is a Mismatch?

In Zoho Analytics, a mismatch occurs ‌when the tables and columns in your Zoho Analytics workspace don't have a direct mapping to the data in the database. ‌In case of any mismatches, Zoho Analytics will not be able to fetch appropriate data from the Google BigQuery database. These mismatches are listed under the Mismatch tab of the corresponding Data Sources page. Refer to the following question to know more.

8. When do Mismatches occur and how do I resolve them?

9. How to reflect the meta data changes of individual tables from the cloud database instantly?

When you have meta data changes in any or all of your tables, you can instantly reflect those changes in Zoho Analytics. Changes in meta data include updates such as column addition and deletion.

Follow the steps below to reflect meta data changes in Zoho Analytics:

Open the required workspace, and click the Data Sources tab from the side panel.
Navigate to the required data source, and click the Sync option that appears on mouse over the required table name.
The meta data changes of the selected table will be reflected instantly from the cloud database to the Zoho Analytics table.

You can also update the meta data changes of all tables from the cloud database by clicking the Sync Design button.

10. Is it possible to connect live with newly added tables in the Google BigQuery database?

Yes. To do this, click the Data Sources option from the side panel and click + Add More Tables to link the newly added tables from the Google BigQuery database to Zoho Analytics.

Note: In case of mismatches, you will not be able to add new tables. The mismatches need to be resolved first. Click here to know more about resolving mismatches.

11. Is it possible to change the data type of the columns in Zoho Analytics?

No. You cannot change the data type of the columns in Zoho Analytics when connecting live with your database.

12. Can I import data from other data sources into a workspace set up with live connection?

No. Data from other data sources can only be imported into workspaces that are created using the Data Import option.

13. Can I create query tables in workspaces set up with live connection?

Unlike data imports, live connections do not fetch data and store it locally in Zoho Analytics. Therefore, query tables cannot be created in such scenarios. To do this, data has to be imported using the Data Import option.

14. What happens when I delete or rename the database in Google BigQuery?

If the database is renamed or deleted, Zoho Analytics loses the connectivity to Google BigQuery, and the following error message appears.

This error message also appears when there are any connectivity issues, or if your Google BigQuery credentials have expired. To overcome this, click the Edit Connection button that appears, and modify the required settings. To learn more about editing live connection settings, click here.

15. How do I remove the Google BigQuery setup?

To remove the live connection setup, the corresponding Zoho Analytics workspace has to be deleted. To do this, navigate to the required workspace in the Zoho Analytics homepage, and click the More Actions icon. Select the Delete Workspace option and confirm your action in the popup that appears.

Access your files securely from anywhere

Zoho CRM Training Programs

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

Redefine the way you work

with Zoho Workplace

Start your free trial

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.

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

Zoho Workerly Home
Forums
Connect With Us:

Zoho Recruit Home
Forums
Connect With Us:

Start tracking your website metrics today

Use PageSense to understand what your visitors are looking for, how they are behaving, and where they are facing problems on your website.

Ready to improve your website's performance?

Install the PageSense code snippet on your site in a matter of minutes and start collecting in-depth data about the website visitors to grow your business.

Track and measure every business goal

Set up goals in PageSense to measure every single action performed by visitors on your website like button or link clicks, form submissions, and page engagements.

Understand the customer journey on your website

Create funnels in PageSense to quickly see which pages visitors use to enter your website, where they navigate to next, and which pages they decide to leave without converting.

Visualize your visitor's behavior with color codes

Set up heatmaps in PageSense to see where users have clicked more, how far they've scrolled, and on which parts of a page they've spent the most time using color-coded patterns in reports.

Measure customer engagement with your web forms

Use form analytics in PageSense to see how people interact with different fields in your form, whether they complete the form successfully or not, and where exactly they drop out on your form.

Record real visitor interactions on your website

Use session recordings in PageSense to watch a video of all the visitor actions performed on your website including the pages they navigate, the buttons they click, the UX issues they face, and more.

Test and optimize webpages for better conversions

Run A/B or Split URL tests in PageSense to figure out which version of your web page works best for your business and results in the best conversion rate.

Give each customer a unique website experience

Use personalization in PageSense to deliver customized versions of your website for every individual customer based on their demographics, local weather, browsing history, and more.

Grow your business through customer feedback

Run polls on your website using PageSense to understand what your customers think about your products/services and what needs improvement on your site.

Send timely updates that customers love

Use web push notifications in PageSense to schedule and notify your customers about an upcoming flash sale, product releases, promotional coupons, and a lot more that can spark conversions on your website.

Advertise your business to website visitors

Use pop-ups in PageSense to instantly grab the attention of visitors by showing attractive signup offers, coupon code discounts, or email newsletters that can eventually convert them into subscribers.

Access more advanced settings in PageSense

Use PageSense's advanced features like creating mutually exclusive groups, enabling cross-domain tracking, configuring customized project JS, and more to get deeper insights about your website.

Try easy-to-use extensions

Download the PageSense extension app available for your web browser with a few clicks and start collecting all of your required website metrics in real time.

Discover your favorite integrations with PageSense

Get a deeper look at your website's data by seamlessly integrating PageSense with a host of popular third-party apps like Google Analytics, Mixpanel, Intercom, and more.

Quick Links	Workflow Automation	Data Collection
Web Forms	Enterprise	Begin Data Collection
Interactive Forms	Workplace	Data Collection App
Offline Forms	Customer Service	Accessible Forms
Digital Forms	Marketing	Forms for Small Business
HTML Forms	Education	Forms for Enterprise
Contact Forms	E-commerce	Forms for any business
Lead Generation Forms	Healthcare	Forms for Startups
Wordpress Forms	Customer onboarding	Order Forms for Small Business
No Code Forms	Construction
Free Forms	Travel
Prefill Forms	Non-Profit
Intake Forms	Legal
Form Designer	HR
Card Forms	Food
Assign Forms	Photography
Translate Forms	Real Estate
Electronic Forms
Notification Emails for Forms
Holiday Forms
Form to PDF
Email Forms CRM Forms Embeddable Forms Drag and Drop form builder HIPAA Forms Encrypted Forms

New to Zoho CRM Plus?

Deliver unforgettable customer experiences

ACCESS ZOHO CRM PLUS

New to Zoho CRM Plus?

Deliver unforgettable customer experiences

ACCESS ZOHO CRM PLUS

New to Zoho Marketing Plus?

Everything you need to run your marketing

ACCESS ZOHO MARKETING PLUS

New to Zoho Marketing Plus?

Everything you need to run your marketing

ACCESS ZOHO MARKETING PLUS

Zoho Pagesense Resources

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.

New to Zoho Survey?

Access Zoho Survey

Latest Feature Updates

Explore our Pricing & Plans

Zoho Survey Resources

Android Mobile Surveys

Insurvey Blogs

Insight Blogs

Tips & Tricks

New to Zoho Social?

Manage your brands on social media

Access Zoho Social

Zoho Desk Resources

Desk Community Learning Series
Digest
Functions
Meetups
Kbase
Resources
Glossary
Desk Marketplace
MVP Corner
Word of the Day

Zoho Sheet Resources

New to Zoho Forms?

Latest Feature Updates

Explore our Pricing & Plans

Zoho Forms Resources

Secure your business

communication with Zoho Mail

Get started

Mail on the move with

Zoho Mail mobile application

Go Mobile

Stay on top of your schedule

at all times

Get started

Carry your calendar with you

Anytime, anywhere

Get started

Latest Announcements

New to Zoho Sign?

Zoho Sign Resources

Sign, Paperless!

Sign and send business documents on the go!

Get Started Now

Zoho SalesIQ Resources

New to Zoho TeamInbox?

Zoho TeamInbox Resources

Connect with us

New to Zoho ZeptoMail?

LEARN MORE

Latest Feature Updates

Zoho DataPrep Resources

New to Zoho DataPrep?

Access Zoho DataPrep

Zoho DataPrep Demo

Get a personalized demo or POC

Design. Discuss. Deliver.

Create visually engaging stories with Zoho Show.

Get Started Now

New to Zoho Workerly?

Access Zoho Workerly

New to Zoho Recruit?

Access Zoho Recruit

New to Zoho CRM?

Signup Now

Access Zoho CRM

Latest Feature Updates

New to Zoho Projects?

Access Zoho Projects

New to Zoho Sprints?

Access Zoho Sprints

New to Zoho Assist?

Access Zoho Assist

New to Bigin?

Signup Now

Access Bigin

Latest Feature Updates

Related Articles
Import data from Google Cloud SQL
If you have stored your data stored in MySQL, PostgreSQL, or MS SQL Server database hosted in Google Cloud SQL, then you can easily import the data into Zoho Analytics. You can easily setup data import from the Google Cloud databases using the simple ...
Import data from Google Cloud SQL MySQL
If you have your data stored online in the Google Cloud SQL MySQL database, then you can seamlessly import your data into Zoho Analytics for reporting and analysis. Zoho Analytics allows you to either import the data into Zoho Analytics or connect ...
Import data from Google Cloud SQL PostgreSQL
If you have your data stored online in the Google Cloud SQL PostgresSQL database, then you can seamlessly import your data into Zoho Analytics for reporting and analysis. Zoho Analytics allows you to either import the data into Zoho Analytics or ...
Import data from Google Cloud SQL MS SQL Server
If you have your data stored in SQL Server hosted in Google Cloud SQL database, you can easily import the data into Zoho Analytics or connect live with the Google Cloud SQL MS SQL Server for advanced reporting and analysis. Data Import: Data from ...
Import data from Cloud Drive
Zoho Analytics allows you to import data from CSV, Excel (XLS and XLSX), JSON, HTML and zipped files stored on different Cloud Drive/Storage such as Google Drive, Dropbox, Box and OneDrive, for advanced reporting and analysis. You can also schedule ...