Automatic data linting rules for etl pipelines

A non-transitory, tangible computer readable medium having instructions stored thereon that, when executed by at least one computing device, causes the at least one computing device to perform operations comprising:

• extracting a schema from a data format associated with a data type included in a database;
• generating a first ruleset from the schema to correspond to the data format associated with the data type;
• generating a second ruleset from a representative data sample which is representative of the schema;
• creating a combined ruleset from the first ruleset and the second ruleset;
• and
• applying the combined ruleset to the database to create a transformed database.

A data linting device comprising:

• a transceiver configured to send and receive signals;
• and
• one or more processors configured to:
• receive a request via the transceiver that requests creation of a ruleset based on a database;
• extracting a schema from a data format associated with a data type included in the database;
• generating a first ruleset from the schema to correspond to the data format associated with the data type;
• generating a second ruleset from a representative data sample which is representative of the schema;
• creating a combined ruleset from the first ruleset and the second ruleset;
• and
• applying the combined ruleset to the database to create a transformed database.