https://stackql.io/assets/js/64e5e29e.9dbf8746.js

1"use strict";(globalThis.webpackChunkstackql_io||=[]).push([[21012],{57847(e,r,s){s.r(r),s.d(r,{default:()=>t,metadata:()=>o});var o=s(64411),n=s(74848),i=s(28453);const l={authorsImageUrls:[void 0]};function a(e){const r={a:"a",code:"code",h2:"h2",li:"li",ol:"ol",p:"p",pre:"pre",strong:"strong",ul:"ul",...(0,i.R)(),...e.components};return(0,n.jsxs)(n.Fragment,{children:[(0,n.jsxs)(r.p,{children:["The latest versions of the Google-related providers for StackQL: ",(0,n.jsx)(r.code,{children:"google"}),", ",(0,n.jsx)(r.code,{children:"googleadmin"}),", ",(0,n.jsx)(r.code,{children:"googleworkspace"}),", and ",(0,n.jsx)(r.code,{children:"firebase"})," are available now. These updates include the latest services, resources and methods available from Google."]}),"\n",(0,n.jsx)(r.h2,{id:"whats-new",children:"What's New"}),"\n",(0,n.jsxs)(r.p,{children:["The latest release introduces several new services to the ",(0,n.jsx)(r.code,{children:"google"})," provider, expanding your ability to manage and query Google Cloud resources:"]}),"\n",(0,n.jsxs)(r.ul,{children:["\n",(0,n.jsxs)(r.li,{children:[(0,n.jsx)(r.strong,{children:"API Hub"}),": Centrally manage and discover APIs across your organization"]}),"\n",(0,n.jsxs)(r.li,{children:[(0,n.jsx)(r.strong,{children:"Area Insights"}),": Access location-based insights and analytics"]}),"\n",(0,n.jsxs)(r.li,{children:[(0,n.jsx)(r.strong,{children:"Cloud Location Finder"}),": Identify optimal Google Cloud regions for your workloads"]}),"\n",(0,n.jsxs)(r.li,{children:[(0,n.jsx)(r.strong,{children:"Gemini Cloud Assist"}),": Leverage Google's AI assistant for cloud operations"]}),"\n",(0,n.jsxs)(r.li,{children:[(0,n.jsx)(r.strong,{children:"Managed Kafka"}),": Work with Google's fully-managed Apache Kafka service"]}),"\n",(0,n.jsxs)(r.li,{children:[(0,n.jsx)(r.strong,{children:"Observability"}),": Enhanced monitoring and observability services"]}),"\n",(0,n.jsxs)(r.li,{children:[(0,n.jsx)(r.strong,{children:"Parallel Store"}),": Interact with Google's high-performance storage solution"]}),"\n",(0,n.jsxs)(r.li,{children:[(0,n.jsx)(r.strong,{children:"Parameter Manager"}),": Manage configuration parameters across services"]}),"\n",(0,n.jsxs)(r.li,{children:[(0,n.jsx)(r.strong,{children:"SaaS Service Management"}),": Tools for managing SaaS offerings on Google Cloud"]}),"\n",(0,n.jsxs)(r.li,{children:[(0,n.jsx)(r.strong,{children:"Secure Source Manager"}),": Google's secure, fully-managed source control service"]}),"\n",(0,n.jsxs)(r.li,{children:[(0,n.jsx)(r.strong,{children:"Security Posture"}),": Assess and improve your cloud security posture"]}),"\n",(0,n.jsxs)(r.li,{children:[(0,n.jsx)(r.strong,{children:"Storage Batch Operations"}),": Perform batch operations on Cloud Storage resources"]}),"\n"]}),"\n",(0,n.jsx)(r.h2,{id:"enhanced-documentation",children:"Enhanced Documentation"}),"\n",(0,n.jsx)(r.p,{children:"We've also released enhanced user documentation to help you get the most out of these providers. Check out our comprehensive docs:"}),"\n",(0,n.jsxs)(r.ul,{children:["\n",(0,n.jsx)(r.li,{children:(0,n.jsx)(r.a,{href:"https://firebase-provider.stackql.io/",children:"Firebase Provider"})}),"\n",(0,n.jsx)(r.li,{children:(0,n.jsx)(r.a,{href:"https://google-provider.stackql.io/",children:"Google Provider"})}),"\n",(0,n.jsx)(r.li,{children:(0,n.jsx)(r.a,{href:"https://googleadmin-provider.stackql.io/",children:"Google Admin Provider"})}),"\n",(0,n.jsx)(r.li,{children:(0,n.jsx)(r.a,{href:"https://googleworkspace-provider.stackql.io/",children:"Google Workspace Provider"})}),"\n"]}),"\n",(0,n.jsx)(r.h2,{id:"getting-started",children:"Getting Started"}),"\n",(0,n.jsxs)(r.p,{children:["To start using these updated providers, simply pull the latest version from ",(0,n.jsx)(r.code,{children:"stackql shell"})," or ",(0,n.jsx)(r.code,{children:"stackql registry"})," command:"]}),"\n",(0,n.jsx)(r.pre,{children:(0,n.jsx)(r.code,{className:"language-sql",children:"registry pull google;\r\nregistry pull googleadmin;\r\nregistry pull googleworkspace;\r\nregistry pull firebase;\n"})}

1),"\n",(0,n.jsx)(r.p,{children:"Then you can begin querying your Google resources with SQL:"}),"\n",(0,n.jsx)(r.pre,{children:(0,n.jsx)(r.code,{className:"language-sql",children:"SELECT name, region, status \r\nFROM google.compute.instances\r\nWHERE project = 'my-project';\n"})}),"\n",(0,n.jsx)(r.h2,{id:"use-cases-for-the-google-provider",children:"Use Cases for the Google Provider"}),"\n",(0,n.jsx)(r.p,{children:"The Google provider for StackQL opens up numerous possibilities:"}),"\n",(0,n.jsxs)(r.ol,{children:["\n",(0,n.jsxs)(r.li,{children:["\n",(0,n.jsxs)(r.p,{children:[(0,n.jsx)(r.strong,{children:"Infrastructure as Code"}),": Manage your Google resources alongside other cloud providers in a unified IaC approach, see ",(0,n.jsx)(r.a,{href:"https://stackql-deploy.io/",children:(0,n.jsx)(r.strong,{children:(0,n.jsx)(r.code,{children:"stackql-deploy"})})}),"."]}),"\n"]}),"\n",(0,n.jsxs)(r.li,{children:["\n",(0,n.jsxs)(r.p,{children:[(0,n.jsx)(r.strong,{children:"Cost Optimization"}),": Identify unused resources and opportunities for cost savings."]}),"\n"]}),"\n",(0,n.jsxs)(r.li,{children:["\n",(0,n.jsxs)(r.p,{children:[(0,n.jsx)(r.strong,{children:"Security and Compliance"}),": Audit account roles, permissions, and access patterns to ensure compliance with security policies."]}),"\n"]}),"\n",(0,n.jsxs)(r.li,{children:["\n",(0,n.jsxs)(r.p,{children:[(0,n.jsx)(r.strong,{children:"Performance Monitoring"}),": Track query performance, warehouse utilization, and identify optimization opportunities."]}),"\n"]}),"\n",(0,n.jsxs)(r.li,{children:["\n",(0,n.jsxs)(r.p,{children:[(0,n.jsx)(r.strong,{children:"Cross-Provider Orchestration"}),": Build workflows that span Google and other cloud providers, enabling sophisticated data and infrastructure pipelines."]}),"\n"]}),"\n",(0,n.jsxs)(r.li,{children:["\n",(0,n.jsxs)(r.p,{children:[(0,n.jsx)(r.strong,{children:"Automated Reporting"}),": Create automated reports on Google usage, performance, and costs."]}),"\n"]}),"\n"]}),"\n",(0,n.jsxs)(r.p,{children:["\u2b50 us on ",(0,n.jsx)(r.a,{href:"https://github.com/stackql/stackql",children:(0,n.jsx)(r.strong,{children:"GitHub"})})," and join our community!"]})]})}function t(e={}){const{wrapper:r}={...(0,i.R)(),...e.components};return r?(0,n.jsx)(r,{...e,children:(0,n.jsx)(a,{...e})}):a(e)}s.d(r,["assets",0,l,"contentTitle",0,void 0,"frontMatter",0,{slug:"updated-google-providers-available",title:"Updated Google Providers for StackQL Available",hide_table_of_contents:!1,authors:["jeffreyaven"],image:"/img/blog/stackql-googleadmin-provider-featured-image.png",description:"Query and interact with Google resources using SQL.",keywords:["stackql","google","firebase","iac","analytics"],tags:["stackql","google","firebase","iac","analytics"]},"toc",0,[{value:"What's New",id:"whats-new",level:2},{value:"Enhanced Documentation",id:"enhanced-documentation",level:2},{value:"Getting Started",id:"getting-started",level:2},{value:"Use Cases for the Google Provider",id:"use-cases-for-the-google-provider",level:2}]])},28453(e,r,s){s.d(r,{R:()=>l,x:()=>a});var o=s(96540);const n={},i=o.createContext(n);function l(e){const r=o.useContext(i);return o.useMemo(function(){return"function"==typeof e?e(r):{...r,...e}},[r,e])}function a(e){let r;return r=e.disableParentContext?"function"==typeof e.components?e.components(n):e.components||n:l(e.components),o.createElement(i.Provider,{value:r},e.children)}},64411(e){e.exports=JSON.parse('{"permalink":"/blog/updated-google-providers-available","editUrl":"https://github.com/stackql/stackql.io/edit/main/blog/2025-08-29-updated-google-providers-available.md","source":"@site/blog/2025-08-29-updated-google-providers-available.md","title":"Updated Google Providers for StackQL Available","description":"Query and interact with Google resources using SQL.","date":"2025-08-29T00:00:00.000Z","tags":[{"inline":true,"label":"stackql","permalink":"/blog/tags/stackql"},{"inline":true,"label":"google","permalink":"/blog/tags/google"},{"inline":true,"label":"firebase","permalink":"/blog/tags/firebase"},{"inline":true,"label":"iac","permalink":"/blog/tags/iac"},{"inline":true,"label":"analytics","permalink":"/blog/tags/analytics"}],"readingTime":1.93,"hasTruncateMarker":false,"authors":[{"name":"Jeffrey Aven","title":"Technologist and Cloud Consultant","url":"https://www.linkedin.com/in/jeffreyaven/","key":"jeffreyaven","page":null}

1],"frontMatter":{"slug":"updated-google-providers-available","title":"Updated Google Providers for StackQL Available","hide_table_of_contents":false,"authors":["jeffreyaven"],"image":"/img/blog/stackql-googleadmin-provider-featured-image.png","description":"Query and interact with Google resources using SQL.","keywords":["stackql","google","firebase","iac","analytics"],"tags":["stackql","google","firebase","iac","analytics"]},"unlisted":false,"prevItem":{"title":"New Okta Provider Released","permalink":"/blog/new-okta-provider-released"},"nextItem":{"title":"Snowflake Provider for StackQL Released","permalink":"/blog/snowflake-provider-for-stackql-released"}}')}}]);