

# Data retrieval APIs for Amazon Redshift
<a name="amazonredshift"></a>

Amazon Redshift provides the following APIs for data retrieval.


****  

| Actions | Description | Access level | 
| --- | --- | --- | 
| <a name="redshift-DescribeAccountAttributes"></a>[https://docs.aws.amazon.com/redshift/latest/APIReference/API_DescribeAccountAttributes.html](https://docs.aws.amazon.com/redshift/latest/APIReference/API_DescribeAccountAttributes.html) | Describe attributes attached to the specified AWS account | Read | 
| <a name="redshift-DescribeAuthenticationProfiles"></a>[API_DescribeAuthenticationProfiles.html](API_DescribeAuthenticationProfiles.html) | Describe created Amazon Redshift authentication profiles | Read | 
| <a name="redshift-DescribeAutonomicsDenylist"></a>[https://docs.aws.amazon.com/redshift/latest/dg/t_Manage_workload_exclusion.html](https://docs.aws.amazon.com/redshift/latest/dg/t_Manage_workload_exclusion.html) | Describe the list of resources that are denylisted from global autonomics decisions for a specified cluster | Read | 
| <a name="redshift-DescribeClusterDbRevisions"></a>[https://docs.aws.amazon.com/redshift/latest/APIReference/API_DescribeClusterDbRevisions.html](https://docs.aws.amazon.com/redshift/latest/APIReference/API_DescribeClusterDbRevisions.html) | Describe database revisions for a cluster | List | 
| <a name="redshift-DescribeClusterParameterGroups"></a>[https://docs.aws.amazon.com/redshift/latest/APIReference/API_DescribeClusterParameterGroups.html](https://docs.aws.amazon.com/redshift/latest/APIReference/API_DescribeClusterParameterGroups.html) | Describe Amazon Redshift parameter groups, including parameter groups you created and the default parameter group | Read | 
| <a name="redshift-DescribeClusterParameters"></a>[https://docs.aws.amazon.com/redshift/latest/APIReference/API_DescribeClusterParameters.html](https://docs.aws.amazon.com/redshift/latest/APIReference/API_DescribeClusterParameters.html) | Describe parameters contained within an Amazon Redshift parameter group | Read | 
| <a name="redshift-DescribeClusterSecurityGroups"></a>[https://docs.aws.amazon.com/redshift/latest/APIReference/API_DescribeClusterSecurityGroups.html](https://docs.aws.amazon.com/redshift/latest/APIReference/API_DescribeClusterSecurityGroups.html) | Describe Amazon Redshift security groups | Read | 
| <a name="redshift-DescribeClusterSnapshots"></a>[https://docs.aws.amazon.com/redshift/latest/APIReference/API_DescribeClusterSnapshots.html](https://docs.aws.amazon.com/redshift/latest/APIReference/API_DescribeClusterSnapshots.html) | Describe one or more snapshot objects, which contain metadata about your cluster snapshots | Read | 
| <a name="redshift-DescribeClusterSubnetGroups"></a>[https://docs.aws.amazon.com/redshift/latest/APIReference/API_DescribeClusterSubnetGroups.html](https://docs.aws.amazon.com/redshift/latest/APIReference/API_DescribeClusterSubnetGroups.html) | Describe one or more cluster subnet group objects, which contain metadata about your cluster subnet groups | Read | 
| <a name="redshift-DescribeClusterTracks"></a>[https://docs.aws.amazon.com/redshift/latest/APIReference/API_DescribeClusterTracks.html](https://docs.aws.amazon.com/redshift/latest/APIReference/API_DescribeClusterTracks.html) | Describe available maintenance tracks | List | 
| <a name="redshift-DescribeClusterVersions"></a>[https://docs.aws.amazon.com/redshift/latest/APIReference/API_DescribeClusterVersions.html](https://docs.aws.amazon.com/redshift/latest/APIReference/API_DescribeClusterVersions.html) | Describe available Amazon Redshift cluster versions | Read | 
| <a name="redshift-DescribeClusters"></a>[https://docs.aws.amazon.com/redshift/latest/APIReference/API_DescribeClusters.html](https://docs.aws.amazon.com/redshift/latest/APIReference/API_DescribeClusters.html) | Describe properties of provisioned clusters | List | 
| <a name="redshift-DescribeCustomDomainAssociations"></a>[https://docs.aws.amazon.com/redshift/latest/APIReference/API_DescribeCustomDomainAssociations.html](https://docs.aws.amazon.com/redshift/latest/APIReference/API_DescribeCustomDomainAssociations.html) | Describe custom domain names for a cluster | List | 
| <a name="redshift-DescribeDataShares"></a>[https://docs.aws.amazon.com/redshift/latest/APIReference/API_DescribeDataShares.html](https://docs.aws.amazon.com/redshift/latest/APIReference/API_DescribeDataShares.html) | Describe datashares created and consumed by your clusters | Read | 
| <a name="redshift-DescribeDataSharesForConsumer"></a>[https://docs.aws.amazon.com/redshift/latest/APIReference/API_DescribeDataSharesForConsumer.html](https://docs.aws.amazon.com/redshift/latest/APIReference/API_DescribeDataSharesForConsumer.html) | Describe only datashares consumed by your clusters | Read | 
| <a name="redshift-DescribeDataSharesForProducer"></a>[https://docs.aws.amazon.com/redshift/latest/APIReference/API_DescribeDataSharesForProducer.html](https://docs.aws.amazon.com/redshift/latest/APIReference/API_DescribeDataSharesForProducer.html) | Describe only datashares created by your clusters | Read | 
| <a name="redshift-DescribeDefaultClusterParameters"></a>[https://docs.aws.amazon.com/redshift/latest/APIReference/API_DescribeDefaultClusterParameters.html](https://docs.aws.amazon.com/redshift/latest/APIReference/API_DescribeDefaultClusterParameters.html) | Describe parameter settings for a parameter group family | Read | 
| <a name="redshift-DescribeEndpointAccess"></a>[https://docs.aws.amazon.com/redshift/latest/APIReference/API_DescribeEndpointAccess.html](https://docs.aws.amazon.com/redshift/latest/APIReference/API_DescribeEndpointAccess.html) | Describe redshift-managed vpc endpoints | Read | 
| <a name="redshift-DescribeEndpointAuthorization"></a>[https://docs.aws.amazon.com/redshift/latest/APIReference/API_DescribeEndpointAuthorization.html](https://docs.aws.amazon.com/redshift/latest/APIReference/API_DescribeEndpointAuthorization.html) | Authorize describe activity for redshift-managed vpc endpoint | List | 
| <a name="redshift-DescribeEventCategories"></a>[https://docs.aws.amazon.com/redshift/latest/APIReference/API_DescribeEventCategories.html](https://docs.aws.amazon.com/redshift/latest/APIReference/API_DescribeEventCategories.html) | Describe event categories for all event source types, or for a specified source type | Read | 
| <a name="redshift-DescribeEventSubscriptions"></a>[https://docs.aws.amazon.com/redshift/latest/APIReference/API_DescribeEventSubscriptions.html](https://docs.aws.amazon.com/redshift/latest/APIReference/API_DescribeEventSubscriptions.html) | Describe Amazon Redshift event notification subscriptions for the specified AWS account | Read | 
| <a name="redshift-DescribeEvents"></a>[https://docs.aws.amazon.com/redshift/latest/APIReference/API_DescribeEvents.html](https://docs.aws.amazon.com/redshift/latest/APIReference/API_DescribeEvents.html) | Describe events related to clusters, security groups, snapshots, and parameter groups for the past 14 days | List | 
| <a name="redshift-DescribeHsmClientCertificates"></a>[https://docs.aws.amazon.com/redshift/latest/APIReference/API_DescribeHsmClientCertificates.html](https://docs.aws.amazon.com/redshift/latest/APIReference/API_DescribeHsmClientCertificates.html) | Describe HSM client certificates | Read | 
| <a name="redshift-DescribeHsmConfigurations"></a>[https://docs.aws.amazon.com/redshift/latest/APIReference/API_DescribeHsmConfigurations.html](https://docs.aws.amazon.com/redshift/latest/APIReference/API_DescribeHsmConfigurations.html) | Describe Amazon Redshift HSM configurations | Read | 
| <a name="redshift-DescribeInboundIntegrations"></a>[https://docs.aws.amazon.com/redshift/latest/APIReference/API_DescribeInboundIntegrations.html](https://docs.aws.amazon.com/redshift/latest/APIReference/API_DescribeInboundIntegrations.html) | List the inbound integrations | List | 
| <a name="redshift-DescribeIntegrations"></a>[https://docs.aws.amazon.com/redshift/latest/APIReference/API_DescribeIntegrations.html](https://docs.aws.amazon.com/redshift/latest/APIReference/API_DescribeIntegrations.html) | Describe an Amazon Redshift zero-ETL integration | List | 
| <a name="redshift-DescribeLoggingStatus"></a>[https://docs.aws.amazon.com/redshift/latest/APIReference/API_DescribeLoggingStatus.html](https://docs.aws.amazon.com/redshift/latest/APIReference/API_DescribeLoggingStatus.html) | Describe whether information, such as queries and connection attempts, is being logged for a cluster | Read | 
| <a name="redshift-DescribeNodeConfigurationOptions"></a>[https://docs.aws.amazon.com/redshift/latest/APIReference/API_DescribeNodeConfigurationOptions.html](https://docs.aws.amazon.com/redshift/latest/APIReference/API_DescribeNodeConfigurationOptions.html) | Describe properties of possible node configurations such as node type, number of nodes, and disk usage for the specified action type | List | 
| <a name="redshift-DescribeOrderableClusterOptions"></a>[https://docs.aws.amazon.com/redshift/latest/APIReference/API_DescribeOrderableClusterOptions.html](https://docs.aws.amazon.com/redshift/latest/APIReference/API_DescribeOrderableClusterOptions.html) | Describe orderable cluster options | Read | 
| <a name="redshift-DescribePartners"></a>[https://docs.aws.amazon.com/redshift/latest/APIReference/API_DescribePartners.html](https://docs.aws.amazon.com/redshift/latest/APIReference/API_DescribePartners.html) | Retrieve information about the partner integrations defined for a cluster | Read | 
| <a name="redshift-DescribeQev2IdcApplications"></a>[https://docs.aws.amazon.com/redshift/latest/mgmt/redshift-iam-access-control-idp-connect.html](https://docs.aws.amazon.com/redshift/latest/mgmt/redshift-iam-access-control-idp-connect.html) | Describe qev2 idc applications | List | 
| <a name="redshift-DescribeQuery"></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) | Describe a query through the Amazon Redshift console | Read | 
| <a name="redshift-DescribeRedshiftIdcApplications"></a>[https://docs.aws.amazon.com/redshift/latest/APIReference/API_DescribeRedshiftIdcApplications.html](https://docs.aws.amazon.com/redshift/latest/APIReference/API_DescribeRedshiftIdcApplications.html) | Describe redshift idc applications | List | 
| <a name="redshift-DescribeReservedNodeExchangeStatus"></a>[https://docs.aws.amazon.com/redshift/latest/APIReference/API_DescribeReservedNodeExchangeStatus.html](https://docs.aws.amazon.com/redshift/latest/APIReference/API_DescribeReservedNodeExchangeStatus.html) | Describe exchange status details and associated metadata for a reserved-node exchange. Statuses include such values as in progress and requested | Read | 
| <a name="redshift-DescribeReservedNodeOfferings"></a>[https://docs.aws.amazon.com/redshift/latest/APIReference/API_DescribeReservedNodeOfferings.html](https://docs.aws.amazon.com/redshift/latest/APIReference/API_DescribeReservedNodeOfferings.html) | Describe available reserved node offerings by Amazon Redshift | Read | 
| <a name="redshift-DescribeReservedNodes"></a>[https://docs.aws.amazon.com/redshift/latest/APIReference/API_DescribeReservedNodes.html](https://docs.aws.amazon.com/redshift/latest/APIReference/API_DescribeReservedNodes.html) | Describe the reserved nodes | Read | 
| <a name="redshift-DescribeResize"></a>[https://docs.aws.amazon.com/redshift/latest/APIReference/API_DescribeResize.html](https://docs.aws.amazon.com/redshift/latest/APIReference/API_DescribeResize.html) | Describe the last resize operation for a cluster | Read | 
| <a name="redshift-DescribeSavedQueries"></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) | Describe saved queries through the Amazon Redshift console | Read | 
| <a name="redshift-DescribeScheduledActions"></a>[API_DescribeScheduledActions.html](API_DescribeScheduledActions.html) | Describe created Amazon Redshift scheduled actions | Read | 
| <a name="redshift-DescribeSnapshotCopyGrants"></a>[https://docs.aws.amazon.com/redshift/latest/APIReference/API_DescribeSnapshotCopyGrants.html](https://docs.aws.amazon.com/redshift/latest/APIReference/API_DescribeSnapshotCopyGrants.html) | Describe snapshot copy grants owned by the specified AWS account in the destination AWS Region | Read | 
| <a name="redshift-DescribeSnapshotSchedules"></a>[https://docs.aws.amazon.com/redshift/latest/APIReference/API_DescribeSnapshotSchedules.html](https://docs.aws.amazon.com/redshift/latest/APIReference/API_DescribeSnapshotSchedules.html) | Describe snapshot schedules | Read | 
| <a name="redshift-DescribeStorage"></a>[https://docs.aws.amazon.com/redshift/latest/APIReference/API_DescribeStorage.html](https://docs.aws.amazon.com/redshift/latest/APIReference/API_DescribeStorage.html) | Describe account level backups storage size and provisional storage | Read | 
| <a name="redshift-DescribeTable"></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) | Describe a table through the Amazon Redshift console | Read | 
| <a name="redshift-DescribeTableRestoreStatus"></a>[https://docs.aws.amazon.com/redshift/latest/APIReference/API_DescribeTableRestoreStatus.html](https://docs.aws.amazon.com/redshift/latest/APIReference/API_DescribeTableRestoreStatus.html) | Describe status of one or more table restore requests made using the RestoreTableFromClusterSnapshot API action | Read | 
| <a name="redshift-DescribeTags"></a>[https://docs.aws.amazon.com/redshift/latest/APIReference/API_DescribeTags.html](https://docs.aws.amazon.com/redshift/latest/APIReference/API_DescribeTags.html) | Describe tags | Read | 
| <a name="redshift-DescribeUsageLimits"></a>[https://docs.aws.amazon.com/redshift/latest/APIReference/API_DescribeUsageLimits.html](https://docs.aws.amazon.com/redshift/latest/APIReference/API_DescribeUsageLimits.html) | Describe usage limits | Read | 
| <a name="redshift-FetchResults"></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) | Fetch query results through the Amazon Redshift console | Read | 
| <a name="redshift-GetIdentityCenterAuthToken"></a>[https://docs.aws.amazon.com/redshift/latest/mgmt/identity-center-authentication.html](https://docs.aws.amazon.com/redshift/latest/mgmt/identity-center-authentication.html) | Get an authorized token for Identity Center users to access Redshift clusters | Read | 
| <a name="redshift-GetReservedNodeExchangeConfigurationOptions"></a>[https://docs.aws.amazon.com/redshift/latest/APIReference/API_GetReservedNodeExchangeConfigurationOptions.html](https://docs.aws.amazon.com/redshift/latest/APIReference/API_GetReservedNodeExchangeConfigurationOptions.html) | Get the configuration options for the reserved-node exchange | Read | 
| <a name="redshift-GetReservedNodeExchangeOfferings"></a>[https://docs.aws.amazon.com/redshift/latest/APIReference/API_GetReservedNodeExchangeOfferings.html](https://docs.aws.amazon.com/redshift/latest/APIReference/API_GetReservedNodeExchangeOfferings.html) | Get an array of DC2 ReservedNodeOfferings that matches the payment type, term, and usage price of the given DC1 reserved node | Read | 
| <a name="redshift-GetResourcePolicy"></a>[https://docs.aws.amazon.com/redshift/latest/APIReference/API_GetResourcePolicy.html](https://docs.aws.amazon.com/redshift/latest/APIReference/API_GetResourcePolicy.html) | Get the resource policy for a specified resource | Read | 
| <a name="redshift-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 through the Amazon Redshift console | List | 
| <a name="redshift-ListRecommendations"></a>[API_ListRecommendations.html](API_ListRecommendations.html) | List Advisor recommendations | List | 
| <a name="redshift-ListSavedQueries"></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 saved queries through the Amazon Redshift console | List | 
| <a name="redshift-ListSchemas"></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 schemas through the Amazon Redshift console | List | 
| <a name="redshift-ListTables"></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 tables through the Amazon Redshift console | List | 
| <a name="redshift-ViewQueriesFromConsole"></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) | View query results through the Amazon Redshift console | List | 
| <a name="redshift-ViewQueriesInConsole"></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) | Terminate running queries and loads through the Amazon Redshift console | List | 