BigQuery News & Updates for December 2024

Google Cloud Code Extension Adds BigQuery Support in VS Code

4 days ago

Google Cloud has enhanced its Visual Studio Code extension with BigQuery support in preview, allowing developers to work with BigQuery datasets and notebooks directly in VS Code. New features include creating and executing BigQuery notebooks using Python kernels and managing datasets by browsing and previewing them. Developers can access these features through the Google Cloud Code section in VS Code and must install the bigframes client library.

The Ultimate Google Analytics Audit Tool

Featured

Get the most out of your Google Analytics data with Marketing Auditor – a powerful tool that helps you uncover and fix errors in minutes. Generate white-label reports packed with actionable insights and a customized action plan to optimize your analytics setup effortlessly. Customize reports with professional themes or your branding, and export them in editable formats like PowerPoint or Google Slides.

BigQuery Introduces Commercial Data Sharing via Cloud Marketplace

5 days ago

BigQuery

Google has updated BigQuery, allowing Analytics Hub publishers to monetize their data offerings via Google Cloud Marketplace. This integration facilitates scalable data sharing. Publishers can list data products, manage specifications, pricing models, and subscription durations. Subscribers benefit from a broader selection of data products, but face limitations, such as standard Analytics Hub restrictions and no support for data clean rooms.

Google Sheets Integrates BigQuery Saved Queries

1 months ago

Google Sheets BigQuery

Google now allows users to search and use pre-defined BigQuery queries directly within Google Sheets Connected Sheets, improving data analysis efficiency. Access saved queries via Connection Settings, Edit connection, Saved queries and query editor, and Project-based search. The feature is rolling out to all domains, expected to complete by December 6, 2024, and is available to Google Workspace customers, Workspace Individual Subscribers, and personal users.

BigQuery Expands Search Index Capabilities with INT64 and TIMESTAMP Support

1 months ago

BigQuery

BigQuery has announced a significant enhancement to its search indexing capabilities, now supporting `INT64` and `TIMESTAMP` data types in search index creation. This feature has reached general availability (GA) status. The complete list of supported data types now includes STRING, INT64, TIMESTAMP, ARRAY<PRIMITIVE_DATA_TYPE>, STRUCT (with supported nested fields), and JSON (with supported nested fields).

Google Ends Free Access to Gemini in BigQuery, Announces Paid Plans

1 months ago

BigQuery

Google announced that Gemini integration in BigQuery will transition from free to paid access, ending the free period on January 27, 2025. Users must choose between BigQuery Enterprise Plus edition reservations or a Gemini Code Assist Enterprise license. Compliance considerations include differing security features from standard BigQuery. Organizations can restrict Gemini access. This change marks Google's move to monetize AI integration.

Google Cloud Enhances Looker with Major User Experience Updates

1 months ago

BigQuery Looker

Google Cloud has rolled out significant updates to both Looker versions, focusing on improving user experience and streamlining onboarding processes. Key updates include a redesigned homepage with an intuitive design, a dedicated Create menu, workspace-inspired interface, streamlined viewing options, and enhanced navigation. BigQuery integration now features Quick Connect for simplified connection and faster setup.

BigQuery Launches Gemini-Enhanced SQL Translation Features

1 months ago

BigQuery

Google BigQuery has introduced new AI-powered SQL translation capabilities using the Gemini model. Features include customizable GoogleSQL translations, translation rule creation, migration-specific adjustments, location-specific support, and rule-based translation modifications. Preview features offer AI-powered translation suggestions, Gemini model integration, configuration YAML file support, automated batch processing, and enhanced accuracy.

BigQuery Data Transfer Service Launches Data Source Change Log for Schema Updates

1 months ago

BigQuery

The BigQuery Data Transfer Service data source change log provides details about upcoming changes to data source schemas and schema mappings. Users can search for data sources like Google Ads API or Facebook Ads API for specific changes. For example, in January 2025, the Google Ads API will update from v16 to v18, affecting column values in certain tables. Users should update their SQL queries to accommodate these changes.

BigQuery Introduces AI-Augmented Data Preparation with Gemini

1 months ago

BigQuery

BigQuery data preparation uses AI to clean, transform, and enrich data, reducing manual effort. Dataform supports CI/CD processes. Users need IAM roles. Managed in BigQuery Studio, Gemini provides context-aware suggestions. Views include data, graph, and schema views. Write modes: full refresh, append, and incremental. Supported steps: source, transformation, filter, validation, join, and delete columns.

BigQuery News

FAQs

What are the top BigQuery updates I must know about in 2024?

What are the latest BigQuery news this month?

What are the best BigQuery tools that I should use?

What's the best source for BigQuery news and updates?

Is there a BigQuery newsletter I can subscribe to?