Generative SQL - Amazon SageMaker Unified Studio

Amazon SageMaker Unified Studio is in preview release and is subject to change.

Generative SQL

Amazon SageMaker Unified Studio allows you to create SQL queries by interacting with a chatbot powered by Amazon Q. The text-to-SQL interpreter understands the context of your data and generates SQL queries that you can use in your analysis.

You can find the Generative SQL tool in the Query Editor of a project.

Screenshot of Amazon SageMaker Unified Studio UI with Generative SQL option in use.

The Generative SQL chat application understands the context of your data and will let you ask natural language questions like "What are the columns in the job success table?", in order to generate SQL. When you ask a question, an SQL query is generated based on the question you have provided. After creating a query with the tool you can add the generated SQL to your querybook with a single click.

Once you have created a query, the query can be saved for later use by yourself or others with access to the project. Query results can be exported in CSV of JSON formats. You can create visualizations directly in the Query editor.