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 feature, and displays four widgets that show the status of your uploaded data.
This widget shows the status of your connection:
- Average response time (ms)
- Maximum response time (ms)
Slowest tables & views
This widget indicates if there is a slow table or view, by showing the following:
- Table/view name
- Number of queries
- Average response time (sec)
In this widget you can check your database usage:
- The size of your database (including the size of the indices)
- The number of rows
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.
Import statistics: Data import
Here you can check the imports:
- API imports (the error rate, the number of uploaded and affected rows)
- SFTP imports (the error rate, the number of uploaded and affected rows)
Data quality page has a collapsible menu on the left, which lets you see the following pages:
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.