Import Data from Panoply Google BigQuery 

If you have your data stored in Panoply Google BigQuery Cloud Database, then you can easily import your data into Zoho Analytics to uncover insights. You can set up periodic schedules to fetch the latest data automatically from your Panoply Google BigQuery database.

Data Import

  1. How do I import data from the Panoply Google BigQuery database?
  2. How can I edit the setup?
  3. How long does it take for the data to be imported into Zoho Analytics?
  4. Can I import data from Views created in Panoply Google BigQuery (apart from Tables) into Zoho Analytics?
  5. Will foreign keys defined between my tables in the Panoply Google BigQuery database be linked in Zoho Analytics as well?
  6. Can I change the data type of the columns in Zoho Analytics?
  7. I have connected to a database and imported a few tables into Zoho Analytics. Can I add more tables from the same source to the existing connection?
  8. Can I import data from Panoply Google BigQuery database table into an existing table in Zoho Analytics?
  9. I have synced data from a database into a table. Can I change the data source of this table?
  10. Can I import data from my Panoply Google BigQuery database into an existing Zoho Analytics workspace?
  11. Can I synchronize the data from my Cloud Database instantly?
  12. The Last Data Sync Status in Datasources page shows Sync Failed. How do I resolve it?
  13. How do I remove the Setup?

Data Import

 1. How do I import data from the Panoply database?

2. How can I edit the setup?

You can modify the import setup like changing the sync settings or the data source anytime during your analysis.

Follow the below the steps to edit the connection setup.

  1. Open the workspace.
  2. Click the Data Sources tab from the left bar.
  3. All data sources for this workspace will be listed. Click the Panoply data source that you want to edit 
  4. The Data Sources page will open. Click the Edit Connection link.
  5. Make the required changes and click Save.

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

After setup, you might have to wait sometime for the initial fetch to happen. This depends upon the amount of data to be imported into Zoho Analytics and also the response time of your Panoply server. You will receive an email notification once the import is complete. Please note that, if you access the workspace before the initial fetch, it will not display any data.

4. Can I import data from Views created in Panoply (apart from Tables) into Zoho Analytics?

Yes, you can import data from Tables as well as Views available in your Panoply database into your Zoho Analytics workspace.

5. Will foreign keys defined between my tables in the Panoply database be linked in Zoho Analytics as well? 

When importing multiple tables, the foreign keys defined between the tables in the Panoply database will be linked in Zoho Analytics. The foreign keys will be created as Look-up columns in Zoho Analytics. 

If you import data from one table at a time (choosing single table option) then the foreign keys will not be defined. However, you can manually link the tables in Zoho Analytics using the Look-up column feature. Click here to learn about the Look-up column feature.

6. Can I change the data type of the columns imported in Zoho Analytics? 

Yes, you can change the data type of the columns imported into Zoho Analytics. However, it is necessary that the data type of your column is compatible with the data type of the column in your Panoply database for successful data synchronizations. It is always recommended that you change the data type in both your Panoply database as well as your Zoho Analytics workspace.

7. I have connected to a database and imported a few tables into Zoho Analytics. Can I add more tables from the same source to the existing connection?

Yes, you can add tables from the same source to the existing connection. Follow the below steps:

  1. From your Panoply workspace, navigate to Create > New Table / Import Data.
  2. Click the Cloud Databases option. The Connect to Cloud Database wizard will open.
  3. From the Connection name drop down menu, select the existing Panoply database name.
  4. The rest of the steps are similar to importing data from cloud database.

Note: In case you change the schedule interval while importing the tables, the same intervals will be applied to already imported tables as well.

8. Can I import data from Panoply database table into an existing table in Zoho Analytics?

Yes, you can import data into an existing table if you are importing from the same source database as the imported table. 

Follow the below steps to import if the source is available in the same Panoply database that is imported into the table. 

  1. From the required table, click Import Data > Import Data into this Table.
  2. Click Import Data Import into this Table.
  3. The Select Data to Import tab of the Import wizard will open. 
  4. You can choose to import from the same or a different table using the Select Table option or import using the Custom Query.
    ​ 

9. I have synced data from a database into a table. Can I change the data source of this table? 

Yes, you can change the data source of a table, into which the Panoply database has been synced. To do this,

  1. Open the workspace.
  2. Click the Data Sources tab from the left bar. 
  3. All the data sources for this workspace will be listed. Click the data source you want to edit.
  4. The Data Sources page will open. Click the Edit Connection link.
  5. In the Cloud Database - Edit Connection dialog that opens, modify the data source.
  6. Click Save to implement the changes made.

10. Can I import data from my Panoply database into an existing Zoho Analytics workspace?

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

  1. Open the workspace into which you wish to import the data.
  2. Navigate through Create > New Table / Import Data
  3. Click the Cloud Databases option.
  4. Configuring the import will be similar to the steps followed in this presentation.

Configuring the import will be similar to the steps followed in this presentation.

11. Can I synchronize the data from my Cloud Database instantly?  

Yes, you can synchronize your data from Cloud Database instantly when needed. 

To synchronize your data instantly:

  1. Open the required workspace.
  2. From the home page, click the Data Sources tab. 
  3. In the Data Sources page that opens, click the Sync Now link.

Note: This option can be used to a maximum of five times per day.

12. The Last Data Sync Status in Datasources page shows Sync Failed. How do I resolve it?

You can resolve your sync failure by understanding the reason behind the failure. There are two methods to know the reason for the sync failure:

Method 1:

  1. Open the required workspace.
  2. Click the Data Sources tab from the left bar. 
  3. All the data sources for this workspace will be listed. Click the data source that has failed to sync.
  4. The Data Sources page will open. Click the View Last Import Details icon that appears on mouse over of each table row. 
  5. The Import Details pop-up page will open. You will find the reason for your failure in the Details section. Take the necessary action based on the reason provided.​

You will find the reason for your failure in the Details section. Take the necessary action based on the reason provided.​

Method 2:

  1. Open the corresponding table.
  2. Navigate through Import Data > Last Import Details.
  3. The Import Details pop-up page will open. You will find the reason for your failure in the Details section. Take the necessary action based on the reason provided.​​

13. How do I remove the Setup?

To remove the setup,

  1. Open the required workspace.
  2. Click the Data Sources tab from the left bar.
  3. All the data sources for this workspace will be listed. Click the Panoply data source that you want to remove.
  4. In the Data Sources tab that opens, click the Settings icon inline to the data source name on the right.
  5. Click the Remove Data Source option from the drop-down menu.

Please note that the data source connection will be removed, but the tables and the data will be retained in the workspace. As the data source connection is removed, no further synchronization will happen.