Google's AI-Powered Gemini Now Available in Preview for Dataform Users

May 13, 2024 at 5:41:20 AM

TL;DR 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.

Google's AI-Powered Gemini Now Available in Preview for Dataform Users

Google's AI-powered collaborator, Gemini, is now available in preview for Dataform users to generate SQLX code. SQLX is an extension of SQL used in Dataform for managing and transforming data through scripts that combine SQL with additional configurations like js. Gemini's automation of script creation aims to reduce errors and enhance code quality.

Gemini, which has already been successful in BigQuery Studio, can generate SQL and Dataform core code inside .sqlx files in Dataform. It doesn't use your prompts or its responses as data for training its models and currently only supports English language prompts.

This update is particularly beneficial for data analysts, data scientists, and data developers who work with SQL workflows in Dataform and have knowledge of Google SQL syntax and how to create Dataform SQL workflow actions.

To use Gemini, users need to:

  • Go to the project selector page in the Google Cloud console.
  • Select or create a Google Cloud project.
  • Activate Gemini in BigQuery.
  • Provide Gemini with a natural language statement to generate a SQL or Dataform core query based on SQL workflow actions defined in your repository.

To improve Gemini's suggestions, users can:

  • Provide the SQL action name enclosed in backticks such as action_name.
  • If the column names or their semantic relationships are unclear or complex, provide context in the prompt to guide Gemini towards the desired answer. This technique is known as prompt engineering.

Q&A

Have more questions on this topic? Ask our AI assistant for in-depth insights.

The Only Digital Marketing Feed You'll Ever Need.

Stay informed your way. Tailored updates when and how you want them. 100% Free.

10,000+ Users

500+ Sources

1000+ Tools

Or

Related Posts

Switch from Scheduled Queries to Dataform for Google Analytics 4 BigQuery Export

Switch from Scheduled Queries to Dataform for Google Analytics 4 BigQuery Export

Automate Meta Ads Creative Generation and Uploading

Automate Meta Ads Creative Generation and Uploading

Featured
Markifact
Markifact

Verified Sponsor

Verified Sponsor

Markifact is a Verified Sponsor. Want to get featured here? Contact us.

Verified Sponsor
Google Ads launches Investment Strategy tab to optimize budget allocation

Google Ads launches Investment Strategy tab to optimize budget allocation

Thomas Eccel
Thomas Eccel

Top Creator

Top Google Ads Creator

Thomas Eccel is a Top Google Ads Creator. Part of Swipe Insight Select, a curated list of top creators.

Top Google Ads Creator
Meta is changing Post engagement to Interactions

Meta is changing Post engagement to Interactions

Bram Van der Hallen
Bram Van der Hallen

Top Creator

Top Meta Ads Creator

Bram Van der Hallen is a Top Meta Ads Creator. Part of Swipe Insight Select, a curated list of top creators.

Top Meta Ads Creator
YouTube rolls out new mental health support tools built for teens

YouTube rolls out new mental health support tools built for teens

YouTube
YouTube

Official Source

Official Source

YouTube is a Official Source. The source has been verified by Swipe Insight team.

Official Source
Instagram Revamps Teen Accounts with PG-13 Guidelines and New Parental Controls

Instagram Revamps Teen Accounts with PG-13 Guidelines and New Parental Controls

Meta
Meta

Official Source

Official Source

Meta is a Official Source. The source has been verified by Swipe Insight team.

Official Source
Google updates Misrepresentation policy for Shopping ads and Merchant Center listings

Google updates Misrepresentation policy for Shopping ads and Merchant Center listings

Google
Google

Official Source

Official Source

Google is a Official Source. The source has been verified by Swipe Insight team.

Official Source
Google Ads PMax Now Supports 9 by 16 Vertical Image Ads with New Specs

Google Ads PMax Now Supports 9 by 16 Vertical Image Ads with New Specs

Thomas Eccel
Thomas Eccel

Top Creator

Top Google Ads Creator

Thomas Eccel is a Top Google Ads Creator. Part of Swipe Insight Select, a curated list of top creators.

Top Google Ads Creator

Related Tools

Markifact logo

Markifact

Verified Tool

Verified Tool

Markifact is a Verified Tool. Want to get this badge? Contact us.

Verified Tool

Marketing Workflows Powered by AI

Featured
Marketing Auditor logo

Marketing Auditor

Verified Tool

Verified Tool

Marketing Auditor is a Verified Tool. Want to get this badge? Contact us.

Verified Tool

Automated audits for Google Ads and Analytics.

Get Featured Here

Showcase your tool in this list.

Contact Us
Databricks logo

Databricks

Generative AI-powered data intelligence platform

Data Engineering
Sisense logo

Sisense

AI-powered analytics for all skill levels

Data Engineering