

# Data retrieval APIs for AWS SQL Workbench
<a name="awssqlworkbench"></a>

AWS SQL Workbench provides the following APIs for data retrieval.


****  

| Actions | Description | Access level | 
| --- | --- | --- | 
| <a name="sqlworkbench-BatchGetNotebookCell"></a>[https://docs.aws.amazon.com/redshift/latest/mgmt/redshift-policy-resources.resource-permissions.html](https://docs.aws.amazon.com/redshift/latest/mgmt/redshift-policy-resources.resource-permissions.html) | Get notebook cells content on your account | Read | 
| <a name="sqlworkbench-ExportNotebook"></a>[https://docs.aws.amazon.com/redshift/latest/mgmt/redshift-policy-resources.resource-permissions.html](https://docs.aws.amazon.com/redshift/latest/mgmt/redshift-policy-resources.resource-permissions.html) | Export a notebook on your account | Read | 
| <a name="sqlworkbench-GetAccountInfo"></a>[https://docs.aws.amazon.com/redshift/latest/mgmt/redshift-policy-resources.resource-permissions.html](https://docs.aws.amazon.com/redshift/latest/mgmt/redshift-policy-resources.resource-permissions.html) | Get account info | Read | 
| <a name="sqlworkbench-GetAccountSettings"></a>[https://docs.aws.amazon.com/redshift/latest/mgmt/redshift-policy-resources.resource-permissions.html](https://docs.aws.amazon.com/redshift/latest/mgmt/redshift-policy-resources.resource-permissions.html) | Get account settings | Read | 
| <a name="sqlworkbench-GetAutocompletionMetadata"></a>[https://docs.aws.amazon.com/redshift/latest/mgmt/redshift-policy-resources.resource-permissions.html](https://docs.aws.amazon.com/redshift/latest/mgmt/redshift-policy-resources.resource-permissions.html) | Get database structure metadata for auto-completion | Read | 
| <a name="sqlworkbench-GetAutocompletionResource"></a>[https://docs.aws.amazon.com/redshift/latest/mgmt/redshift-policy-resources.resource-permissions.html](https://docs.aws.amazon.com/redshift/latest/mgmt/redshift-policy-resources.resource-permissions.html) | Get database structure information for auto-completion | Read | 
| <a name="sqlworkbench-GetChart"></a>[https://docs.aws.amazon.com/redshift/latest/mgmt/redshift-policy-resources.resource-permissions.html](https://docs.aws.amazon.com/redshift/latest/mgmt/redshift-policy-resources.resource-permissions.html) | Get charts on your account | Read | 
| <a name="sqlworkbench-GetConnection"></a>[https://docs.aws.amazon.com/redshift/latest/mgmt/redshift-policy-resources.resource-permissions.html](https://docs.aws.amazon.com/redshift/latest/mgmt/redshift-policy-resources.resource-permissions.html) | Get connections on your account | Read | 
| <a name="sqlworkbench-GetNotebook"></a>[https://docs.aws.amazon.com/redshift/latest/mgmt/redshift-policy-resources.resource-permissions.html](https://docs.aws.amazon.com/redshift/latest/mgmt/redshift-policy-resources.resource-permissions.html) | Get notebook metadata on your account | Read | 
| <a name="sqlworkbench-GetNotebookVersion"></a>[https://docs.aws.amazon.com/redshift/latest/mgmt/redshift-policy-resources.resource-permissions.html](https://docs.aws.amazon.com/redshift/latest/mgmt/redshift-policy-resources.resource-permissions.html) | Get the content of a notebook version on your account | Read | 
| <a name="sqlworkbench-GetQCustomContext"></a>[https://docs.aws.amazon.com/redshift/latest/mgmt/redshift-policy-resources.resource-permissions.html](https://docs.aws.amazon.com/redshift/latest/mgmt/redshift-policy-resources.resource-permissions.html) | Get account-wide custom context | Read | 
| <a name="sqlworkbench-GetQSqlPromptQuotas"></a>[https://docs.aws.amazon.com/redshift/latest/mgmt/redshift-policy-resources.resource-permissions.html](https://docs.aws.amazon.com/redshift/latest/mgmt/redshift-policy-resources.resource-permissions.html) | Get Q generative SQL maximum prompt quotas | Read | 
| <a name="sqlworkbench-GetQSqlRecommendations"></a>[https://docs.aws.amazon.com/redshift/latest/mgmt/redshift-policy-resources.resource-permissions.html](https://docs.aws.amazon.com/redshift/latest/mgmt/redshift-policy-resources.resource-permissions.html) | Get text to SQL recommendations | Read | 
| <a name="sqlworkbench-GetQueryExecutionHistory"></a>[https://docs.aws.amazon.com/redshift/latest/mgmt/redshift-policy-resources.resource-permissions.html](https://docs.aws.amazon.com/redshift/latest/mgmt/redshift-policy-resources.resource-permissions.html) | Get the query execution history on your account | Read | 
| <a name="sqlworkbench-GetSavedQuery"></a>[https://docs.aws.amazon.com/redshift/latest/mgmt/redshift-policy-resources.resource-permissions.html](https://docs.aws.amazon.com/redshift/latest/mgmt/redshift-policy-resources.resource-permissions.html) | Get saved query on your account | Read | 
| <a name="sqlworkbench-GetSchemaInference"></a>[https://docs.aws.amazon.com/redshift/latest/mgmt/redshift-policy-resources.resource-permissions.html](https://docs.aws.amazon.com/redshift/latest/mgmt/redshift-policy-resources.resource-permissions.html) | Get the columns and data types inferred from a file | Read | 
| <a name="sqlworkbench-GetSqlGenerationContext"></a>[https://docs.aws.amazon.com/redshift/latest/mgmt/redshift-policy-resources.resource-permissions.html](https://docs.aws.amazon.com/redshift/latest/mgmt/redshift-policy-resources.resource-permissions.html) | Get sql generation context | Read | 
| <a name="sqlworkbench-GetSqlRecommendations"></a>[https://docs.aws.amazon.com/redshift/latest/mgmt/redshift-policy-resources.resource-permissions.html](https://docs.aws.amazon.com/redshift/latest/mgmt/redshift-policy-resources.resource-permissions.html) | Get text to SQL recommendations | Read | 
| <a name="sqlworkbench-GetUserInfo"></a>[https://docs.aws.amazon.com/redshift/latest/mgmt/redshift-policy-resources.resource-permissions.html](https://docs.aws.amazon.com/redshift/latest/mgmt/redshift-policy-resources.resource-permissions.html) | Get user info | Read | 
| <a name="sqlworkbench-GetUserWorkspaceSettings"></a>[https://docs.aws.amazon.com/redshift/latest/mgmt/redshift-policy-resources.resource-permissions.html](https://docs.aws.amazon.com/redshift/latest/mgmt/redshift-policy-resources.resource-permissions.html) | Get workspace settings on your account | Read | 
| <a name="sqlworkbench-ListConnections"></a>[https://docs.aws.amazon.com/redshift/latest/mgmt/redshift-policy-resources.resource-permissions.html](https://docs.aws.amazon.com/redshift/latest/mgmt/redshift-policy-resources.resource-permissions.html) | List the connections on your account | List | 
| <a name="sqlworkbench-ListDatabases"></a>[https://docs.aws.amazon.com/redshift/latest/mgmt/redshift-policy-resources.resource-permissions.html](https://docs.aws.amazon.com/redshift/latest/mgmt/redshift-policy-resources.resource-permissions.html) | List databases of your redshift cluster | List | 
| <a name="sqlworkbench-ListFiles"></a>[https://docs.aws.amazon.com/redshift/latest/mgmt/redshift-policy-resources.resource-permissions.html](https://docs.aws.amazon.com/redshift/latest/mgmt/redshift-policy-resources.resource-permissions.html) | List files and folders | List | 
| <a name="sqlworkbench-ListNotebookVersions"></a>[https://docs.aws.amazon.com/redshift/latest/mgmt/redshift-policy-resources.resource-permissions.html](https://docs.aws.amazon.com/redshift/latest/mgmt/redshift-policy-resources.resource-permissions.html) | Get notebook versions metadata on your account | List | 
| <a name="sqlworkbench-ListNotebooks"></a>[https://docs.aws.amazon.com/redshift/latest/mgmt/redshift-policy-resources.resource-permissions.html](https://docs.aws.amazon.com/redshift/latest/mgmt/redshift-policy-resources.resource-permissions.html) | List the notebooks on your account | List | 
| <a name="sqlworkbench-ListQueryExecutionHistory"></a>[https://docs.aws.amazon.com/redshift/latest/mgmt/redshift-policy-resources.resource-permissions.html](https://docs.aws.amazon.com/redshift/latest/mgmt/redshift-policy-resources.resource-permissions.html) | List the query execution history on your account | List | 
| <a name="sqlworkbench-ListRedshiftClusters"></a>[https://docs.aws.amazon.com/redshift/latest/mgmt/redshift-policy-resources.resource-permissions.html](https://docs.aws.amazon.com/redshift/latest/mgmt/redshift-policy-resources.resource-permissions.html) | List redshift clusters on your account | List | 
| <a name="sqlworkbench-ListSampleDatabases"></a>[https://docs.aws.amazon.com/redshift/latest/mgmt/redshift-policy-resources.resource-permissions.html](https://docs.aws.amazon.com/redshift/latest/mgmt/redshift-policy-resources.resource-permissions.html) | List sample databases | Read | 
| <a name="sqlworkbench-ListSavedQueryVersions"></a>[https://docs.aws.amazon.com/redshift/latest/mgmt/redshift-policy-resources.resource-permissions.html](https://docs.aws.amazon.com/redshift/latest/mgmt/redshift-policy-resources.resource-permissions.html) | List versions of saved query on your account | List | 
| <a name="sqlworkbench-ListTabs"></a>[https://docs.aws.amazon.com/redshift/latest/mgmt/redshift-policy-resources.resource-permissions.html](https://docs.aws.amazon.com/redshift/latest/mgmt/redshift-policy-resources.resource-permissions.html) | List tabs on your account | List | 
| <a name="sqlworkbench-ListTaggedResources"></a>[https://docs.aws.amazon.com/redshift/latest/mgmt/redshift-policy-resources.resource-permissions.html](https://docs.aws.amazon.com/redshift/latest/mgmt/redshift-policy-resources.resource-permissions.html) | List tagged resources | Read | 
| <a name="sqlworkbench-ListTagsForResource"></a>[https://docs.aws.amazon.com/redshift/latest/mgmt/redshift-policy-resources.resource-permissions.html](https://docs.aws.amazon.com/redshift/latest/mgmt/redshift-policy-resources.resource-permissions.html) | List the tags of an sqlworkbench resource | Read | 