Indexing Google Professional Data Engineer GCP

  1. Home
  2. Indexing Google Professional Data Engineer GCP

An index is

  • defined on a list of properties of a given entity kind,
  • a order (ascending or descending) for each property is also defined
  • Indexes – Created on every category which is not null
  • Secondary and composite indexes – done using multiple fields
  • by default, 1 index per column is created,
  • restrictions with combining multiple columns.
  • To use multiple columns as indexes, we need to create composite indexes.
  • Creating composite index:
    • Create index.yaml:
    • Create index:
    • gcloud datastore create-indexes index.yaml


An index table

  • contains a column for every property named in the index’s definition.
  • Each row represents an entity with a potential result for queries based on the index.