Saturday, September 2, 2017

What is Google BigQuery?

If you want to query lots of data at great speeds, then this is the tool you should be aware of. The queries are not SQL, but SQL-like a slight variant. You can use your own data sets or use the sandbox. 



More here:

https://cloud.google.com/bigquery/docs/
You can store results on Google Cloud or download as a CSV.

Is it free? Yes, upto a certain size of data (10MB).

You can query as many times and as many queries as you like. If you are saving the data to cloud it may cost a little bit, assuming your data is a little set ($0.026 per GB/month).

You will also be working with a BigQuery browser tool. Use this tool to load data and run queries. Of course you can use a querying tool other than this as well.

Microsoft Power BI is another tool that can pull data of BigQuery according to this link here.






No comments: