BigQuery documentation
BigQuery is Google Cloud's fully managed, petabyte-scale, and cost-effective analytics data warehouse that lets you run analytics over vast amounts of data in near real time. With BigQuery, there's no infrastructure to set up or manage, letting you focus on finding meaningful insights using GoogleSQL and taking advantage of flexible pricing models across on-demand and flat-rate options. Learn more
Start your proof of concept with $300 in free credit
- Get access to Gemini 2.0 Flash Thinking
- Free monthly usage of popular products, including AI APIs and BigQuery
- No automatic charges, no commitment
Documentation resources
Guides
-
Quickstarts: Console, Command line, or Client libraries
-
Creating and using tables
-
Introduction to partitioned tables
-
Introduction to BigQuery ML
-
Predefined roles and permissions
-
Introduction to loading data
-
Loading CSV data from Cloud Storage
-
Exporting table data
-
Create machine learning models in BigQuery ML
-
Querying external data sources
Reference
-
Functions in GoogleSQL
-
Operators in GoogleSQL
-
Conditional expressions in GoogleSQL
-
Date functions in GoogleSQL
-
Query syntax in GoogleSQL
-
String functions in GoogleSQL
-
Using the bq command-line tool
-
End-to-end journey for machine learning models
-
BigQuery API Client Libraries
-
Creating and training models
Related resources
Related videos
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.
Try BigQuery for yourself
Create an account to evaluate how our products perform in real-world
scenarios.
New customers also get $300 in free credits to run, test,
and deploy workloads.