schemaValidation property

String? schemaValidation
getter/setter pair

Configure how much PostgreSQL schema validation to perform against the live database before deploying the FDC schema.

Optional. Possible string values are:

  • "SQL_SCHEMA_VALIDATION_UNSPECIFIED" : Unspecified SQL schema validation. Defaults to STRICT.
  • "NONE" : Skips SQL schema validation. Deployment succeeds even if the database is pending provisioning, unavailable, or incompatible. Under NONE, newly created services route requests to a temporary ephemeral database (in-memory emulation) so the API can be tested immediately. Ephemeral data expires after 24 hours unless successfully validated or migrated to a linked database.
  • "STRICT" : Connects to the SQL database and validates that the SQL DDL matches the FDC schema exactly. Any discrepancies (extra or missing tables/columns) result in a FAILED_PRECONDITION error with required SQL diffs. Recommended for greenfield projects to ensure full schema consistency.
  • "COMPATIBLE" : Connects to the SQL database and validates that it contains all the SQL resources required by the FDC schema. Succeeds even if the database contains additional tables or columns not used by FDC. Suitable when sharing a database with other tools or legacy applications.

Implementation

core.String? schemaValidation;