Goal
Implement the mechanism to create a flattened cache table in the database when an export is run, named after the sanitized mapping name (e.g., dwc_fish).
Background
The cache table enables post-processing pipelines and mirrors the Specify 6 approach. The table must be created or replaced and include a primary key column.
Acceptance Criteria
Goal
Implement the mechanism to create a flattened cache table in the database when an export is run, named after the sanitized mapping name (e.g.,
dwc_fish).Background
The cache table enables post-processing pipelines and mirrors the Specify 6 approach. The table must be created or replaced and include a primary key column.
Acceptance Criteria
{MappingName}(sanitized for MariaDB identifiers) is created in the database.<table>Id).INSERT … SELECTorLOAD DATA INFILE).