Did you know that with Bigtable's continuous materialized views you can build
Bigtable
Scale your latency-sensitive applications with the NoSQL pioneer
Low-latency, Cassandra, and HBase-compatible NoSQL database service for machine learning, operational analytics, and user-facing applications.
New customers get $300 in free credits to spend on Bigtable.
Features
Low latency and high throughput
Bigtable is a key-value and wide-column store ideal for fast access to structured, semi-structured, or unstructured data. This makes latency-sensitive workloads like personalization a perfect fit for Bigtable.
Distributed counters and high read and write throughput per dollar makes it also a great fit for clickstream and IoT use cases, and even batch analytics for high-performance computing (HPC) applications, including training ML models.
Write and read scalability with no limits
Bigtable decouples compute resources from data storage, which makes it possible to transparently adjust processing resources. Each additional node can process reads and writes equally well, providing effortless horizontal scalability. Bigtable optimizes performance by automatically scaling resources to adapt to server traffic, handling the sharding, replication, and query processing.
SQL and continuous materialized views
Bigtable SQL empowers users to build fully-managed, real-time applications using familiar SQL syntax, with specialized features that preserve Bigtable's flexible schema. You can also use the SQL interface to build incremental materialized views that simplify the creation of real-time metrics. A Bigtable materialized view will automatically keep data up to date by processing the changes as they arrive without impacting your write and read performance and scales automatically in response to the traffic.
Data model flexibility
Bigtable lets your data model evolve organically. Store anything from scalars, JSON, Protocol Buffers, Avro, Arrow to embeddings, images, and dynamically add/remove new columns as needed. Deliver low-latency serving or high-performance batch analytics over raw, unstructured data in a single database.
Easy migration from NoSQL databases
Bigtable offers Apache Cassandra and HBase APIs and migration tooling that enables faster and simpler onboarding by ensuring accurate data migration with reduced effort. HBase Bigtable replication library and Cassandra Proxy allow for no-downtime live migrations while Bigtable Data Bridge simplifies migrations from Amazon DynamoDB.
From a single zone up to eight regions at once
Apps backed by Bigtable can deliver low-latency reads and writes with globally distributed multi-primary configurations, no matter where your users may be. Zonal instances are great for cost savings and can be seamlessly scaled up to multi-region deployments with automatic replication. When running a multi-region instance, your database is protected against a regional failure and offers industry-leading 99.999% availability.
High-performance, workload-isolated data processing
Bigtable Data Boost enables users to run analytical queries, batch ETL processes, train ML models, or export data faster without affecting transactional workloads. Data Boost does not require capacity planning or management. It allows directly querying data stored in Google’s distributed storage system, Colossus using on-demand capacity letting users easily handle mixed workloads and share data worry-free.
Rich application and tool support
Easily connect to the open source ecosystem with the Apache HBase API. Build data-driven applications faster with seamless integrations with Apache Spark , Hadoop , GKE , Dataflow , Dataproc , Vertex AI Vector Search , and BigQuery . Meet development teams where they are with SQL and client libraries for Java, Go, Python, C#, Node.js, PHP, Ruby, C++, HBase , and integration with LangChain .
No IOPS charges, no cost for taking or restoring backups, no disproportionate read/write pricing to impact your budget as your workloads evolve.
Real-time change data capture and eventing
Use Bigtable change streams to capture change data from Bigtable databases and integrate it with other systems for analytics, event triggering, and compliance.
Enterprise-grade security and controls
Customer-managed encryption keys (CMEK) with Cloud External Key Manager support, IAM integration for access and controls, support for VPC-SC, Access Transparency, Access Approval, and comprehensive audit logging help ensure your data is protected and complies with regulations. Fine-grained access control lets you authorize access at table, column, or row level.
Observability
Monitor performance of Bigtable databases with server-side metrics . Analyze usage patterns with Key Visualizer interactive monitoring tool. Use query stats , table stats , and the hot tablets tool for troubleshooting query performance issues and quickly diagnose latency issues with client-side monitoring .
Disaster recovery
Take instant, incremental backups of your database cost-effectively and restore on demand. Store backups in different regions for additional resilience, easily restore between instances, or projects for test versus production scenarios.
Vertex AI Vector Search integration
Use the Bigtable to Vertex AI Vector Search template to index data in your Bigtable database with Vertex AI to perform a similarity search over vector embeddings with Vertex AI Vector Search .
LangChain integration
Easily build generative AI applications that are more accurate, transparent, and reliable with built-in kNN nearest neighbor vector search (in Preview) and LangChain integration. Visit the GitHub repository to learn more.
How It Works
Bigtable instances provide compute and storage in one or more regions. Each Bigtable cluster can receive both reads and writes. Data is automatically "split" for scalability and replicated between clusters asynchronously. A distributed clock called TrueTime guarantees transactions are correctly ordered.
Bigtable instances provide compute and storage in one or more regions. Each Bigtable cluster can receive both reads and writes. Data is automatically "split" for scalability and replicated between clusters asynchronously. A distributed clock called TrueTime guarantees transactions are correctly ordered.
Common Uses
Real-time analytics
Increase data freshness and reduce query latency
- every movement of the ball and every player in real-time with Bigtable
MLB captures
Learn how to build a real-time analytics platform with
Learn how to use the Apache Beam Enrichment transform to
Learning resources
Increase data freshness and reduce query latency
- every movement of the ball and every player in real-time with Bigtable
MLB captures
Learn how to build a real-time analytics platform with
Learn how to use the Apache Beam Enrichment transform to
AdTech and retail
Personalize experiences in real time
- ad personalization with Bigtable
How Google scales
Home Depot delivers
OpenX serves over
Learning resources
Personalize experiences in real time
- ad personalization with Bigtable
How Google scales
Home Depot delivers
OpenX serves over
Data fabric and operational analytics
Consolidate data silos and scale out legacy systems
- data fabric converts data silos into data products with Bigtable
Equifax’s
Macy’s
Reltio’s
Learning resources
Consolidate data silos and scale out legacy systems
- data fabric converts data silos into data products with Bigtable
Equifax’s
Macy’s
Reltio’s
Cybersecurity
Detect malware, payment fraud, stop spam and scams
- fraud detection with Bigtable
Ravelin scales
Learn how Sift
How Stairwell built an
Learning resources
Detect malware, payment fraud, stop spam and scams
- fraud detection with Bigtable
Ravelin scales
Learn how Sift
How Stairwell built an
Media
Deliver media content and engagement analytics
- YouTube data warehouse relies on Bigtable
How
Bigtable powers Twitter’s
Spotify serves
Learning resources
Deliver media content and engagement analytics
- YouTube data warehouse relies on Bigtable
How
Bigtable powers Twitter’s
Spotify serves
Time series and IoT
Manage time series data at any scale
Ecobee improved performance by 10x by migrating
MLB captures
Learning resources
Manage time series data at any scale
Ecobee improved performance by 10x by migrating
MLB captures
Machine learning infrastructure
Scale model training and serving
Credit Karma uses Bigtable to make
How Go-Jek uses Bigtable as their
Learn how to use Bigtable with popular open-source feature stores .
Learning resources
Scale model training and serving
Credit Karma uses Bigtable to make
How Go-Jek uses Bigtable as their
Learn how to use Bigtable with popular open-source feature stores .
Pricing
Compute capacity
Compute capacity is provisioned as nodes.
Starting at
$0.65
per node per hour
Data Boost
On-demand, isolated compute resources for batch processing
Starting at
$0.000845
per serverless processing unit per hour
Data storage
SSD
Pricing is based on the physical size of tables. Each replica is billed separately. Recommended for low-latency serving.
Starting at
$0.17
per GB per month
HDD
Pricing is based on the physical size of tables. Each replica is billed separately.
Starting at
$0.026
per GB per month
Backups
Pricing is based on the physical size of backups. Bigtable backups are incremental.
Starting at
$0.026
per GB per month
Network
Ingress
Free
Egress within same region
Free
Egress between regions
Starting at
$0.10
per GB
Replication
Within same region
Free
Between regions
Starting at
$0.01
per GB
Learn more about Bigtable pricing and committed use discounts .
How Bigtable pricing works
Bigtable pricing is based on compute capacity, database storage, backup storage, and network usage. Committed use discounts reduce the price further.
Compute capacity
Compute capacity is provisioned as nodes.
Starting at
$0.65
per node per hour
Data Boost
On-demand, isolated compute resources for batch processing
Starting at
$0.000845
per serverless processing unit per hour
Data storage
SSD
Pricing is based on the physical size of tables. Each replica is billed separately. Recommended for low-latency serving.
Starting at
$0.17
per GB per month
HDD
Pricing is based on the physical size of tables. Each replica is billed separately.
Starting at
$0.026
per GB per month
Backups
Pricing is based on the physical size of backups. Bigtable backups are incremental.
Starting at
$0.026
per GB per month
Network
Ingress
Free
Egress within same region
Free
Egress between regions
Starting at
$0.10
per GB
Replication
Within same region
Free
Between regions
Starting at
$0.01
per GB
Learn more about Bigtable pricing and committed use discounts .
Business Case
Explore how other businesses built innovative apps to deliver great customer experiences, cut costs, and increase ROI with Bigtable
Explore how Box modernized their NoSQL databases with Bigtable
Box enhanced scalability and availability while reducing cost to manage, through a seamless migration.
Benefits and customers
Grow your business with innovative applications that scale limitlessly to meet any demand.
Get best-in-class price-performance and pay for what you use.
Migrate easily from other NoSQL databases and run hybrid or multicloud deployments with open source APIs and migration tools.
Partners & Integration
Take advantage of partners with Bigtable expertise to help you at every step of the journey, from assessments and business cases to migrations and building new apps on Bigtable.
System integrators
Want to get more details about which partner or third-party integration is best for your business? Go to the partner directory .
FAQ
What type of database is Bigtable?
Bigtable is a NoSQL database service, specifically a key-value store that allows for very wide tables with tens of thousands of columns, hence also referred to as a wide-column database or a distributed multi-dimensional map. Bigtable is a NoSQL database in the "Not only SQL" sense, rather than "zero SQL." It supports many capabilities beyond key-value lookups including aggregations and global secondary indexes.
Bigtable is most similar to popular open source projects it inspired, such as Apache HBase and Cassandra, and hence is the most common destination for customers that deal with large data volumes looking for a high-performance, cost-effective, fully managed NoSQL database solution on Google Cloud.
Does Bigtable support SQL?
In addition to its key-value APIs, Bigtable also supports SQL queries in three different ways:
- For low-latency application development, Bigtable offers a SQL query API that builds upon GoogleSQL with extensions for the wide-column data model resembling Cassandra Query Language (CQL). It supports 100+ functions including aggregations (GROUP BY), JSON processing functions and vector search (kNN).
- For data science use cases or other kinds of batch processing and ETL, Bigtable supports SparkSQL using its Spark client .
- For users who want to do post-hoc exploratory analysis or blend data from multiple sources for batch analytics, Bigtable data can also be accessed from BigQuery. Simply register your Bigtable tables in BigQuery and query like any other BigQuery table without any ETL or data duplication.
How do I migrate databases to Bigtable?
Bigtable offers Apache Cassandra and HBase APIs and migration tooling that enables faster and simpler onboarding by ensuring accurate data migration with reduced effort. Bigtable’s HBase replication library and Cassandra migration tools allow for no-downtime, live migrations. Bigtable also offers utilities to simplify migrations from DynamoDB.
Is Bigtable serverless?
Bigtable storage is billed per GB used similar to a serverless model. Bigtable also offers linear horizontal scaling and can automatically scale up and down compute resources in response to demand fluctuations. Hence it doesn’t require a long term capacity commitment for storage or compute. However, pricing for low-latency compute is capacity-based and billed per node, not per request where each node can serve up to 17K requests per second. This makes Bigtable price more favorable for larger workloads but less ideal for small applications, which may be more suitable for Google Cloud databases such as Firestore .
For batch data processing Bigtable offers Data Boost , which bills in Serverless Processing Units (SPU).
- Accelerate your digital transformation
- Whether your business is early in its journey or well on its way to digital transformation, Google Cloud can help solve your toughest challenges.
- Key benefits
- Featured Products
- AI and Machine Learning
- Business Intelligence
- Compute
- Containers
- Data Analytics
- Databases
- Developer Tools
- Distributed Cloud
- Hybrid and Multicloud
- Industry Specific
- Integration Services
- Management Tools
- Maps and Geospatial
- Media Services
- Migration
- Mixed Reality
- Networking
- Operations
- Productivity and Collaboration
- Security and Identity
- Serverless
- Storage
- Web3
- Featured Products
- Not seeing what you're looking for?
- See all products (100+)
- Not seeing what you're looking for?
- See all AI and machine learning products
- Business Intelligence
- Not seeing what you're looking for?
- See all compute products
- Not seeing what you're looking for?
- See all data analytics products
- Not seeing what you're looking for?
- See all developer tools
- Hybrid and Multicloud
- Industry Specific
- Not seeing what you're looking for?
- See all management tools
- Media Services
- Not seeing what you're looking for?
- See all networking products
- Productivity and Collaboration
- Not seeing what you're looking for?
- See all security and identity products
- Save money with our transparent approach to pricing
- Google Cloud's pay-as-you-go pricing offers automatic savings based on monthly usage and discounted rates for prepaid resources. Contact us today to get a quote.
- Pricing overview and tools
- Product-specific Pricing
- Learn & build
- Connect
- Accelerate your digital transformation
- Learn more
- Key benefits
- Why Google Cloud
- AI and ML
- Multicloud
- Global infrastructure
- Data Cloud
- Modern Infrastructure Cloud
- Security
- Productivity and collaboration
- Reports and insights
- Executive insights
- Analyst reports
- Whitepapers
- Customer stories
- Industry Solutions
- Retail
- Consumer Packaged Goods
- Financial Services
- Healthcare and Life Sciences
- Media and Entertainment
- Telecommunications
- Games
- Manufacturing
- Supply Chain and Logistics
- Government
- Education
- See all industry solutions
- See all solutions
- Application Modernization
- CAMP
- Modernize Traditional Applications
- Migrate from PaaS: Cloud Foundry, Openshift
- Migrate from Mainframe
- Modernize Software Delivery
- DevOps Best Practices
- SRE Principles
- Day 2 Operations for GKE
- FinOps and Optimization of GKE
- Run Applications at the Edge
- Architect for Multicloud
- Go Serverless
- Artificial Intelligence
- Customer Engagement Suite with Google AI
- Document AI
- Vertex AI Search for retail
- Gemini for Google Cloud
- Generative AI on Google Cloud
- APIs and Applications
- New Business Channels Using APIs
- Unlocking Legacy Applications Using APIs
- Open Banking APIx
- Data Analytics
- Data Migration
- Data Lake Modernization
- Stream Analytics
- Marketing Analytics
- Datasets
- Business Intelligence
- AI for Data Analytics
- Databases
- Database Migration
- Database Modernization
- Databases for Games
- Google Cloud Databases
- Migrate Oracle workloads to Google Cloud
- Open Source Databases
- SQL Server on Google Cloud
- Gemini for Databases
- Infrastructure Modernization
- Application Migration
- SAP on Google Cloud
- High Performance Computing
- Windows on Google Cloud
- Data Center Migration
- Active Assist
- Virtual Desktops
- Rapid Migration and Modernization Program
- Backup and Disaster Recovery
- Red Hat on Google Cloud
- Cross-Cloud Network
- Observability
- Productivity and Collaboration
- Google Workspace
- Google Workspace Essentials
- Cloud Identity
- Chrome Enterprise
- Security
- Security Analytics and Operations
- Web App and API Protection
- Security and Resilience Framework
- Risk and compliance as code (RCaC)
- Software Supply Chain Security
- Security Foundation
- Google Cloud Cybershield™
- Startups and SMB
- Startup Program
- Small and Medium Business
- Software as a Service
- Featured Products
- Compute Engine
- Cloud Storage
- BigQuery
- Cloud Run
- Google Kubernetes Engine
- Vertex AI
- Looker
- Apigee API Management
- Cloud SQL
- Gemini
- Cloud CDN
- See all products (100+)
- AI and Machine Learning
- Vertex AI Platform
- Vertex AI Studio
- Vertex AI Agent Builder
- Conversational Agents
- Vertex AI Search
- Speech-to-Text
- Text-to-Speech
- Translation AI
- Document AI
- Vision AI
- Contact Center as a Service
- See all AI and machine learning products
- Business Intelligence
- Looker
- Looker Studio
- Compute
- Compute Engine
- App Engine
- Cloud GPUs
- Migrate to Virtual Machines
- Spot VMs
- Batch
- Sole-Tenant Nodes
- Bare Metal
- Recommender
- VMware Engine
- Cloud Run
- See all compute products
- Containers
- Google Kubernetes Engine
- Cloud Run
- Cloud Build
- Artifact Registry
- Cloud Code
- Cloud Deploy
- Migrate to Containers
- Deep Learning Containers
- Knative
- Data Analytics
- BigQuery
- Looker
- Dataflow
- Pub/Sub
- Dataproc
- Cloud Data Fusion
- Cloud Composer
- BigLake
- Dataplex
- Dataform
- Analytics Hub
- See all data analytics products
- Databases
- AlloyDB for PostgreSQL
- Cloud SQL
- Firestore
- Spanner
- Bigtable
- Datastream
- Database Migration Service
- Bare Metal Solution
- Memorystore
- Developer Tools
- Artifact Registry
- Cloud Code
- Cloud Build
- Cloud Deploy
- Cloud Deployment Manager
- Cloud SDK
- Cloud Scheduler
- Cloud Source Repositories
- Infrastructure Manager
- Cloud Workstations
- Gemini Code Assist
- See all developer tools
- Distributed Cloud
- Google Distributed Cloud Connected
- Google Distributed Cloud Air-gapped
- Hybrid and Multicloud
- Google Kubernetes Engine
- Apigee API Management
- Migrate to Containers
- Cloud Build
- Observability
- Cloud Service Mesh
- Google Distributed Cloud
- Industry Specific
- Anti Money Laundering AI
- Cloud Healthcare API
- Device Connect for Fitbit
- Telecom Network Automation
- Telecom Data Fabric
- Telecom Subscriber Insights
- Spectrum Access System (SAS)
- Integration Services
- Application Integration
- Workflows
- Apigee API Management
- Cloud Tasks
- Cloud Scheduler
- Dataproc
- Cloud Data Fusion
- Cloud Composer
- Pub/Sub
- Eventarc
- Management Tools
- Cloud Shell
- Cloud console
- Cloud Endpoints
- Cloud IAM
- Cloud APIs
- Service Catalog
- Cost Management
- Observability
- Carbon Footprint
- Config Connector
- Active Assist
- See all management tools
- Maps and Geospatial
- Earth Engine
- Google Maps Platform
- Media Services
- Cloud CDN
- Live Stream API
- OpenCue
- Transcoder API
- Video Stitcher API
- Migration
- Migration Center
- Application Migration
- Migrate to Virtual Machines
- Cloud Foundation Toolkit
- Database Migration Service
- Migrate to Containers
- BigQuery Data Transfer Service
- Rapid Migration and Modernization Program
- Transfer Appliance
- Storage Transfer Service
- VMware Engine
- Mixed Reality
- Immersive Stream for XR
- Networking
- Cloud Armor
- Cloud CDN and Media CDN
- Cloud DNS
- Cloud Load Balancing
- Cloud NAT
- Cloud Connectivity
- Network Connectivity Center
- Network Intelligence Center
- Network Service Tiers
- Virtual Private Cloud
- Private Service Connect
- See all networking products
- Operations
- Cloud Logging
- Cloud Monitoring
- Error Reporting
- Managed Service for Prometheus
- Cloud Trace
- Cloud Profiler
- Cloud Quotas
- Productivity and Collaboration
- AppSheet
- AppSheet Automation
- Google Workspace
- Google Workspace Essentials
- Gemini for Workspace
- Cloud Identity
- Chrome Enterprise
- Security and Identity
- Cloud IAM
- Sensitive Data Protection
- Mandiant Managed Defense
- Google Threat Intelligence
- Security Command Center
- Cloud Key Management
- Mandiant Incident Response
- Chrome Enterprise Premium
- Assured Workloads
- Google Security Operations
- Mandiant Consulting
- See all security and identity products
- Serverless
- Cloud Run
- Cloud Functions
- App Engine
- Workflows
- API Gateway
- Storage
- Cloud Storage
- Block Storage
- Filestore
- Persistent Disk
- Cloud Storage for Firebase
- Local SSD
- Storage Transfer Service
- Parallelstore
- Google Cloud NetApp Volumes
- Backup and DR Service
- Web3
- Blockchain Node Engine
- Blockchain RPC
- Save money with our transparent approach to pricing
- Request a quote
- Pricing overview and tools
- Google Cloud pricing
- Pricing calculator
- Google Cloud free tier
- Cost optimization framework
- Cost management tools
- Product-specific Pricing
- Compute Engine
- Cloud SQL
- Google Kubernetes Engine
- Cloud Storage
- BigQuery
- See full price list with 100+ products
- Learn & build
- Google Cloud Free Program
- Solution Generator
- Quickstarts
- Blog
- Learning Hub
- Google Cloud certification
- Cloud computing basics
- Cloud Architecture Center
- Connect
- Innovators
- Developer Center
- Events and webinars
- Google Cloud Community
- Consulting and Partners
- Google Cloud Consulting
- Google Cloud Marketplace
- Google Cloud partners
- Become a partner
