Google Cloud | Swipe Insight

Google Launches Gemini AI-Powered Join Operations in BigQuery Data Preparation

7 days ago

Google has launched a Preview feature in BigQuery that uses Gemini AI for intelligent join operation recommendations. It provides context-aware suggestions and natural language processing for accurate joins, generating SQL expressions and descriptions. Users can access it in the data view interface, select join types, and preview results. The system defaults to a Cross join if no conditions are specified, allowing users to refine their options.

BigQuery Introduces JavaScript User-Defined Aggregate Functions

11 days ago

BigQuery

Google has announced the general availability of JavaScript User-Defined Aggregate Functions (UDAF) in BigQuery, allowing users to create custom aggregate functions using JavaScript. The process requires JavaScript code as a quoted string and implementation of four essential functions: initialState, aggregate, merge, and finalize. Persistent UDAFs are reusable, secure, and maintain data integrity. Users must use the CREATE AGGREGATE FUNCTION statement and include the dataset in the path.

BigQuery Enhances ML Bucketing Function and Set Operation Features

14 days ago

BigQuery

Google has improved its BigQuery ML platform with new features for bucketing functions and set operations. The ML.BUCKETIZE and ML.QUANTILE_BUCKETIZE functions now allow customizable output formatting through the output_format argument, supporting string format, interval notation, or JSON. Additionally, the BY NAME and CORRESPONDING modifiers are now available for set operations, enabling column matching by name and simplifying data manipulation.

BigQuery Adds Stored Column Usage Tracking for Vector Search Queries

19 days ago

BigQuery

Google launched a feature for BigQuery that tracks stored column usage in vector search queries. The StoredColumnsUsage feature includes three parts: reasons for unused columns, whether they sped up query execution, and the main table referenced. It employs a JSON structure to monitor these metrics, offering insights into query performance and stored column use, thus improving BigQuery's vector search capabilities.

Tired of spending too much time creating audits for your clients?

Featured

Marketing Auditor simplifies your audit process, letting you generate comprehensive, white-label reports in just a few clicks. Save over 10 hours per report while analyzing 200+ data points and delivering 50+ pages of actionable insights. Customize reports with professional themes or your own branding, and export them in editable formats like PowerPoint or Google Slides to showcase your expertise.

Google Delays Paid Access Requirement for Gemini in BigQuery

21 days ago

BigQuery

Google has enhanced BigQuery ML with new generative AI capabilities and improved access control features. Updates include remote model creation using open models from Vertex Model Garden or Hugging Face, support for text generation models like Llama and Gemma, and new functions like ML.GENERATE_TEXT and ML.EVALUATE. Google has also delayed Gemini procurement requirements, allowing users to access its features for free until further notice.

Looker Studio Unveils Major Updates with Modern Charts and Enhanced Pivot Tables

22 days ago

Looker Studio

Google's Looker Studio announced updates, introducing Modern charts in preview, improved pivot table functionality, and enhanced filter conditions for Looker data sources. Modern charts feature new color themes, rounded edges, line gradients, transparency controls, and customization options. Pivot tables can sort by any metric, and the 'Is Any' filter condition addresses blank parameters. Features are gradually released during the preview period.

Google Launches BigQuery Metastore for Unified Metadata Management

26 days ago

BigQuery

Google has launched BigQuery metastore, a fully managed service for unified metadata management in data analytics. Currently in preview, it allows users to access metadata from BigQuery and Apache Spark, supporting formats like Apache Iceberg. Its serverless architecture reduces operational overhead and enables automatic scaling. Users can create and query tables seamlessly across platforms.

Google Introduces Natural Language Data Preparation in BigQuery with Gemini

27 days ago

Gemini BigQuery

Google has integrated Gemini with BigQuery Studio for natural language data preparation, allowing users to transform data using conversational prompts instead of SQL queries. Key features include automated suggestions, contextual recommendations, and SQL generation from natural language. The platform supports filtering, column management, and join operations, simplifying workflows for users without extensive SQL expertise.

Google Updates BigQuery with Multi-Time Series Forecasting and Enhanced Security Features

1 months ago

BigQuery

Google has updated BigQuery with enhancements in machine learning and security. The preview of multi-time series forecasting in BigQuery ML includes the TIME_SERIES_ID_COL option, supporting various data types and allowing a forecasting horizon of up to 10,000 time points. Additionally, VPC allowlists are available for organizations to restrict access to AWS S3 buckets and Azure Blob Storage while managing permissions from specific BigQuery Omni VPCs.