logo

How to create composite index in Datastore | GCP

gcptutorials.com GCP

Cloud Datastore is a highly-scalable NoSQL database for web and mobile applications. For writing complex queries in Datastore composite indexes are required. Follow this tutorial for creating composite indexes with cloud shell.

This tutorial assumes you have below kind and properties already available in Datastore

  • A kind with the name of post
  • In kind post, entities with property name url, title, date-posted.

    • Login to Google Cloud Console

    Click Activate Cloud Shell to open Cloud Shell.

    Create a file index.yaml

    
nano index.yaml

    For creating composite index on all three properties, write below code in index.yaml 

    
indexes:

- kind: post
  ancestor: no
  properties:
  - name: url
  - name: title
  - name: date-posted

    Create composite index with gcloud

    
gcloud datastore indexes create index.yaml

    Above command will ask for confirmation , check listed configurations and confirm, successful execution should display created index in Indexes section of Datastore UI.

    Category: GCP