Systems and methods for computer-implemented ingestion and schema-governed validation of structured data files using executable metadata tokens

A computer-program product comprising a non-transitory machine-readable storage medium storing computer instructions that, when executed by one or more processors, perform operations comprising:

• receiving, via an application programming interface (API) server, an upload request comprising a logical table reference parameter and a structured data file;
• searching a table metadata repository for a table metadata schema corresponding to the logical table reference parameter, wherein a table description attribute of the table metadata schema specifies the logical table reference parameter;
• converting a plurality of data entries of the structured data file into a plurality of schema-conforming data records using the table metadata schema, wherein converting the plurality of data entries into the plurality of schema-conforming data records includes:
• extracting, from the table metadata schema, a plurality of column metadata definitions,
• identifying a plurality of source column headers of the structured data file that correspond to a plurality of source column identifiers specified in the plurality of column metadata definitions,
• parsing, from the plurality of data entries, a plurality of cell value sets associated with the plurality of source column headers,
• detecting a plurality of valid cell value sets from the plurality of cell value sets based on validation criteria defined in the plurality of column metadata definitions, and
• generating the plurality of schema-conforming data records by associating the plurality of valid cell value sets with a plurality of database columns that correspond to the plurality of source column identifiers in the plurality of column metadata definitions;
• and
• persisting the plurality of schema-conforming data records to a database table designated in the table metadata schema.