BigQuery is a fully managed enterprise [[data warehouse]] with built-in functionality for machine learning, geospatial analysis, and business intelligence. BigQuery's distributed analysis engine can query terabytes of data in seconds by separating the compute from the storage, allowing independent scaling of both.
You can store ana analyze data within BigQuery or use BigQuery to analyze data where it lives. Federated queries allow reading from external sources and streaming.
BigQuery storage is fully managed by BigQuery (meaning you don't need to provision resources yourself or worry about scaling). BigQuery automatically replicates data for durability.
BigQuery uses columnar data storage for performance using Google's proprietary Capacitor file format. Capacitor can also reshuffle data for compact storage.
BigQuery ML allows building [[machine learning]] models inside of BigQuery with a SQL-like syntax. BigQuery also supports client libraries for Python, JavaScript, Java, and Go.
Play around with BigQuery's public datasets to understand its capabilities (turn off billing for the project to avoid surprise charges).