This lab walks you through BigTable, and how it is different from BigQuery.
You will be creating a BigTable Cluster and Table.
Duration: 60 minutes
Bigtable is a distributed database that runs on clusters for applications that has massive data. Its mainly designed for unstructured data, and scales horizontally.
Cloud Bigtable is not a relational database system. It stores data in key-value pairs.
For Interactive querying in an online analytical processing system use BigQuery.
BigQuery is a data warehouse application, and it stores data in structured tables.
BigQuery supports SQL queries whereas BigTable doesn't support SQL queries.
BigTable is not a recommended solution for a small volume of data(< 1 TB).
BigTable is characteristic of a NoSQL system whereas BigQuery is somewhat of a hybrid where it is mainly used for SQL queries but it does support NoSQL as well.
For e.g. If you want to do analytics or business intelligence from collected data from different sources into one location i.e BigQuery.
Simple, Database - BigTable whereas Analytics - BigQuery
Login into GCP Console.
Creating BigTable Instance.
Creating a BigTable Cluster.
Create a Table.
Create a Column Family.
Inserting data into Table.
Reading data through the Table.