Concept | AI SQL Assistant

Dataiku’s AI SQL assistant allows users of all levels to develop SQL queries using plain language in notebooks or recipes.

You can write what you’d like the code to accomplish, and create SQL code using Generative AI.

Important

Administrators need to enable AI SQL Assistant under Administration > Settings > AI Services. The assistant uses Dataiku’s AI Services, and no separate Large Language Model (LLM) connection is required.

Use case

In either a SQL notebook or SQL recipe, users can write their plain language into the Generate tab. The assistant will translate the prompt into SQL and return a reasoning explaining the code.

In a SQL notebook, the assistant will generate SQL based on all tables found in the current Dataiku project.

In a SQL recipe, the assistant will generate SQL based on the input table(s) of the recipe.

What’s next?

Learn about Dataiku’s other AI assistants:

• How-to | Generate Prepare recipe steps with AI

• Concept | Generate recipes using Generative AI

• AI Code Assistant

You can also check out Dataiku’s other Generative AI features by visiting by visiting Generative AI and Large Language Models (LLMs)!