{"id":41102,"date":"2020-07-14T14:22:29","date_gmt":"2020-07-14T14:22:29","guid":{"rendered":"http:\/\/icloud.pe\/blog\/?guid=58237086bb772e912b66e908a7d361ec"},"modified":"2020-07-14T14:22:29","modified_gmt":"2020-07-14T14:22:29","slug":"bigquery-omni-pulls-google-aws-and-azure-analytics-into-one-ui","status":"publish","type":"post","link":"https:\/\/icloud.pe\/blog\/bigquery-omni-pulls-google-aws-and-azure-analytics-into-one-ui\/","title":{"rendered":"BigQuery Omni pulls Google, AWS, and Azure analytics into one UI"},"content":{"rendered":"


\n Dale Walker<\/a><\/span>
\n <\/span><\/p>\n

\n
\n
14 Jul, 2020<\/span><\/div>\n<\/p><\/div>\n<\/div>\n

\n<\/a><\/p>\n

\n

\u200b<\/span>Google has launched an early version of BigQuery Omni, its new analytics tool that lets users access and view data across Google Cloud and Amazon Web Services without leaving the Big Query<\/a> UI.<\/p>\n

Powered by Google Anthos<\/a>, its vendor-neutral app development platform, users will be able to use SQL<\/a> and the standard BigQuery APIs to manipulate data silos sourced from multiple platforms, without having to manage the underlying infrastructure.<\/p>\n

Although the initial alpha launch of the service is restricted to Google Cloud and AWS, Google has also confirmed that Microsoft Azure will eventually be supported.<\/p>\n

The tool has been designed to target those customers who rely on multiple cloud service providers and are forced to juggle and consolidate a number of analytics tools in order to get a view of their data.<\/p>\n

This is made possible by the decoupling of storage and compute, according to the firm. The compute side has always been regarded as \u2018stateless\u2019 but, until now, BigQuery required data to be stored in Google Cloud \u2013 this restriction has now been scrapped, allowing customers to store their data in any supported public cloud.<\/p>\n

This single view means that customers can use BigQuery Omni to run SQL queries on clusters in whichever region the data resides. For example, it will be possible to query Google Analytics 360 Ads data stored in Google Cloud while simultaneously querying logs data from any apps stored in AWS S3<\/a>. This can then be used to build a dashboard to get a complete view of audience behaviour alongside ad spend.<\/p>\n

This means customers can avoid any costs associated with moving or copying data between cloud platforms in order to get a full view, Google claims.<\/p>\n

\u201c85% of respondents to 451 Research\u2019s Voice of the Enterprise Data & Analytics, Data Platforms 1H20 survey agreed that the ability to run the same database on multiple cloud\/data centre\u00a0environments is an important consideration when selecting a new data platform,\u201d said Matt Aslett, research director, Data, AI and Analytics, 451 Research.<\/p>\n

\u201cAs hybrid and multi-cloud adoption has become the norm, enterprises are increasingly looking for data products that provide a consistent experience and lower complexity of using multiple clouds, while enabling the ongoing use of existing infrastructure investments,” he added.<\/p>\n

The new system is built using Anthos, an app development platform launched last year<\/a> to appease customers that wanted a single programming model that allowed for data to be moved between their various cloud providers without charge or requiring changes.<\/p>\n

The underlying infrastructure is run entirely by Google, including any communication between cloud providers, on the familiar BigQuery UI, so there will be little operational change from the customers\u2019 perspective, the company claims.<\/p>\n

BigQuery Omni\u2019s engine will run on Anthos clusters inside the BigQuery managed service, and will source data from the various data silos across a customer\u2019s public cloud services, provided they have provided authorisation. In order to run queries, data is temporarily moved from the cloud provider\u2019s data storage to the BigQuery cluster running on Anthos.<\/p>\n

For now, BigQuery Omni is only available in private alpha, so customers will need to apply to Google to use it if they\u2019re interested. It\u2019s also only available for AWS S3 for now, with Azure support coming soon.<\/p>\n

There is currently no general release date available. <\/p>\n<\/p><\/div>\n","protected":false},"excerpt":{"rendered":"

Dale Walker<\/p>\n

14 Jul, 2020 <\/p>\n

\u200bGoogle has launched an early version of BigQuery Omni, its new analytics tool that lets users access and view data across Google Cloud and Amazon Web Services without leaving the Big Query UI.
\nP…<\/p>\n","protected":false},"author":407,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-41102","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/icloud.pe\/blog\/wp-json\/wp\/v2\/posts\/41102","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/icloud.pe\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/icloud.pe\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/icloud.pe\/blog\/wp-json\/wp\/v2\/users\/407"}],"replies":[{"embeddable":true,"href":"https:\/\/icloud.pe\/blog\/wp-json\/wp\/v2\/comments?post=41102"}],"version-history":[{"count":1,"href":"https:\/\/icloud.pe\/blog\/wp-json\/wp\/v2\/posts\/41102\/revisions"}],"predecessor-version":[{"id":41103,"href":"https:\/\/icloud.pe\/blog\/wp-json\/wp\/v2\/posts\/41102\/revisions\/41103"}],"wp:attachment":[{"href":"https:\/\/icloud.pe\/blog\/wp-json\/wp\/v2\/media?parent=41102"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/icloud.pe\/blog\/wp-json\/wp\/v2\/categories?post=41102"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/icloud.pe\/blog\/wp-json\/wp\/v2\/tags?post=41102"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}