Importing data from Singlestore

If you have your data stored in the Singlestore cloud database, you can import the data into Analytics Plus easily for advanced reporting and analysis. Analytics Plus allows you to set up periodic schedules to fetch the latest data automatically from the cloud database.

Data import

1. Why should I allowlist Analytics Plus' IP addresses and how do I do it?
2. How do I import data from the Singlestore database into Analytics Plus?
3. How do I edit the data import configuration?
4. How long does it take for the Singlestore data to be imported?
5. Will foreign keys defined between the tables in the Singlestore database be linked in Analytics Plus as well?
6. Is it possible to change the data type of the columns imported into Analytics Plus?
7. How do I schedule data import?
8. How do I get notified of import failures?
9. Can I import data from the Singlestore database into an existing workspace in Analytics Plus?
10. Can I synchronize data from the Singlestore database instantly?
11. How do I resolve synchronization failure?
12. How do I remove the Singlestore data source?

1. Why should I allowlist Analytics Plus' IP addresses and how do I do it?

Click here to view the entire list of IP addresses that needs to be allowlisted categorized based on different data centers.

2. How do I import data from the Singlestore database into Analytics Plus?

3. How do I edit the data import configuration?

4. How long does it take for the Singlestore data to be imported?

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.

5. Will foreign keys defined between the tables in the Singlestore database be linked in Analytics Plus as well?

When importing multiple tables, the foreign keys defined between the tables in the cloud database will be linked in Analytics Plus 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 Analytics Plus using the lookup column functionality. To learn more about lookup columns, click here.

6. Is it possible to change the data type of the columns imported into Analytics Plus?

Yes. To learn more about changing the column type in Analytics Plus, click here.

Note: While changing the column's data type in Analytics Plus, ensure that it is compatible with the column's data type in the cloud database, for successful data synchronization.

7. How do I schedule data import?

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

• Select the Data Sources option from the side panel, and navigate to the required Singlestore 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 Singlestore database will be imported into Analytics Plus at the specified intervals.

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

8. How do I get notified of import failures?

Analytics Plus 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 Singlestore 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 process. Refer this presentation to know more.

9. Can I import data from the Singlestore database into an existing workspace in Analytics Plus?

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.

10. Can I synchronize data from the Singlestore 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 Singlestore data source and click the Sync Now link.

11. How do I resolve synchronization failure?

To resolve synchronization failure, you need to understand the reason behind the failure. For 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.

12. How do I remove the Singlestore 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 Analytics Plus. However, further synchronization cannot be carried out.