BigQuery is a fully managed enterprise data warehouse that helps you manage and analyze your data with built-in features like machine learning, geospatial analysis, and business intelligence. BigQuery is on Google Cloud. Data analysts can query, filter large datasets, aggregate results, and perform complex operations.

Types of BigQuery accounts

There are two different types of accounts: sandbox and free trial. A sandbox account allows you to practice queries and explore public datasets for free, but has additional restrictions on top of the standard quotas and limits.

• A free sandbox account doesn’t ask for a method of payment. It does, however, limit you to 12 projects. It also doesn’t allow you to insert new records to a database or update the field values of existing records. These data manipulation language (DML) operations aren’t supported in the sandbox.
• A free trial account requires a method of payment to establish a billable account, but offers full functionality during the trial period.

With either type of account, you can upgrade to a paid account at any time and retain all of your existing projects. If you set up a free trial account but choose not to upgrade to a paid account when your trial period ends, you can still set up a free sandbox account at that time. However, projects from your trial account won’t transfer to your sandbox account. It would be like starting from scratch again.

BigQuery is located at https://console.cloud.google.com/bigquery.

On YouTube there is s series of instructional videos called BigQuery Spotlight.

Machine Learning

Machine learning capabilities are built into Big Query, so you don’t need to move your data out of Big Query to run your machine learning programs.