How to reset the log_action table export in the Data Warehouse Connector

The Data Warehouse Connector in Matomo enables you to export raw analytics data to external systems for advanced querying and reporting. While most tables in the export process include timestamp information, the log_action table does not. Instead, it uses the idaction primary key to determine export batches.

Because of this structural difference, the log_action table is handled uniquely within the export system. If you’re exporting data from one or more sites and have already completed a full export of the log_action table, you can perform a full or partial reset of the export process.

Note: The log_action table is exported in full for each site when it is first configured and enabled in Matomo. A reset is only necessary if earlier exports were not synced, for example during testing or initial configuration as the exported data is automatically deleted after 14 days.

Reset options for the log_action table export

1. Go to Matomo settings (Administration) > Export > Data Warehouse Connector.
2. Click on Sync Settings.
3. Full Reset:
   • To re-export the entire log_action table, set the Type of reset as Full.
   • Click Reset Log Action Sync.
   • On the next sync (depending on batch size), the log_action table will be re-exported from the minimum idaction to the maximum ID currently in the table.
4. Partial Reset:
   • To export only a subset of the log_action table: set the Type of reset as Partial.
   • Provide an idaction value as the upper limit.
   • On the next sync, the log_action table will be exported from the minimum ID available in the database up to (but not including) the specified idaction.
     

Important Notes

• You can only trigger a reset after a full sync of log_action has completed.
• If a sync is still in progress and you attempt a reset, an error message will indicate that a sync is still underway.
• If no export metadata exists for the log_action table i.e. no previous export has been started or completed, attempting a reset will result in an error message explaining the current state.