BigQuery is a fully-managed, serverless data warehouse that enables scalable analysis over petabytes of data. It is a Platform as a Service that supports querying using ANSI SQL. It also has built-in machine learning capabilities. BigQuery was announced in May 2010 and made generally available in November 2011.
Storing and querying massive datasets can be time consuming and expensive without the right hardware and infrastructure. BigQuery is an enterprise data warehouse that solves this problem by enabling super-fast SQL queries using the processing power of Google's infrastructure. Simply move your data into BigQuery and let us handle the hard work. You can control access to both the project and your data based on your business needs, such as giving others the ability to view or query your data.
You can access BigQuery by using the Cloud Console, by using the bq command-line tool, or by making calls to the BigQuery REST API using a variety of client libraries such as Java, .NET, or Python. There are also a variety of third-party tools that you can use to interact with BigQuery, such as visualizing the data or loading the data.
BigQuery is fully-managed. To get started, you don't need to deploy any resources, such as disks and virtual machines.
Microsoft Azure SQL Database is a managed cloud database provided as part of Microsoft Azure.
Db2 is a family of data management products, including database servers, developed by IBM. They initially supported the relational model, but were extended to support object–relational features and non-relational structures like JSON and XML.
Amazon Redshift is a data center product that is part of the broader Amazon Web Services cloud-computing network. The name implies moving away from Oracle, with red being an allusion to Oracle, whose corporate color is red and known informally as "Big Red."
Yellowbrick Data was founded in 2014 by Neil Carson, Jim Dawson, and Mark Brinicombe to bring to market a next generation flash storage optimized data warehouse.
Amazon Aurora is a relational database service developed and offered by Amazon Web Services beginning in October 2014. Aurora is available as part of the Amazon Relational Database Service.