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.
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.
Markifact automates the creation and uploading of Meta ads using AI. Users generate custom visuals and matching ad copy by writing detailed prompts and uploading reference images. Ads are uploaded in a paused status for review before going live. This tool allows for quick creation of multiple ad variations, adaptation to market trends, and scaling of campaigns without needing extensive design or copywriting resources.