Google Cloud | Swipe Insight

BigQuery adds WITH expressions for temporary variables in GoogleSQL queries

1 days ago

BigQuery now supports WITH expressions in GoogleSQL to create temporary variables within queries. Variables are assigned once and can be used in subsequent expressions but not as arguments in aggregate or analytic functions. Each variable is evaluated once. This feature differs from WITH clauses and allows for cleaner, modular queries with examples showing concatenation, random value evaluation, and aggregate calculations.

BigQuery Update Enabling advanced runtime with short query optimizations in preview

2 days ago

BigQuery

BigQuery's advanced runtime now includes short query optimizations in preview, which reduce latency and slot use by running some queries as a single stage. These optimizations depend on data scan size, data movement, filter selectivity, data layout, query structure, and past execution stats. Enable or disable this runtime using ALTER PROJECT or ALTER ORGANIZATION statements with query_runtime set to 'advanced' or NULL. Changes take minutes to apply.

Looker Studio Pro adds Code Interpreter for advanced data analysis in preview

15 days ago

Looker Studio

The Code Interpreter is now available in Preview for Looker Studio Pro. It translates natural language questions into Python code to perform advanced analysis and visualizations. Disabled by default, it supports a wide range of analytics, from basic computations to time series forecasting, enhancing Conversational Analytics without needing advanced coding skills. Available in Looker Studio Pro, Looker original, and Google Cloud core.

BigQuery Introduces New Vector Index Management and Data Loading Features

20 days ago

BigQuery

BigQuery introduces VECTOR_INDEX.STATISTICS to track data drift and ALTER VECTOR INDEX REBUILD for index maintenance, both in Preview. Access Transparency now covers BigQuery data prep in GA. New Preview options for CREATE EXTERNAL TABLE and LOAD DATA include null_markers for NULL strings and source_column_match for column mapping. MATCH_RECOGNIZE clause adds pattern recognition in SQL queries, enhancing analytical capabilities.

Marketing Workflow Templates

Featured

Markifact offers ready-to-use marketing workflow templates to save time and automate digital marketing tasks. It is a no-code platform that enables users to create AI-powered workflows for automating decisions and actions across various marketing channels. Scale your marketing with agentic workflows, start using Markifact now for free!

BigQuery launches DISTINCT pipe operator for selecting unique rows in queries

22 days ago

BigQuery

BigQuery now supports the DISTINCT pipe operator in pipe syntax queries, which returns distinct rows from an input table while preserving table aliases. It works like SELECT DISTINCT or UNION DISTINCT but can be used anywhere in the query. It computes distinct rows based on all visible columns, ignoring pseudo-columns, and does not expand value table fields. This feature is generally available.

Looker Studio Adds Report Abuse Feature and Boosts BigQuery Performance

23 days ago

Looker Studio

Google's Looker Studio added a report abuse feature letting viewers flag inappropriate content, which is then reviewed and removed or hidden. Performance improvements were made for BigQuery data sources, including a short query optimized mode that speeds up queries under certain credential conditions, enhancing response times without changing workflows for data source owners.

BigQuery Sharing Listings Can Now Be Monetized on Google Cloud Marketplace

28 days ago

BigQuery

You can commercialize BigQuery sharing listings on Google Cloud Marketplace using Analytics Hub. Publishers list data products with pricing and duration options, while subscribers find and use datasets. Required IAM roles and enabling the Analytics Hub API are needed. Listings link Sharing and Cloud Marketplace, creating linked datasets. Subscriptions are managed via Cloud Marketplace orders with standard pricing and revenue sharing.

Google Introduces Automated Data Insights Feature for BigQuery with Gemini Integration

1 months ago

BigQuery

Google launched an automated data insights feature for BigQuery with Gemini integration that creates natural language questions and SQL queries from metadata, helping analysts explore datasets efficiently. It reveals patterns, checks data quality, and aids analysis without starting from scratch. A Preview feature auto-generates table and column descriptions to improve documentation and discoverability.

BigQuery adds configuration settings and new data loading features

2 months ago

BigQuery

Google BigQuery now allows admins to customize the BigQuery Studio interface for projects or organizations. It supports Spanner external datasets with enhanced security features. Data loading options include time zone and date/time formatting parameters in preview. A new Apache Spark demo notebook is available to demonstrate serverless Spark capabilities. These updates improve integration, flexibility, and user experience.