spanner-provisioning

Spanner edition selection depends on schema features like graph or vector index usage, requiring Enterprise. Compute capacity requires 100 processing units minimum for dev/test, while production starts at 1000 processing units with autoscaling guidance.

To apply Spanner DDL idempotently, verify if key objects exist by querying INFORMATION_SCHEMA.TABLES before applying DDL. Use ALTER statements for updates to existing schema objects, and drop and recreate objects only for a full schema reset.

The minimum Spanner compute capacity for development and testing environments is 100 processing units. Production environments require a higher starting capacity of 1000 processing units, with additional autoscaling guidance available as needed.

Select Spanner Enterprise edition instead of Standard when your database schema requires advanced features such as graph or vector index usage. Standard edition is suitable for workloads that do not depend on these specific schema capabilities.

Spanner provisioning supports schema updates by using ALTER statements to modify existing objects. Before applying any DDL, the process verifies existing schema objects through INFORMATION_SCHEMA queries to ensure safe, idempotent updates without duplicates.