Conclusion

BigQuery is Google’s managed data warehouse in the cloud. BigQuery is incredibly fast. It can scan billions of rows in seconds. It’s also surprisingly inexpensive and easy to use. Querying terabytes of data costs only pennies and you only pay for what you use since there are no up-front costs.

This is a hands-on course where you can follow along with the demos using your own Google Cloud account or a trial account. You do not need any prior knowledge of Google Cloud Platform and the only pre-requisite is having some experience with databases.

Learning Objectives

• Load data into BigQuery using files or by streaming one record at a time
• Run a query using standard SQL and save your results to a table
• Export data from BigQuery using Google Cloud Storage

 

I hope you enjoyed learning how to use BigQuery. Now you know how to load data, run queries and save the results, stream data one record at a time, and export data.

To learn more about BigQuery, you can read Google's online documentation. You can also try one of the other Google courses on CloudAcademy and watch for new ones because we're always developing new courses.

If you have any questions or comments, please let me know in the Comments tab below this video. Thanks and keep on learning.