To open the Relational Data page, go to Add-ons > Relational Data.
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
This widget shows the status of your connection:
- Average response time (ms)
- Maximum response time (ms)
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
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
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.
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)
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.
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.