You can view the following fields when you select Add or Replace from Column Action.

1. Enter a prompt in natural language or specify SQL for column: Select any one of the prompts suggested by the tool.
   Note
   
   The Data Studio suite of tools uses a Large Language Model (LLM) when using prompts to generate SQL.
2. Click Ask AI.

   The Ask AI button sends the prompt, along with the table metadata (not data) to the Large Language Model (LLM) that is selected in your Data Studio settings. The LLM then attempts to generate SQL that will perform the request of the prompt.

3. Select New Column to create a new column that consists of the updated new column.

   After you select New Column, you can view a text box where you specify the name of the new column.

   The SQL textbox displays the SQL code the tool generates to display the action performed by the column action you selected in the previous step.

4. Under Data Preview, you can view the existing old column and the generated new column.

After you have decided the column action, click Add Step to add this step in the main recipe panel.

Clicking Add Step closes the Add Step dialog and opens the Table AI assist page.