Welcome to the Nightingale HQ overview about BigQuery.
Here we aim to introduce people to what they need to know.
BigQuery is a Google Cloud product. Read more about Google Cloud here.
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.
Check out our article ‘What is Data Warehousing?’ to find out more the benefits of a data warehouse.
BigQuery is a fully-managed, serverless cloud data warehouse that scales with your needs and is easy to set-up and manage. By adopting BigQuery, you can avoid the hassle of developing and managing the infrastructure needed to store large, complex datasets, allowing you to focus on gaining insight from your data. You can query your data using standard SQL statements, making it easy to get started with analysing your data.
You may need BigQuery if:
Benefits of BigQuery include:
To get started with BigQuery, you need a Google Cloud account. Read more about Google Cloud here.
Google Cloud offers comprehensive documentation to assist you if you plan to migrate your data from a different Data Warehouse environment, such as Teradata of Amazon RedShift.
BigQuery integrates with a suite of Google Cloud tools and partners, including:
Google Cloud services are built on the same secure-by-design infrastructure that is used by Google itself. Google has a policy of creating trust through transparency so you can read all about their security, privacy and compliance measures by visiting their Trust and Security centre.
BigQuery provides strong security and governance controls with fine-grained Identity and Access Management, and your data is always encrypted at rest and in transit.
BigQuery is a pay-as-you-go service so you only pay for what you use, and there are no up-front set-up fees. Read more about Google Cloud and its pricing structure here.
The cost of using BigQuery depends on both your storage and query requirements, as outlined below:
Flat-rate pricing is also available for querying data, starting at $10000 per month for reserving 500 slots.
You can read more about BigQuery pricing here.
If you already use Google Cloud services then BigQuery is a sensible option for your data warehouse. Other cloud vendors offer their own data warehouses, which you should also consider. When choosing a data warehouse service, considee the cost of storing and querying data, the speed of data analysis, the availability and security of your data, and the integrations available.
Other cloud data warehousing services include: