{"id":651764,"date":"2022-05-01T16:30:00","date_gmt":"2022-05-01T14:30:00","guid":{"rendered":"https:\/\/www.devoteam.com\/?post_type=expert-view&#038;p=651764"},"modified":"2025-06-26T16:33:28","modified_gmt":"2025-06-26T14:33:28","slug":"bigquery-uma-poderosa-interface-analitica-unificada-no-data-ocean","status":"publish","type":"expert-view","link":"https:\/\/devoteam.info\/pt\/expert-view\/bigquery-uma-poderosa-interface-analitica-unificada-no-data-ocean\/","title":{"rendered":"BigQuery: uma poderosa interface anal\u00edtica unificada no Data Ocean"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Sim, eu disse\u00a0<strong>Data Ocean<\/strong>\u00a0e n\u00e3o\u00a0<a href=\"https:\/\/en.wikipedia.org\/wiki\/Data_warehouse\">Data Warehouse<\/a>\u00a0ou\u00a0<a href=\"https:\/\/en.wikipedia.org\/wiki\/Data_lake\">Data Lake<\/a>! Isto porque ambos s\u00e3o conceitos normalmente restritos a um determinado dom\u00ednio, tal como uma organiza\u00e7\u00e3o, que atualmente \u00e9 limitado para as capacidades do\u00a0<a href=\"https:\/\/cloud.google.com\/bigquery\">BigQuery<\/a>.\u00a0<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">A Google tem trabalhado para aumentar as capacidades do BigQuery e torn\u00e1-lo cada vez mais uma interface anal\u00edtica unificada em qualquer n\u00edvel de armazenamento, independentemente do formato e localiza\u00e7\u00e3o dos dados. Ter uma&nbsp;<a href=\"https:\/\/cloud.google.com\/blog\/products\/bigquery\/separation-of-storage-and-compute-in-bigquery\">arquitetura<\/a>&nbsp;em que o&nbsp;<a href=\"https:\/\/cloud.google.com\/bigquery\/docs\/storage_overview\">armazenamento<\/a>&nbsp;e a&nbsp;<a href=\"https:\/\/cloud.google.com\/bigquery\/docs\/query-overview\">processamento<\/a>&nbsp;est\u00e3o separados \u00e9 um fator importante para alavancar esta estrat\u00e9gia.&nbsp;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">O&nbsp;<a href=\"https:\/\/cloud.google.com\/blog\/products\/data-analytics\/unifying-data-lakes-and-data-warehouses-across-clouds-with-biglake\">BigLake<\/a>, servi\u00e7o recentemente anunciado na&nbsp;<a href=\"https:\/\/cloudonair.withgoogle.com\/events\/summit-data-cloud-2022?talk=vod_da1_s1_big_lake\">Google Data Cloud Summit 2022<\/a>, exemplifica este investimento, atrav\u00e9s da expans\u00e3o do BigQuery para unificar Data Warehouses e Data Lakes com uma governa\u00e7\u00e3o refinada em ambientes multi-cloud.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Algo assinal\u00e1vel, porque remove todas as fronteiras de dados e ultrapassa a barreira entre Data Lakes e Data Warehouses. N\u00e3o \u00e9 necess\u00e1rio copiar os dados ou mov\u00ea-los entre os seus armazenamentos de objectos, simplesmente obt\u00e9m um \u00fanico local para aceder a todos os seus dados.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Permite tamb\u00e9m, por exemplo, parcerias entre empresas para partilhar informa\u00e7\u00e3o estrat\u00e9gica, sem a necessidade de transferir dados, numa \u00fanica plataforma anal\u00edtica, de forma totalmente controlada e segura.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Esta \u00e9 uma das recentes not\u00edcias anunciadas pela Google, mas o&nbsp;<strong>ecossistema anal\u00edtico<\/strong>&nbsp;em torno do BigQuery n\u00e3o \u00e9 apenas isto, conforme seguidamente apresentado:<\/p>\n\n\n\n<h1 class=\"wp-block-heading\" id=\"h-funcionalidades\"><strong>Funcionalidades<\/strong><\/h1>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/cloud.google.com\/bigquery-ml\/docs\/\"><strong>BigQueryML<\/strong><\/a><strong>:\u00a0<\/strong>permite construir e executar modelos Machine Learning no BigQuery. As integra\u00e7\u00f5es com\u00a0<a href=\"https:\/\/cloud.google.com\/vertex-ai\">Vertex AI<\/a>\u00a0e\u00a0<a href=\"https:\/\/cloud.google.com\/tensorflow-enterprise\">TensorFlow<\/a>\u00a0permitem treinar e executar modelos poderosos sobre dados estruturados em minutos. Tudo isto apenas com o SQL.<\/li>\n\n\n\n<li><a href=\"https:\/\/cloud.google.com\/bigquery\/docs\/geospatial-intro\"><strong>BigQuery GIS<\/strong><\/a>: combina de forma \u00fanica a arquitetura sem servidor do BigQuery com suporte nativo para an\u00e1lise geoespacial usando o SQL padr\u00e3o.<\/li>\n\n\n\n<li><a href=\"https:\/\/cloud.google.com\/bigquery-omni\/docs\"><strong>BigQuery Omni<\/strong><\/a>: uma solu\u00e7\u00e3o anal\u00edtica flex\u00edvel e multi-cloud,\u00a0<a href=\"https:\/\/cloud.google.com\/anthos\" target=\"_blank\" rel=\"noreferrer noopener\">Anthos<\/a>, que permite analisar dados atrav\u00e9s das clouds, a utilizar SQL padr\u00e3o e a interface familiar do BigQuery.<\/li>\n\n\n\n<li><a href=\"https:\/\/cloud.google.com\/bigquery\/docs\/bi-engine-intro\"><strong>BigQuery BI Engine<\/strong><\/a>: um servi\u00e7o de an\u00e1lise in-memory integrado com o BigQuery que permite aos utilizadores analisar interativamente grandes e complexos conjuntos de dados com tempo de resposta de consulta de sub-segundos e elevada simultaneidade.<\/li>\n\n\n\n<li><a href=\"https:\/\/cloud.google.com\/bigquery-transfer\/docs\/introduction\"><strong>BigQuery Data Transfer Service<\/strong><\/a>: transfere automaticamente dados para BigQuery de fontes de dados externas, como a Google Marketing Platform, o Google Ads, o YouTube, aplica\u00e7\u00f5es SaaS parceiras, Teradata e Amazon S3, de forma programada e totalmente gerida.<\/li>\n\n\n\n<li><a href=\"https:\/\/cloud.google.com\/blog\/products\/g-suite\/connected-sheets-is-generally-available\"><strong>Connected Sheets<\/strong><\/a>: permite aos utilizadores analisar milhares de milh\u00f5es de linhas de dados do BigQuery em tempo real no Google Sheets n\u00e3o sendo necess\u00e1rio possuir conhecimentos de SQL.\u00a0<\/li>\n\n\n\n<li><a href=\"https:\/\/cloud.google.com\/biglake\"><strong>BigLake<\/strong><\/a>: um motor de armazenamento que permite unificar Data Warehouses e Data Lakes, permite-lhes efetuar um controlo de acesso uniforme e preciso e acelera o desempenho da consulta em armazenamento multi-cloud e formatos abertos. As liga\u00e7\u00f5es de\u00a0<a href=\"https:\/\/cloud.google.com\/bigquery\/external-data-sources\">fontes de dados externas<\/a>\u00a0n\u00e3o s\u00e3o uma novidade para o BigQuery, uma vez que j\u00e1 era poss\u00edvel criar\u00a0<a href=\"https:\/\/cloud.google.com\/bigquery\/docs\/external-tables\">tabelas externas<\/a>\u00a0ou\u00a0<a href=\"https:\/\/cloud.google.com\/bigquery\/docs\/reference\/standard-sql\/federated_query_functions\">fun\u00e7\u00f5es de consulta federada<\/a>.<\/li>\n\n\n\n<li><a href=\"https:\/\/cloud.google.com\/bigquery\/docs\/search-intro\"><strong>Pesquisa em BigQuery<\/strong><\/a>: permite-lhe utilizar o SQL para encontrar facilmente elementos de dados \u00fanicos escondidos em texto n\u00e3o estruturado e dados JSON semiestruturados, sem ter de conhecer previamente o esquemas da tabela.<\/li>\n\n\n\n<li><a href=\"https:\/\/cloud.google.com\/bigquery\/docs\/reference\/standard-sql\/remote-functions\"><strong>Fun\u00e7\u00f5es Remotas<\/strong><\/a>: permite-lhe expandir as funcionalidades de BigQuery SQL com software fora do BigQuery atrav\u00e9s da integra\u00e7\u00e3o direta com as Cloud Functions, o ambiente serverless do Google Cloud para fun\u00e7\u00f5es com uma \u00fanica finalidade. Permite a implementa\u00e7\u00e3o de fun\u00e7\u00f5es noutras linguagens para al\u00e9m do SQL e JavaScript ou com as bibliotecas ou servi\u00e7os que n\u00e3o s\u00e3o permitidos nas fun\u00e7\u00f5es definidas pelo utilizador no BigQuery.<\/li>\n\n\n\n<li><a href=\"https:\/\/cloud.google.com\/bigquery\/docs\/reference\/standard-sql\/json-data\"><strong>Dados JSON em SQL padr\u00e3o<\/strong><\/a>: O SQL padr\u00e3o do BigQuery suporta agora os dados tipo JSON para armazenamento de dados JSON. Deste modo pode inserir dados JSON semiestruturados em BigQuery sem a necessidade de definir previamente um esquema. Permite armazenar e consultar dados que nem sempre aderem a esquemas e tipos de dados fixos.<\/li>\n\n\n\n<li><a href=\"https:\/\/cloud.google.com\/blog\/products\/data-analytics\/bigquery-connector-for-sap\"><strong>Conector BigQuery para SAP<\/strong><\/a>: uma forma r\u00e1pida, simples, econ\u00f3mica e extremamente escal\u00e1vel de tornar os dados SAP totalmente acess\u00edveis dentro do BigQuery, aproveitando as ferramentas e os conjuntos de compet\u00eancias existentes do SAP Landscape Transformation Replication Server (SLT) dos clientes.\u00a0<strong>Atualmente \u00e9 oferecido sem qualquer custo<\/strong>.<\/li>\n\n\n\n<li><a href=\"https:\/\/cloud.google.com\/datasets\"><strong>Datasets p\u00fablicos<\/strong><\/a>: oferecem um poderoso reposit\u00f3rio de dados com mais de 200 conjuntos de dados p\u00fablicos com grande procura de diferentes ind\u00fastrias.\u00a0<\/li>\n\n\n\n<li><a href=\"https:\/\/cloud.google.com\/bigquery\/docs\/sandbox\"><strong>BigQuery Sandbox<\/strong><\/a>: acesso inteiramente livre ao poder total do BigQuery sujeito a determinados limites. N\u00e3o \u00e9 necess\u00e1rio um cart\u00e3o de cr\u00e9dito nem criar ou ativar uma conta de fatura\u00e7\u00e3o.<\/li>\n\n\n\n<li><strong><a href=\"https:\/\/cloud.google.com\/bigquery\/pricing#free-tier\" target=\"_blank\" rel=\"noreferrer noopener\">N\u00edvel de utiliza\u00e7\u00e3o livre<\/a><\/strong>:\u00a0<strong>\u00a0<\/strong>Como parte integrante do\u00a0<a href=\"https:\/\/cloud.google.com\/free\">Google Cloud Free Tier<\/a>, o BigQuery oferece alguns recursos gratuitos at\u00e9 um limite espec\u00edfico. Estes limites de utiliza\u00e7\u00e3o gratuita est\u00e3o dispon\u00edveis durante e ap\u00f3s o per\u00edodo experimental gratuito.\u00a0<\/li>\n<\/ul>\n\n\n\n<h1 class=\"wp-block-heading\" id=\"h-solucoes-relacionadas\"><strong>Solu\u00e7\u00f5es relacionadas<\/strong><\/h1>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/docs.google.com\/forms\/d\/e\/1FAIpQLSccIXlE5gJNE0dNs6vQvCfrCcSjnoHqaW2lxpoVkAh56KLOwA\/viewform\"><\/a><strong><a href=\"https:\/\/docs.google.com\/forms\/d\/e\/1FAIpQLSccIXlE5gJNE0dNs6vQvCfrCcSjnoHqaW2lxpoVkAh56KLOwA\/viewform\"><strong>Serverless Spark through BigQuery<\/strong><\/a><\/strong>: O editor PySpark na Consola BigQuery, fornecido atrav\u00e9s do Serverless Spark backend. Encontre informa\u00e7\u00f5es relacionadas\u00a0<a href=\"https:\/\/cloud.google.com\/blog\/products\/data-analytics\/making-serverless-spark-even-more-powerful\">aqui<\/a>\u00a0e\u00a0<a href=\"https:\/\/cloud.google.com\/blog\/products\/data-analytics\/simplify-data-processing-and-data-science-jobs-with-spark-on-google-cloud\">aqui<\/a>.<\/li>\n\n\n\n<li><a href=\"https:\/\/cloud.google.com\/analytics-hub\"><strong>Analytics Hub<\/strong><\/a>: um modelo de publica\u00e7\u00e3o e subscri\u00e7\u00e3o de conjuntos de dados BigQuery. Permite a troca eficiente e segura de ativos de dados entre organiza\u00e7\u00f5es para enfrentar os desafios da fiabilidade dos dados e dos custos.<\/li>\n\n\n\n<li><a href=\"https:\/\/cloud.google.com\/solutions\/cortex\"><\/a><strong><a href=\"https:\/\/cloud.google.com\/solutions\/cortex\"><strong>Google Cloud Cortex Framework<\/strong><\/a><\/strong>: um conjunto de modelos, blocos de constru\u00e7\u00e3o e arquiteturas de refer\u00eancia que ir\u00e3o simplificar e acelerar o planeamento, a engenharia e as implementa\u00e7\u00f5es em Google Cloud Platform. Pode iniciar rapidamente os insights com\u00a0<a href=\"https:\/\/cloud.google.com\/solutions\/sap\">Dados SAP em BigQuery<\/a>\u00a0com arquiteturas anal\u00edticas de refer\u00eancia, visualiza\u00e7\u00f5es BigQuery pr\u00e9-definidas e alterar scripts de captura de dados, modelos BigQuery ML e Plug and Play Looker dashboards.<\/li>\n\n\n\n<li><a href=\"https:\/\/cloud.google.com\/dataplex\"><strong>Dataplex<\/strong><\/a>: uma camada de dados inteligente que ajuda a unificar os dados distribu\u00eddos sem qualquer movimento de dados, organizando-os em fun\u00e7\u00e3o das necessidades das empresas e com uma gest\u00e3o, monitoriza\u00e7\u00e3o e governa\u00e7\u00e3o centralizada.<\/li>\n\n\n\n<li><a href=\"https:\/\/cloud.google.com\/vertex-ai\/docs\"><strong>Vertex AI<\/strong>:<\/a>\u00a0unifica o\u00a0<a href=\"https:\/\/cloud.google.com\/automl\">AutoML<\/a>\u00a0e a\u00a0<a href=\"https:\/\/cloud.google.com\/ai-platform\/docs\/technical-overview\">AI Platform<\/a>\u00a0numa API unificada, client library e interface de utilizador. H\u00e1 tamb\u00e9m o\u00a0<a href=\"https:\/\/cloud.google.com\/vertex-ai-workbench\">Vertex AI Workbench<\/a>\u00a0um \u00fanico ambiente de desenvolvimento para todo o fluxo de trabalho da ci\u00eancia dos dados, e o\u00a0<a href=\"https:\/\/cloud.google.com\/vertex-ai\/docs\/model-registry\/introduction\">Vertex AI Model Registry<\/a>\u00a0um reposit\u00f3rio central para gerir e governar o ciclo de vida dos modelos ML.<\/li>\n\n\n\n<li><strong><a href=\"https:\/\/cloud.google.com\/dlp\/docs\" target=\"_blank\" rel=\"noreferrer noopener\"><\/a><a href=\"https:\/\/cloud.google.com\/dlp\/docs\"><strong>Cloud Data Loss Prevention<\/strong><\/a>\u00a0(DLP)<\/strong>: um servi\u00e7o totalmente gerido que d\u00e1 acesso a uma poderosa plataforma de inspe\u00e7\u00e3o, classifica\u00e7\u00e3o e anonimiza\u00e7\u00e3o de dados sens\u00edveis. Existem servi\u00e7os tais como\u00a0<a href=\"https:\/\/cloud.google.com\/dlp\/docs\/data-profiles\">Data profiles<\/a>\u00a0para dados BigQuery que analisam automaticamente todas as tabelas e colunas em toda a organiza\u00e7\u00e3o, pastas individuais, e projetos, identificando onde residem os dados sens\u00edveis e de alto risco. Pode encontrar mais informa\u00e7\u00e3o sobre DLP autom\u00e1tico para BigQuery\u00a0<a href=\"https:\/\/cloud.google.com\/blog\/products\/identity-security\/automatic-dlp-for-bigquery\">aqui<\/a>\u00a0e\u00a0<a href=\"https:\/\/cloud.google.com\/blog\/products\/identity-security\/google-launches-automatic-dlp-for-bigquery\">aqui<\/a>.<\/li>\n\n\n\n<li><a href=\"https:\/\/cloud.google.com\/logging\/docs\/log-analytics\"><strong>Log Analytics<\/strong><\/a>: d\u00e1-lhe o poder anal\u00edtico do BigQuery diretamente no Cloud Logging com uma nova interface de utilizador otimizada para analisar os dados de log. Pode usar o SQL para realizar an\u00e1lises avan\u00e7adas de logs e tamb\u00e9m disponibiliz\u00e1-los diretamente no BigQuery. Pode correlacionar os seus logs com outros dados empresariais armazenados no BigQuery, dando-lhe uma vis\u00e3o mais ampla dos seus servi\u00e7os Google Cloud.<strong>\u00a0<\/strong><\/li>\n\n\n\n<li><a href=\"https:\/\/cloud.google.com\/blog\/products\/data-analytics\/google-cloud-launches-bigquery-capacity-recommendations\"><strong>Recomenda\u00e7\u00f5es de assist\u00eancia ativa para BigQuery<\/strong><\/a>: cria recomenda\u00e7\u00f5es para clientes que utilizam fatura\u00e7\u00e3o a pedido. Estas recomenda\u00e7\u00f5es ajudam-no a compreender as suas necessidades de capacidade BigQuery e os tradeoffs de custo e desempenho da compra de diferentes quantidades de capacidade de slot. Esta funcionalidade \u00e9 fornecida pelo\u00a0<a href=\"https:\/\/cloud.google.com\/solutions\/active-assist\">Active Assist<\/a>, uma parte da solu\u00e7\u00e3o AIOps do Google Cloud que utiliza dados, intelig\u00eancia, e Machine Learning para reduzir a complexidade da Cloud e o trabalho administrativo.<\/li>\n<\/ul>\n\n\n\n<h1 class=\"wp-block-heading\" id=\"h-topicos-adicionais\"><strong>T\u00f3picos adicionais<\/strong><\/h1>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/cloud.google.com\/bigquery\/docs\/data-governance\"><\/a><strong><a href=\"https:\/\/cloud.google.com\/bigquery\/docs\/data-governance\"><strong>Data security and governance<\/strong><\/a><\/strong>: conceitos de governa\u00e7\u00e3o de dados e quais os controlos de que poder\u00e1 necessitar para proteger os recursos do BigQuery.<\/li>\n\n\n\n<li><a href=\"https:\/\/cloud.google.com\/blog\/search;query=bigquery%20admin%20reference%20guide;paginate=25;order=newest\"><strong>BigQuery Admin Reference Guide<\/strong><\/a>: um conjunto de artigos incluindo monitoriza\u00e7\u00e3o, governa\u00e7\u00e3o, processamento e otimiza\u00e7\u00e3o de consultas, hierarquia de recursos, etc.<\/li>\n\n\n\n<li><a href=\"https:\/\/cloud.google.com\/bigquery\/docs\/bigquery-ready-overview\"><strong>Google Cloud Ready \u2013 BigQuery<\/strong><\/a>: um programa de valida\u00e7\u00e3o atrav\u00e9s do qual as equipas de engenharia do Google Cloud avaliam e validam as integra\u00e7\u00f5es e os conetores BigQuery utilizando uma s\u00e9rie de testes de integra\u00e7\u00e3o de dados e benchmarks.<\/li>\n\n\n\n<li><a href=\"https:\/\/cloud.google.com\/solutions%23section-2\"><\/a><strong><a href=\"https:\/\/cloud.google.com\/solutions#section-2\"><strong>Industry Solutions<\/strong><\/a><\/strong>: As solu\u00e7\u00f5es Google Cloud podem ajudar a melhorar a efici\u00eancia e a agilidade, reduzir custos, participar em novos modelos de neg\u00f3cio e captar novas oportunidades de mercado. O BigQuery \u00e9 uma parte essencial destas solu\u00e7\u00f5es anal\u00edticas.\u00a0\u00a0<\/li>\n\n\n\n<li><a href=\"https:\/\/cloud.google.com\/architecture\/dw2bq\/dw-bq-migration-overview\"><\/a><strong><a href=\"https:\/\/cloud.google.com\/architecture\/dw2bq\/dw-bq-migration-overview\"><strong>Migrating data warehouses to BigQuery<\/strong><\/a><\/strong>: este documento faz parte de uma s\u00e9rie que o ajuda na transi\u00e7\u00e3o de um Data Warehouse nas suas instala\u00e7\u00f5es para o BigQuery. Numa se\u00e7\u00e3o posterior s\u00e3o apresentados detalhes sobre a transi\u00e7\u00e3o de tecnologias espec\u00edficas de armazenamento de dados para o BigQuery, tais como Netezza, Oracle, Amazon Redshift, Teradata e Snowflake.<\/li>\n<\/ul>\n\n\n\n<h1 class=\"wp-block-heading\" id=\"h-conclusao\"><strong>Conclus\u00e3o<\/strong><\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">Estas s\u00e3o apenas um subconjunto das funcionalidades e solu\u00e7\u00f5es do BigQuery, n\u00e3o \u00e9 uma lista exaustiva. O BigQuery est\u00e1 totalmente integrado com os servi\u00e7os Google Cloud e n\u00e3o s\u00f3, em conformidade com a estrat\u00e9gia&nbsp;<a href=\"https:\/\/cloud.google.com\/open-cloud\">Open Cloud<\/a>&nbsp;da Google, que \u00e9 cada vez mais aberta e democr\u00e1tica, tal como podemos constatar, por exemplo, atrav\u00e9s do BigLake e do BigQuery Omni.Pode encontrar muito mais informa\u00e7\u00e3o no&nbsp;<a href=\"https:\/\/cloud.google.com\/blog\">blog<\/a>&nbsp;dos&nbsp;<a href=\"https:\/\/cloud.google.com\/products\">produtos<\/a>&nbsp;e&nbsp;<a href=\"https:\/\/cloud.google.com\/solutions\">solu\u00e7\u00f5es<\/a>&nbsp;Google Cloud e&nbsp;<a href=\"https:\/\/cloud.google.com\/docs\">documenta\u00e7\u00e3o<\/a>&nbsp;tal como:&nbsp;<a href=\"https:\/\/cloud.google.com\/bigquery\/docs\">BigQuery Documentation<\/a>,&nbsp;<a href=\"https:\/\/cloud.google.com\/bigquery\/docs\/release-notes\">BigQuery Release Notes<\/a>,&nbsp;<a href=\"https:\/\/cloud.google.com\/dataproc-serverless\/docs\">Dataproc Serverless Spark<\/a>&nbsp;e&nbsp;<a href=\"https:\/\/cloud.google.com\/solutions\/spark\">Spark on Google Cloud<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Sim, eu disse\u00a0Data Ocean\u00a0e n\u00e3o\u00a0Data Warehouse\u00a0ou\u00a0Data Lake! Isto porque ambos s\u00e3o conceitos normalmente restritos a um determinado dom\u00ednio, tal como uma organiza\u00e7\u00e3o, que atualmente \u00e9 limitado para as capacidades do\u00a0BigQuery.\u00a0 A Google tem trabalhado para aumentar as capacidades do BigQuery e torn\u00e1-lo cada vez mais uma interface anal\u00edtica unificada em qualquer n\u00edvel de armazenamento, independentemente [&hellip;]<\/p>\n","protected":false},"featured_media":651765,"template":"","categories":[951],"tags":[],"industry":[],"class_list":["post-651764","expert-view","type-expert-view","status-publish","has-post-thumbnail","hentry","category-nuvem-do-google"],"acf":[],"cards":"\n\t<div class=\"single-post-card\">\n\n\t\t<figure class=\"wp-block-post-featured-image\"><a href=\"https:\/\/devoteam.info\/pt\/expert-view\/bigquery-uma-poderosa-interface-analitica-unificada-no-data-ocean\/\" target=\"_self\" ><img width=\"780\" height=\"450\" src=\"https:\/\/devoteam.info\/wp-content\/uploads\/2025\/06\/big-data-Istock_000021034262.jpg\" class=\"attachment-post-thumbnail size-post-thumbnail wp-post-image\" alt=\"BigQuery: uma poderosa interface anal\u00edtica unificada no Data Ocean\" style=\"aspect-ratio:4\/3;width:100%;object-fit:cover;\" decoding=\"async\" loading=\"lazy\" srcset=\"https:\/\/devoteam.info\/wp-content\/uploads\/2025\/06\/big-data-Istock_000021034262.jpg 780w, https:\/\/devoteam.info\/wp-content\/uploads\/2025\/06\/big-data-Istock_000021034262-300x173.jpg 300w, https:\/\/devoteam.info\/wp-content\/uploads\/2025\/06\/big-data-Istock_000021034262-768x443.jpg 768w\" sizes=\"auto, (max-width: 780px) 100vw, 780px\" \/><\/a><\/figure>\n\n\t\t\n\t\t<div class=\"wp-block-group is-vertical is-layout-flex wp-container-core-group-is-layout-43282307 wp-block-group-is-layout-flex\">\n\t<p style=\"font-style:normal;font-weight:700\" class=\"has-link-color wp-elements-1 wp-block-lp-post-type has-text-color has-primary-color has-small-font-size\">Expert View<\/p>\n\n\t\t\n\t\t<h3 style=\"font-style:normal;font-weight:400\" class=\"wp-block-post-title has-base-font-size\"><a href=\"https:\/\/devoteam.info\/pt\/expert-view\/bigquery-uma-poderosa-interface-analitica-unificada-no-data-ocean\/\" target=\"_self\" >BigQuery: uma poderosa interface anal\u00edtica unificada no Data Ocean<\/a><\/h3><\/div>\n\t\t\n\t<\/div>\n\n","yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v28.4 (Yoast SEO v28.4) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>BigQuery: uma poderosa interface anal\u00edtica unificada no Data Ocean | Devoteam<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/devoteam.info\/pt\/expert-view\/bigquery-uma-poderosa-interface-analitica-unificada-no-data-ocean\/\" \/>\n<meta property=\"og:locale\" content=\"pt_PT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"BigQuery: uma poderosa interface anal\u00edtica unificada no Data Ocean\" \/>\n<meta property=\"og:description\" content=\"Sim, eu disse\u00a0Data Ocean\u00a0e n\u00e3o\u00a0Data Warehouse\u00a0ou\u00a0Data Lake! Isto porque ambos s\u00e3o conceitos normalmente restritos a um determinado dom\u00ednio, tal como uma organiza\u00e7\u00e3o, que atualmente \u00e9 limitado para as capacidades do\u00a0BigQuery.\u00a0 A Google tem trabalhado para aumentar as capacidades do BigQuery e torn\u00e1-lo cada vez mais uma interface anal\u00edtica unificada em qualquer n\u00edvel de armazenamento, independentemente [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/devoteam.info\/pt\/expert-view\/bigquery-uma-poderosa-interface-analitica-unificada-no-data-ocean\/\" \/>\n<meta property=\"og:site_name\" content=\"Devoteam\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-26T14:33:28+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/devoteam.info\/wp-content\/uploads\/2025\/06\/big-data-Istock_000021034262.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"780\" \/>\n\t<meta property=\"og:image:height\" content=\"450\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Tempo estimado de leitura\" \/>\n\t<meta name=\"twitter:data1\" content=\"7 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/devoteam.info\\\/pt\\\/expert-view\\\/bigquery-uma-poderosa-interface-analitica-unificada-no-data-ocean\\\/\",\"url\":\"https:\\\/\\\/devoteam.info\\\/pt\\\/expert-view\\\/bigquery-uma-poderosa-interface-analitica-unificada-no-data-ocean\\\/\",\"name\":\"BigQuery: uma poderosa interface anal\u00edtica unificada no Data Ocean | Devoteam\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/devoteam.info\\\/pt\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/devoteam.info\\\/pt\\\/expert-view\\\/bigquery-uma-poderosa-interface-analitica-unificada-no-data-ocean\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/devoteam.info\\\/pt\\\/expert-view\\\/bigquery-uma-poderosa-interface-analitica-unificada-no-data-ocean\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/devoteam.info\\\/wp-content\\\/uploads\\\/2025\\\/06\\\/big-data-Istock_000021034262.jpg\",\"datePublished\":\"2022-05-01T14:30:00+00:00\",\"dateModified\":\"2025-06-26T14:33:28+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/devoteam.info\\\/pt\\\/expert-view\\\/bigquery-uma-poderosa-interface-analitica-unificada-no-data-ocean\\\/#breadcrumb\"},\"inLanguage\":\"pt-PT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/devoteam.info\\\/pt\\\/expert-view\\\/bigquery-uma-poderosa-interface-analitica-unificada-no-data-ocean\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@id\":\"https:\\\/\\\/devoteam.info\\\/pt\\\/expert-view\\\/bigquery-uma-poderosa-interface-analitica-unificada-no-data-ocean\\\/#primaryimage\",\"url\":\"https:\\\/\\\/devoteam.info\\\/wp-content\\\/uploads\\\/2025\\\/06\\\/big-data-Istock_000021034262.jpg\",\"contentUrl\":\"https:\\\/\\\/devoteam.info\\\/wp-content\\\/uploads\\\/2025\\\/06\\\/big-data-Istock_000021034262.jpg\",\"width\":780,\"height\":450},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/devoteam.info\\\/pt\\\/expert-view\\\/bigquery-uma-poderosa-interface-analitica-unificada-no-data-ocean\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/devoteam.info\\\/pt\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Expert View\",\"item\":\"https:\\\/\\\/devoteam.info\\\/pt\\\/expert-view\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"BigQuery: uma poderosa interface anal\u00edtica unificada no Data Ocean\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/devoteam.info\\\/pt\\\/#website\",\"url\":\"https:\\\/\\\/devoteam.info\\\/pt\\\/\",\"name\":\"Devoteam\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/devoteam.info\\\/pt\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"pt-PT\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"BigQuery: uma poderosa interface anal\u00edtica unificada no Data Ocean | Devoteam","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/devoteam.info\/pt\/expert-view\/bigquery-uma-poderosa-interface-analitica-unificada-no-data-ocean\/","og_locale":"pt_PT","og_type":"article","og_title":"BigQuery: uma poderosa interface anal\u00edtica unificada no Data Ocean","og_description":"Sim, eu disse\u00a0Data Ocean\u00a0e n\u00e3o\u00a0Data Warehouse\u00a0ou\u00a0Data Lake! Isto porque ambos s\u00e3o conceitos normalmente restritos a um determinado dom\u00ednio, tal como uma organiza\u00e7\u00e3o, que atualmente \u00e9 limitado para as capacidades do\u00a0BigQuery.\u00a0 A Google tem trabalhado para aumentar as capacidades do BigQuery e torn\u00e1-lo cada vez mais uma interface anal\u00edtica unificada em qualquer n\u00edvel de armazenamento, independentemente [&hellip;]","og_url":"https:\/\/devoteam.info\/pt\/expert-view\/bigquery-uma-poderosa-interface-analitica-unificada-no-data-ocean\/","og_site_name":"Devoteam","article_modified_time":"2025-06-26T14:33:28+00:00","og_image":[{"width":780,"height":450,"url":"https:\/\/devoteam.info\/wp-content\/uploads\/2025\/06\/big-data-Istock_000021034262.jpg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_misc":{"Tempo estimado de leitura":"7 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/devoteam.info\/pt\/expert-view\/bigquery-uma-poderosa-interface-analitica-unificada-no-data-ocean\/","url":"https:\/\/devoteam.info\/pt\/expert-view\/bigquery-uma-poderosa-interface-analitica-unificada-no-data-ocean\/","name":"BigQuery: uma poderosa interface anal\u00edtica unificada no Data Ocean | Devoteam","isPartOf":{"@id":"https:\/\/devoteam.info\/pt\/#website"},"primaryImageOfPage":{"@id":"https:\/\/devoteam.info\/pt\/expert-view\/bigquery-uma-poderosa-interface-analitica-unificada-no-data-ocean\/#primaryimage"},"image":{"@id":"https:\/\/devoteam.info\/pt\/expert-view\/bigquery-uma-poderosa-interface-analitica-unificada-no-data-ocean\/#primaryimage"},"thumbnailUrl":"https:\/\/devoteam.info\/wp-content\/uploads\/2025\/06\/big-data-Istock_000021034262.jpg","datePublished":"2022-05-01T14:30:00+00:00","dateModified":"2025-06-26T14:33:28+00:00","breadcrumb":{"@id":"https:\/\/devoteam.info\/pt\/expert-view\/bigquery-uma-poderosa-interface-analitica-unificada-no-data-ocean\/#breadcrumb"},"inLanguage":"pt-PT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/devoteam.info\/pt\/expert-view\/bigquery-uma-poderosa-interface-analitica-unificada-no-data-ocean\/"]}]},{"@type":"ImageObject","inLanguage":"pt-PT","@id":"https:\/\/devoteam.info\/pt\/expert-view\/bigquery-uma-poderosa-interface-analitica-unificada-no-data-ocean\/#primaryimage","url":"https:\/\/devoteam.info\/wp-content\/uploads\/2025\/06\/big-data-Istock_000021034262.jpg","contentUrl":"https:\/\/devoteam.info\/wp-content\/uploads\/2025\/06\/big-data-Istock_000021034262.jpg","width":780,"height":450},{"@type":"BreadcrumbList","@id":"https:\/\/devoteam.info\/pt\/expert-view\/bigquery-uma-poderosa-interface-analitica-unificada-no-data-ocean\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/devoteam.info\/pt\/"},{"@type":"ListItem","position":2,"name":"Expert View","item":"https:\/\/devoteam.info\/pt\/expert-view\/"},{"@type":"ListItem","position":3,"name":"BigQuery: uma poderosa interface anal\u00edtica unificada no Data Ocean"}]},{"@type":"WebSite","@id":"https:\/\/devoteam.info\/pt\/#website","url":"https:\/\/devoteam.info\/pt\/","name":"Devoteam","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/devoteam.info\/pt\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"pt-PT"}]}},"uagb_featured_image_src":{"full":["https:\/\/devoteam.info\/wp-content\/uploads\/2025\/06\/big-data-Istock_000021034262.jpg",780,450,false],"thumbnail":["https:\/\/devoteam.info\/wp-content\/uploads\/2025\/06\/big-data-Istock_000021034262-150x150.jpg",150,150,true],"medium":["https:\/\/devoteam.info\/wp-content\/uploads\/2025\/06\/big-data-Istock_000021034262-300x173.jpg",300,173,true],"medium_large":["https:\/\/devoteam.info\/wp-content\/uploads\/2025\/06\/big-data-Istock_000021034262-768x443.jpg",768,443,true],"large":["https:\/\/devoteam.info\/wp-content\/uploads\/2025\/06\/big-data-Istock_000021034262.jpg",780,450,false],"1536x1536":["https:\/\/devoteam.info\/wp-content\/uploads\/2025\/06\/big-data-Istock_000021034262.jpg",780,450,false],"2048x2048":["https:\/\/devoteam.info\/wp-content\/uploads\/2025\/06\/big-data-Istock_000021034262.jpg",780,450,false]},"uagb_author_info":{"display_name":"aleksandra.juda","author_link":"https:\/\/devoteam.info\/pt\/author\/"},"uagb_comment_info":0,"uagb_excerpt":"Sim, eu disse\u00a0Data Ocean\u00a0e n\u00e3o\u00a0Data Warehouse\u00a0ou\u00a0Data Lake! Isto porque ambos s\u00e3o conceitos normalmente restritos a um determinado dom\u00ednio, tal como uma organiza\u00e7\u00e3o, que atualmente \u00e9 limitado para as capacidades do\u00a0BigQuery.\u00a0 A Google tem trabalhado para aumentar as capacidades do BigQuery e torn\u00e1-lo cada vez mais uma interface anal\u00edtica unificada em qualquer n\u00edvel de armazenamento, independentemente&hellip;","_links":{"self":[{"href":"https:\/\/devoteam.info\/pt\/wp-json\/wp\/v2\/expert-view\/651764","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devoteam.info\/pt\/wp-json\/wp\/v2\/expert-view"}],"about":[{"href":"https:\/\/devoteam.info\/pt\/wp-json\/wp\/v2\/types\/expert-view"}],"version-history":[{"count":0,"href":"https:\/\/devoteam.info\/pt\/wp-json\/wp\/v2\/expert-view\/651764\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devoteam.info\/pt\/wp-json\/wp\/v2\/media\/651765"}],"wp:attachment":[{"href":"https:\/\/devoteam.info\/pt\/wp-json\/wp\/v2\/media?parent=651764"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devoteam.info\/pt\/wp-json\/wp\/v2\/categories?post=651764"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devoteam.info\/pt\/wp-json\/wp\/v2\/tags?post=651764"},{"taxonomy":"industry","embeddable":true,"href":"https:\/\/devoteam.info\/pt\/wp-json\/wp\/v2\/industry?post=651764"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}