BigQuery has introduced a feature allowing users to view Query text within the Execution graph. This shows which part of the SQL corresponds to each stage step, helping identify bottlenecks. Users can see the source of each subquery, what data was read, aggregated, or written, and understand why certain steps, like the "0.28 sec Input," may be causing delays. This small UI update significantly aids in debugging and performance tuning.
Upload all Meta ad types in bulk directly from Google Sheets, single image, video, carousel, and flexible ads. Control placements, multiple headlines, primary texts, descriptions, and creatives from one spreadsheet. Built for agencies and teams managing dozens of ads across multiple accounts, helping you launch faster, stay consistent, and avoid costly manual errors.
Google's AI-powered collaborator, Gemini, is now available in preview for Dataform users to generate SQLX code. SQLX, an extension of SQL used in Dataform, manages and transforms data through scripts that combine SQL with additional configurations like js. Gemini automates script creation, reducing errors and improving code quality. The feature is currently in preview, hinting at the future of data transformation projects.