What does the "Verify" button do in a Data Store?

The "Verify" button in a Data Store serves the specific purpose of comparing the Data Store Entities to the underlying RDBMS (Relational Database Management System) structure. This functionality ensures that the configuration of the Data Store matches the actual structure of the database, which includes table names, column names, data types, and relationships.

When the verification process is run, it identifies any discrepancies between the Data Store entities and the actual database schema. This is crucial for maintaining data integrity and ensuring that any queries or operations that depend on this configuration function correctly. Proper alignment between the Data Store and the RDBMS structure helps prevent runtime errors and supports the smooth operation of applications built on the Appian platform.

This capability is distinct from simply checking for data validity, allowing for query execution, or saving the Data Store configuration, as those tasks are managed through different mechanisms within the Appian environment.