documentación de BigQuery
BigQuery es el almacén de datos de estadísticas rentable, a escala de petabytes y completamente administrado de Google Cloudque te permite ejecutar estadísticas en grandes cantidades de datos casi en tiempo real. Con BigQuery, no debes configurar ni administrar ninguna infraestructura, lo que te permite enfocarte en encontrar estadísticas significativas mediante GoogleSQL y aprovechar los modelos de precios flexibles en las opciones a pedido y de tasa fija. Más información
Comienza tu prueba de concepto con un crédito gratis de USD 300
- Accede a Gemini 2.0 Flash Thinking
- Uso mensual gratuito de productos populares, incluidas las APIs de IA y BigQuery
- Sin cargos automáticos y sin compromisos
Recursos de documentación
Guías
-
Guías de inicio rápido: consola, línea de comandos, o bibliotecas cliente
-
Crea y usa tablas
-
Introducción a las tablas particionadas
-
Introducción a BigQuery ML
-
Funciones y permisos predefinidos
-
Introducción a la carga de datos
-
Carga datos de CSV desde Cloud Storage
-
Exporta datos de tablas
-
Crea modelos de aprendizaje automático en BigQuery ML
-
Consulta fuentes de datos externas
Reference
-
Funciones en GoogleSQL
-
Operadores de GoogleSQL
-
Expresiones condicionales en GoogleSQL
-
Funciones de fecha en GoogleSQL
-
Sintaxis de consulta en GoogleSQL
-
Funciones de string en GoogleSQL
-
Usa la herramienta de línea de comandos de bq
-
Recorrido de extremo a extremo para los modelos de aprendizaje automático
-
Bibliotecas cliente de la API de BigQuery
-
Crea y entrena modelos
Recursos relacionados
Videos relacionados
New Way Now: Radisson Hotel Group makes every moment matter with multilingual customers experiences
*Featured in this video:* Velit Dundar, vice president of global ecommerce at Radisson Hotel Group *Executive summary:* With over 1,400 hotels spanning nearly 100 countries, Radisson Hotel Group was looking for a way to personalize its marketing
RAG with BigQuery
Check out the course on Google Cloud Skills Boost → http://goo.gle/4gpchIs AI is powerful, but it can also hallucinate. In this video, we'll show you how to overcome this challenge by building a RAG pipeline with BigQuery. We'll walk through the
New Way Now: SAP fuels innovation by transforming data into solutions with AI-powered analytics
*Summary:* Frederik Pohl, vice president and head of strategic cloud management at SAP, leads the team responsible for orchestrating the enterprise software giant’s cloud strategy across their own infrastructure and with large partners like Google.
Bauli Improves Efficiency and Forecasts with Google Cloud's AI and BigQuery
Discover how 100-year-old Italian bakery Bauli blends tradition and innovation with Google Cloud. Their Digital Lab leverages AI and BigQuery to optimize stock, streamline processes, and drive sustainable growth. Learn how Vertex AI helps them
Google Cloud Mainframe Connector
Google Cloud Mainframe Connector allows organizations to unlock the full potential of their mainframe data - establishing an agile and highly cost efficient Enterprise Data Warehouse in Google Cloud, iteratively populated with fresh data from the
Looker Conversational Analytics
Conversational Analytics comes to Gemini → https://goo.gle/3Zh9sUt Query your data in natural language → https://goo.gle/3ARMNot Gemini in Looker → https://goo.gle/3ZgC1BC Unlock the power of your data with Looker Conversational Analytics. This video
How leading organizations are unifying data and AI to create powerful customer experiences
Unlock the potential of your data and AI with Google Cloud. This video showcases how leading companies like Shopify, Character.AI, Priceline, and Alaska Airlines use BigQuery, AlloyDB, Vertex AI, and Looker to gain actionable insights and build
New Way Now: Mercado Libre is boxing up real-time data delivery with Google Cloud
*Summary:* Diego Delgado, software senior expert for cloud and platform services at Mercado Libre, shares how Google Cloud helped the online marketplace make a big data move towards AI innovation. Mercado Libre migrated its messaging service to
New Way Now: Arpalus is reimagining retail inventory management with Google Cloud
*Summary:* Ofir Zilberberg, the CEO of Arpalus, shares how Google Cloud is helping the retail tech company leverage AI to put a fresh spin on managing the retail shelf. With Google Cloud, Arpalus leveraged advanced AI technologies, such as computer
New Way Now: The Home Depot is renovating DIY experiences with data and AI
*Summary:* Chris Black, chief architect and vice president of information technology at The Home Depot, shares how Google Cloud is helping the world’s largest home improvement retailer embrace AI innovation to remodel its future. With Google Cloud,
Introducing pipe syntax in BigQuery and Cloud Logging
BigQuery pipe syntax documentation → https://goo.gle/4dFaZrB Pipe syntax examples and reference guide → https://goo.gle/3U1wcF3 Blog: Introducing pipe syntax in BigQuery and Cloud Logging → https://goo.gle/3ZUr75l Writing complex SQL queries can be
New Way Now: Technogym personalizes fitness with generative AI
*Summary:* Technogym uses Google Cloud's generative AI to power Technogym Coach, an AI-based virtual trainer that delivers personalized fitness programs and motivates users to achieve their goals. *Challenge:* Providing personalized fitness
Persistent runtimes for notebooks ❌⌛️📒 #ProTip
Tired of losing your variables and having your scripts die? 😠 Persistent notebooks are so easy to set up and a great lightway approach for long-term analytics projects. 🙌 #BigQuery #Python #Notebooks #JupyterNotebook #DataScience #MachineLearning
Boost Productivity with Gemini in BigQuery
Ready to boost productivity? → https://goo.gle/3Yew3R9 Tired of struggling with data cold starts, endless data prep, and complex code? Meet Gemini in BigQuery, your new AI-powered assistant for data analysis! 🚀 In this video, join Diane and Tate as
New Way Now: Connected-Stories revolutionizes creative workflows with generative AI
*Summary:* Connected-Stories is a platform that leverages generative AI to help businesses create dynamic, personalized content at scale. This allows advertisers to build lasting customer relationships in a way that was not possible before.
New Way Now: Wayfair furnishes a new era of developer productivity with Google Cloud's AI
𝗦𝘂𝗺𝗺𝗮𝗿𝘆: Niraj Nagrani, VP and GM for Consumer and Supplier Technologies at Wayfair, shares how the global home furnishings giant is partnering with Google Cloud to supercharge its technology transformation. Discover how Wayfair is using Google
Gemini for Developers - BigQuery
Analyzing in BigQuery with Remote Models → https://goo.gle/4gE1jAo Join the Google Cloud Innovators Program → https://goo.gle/3MVmu3h Want to learn more about how you can use Gemini with BigQuery? In this video, Chloe Condon (Developer Relations
Visualize BigQuery data with Looker
Looker + BigQuery solutions → https://goo.gle/4gzuCE9 Learn how to transform your raw BigQuery data into captivating visualizations and actionable insights. This video demonstrates how to seamlessly connect and visualize your BigQuery data using
New Way Now: Priceline gets travelers to their happy places at happy prices with data and AI
𝗦𝘂𝗺𝗺𝗮𝗿𝘆: Sachin Menon, vice president of engineering — data, marketing, and FinTech technology at Priceline, shares how the online travel agency is innovating with cloud technology to help travelers plan their next trip with ease and efficiency. With
Migrate to BigQuery with Google Cloud
BigQuery is a fully managed, AI-ready data analytics platform that helps you maximize value from your data and is designed to be multi-engine, multi-format, and multi-cloud. Up to 54% lower TCO compared to alternative cloud data warehouses offerings
🦸⚡️📈 Supercharge BigQuery with Claude
Integrating Anthropic's Claude models into BigQuery opens new doors for advanced analytics and insights. From security enhancements to content localization, the possibilities are vast. Learn how in this quick tutorial. Read more →
New Way Now: Broadcom connects and protects the digital world with the help of AI
𝗦𝘂𝗺𝗺𝗮𝗿𝘆: Rich Jardine, VP of Cloud Platform Engineering and Operations at Broadcom, discusses their unique partnership with Google Cloud, and how the global infrastructure technology leader is modernizing its infrastructure and building a scalable
Streamline Your SQL Workflows with Dataform: A Step-by-Step Guide
Interested in learning more about SQL in BigQuery? → https://goo.gle/3ZiCS53 Just like crafting the perfect ice cream requires a well-orchestrated process, SQL workflows demand a streamlined approach. In this video, we'll guide you through setting up
New Way Now: Fortenova is using AI to build a waste-free future with Google Cloud
𝗦𝘂𝗺𝗺𝗮𝗿𝘆: Bojan Radlovic, chief digital officer at Fortenova Group, shares how Google Cloud is helping the leading food producer and retailer leverage AI to tackle critical global issues. With Google Cloud, Fortenova Group created an AI inventory
Customer Voices: Monzo
Monzo, the UK's largest digital bank, tells us how they're using Google Cloud BigQuery, Looker and Vertex to support their business, from things such as incident management, fraud detection and financial crime. Learn more about Monzo here:
🤯 Ask your BigQuery questions with Gemini powered natural language
Tired of wrestling with SQL? BigQuery lets you ask questions in plain English & get instant answers. 🚀 Watch how! #shorts #BigQueryTips #DataMadeEasy
New Way Now: Juganu is reshaping the world of retail with Google Cloud
𝗦𝘂𝗺𝗺𝗮𝗿𝘆: Roger Bigio, chief revenue officer of Juganu, shares how Google Cloud is helping the AI platform to automate and digitize the physical store. With Google Cloud, Juganu is unlocking new AI-powered insights and advanced analytics capabilities
New Way Now: Shopify is building the future of ecommerce on a modern data & AI platform
𝗦𝘂𝗺𝗺𝗮𝗿𝘆: Rajpreet Bajwa, director of engineering for data and ML at Shopify, shares how Google Cloud is helping the leading ecommerce platform unbox even more value for millions of online merchants. Using Google Cloud, Shopify completely
New Way Now: Cainz is renovating the customer experience with Google Cloud
𝗦𝘂𝗺𝗺𝗮𝗿𝘆: Kunie Aoyama, lead of the next-generation store product management at Cainz, shares how Google Cloud is helping the Japanese home improvement chain construct its autonomous, next generation store. Using Google Cloud, Cainz is using advanced
Unlock modern data sharing with Bobsled on BigQuery
Learn how teams that build in #bigquery can use #bobsled to securely share tables and views with external teams natively in their cloud data warehouse or file storage. Secure, #zerocopy sharing anywhere in the cloud. All without leaving BigQuery.
Prueba BigQuery
Crea una cuenta para evaluar el rendimiento de nuestros productos en situaciones reales.
Los clientes nuevos también obtienen $300 en créditos gratuitos para ejecutar, probar y, además, implementar cargas de trabajo.