From the course: Data Warehousing on Google Cloud Platform
Join today to access over 25,300 courses taught by industry experts.
BigQuery - Google Cloud Platform Tutorial
From the course: Data Warehousing on Google Cloud Platform
BigQuery
- [Instructor] BigQuery is Google Cloud's serverless enterprise data warehouse solution. With BigQuery, you don't need to provision or manage instances on Compute Engine, purchase licenses, or configure the database instance. BigQuery is fully-managed, and provides SQL support through a web interface, the CLI, or even through Python and Jupyter Notebook. It provides support for real-time data ingestion, interactive queries, and suitable for real-time analytics. Data can be stored in BigQuery natively or in external tables in cloud storage or Bigtable. The main advantages to using BigQuery is that it is a fully-managed service and scalable. It supports SQL, and has an interface where users can perform their own SQL queries. It's also horizontally-scalable and able to grow as your needs grow. Some limitations are that BigQuery is native to Google Cloud. While you can't migrate the entire BigQuery solution, you can export datasets. Users should also consider costs. Optimizing queries can…
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.