The past two weeks at Google Cloud Next '20: On-Air featured dozens of unique news and stories about data analytics and data management, but the big story was the new information that came out about BigQuery Omni.
BigQuery Omni lets website admins access and securely analyze data across clouds hosted on Google, Amazon Web Services (AWS) and Azure without leaving the comfort of the BigQuery user interface. Why does that matter? In a survey by Gartner about cloud adoption, more than 80 percent of respondents who used the public cloud said they actually used more than one cloud service provider.
The Pros & Cons of Multi-Cloud
It makes sense that more businesses are going with a multi-cloud approach to their data. While having all your compute systems housed on one platform makes managing them easier, it also means that your organization is more or less locked in with that one vendor, which is something many businesses try to avoid.
Practically speaking, having your organization go multi-cloud isn’t always easy to achieve. You're talking about having data live in two environments that work differently. The fundamental concepts that drive Google Cloud and AWS are different; it takes time and energy to master them both and can be difficult to maintain that expertise. You also potentially face egress costs – charges that cloud vendors apply to discourage you from moving data en masse on an ongoing basis from their platform to another. But since multi-cloud is where you want to be, this is where Cloudbakers can help with Google Cloud.
Multi-Cloud Made Easy
The beauty of BigQuery Omni is that it allows you to break down data silos and centralize your data management in a way that doesn’t force you to move your data off its originating platform. Being able to look at and analyze that data in one location makes it possible for analysts — and subsequently the leaders they report to — to better understand what's happening in their business, providing opportunities to fix problems and identify potential growth opportunities. Having that process happen in a single, unified environment makes it easier to onboard new employees and decreases time-to-insight.
BigQuery Omni is made more powerful thanks to Looker, a data analytics platform that allows you to programmatically define your company's desired metrics, making it possible not just to create dashboards and reports with them but also to operationalize those metrics in an extremely effective way. Use Looker webhooks to send calculated metrics back to origination systems, parametrize database or table inputs to spin up templated reports efficiently, and apply version control to your metric definitions so that you can track changes over time, deploy timed releases, and rollback problematic changes quickly. Simply put, Looker is the finishing touch on an enterprise data warehouse that drives home what it means to be a data-driven business.
When prospective clients come to Cloudbakers looking for help with data management, they often come with an open mind, which is exciting for us because it allows us to partner with them to find a solution that works for their unique needs. A lot of times, customers want to understand how databases scale, how much potential solutions will cost and how our recommendations for using Google Cloud compare to other database platforms.
One thing we always say about BigQuery is that the beauty of it is that it's a system that is totally pay-as-you-go. You don't have to dive in and learn to swim all at once. You can start with the teeniest amount of data and begin to work with the system and build your way up. Other platforms require you to choose a data tier ahead of time or commit to a certain amount of cost as you build up your data analytics as a whole.
For our clients, being able to get their toes in the water and start to understand how to perform functions like automated reporting is a huge win. Now, with the addition of BigQuery Omni, clients can quickly see the value of a centralized data warehouse, even if that data lives in multiple clouds.Originally published on August 25, 2020