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.
Other interfaces
From the course: Data Science on Google Cloud Platform: Designing Data Warehouses
Other interfaces
- [Instructor] There is one thing that GCP does great for any of its products. It supports multiple interfaces to work with these products. Let us explore additional interfaces available for working with BigQuery. Everything that is done through the web UI console can also be done on the command line through the Google Cloud Shell. This is also for scripting of commands and scheduling them if required. BigQuery also had a REST API that allows for management of datasets and tables. It provides data injection and querying capabilities similar to the web UI. In addition, data programming SDKs available in multiple languages. The REST API allows application developers to build applications that run outside the GCP framework and to integrate with GCP's BigQuery for data manipulation and querying. You can perform single or bulk inserts, updates, and deletes for data. You can of course run SQL queries using the REST API and get results back using JSON. Programming SDKs can be downloaded and…
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.