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 próximo proyecto con un crédito gratis de $300
Crea y prueba una prueba de concepto con los créditos de la prueba gratuita y el uso mensual gratuito de más de 20 productos.
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
How to use Retrieval Augmented Generation (RAG)
Get familiar with RAG → https://goo.gle/3YclIUC What is RAG? → https://goo.gle/4hahoOi What is Retrieval Augmented Generation (RAG) and how does it enhance generative AI capabilities in apps? Watch along as Googlers Aja Hammerly and Jason Davenport
Dataflow for IoT galactic research
What if you could harness your IoT data to instantly predict anomalies, optimize performance, and make split second business decisions. Dataflow provides the speed and scale you need to turn raw sensor data into actionable intelligence. Watch more
Dataflow for real-time IoT analytics
Deploy sample code → https://goo.gle/3zGVK3u One-pager with use cases & case studies → https://goo.gle/3Y3tgdt Unlock the power of real-time insights from Internet of Things (IoT) devices with Dataflow. Discover how Dataflow can process high
Dataflow: Real-time clickstream analytics
Every click, scroll, and interaction on your website or app tells a story. Follow those stories with Dataflow for real-time clickstream analytics and unlock valuable insights from user interactions to transform your business. Watch more Dataflow
Dataflow for Real-time Clickstream Analytics
Real-time Clickstream Analytics with Dataflow → https://goo.gle/3TRfw37 Deploy sample code → https://goo.gle/3zGVK3u One-pager with use cases & case studies → https://goo.gle/3Y3tgdt Unlock the secrets of customer behavior with real-time
🌌 How to run ads across the galaxy with Dataflow
Don’t let slow data processing keep you from reaching your customers. Learn to create pipelines that unify and analyze data from various sources and enable personalized experiences. Discover how Dataflow helps you enrich data with machine learning
Dataflow for Real-time Marketing Intelligence
Real-time Marketing Intelligence with Dataflow → https://goo.gle/3THkUWe Deploy sample code → https://goo.gle/4gDavVt One-pager with use cases & case studies → https://goo.gle/3zxhqPu Don’t let slow data processing keep you from reaching your
How Dataflow helps astronauts and you 🚀
How do space scientists build real-time pipelines that capture, process, and analyze logs from any source? Check out the latest Dataflow Solutions video for an indepth look at Dataflow with Jeff Nelson. Watch more Dataflow Solutions for Developers
Dataflow for Real-time Log Replication and Analytics
Deploy sample code → https://goo.gle/3TA3omR Streamline your log replication and analysis with Dataflow! Learn to build real-time pipelines that capture, process, and analyze logs from any source. See examples like detecting IoT sensor anomalies,
Is slow data holding you back?
Build and deploy real-time ETL pipelines that process data streams from diverse sources and deliver insights in seconds. Learn how Dataflow's unified approach to batch and streaming data, combined with its auto-scaling capabilities and real-time
Dataflow for Real-time ETL and Integration
Real-time ETL / Integration with Dataflow → https://goo.gle/4gjEOjM Deploy sample code → https://goo.gle/3TqDORb Dataflow templates → https://goo.gle/3XdI8UQ Build and deploy real-time ETL pipelines that process data streams from diverse sources and
Supercharge your business with Dataflow
Build and deploy real-time machine learning and generative AI pipelines with Google Cloud’s Dataflow. Make predictions on the fly using custom or pre-trained models and seamlessly integrate with Vertex AI to unlock the full potential of your
Dataflow for Real-time ML and Generative AI
Real-time ML and generative AI with Dataflow → https://goo.gle/3MVpUmF Start building with Dataflow ML → https://goo.gle/3XxfnE0 Deploy with sample code → https://goo.gle/3XvlNng Build and deploy real-time machine learning and generative AI pipelines
New Way Now: Zebra Technologies drives retail transformation with Google Cloud
𝗦𝘂𝗺𝗺𝗮𝗿𝘆: Drew Ehlers, head of global partners and global futurist for Zebra Technologies, shares how Google Cloud is helping the innovative mobile computing leader deliver on-device AI capabilities to drive better work and customer experiences. With
Bring the power of machine learning to the world of streaming data
Take the next step in your AI/ML journey with streaming data. Learn to deploy and manage complete ML pipelines to run inference and predictions, classify images, run remote inference calls, build a custom model handler, and much more with the latest
Supercharge Your Streaming Data: AI/ML Made Easy with Beam and Dataflow
Dataflow ML Documentation → https://goo.gle/4aMiaN9 Github Notebooks → https://goo.gle/3wRPZi5 Learn how Dataflow and Beam can help you easily craft and manage a streaming pipeline with AI/ML. Subscribe to Google Cloud Tech →
Connecting data sources with AI
In this exciting demo Luka Fontanilla, Custom Engineer Google Cloud, demonstrates a Google LLM with multiple data sources and rich analysis powered by AI. Watch along as Luka shows the power of BigQuery, Looker, Google Maps Platform, and how to
New Way Now: Macquarie Bank is building a new way of interacting with financial services
Luis Uguina, Chief Digital Officer of Macquarie Bank, shares how Google Cloud is helping the financial services group remove traditional roadblocks and embrace the AI era. Macquarie Bank has gone all-in on cloud, utilizing Google Cloud services like
Understanding event driven architecture
Dive into the world of event-driven architectures (EDAs) and discover how they can revolutionize your software applications. In this video, explore the key concepts of EDAs, their benefits, and how to effectively implement them using Google Cloud's
Bringing machine learning to streaming data with a few lines of code
Streaming data presents a big opportunity to businesses across all industries to build delightful user experiences and drive operational efficiencies. Doing that requires data teams to apply machine learning to streaming data. Dataflow and its open
Data Analytics Deep Dives - BigQuery using AI/ML to build an AI Lakehouse
Learn how to build an analytics lakehouse from end to end in Google Cloud. An analytics lakehouse combines the benefits of data lakes and warehouses. We will create a unified platform for users, data engineers, data scientists and analysts. You will
Word clustering in a Dataflow ML Pipeline: Part 1
In this video, Aniket dives into how to run ML and NLP operations in a data processing pipeline at scale. In the first part of the demo, Aniket Agrawal, Strategic Cloud Engineer at Google, employs Dataflow ML for a well-known ML-NLP application
Word clustering in a Dataflow ML pipeline: Part 2
How do you seamlessly inspect the interactive pipeline data and export it as a Dataflow job? In this demo's second part, Aniket Agrawal, Strategic Cloud Engineer at Google, visualizes the PCollection outputs obtained in part one. Aniket also performs
How to run ML Inference with Apache Beam
RunInference → https://goo.gle/3kWnkC5 Machine Learning → https://goo.gle/3XR73wD Dataflow ML → https://goo.gle/3kWwMVL You’ve built a machine learning model and run it on your laptop for development and testing. However, you are ready for more
Troubleshoot Autoscaling in Dataflow - Part 2: Jobs not scaling up
Are your Dataflow jobs not scaling to maximum number of workers? In this video, we show you the step by step process to troubleshoot and resolve the issue where your Dataflow jobs are not scaling up to max workers, even though there is a requirement
Detecting fraud with Cloud Bigtable
Credit card fraud detection using Cloud Bigtable → https://goo.gle/3tlX6to With millions of daily credit card purchases, how can you detect which transactions are fraudulent before they complete? In this video, developer advocate Billy Jacobson shows
What is Dataflow Prime?
What is Dataflow? → https://goo.gle/3RnUEwN Dataflow Product Page → https://goo.gle/3T2FL3Y Dataflow Documentation → https://goo.gle/3evJh7W We’re excited to announce Dataflow Prime, the next generation of Dataflow: Google Cloud’s truly unified batch
How Sharechat is building India's Largest Content Ecosystem on Google Cloud
Learn how Sharechat has built a strong technical foundation on Google Cloud that allows them to massively scale their services effortlessly. Learn how the combination of GKE, Pub/Sub, Spanner, BigTable, Dataflow and BigQuery allowed Sharechat to
Troubleshoot Dataflow Permission Errors
Are you observing permission errors during the creation of Dataflow jobs? Is your Dataflow workflow failing with permission errors? Then check out this video where we introduce the Service Accounts and IAM roles and permissions required to create and
Troubleshoot Slow or Stuck Jobs in Google Cloud Dataflow
Are you experiencing slowness with your jobs or your jobs getting stuck in Cloud Dataflow? Slow/Stuck Dataflow jobs can be caused by a number of factors, but they can be investigated and solved with a handful of steps! Check out this video to learn
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.