AWS sagemaker-unified-studio documentation change
Summary
Restructured SQL query documentation with updated title, introduction, and topic organization. Added note about IAM Identity Center (IdC) domain behavior differences and reformatted supported query engines section into a table format.
Security assessment
The change adds documentation about IAM Identity Center (IdC) integration and how query editor features behave differently in IdC domains. This relates to identity and access management (a security feature) but does not indicate a specific security vulnerability being addressed. The change is primarily organizational and informational.
Diff
diff --git a/sagemaker-unified-studio/latest/userguide/sql-query.md b/sagemaker-unified-studio/latest/userguide/sql-query.md index 8b71171e8..7843647ab 100644 --- a//sagemaker-unified-studio/latest/userguide/sql-query.md +++ b//sagemaker-unified-studio/latest/userguide/sql-query.md @@ -9 +9 @@ Supported query engines -# SQL analytics +# Query data with SQL @@ -11 +11 @@ Supported query engines -You can use the query editor to perform analysis using SQL. The query editor tool provides a place to write and run queries, view results, and share your work with your team. +Use the query editor in Amazon SageMaker Unified Studio to write SQL queries, run them against your data sources, and visualize results, all within your project. You can work with multiple query engines, browse your data catalog, generate SQL using natural language, and schedule queries to run automatically. @@ -13 +13 @@ You can use the query editor to perform analysis using SQL. The query editor too -For information about getting started with the query editor, see [Get started with the query editor in Amazon SageMaker Unified Studio](./getting-started-querying.html). +###### Note @@ -15,3 +15 @@ For information about getting started with the query editor, see [Get started wi -###### Topics - - * [Navigate the query editor](./query-editor-navigate.html) +If your Amazon SageMaker Unified Studio domain uses IAM Identity Center (IdC), some query editor features behave differently. See [Query editor in IdC domains](./sql-query-idc.html) for details. @@ -19 +17 @@ For information about getting started with the query editor, see [Get started wi - * [Connect data resources](./query-connect-resources.html) +###### Topics @@ -23 +21 @@ For information about getting started with the query editor, see [Get started wi - * [Create a query](./query-create.html) + * [Get started with the query editor](./sql-query-get-started.html) @@ -25 +23 @@ For information about getting started with the query editor, see [Get started wi - * [Generative SQL](./generative-sql.html) + * [Write, run, and view query results](./sql-query-write-run.html) @@ -27 +25 @@ For information about getting started with the query editor, see [Get started wi - * [Review query history](./query-history.html) + * [Generate SQL with the Data Agent](./sql-query-data-agent.html) @@ -29 +27 @@ For information about getting started with the query editor, see [Get started wi - * [Schedule a query](./query-schedule.html) + * [Save, schedule, and review queries](./sql-query-save-share.html) @@ -30,0 +29 @@ For information about getting started with the query editor, see [Get started wi + * [Query editor in IdC domains](./sql-query-idc.html) @@ -34,8 +32,0 @@ For information about getting started with the query editor, see [Get started wi -## Supported query engines - -The Amazon SageMaker Unified Studio query editor supports the following query engines: - - * Amazon Redshift. For more information, see [Query processing](https://docs.aws.amazon.com/redshift/latest/dg/c-query-processing.html) in the Amazon Amazon Redshift Database Developer Guide. - - * Amazon Athena. For more information, see [Running SQL queries using Amazon Athena](https://docs.aws.amazon.com/athena/latest/ug/querying-athena-tables.html) in the Amazon Amazon Athena User Guide. - @@ -42,0 +34 @@ The Amazon SageMaker Unified Studio query editor supports the following query en +## Supported query engines @@ -43,0 +36 @@ The Amazon SageMaker Unified Studio query editor supports the following query en +The query editor supports the following engines. You can switch between engines within the same querybook. @@ -45 +38,4 @@ The Amazon SageMaker Unified Studio query editor supports the following query en -Both engines use Querybooks to develop queries and work with data from one place. You can change the query engine from the upper-right corner of the Querybook editor and selecting the data source you want to use from the dropdown menu. +Engine | Description | SQL reference +---|---|--- +Amazon Athena | Serverless query engine for data stored in Amazon S3 and AWS Glue Data Catalog. Best for ad-hoc queries against lakehouse data. | [Athena SQL reference](https://docs.aws.amazon.com/athena/latest/ug/ddl-sql-reference.html) +Amazon Redshift | Data warehouse engine for structured and semi-structured data. Best for complex analytical queries and joins across large datasets. | [Redshift SQL reference](https://docs.aws.amazon.com/redshift/latest/dg/c_redshift-sql.html) @@ -55 +51 @@ Share dashboards -Navigate the query editor +Get started with the query editor