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.