To open the Relational Data page, go to Add-ons > Relational Data.
The following tabs help you troubleshoot your Relational Data connections
The Relational Data Dashboard
The dashboard is the starting page of the Relational Data, and displays four widgets that show the status of your uploaded data.
- Personalization health widget
- Slowest tables & views widget
- Database size widget - This widget is only visible for clients using Emarsys-hosted databases. Learn more.
- Data import widget - This widget is only visible for clients using Emarsys-hosted databases. Learn more.
Personalization health widget
This widget shows the status of your connection:
- Average response time (ms)
- Maximum response time (ms)
Click Go to Personalization Health to open Personalization health tab, under Data quality.
Slowest tables & views widget
This widget indicates if there is a slow table or view, by showing the following:
- Table/view name
- Connection name
- Number of queries
- Average response time (ms): A warning icon is displayed for connections with a slow average or a max response time.
Click Go to Tables and Views to open Tables & Views tab.
Database size widget
This widget is only visible for clients using Emarsys-hosted databases. Learn more.
In this widget you can check your database usage:
- The total size of your database (including the size of the indices):
- Data size
- Index size
The Total Database Size is the amount of the Index Size plus the Data Size values. These charts are stacked on top of each other to give the Total Database Size and display the combined total of data used.
Data import widget
This widget is only visible for clients using Emarsys-hosted databases. Learn more.
Here you can select the API or SFTP Import data
- API imports (the error rate, the number of uploaded and affected rows)
- SFTP imports (the error rate, the number of uploaded and affected rows)
- The following data points are displayed: successful imports, failed requests, and total sent requests, and total rows affected in the database.
Click Go to API Errors to open API errors under the Data quality tab.
Data quality
Data quality page has a collapsible menu on the left, which lets you see the following pages:
Import history
The Import history menu is only visible for clients using Emarsys-hosted databases. Learn more.
As an extension of the troubleshooting dashboard, this tab provides further information on the status of your SFTP uploads. The following information is available:
- Time of import
- File name
- Rows in file
- Rows affected
- Duration of import
- Status (Pending, Successful, Failed)
- Operation (Append, Replace, Upsert)
- Table (name of the table where the data will be loaded)
API errors
This tab provides information about the API errors that might have occurred during the upload:
- Event time
- Table name
- Operation (Insert, Upsert, Replace, Update, Delete, Search, Unknown)
- Error code (all error codes are available here)
- Error message
- View packet - click this button to check the fault request body.
Personalization health
This tab shows you all tables and views used for personalization, showing the connection name, average response time, and the slowest response time.
Personalization health graphs
Click the graph icon on the right to drill down into any table or view to get a performance trend over time from the logged response times.
For troubleshooting purposes the view can be toggled from Daily to Hourly to help narrow down any spikes or issues. This drill down gives you the last 90 days of data to work with, and can be adjusted to focus on any particular scope within that timeframe.
