Google Datastore

https://cloud.google.com/datastore/

Google Cloud Datastore is a highly scalable NoSQL database for your applications.

Installation

Required packages: python-datastore-sqlalchemy

Connection String

datastore://{project_id}/?database={database_id}

Authentication Methods

Service Account JSON

Supported Features

JOINsSubqueriesDynamic SchemaCatalog SupportDynamic CatalogSSH TunnelingQuery CancellationFile UploadUser ImpersonationCost EstimationSQL Validation

Feature Score: 73/201

Time Grains

Common Time Grains:

SECONDMINUTEHOURDAYWEEKMONTHQUARTERYEAR

Extended Time Grains:

FIVE_SECONDSTHIRTY_SECONDSFIVE_MINUTESTEN_MINUTESFIFTEEN_MINUTESTHIRTY_MINUTESHALF_HOURSIX_HOURSWEEK_STARTING_SUNDAYWEEK_STARTING_MONDAYWEEK_ENDING_SATURDAYWEEK_ENDING_SUNDAYQUARTER_YEAR

Extended Aggregate Functions

The base aggregates (SUM, COUNT, AVG, MIN, MAX, COUNT DISTINCT) are supported everywhere; these are opt-in per engine.

MEDIANSTDDEV_SAMPVAR_SAMP

Troubleshooting

Common error messages you may encounter when connecting to or querying Google Datastore, along with their causes and solutions.

Permissions1 error

Query4 errors

Notes

Create a Service Account via GCP console with access to datastore datasets.

Resources

Official Documentation

Help improve this documentation by editing the engine spec:

Edit datastore.py