From the course: Data Science on Google Cloud Platform: Designing Data Warehouses
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Cloud BigQuery
From the course: Data Science on Google Cloud Platform: Designing Data Warehouses
Cloud BigQuery
- [Narrator] BigQuery is an Enterprise data warehouse product available on the GCP platform. It is serverless. You don't need to provision and manage physical instances of compute engines for BigQuery. It has support for standard SQL. This makes it easy to manage and query data. It supports real-time data ingestion and interactive queries, so it is suited for real-time analytics. It can either store data natively, or provide a SQL interface to data in other sources, like cloud storage and Bigtable. What are the strengths of Cloud BigQuery? It is serverless and fully managed. There is no DBA effort needed to use BigQuery. It has support for standard SQL. It is horizontally scalable. It can use native or external storage. What are its shortcomings? It is native to GCP, so applications using BigQuery are tied to the GCP platform. There is no support for ACID consistency. There is no support for transactions, either. Using BigQuery can be expensive, if proper quarters are not set, or…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.