BigQuery introduces identity columns, a feature that automatically generates sequential 64-bit integer values for table rows, reducing the need to pre-calculate unique keys in application logic or ETL pipelines.

Users can define columns as GENERATED ALWAYS AS IDENTITY (fully automatic, no overrides) or GENERATED BY DEFAULT AS IDENTITY (automatic with allowance for manual insertion).

The feature integrates with standard DML operations like INSERT and MERGE, simplifying ingestion and reducing boilerplate SQL code.

Identity columns are set up directly in CREATE TABLE statements using familiar SQL syntax.

This announcement positions the feature as a built-in mechanism for surrogate key generation, aimed at building scalable and maintainable data architectures on BigQuery.

No external benchmarks or comparisons were provided.