Amazon DynamoDB vs Google Cloud Bigtable

Amazon DynamoDB is a serverless, managed NoSQL database for applications that need single-digit millisecond performance at any scale, according to AWS. Users do not provision or patch database servers, and tables can scale automatically, including to zero in on-demand mode. Primary keys and global or local secondary indexes provide ways to query data. Global tables support multi-Region, multi-active operation; AWS says they are designed for up to 99.999% availability. The database also supports native vector search for similarity searches and agent memory use cases. Data is encrypted in transit and at rest by default, and IAM policies can restrict access to specific items and attributes. Point-in-time recovery provides continuous, per-second backups and restoration within a configured period of 1 to 35 days. A free tier is listed with 25 WCUs, 25 RCUs, and 25 GB of storage per Region and payer account, among other limits. On-demand capacity is billed per request consumed; provisioned capacity is billed for specified capacity even if usage is lower.

Google Cloud Bigtable is a managed, low-latency NoSQL database for machine learning, operational analytics, and user-facing applications. It stores structured, semi-structured, and unstructured data in key-value and wide-column formats. SQL querying includes an API with more than 200 functions and support for aggregations, windowing, geospatial and JSON processing, and vector search. Compute scales horizontally, and instances can span up to eight regions with automatic replication between clusters. Google says multi-region instances offer 99.999% availability and protection against a regional failure. Integrations listed include Apache Spark, Hadoop, GKE, Dataflow, Dataproc, Vertex AI Vector Search, BigQuery, and LangChain. Bigtable provides Apache HBase and Cassandra APIs, plus migration tools for HBase, Cassandra, DynamoDB, and Aerospike. Security controls include IAM, customer-managed encryption keys, audit logging, and table-, column-, or row-level access control. Deployment is cloud-based. Google describes its capacity-based low-latency compute as more favorable for larger workloads than small applications. A 10-day trial is available subject to eligibility requirements.