Copyright	(c) 2013-2021 Brendan Hay
License	Mozilla Public License, v. 2.0.
Maintainer	Brendan Hay <brendan.g.hay+amazonka@gmail.com>
Stability	auto-generated
Portability	non-portable (GHC extensions)
Safe Haskell	None

Amazonka.RedshiftData.DescribeTable

Contents

Creating a Request
Request Lenses
Destructuring the Response
Response Lenses

Description

Describes the detailed information about a table from metadata in the cluster. The information includes its columns. A token is returned to page through the column list. Depending on the authorization method, use one of the following combinations of request parameters:

Secrets Manager - specify the Amazon Resource Name (ARN) of the secret, the database name, and the cluster identifier that matches the cluster in the secret.
Temporary credentials - specify the cluster identifier, the database name, and the database user name. Permission to call the redshift:GetClusterCredentials operation is required to use this method.

This operation returns paginated results.

Synopsis

data DescribeTable = DescribeTable' {
- dbUser :: Maybe Text
- connectedDatabase :: Maybe Text
- schema :: Maybe Text
- nextToken :: Maybe Text
- secretArn :: Maybe Text
- table :: Maybe Text
- maxResults :: Maybe Natural
- clusterIdentifier :: Text
- database :: Text
}
newDescribeTable :: Text -> Text -> DescribeTable
describeTable_dbUser :: Lens' DescribeTable (Maybe Text)
describeTable_connectedDatabase :: Lens' DescribeTable (Maybe Text)
describeTable_schema :: Lens' DescribeTable (Maybe Text)
describeTable_nextToken :: Lens' DescribeTable (Maybe Text)
describeTable_secretArn :: Lens' DescribeTable (Maybe Text)
describeTable_table :: Lens' DescribeTable (Maybe Text)
describeTable_maxResults :: Lens' DescribeTable (Maybe Natural)
describeTable_clusterIdentifier :: Lens' DescribeTable Text
describeTable_database :: Lens' DescribeTable Text
data DescribeTableResponse = DescribeTableResponse' {
- columnList :: Maybe [ColumnMetadata]
- nextToken :: Maybe Text
- tableName :: Maybe Text
- httpStatus :: Int
}
newDescribeTableResponse :: Int -> DescribeTableResponse
describeTableResponse_columnList :: Lens' DescribeTableResponse (Maybe [ColumnMetadata])
describeTableResponse_nextToken :: Lens' DescribeTableResponse (Maybe Text)
describeTableResponse_tableName :: Lens' DescribeTableResponse (Maybe Text)
describeTableResponse_httpStatus :: Lens' DescribeTableResponse Int

Creating a Request

data DescribeTable Source #

See: newDescribeTable smart constructor.

Constructors

DescribeTable'

Fields

dbUser :: Maybe Text
The database user name. This parameter is required when authenticating using temporary credentials.
connectedDatabase :: Maybe Text
A database name. The connected database is specified when you connect with your authentication credentials.
schema :: Maybe Text
The schema that contains the table. If no schema is specified, then matching tables for all schemas are returned.
nextToken :: Maybe Text
A value that indicates the starting point for the next set of response records in a subsequent request. If a value is returned in a response, you can retrieve the next set of records by providing this returned NextToken value in the next NextToken parameter and retrying the command. If the NextToken field is empty, all response records have been retrieved for the request.
secretArn :: Maybe Text
The name or ARN of the secret that enables access to the database. This parameter is required when authenticating using Secrets Manager.
table :: Maybe Text
The table name. If no table is specified, then all tables for all matching schemas are returned. If no table and no schema is specified, then all tables for all schemas in the database are returned
maxResults :: Maybe Natural
The maximum number of tables to return in the response. If more tables exist than fit in one response, then NextToken is returned to page through the results.
clusterIdentifier :: Text
The cluster identifier. This parameter is required when authenticating using either Secrets Manager or temporary credentials.
database :: Text
The name of the database that contains the tables to be described. If ConnectedDatabase is not specified, this is also the database to connect to with your authentication credentials.

Instances

Instances details

Eq DescribeTable Source #
Instance details Defined in Amazonka.RedshiftData.DescribeTable Methods (==) :: DescribeTable -> DescribeTable -> Bool # (/=) :: DescribeTable -> DescribeTable -> Bool #
Read DescribeTable Source #
Instance details Defined in Amazonka.RedshiftData.DescribeTable Methods readsPrec :: Int -> ReadS DescribeTable # readList :: ReadS [DescribeTable] # readPrec :: ReadPrec DescribeTable # readListPrec :: ReadPrec [DescribeTable] #
Show DescribeTable Source #
Instance details Defined in Amazonka.RedshiftData.DescribeTable Methods showsPrec :: Int -> DescribeTable -> ShowS # show :: DescribeTable -> String # showList :: [DescribeTable] -> ShowS #
Generic DescribeTable Source #
Instance details Defined in Amazonka.RedshiftData.DescribeTable Associated Types type Rep DescribeTable :: Type -> Type # Methods from :: DescribeTable -> Rep DescribeTable x # to :: Rep DescribeTable x -> DescribeTable #
NFData DescribeTable Source #
Instance details Defined in Amazonka.RedshiftData.DescribeTable Methods rnf :: DescribeTable -> () #
Hashable DescribeTable Source #
Instance details Defined in Amazonka.RedshiftData.DescribeTable Methods hashWithSalt :: Int -> DescribeTable -> Int # hash :: DescribeTable -> Int #
ToJSON DescribeTable Source #
Instance details Defined in Amazonka.RedshiftData.DescribeTable Methods toJSON :: DescribeTable -> Value # toEncoding :: DescribeTable -> Encoding # toJSONList :: [DescribeTable] -> Value # toEncodingList :: [DescribeTable] -> Encoding #
AWSPager DescribeTable Source #
Instance details Defined in Amazonka.RedshiftData.DescribeTable Methods page :: DescribeTable -> AWSResponse DescribeTable -> Maybe DescribeTable #
AWSRequest DescribeTable Source #
Instance details Defined in Amazonka.RedshiftData.DescribeTable Associated Types type AWSResponse DescribeTable # Methods request :: DescribeTable -> Request DescribeTable # response :: MonadResource m => Logger -> Service -> Proxy DescribeTable -> ClientResponse ClientBody -> m (Either Error (ClientResponse (AWSResponse DescribeTable))) #
ToHeaders DescribeTable Source #
Instance details Defined in Amazonka.RedshiftData.DescribeTable Methods toHeaders :: DescribeTable -> [Header] #
ToPath DescribeTable Source #
Instance details Defined in Amazonka.RedshiftData.DescribeTable Methods toPath :: DescribeTable -> ByteString #
ToQuery DescribeTable Source #
Instance details Defined in Amazonka.RedshiftData.DescribeTable Methods toQuery :: DescribeTable -> QueryString #
type Rep DescribeTable Source #
Instance details Defined in Amazonka.RedshiftData.DescribeTable type Rep DescribeTable = D1 ('MetaData "DescribeTable" "Amazonka.RedshiftData.DescribeTable" "libZSservicesZSamazonka-redshift-dataZSamazonka-redshift-data" 'False) (C1 ('MetaCons "DescribeTable'" 'PrefixI 'True) (((S1 ('MetaSel ('Just "dbUser") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedStrict) (Rec0 (Maybe Text)) :: S1 ('MetaSel ('Just "connectedDatabase") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedStrict) (Rec0 (Maybe Text))) :: (S1 ('MetaSel ('Just "schema") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedStrict) (Rec0 (Maybe Text)) :: S1 ('MetaSel ('Just "nextToken") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedStrict) (Rec0 (Maybe Text)))) :: ((S1 ('MetaSel ('Just "secretArn") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedStrict) (Rec0 (Maybe Text)) :: S1 ('MetaSel ('Just "table") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedStrict) (Rec0 (Maybe Text))) :: (S1 ('MetaSel ('Just "maxResults") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedStrict) (Rec0 (Maybe Natural)) :: (S1 ('MetaSel ('Just "clusterIdentifier") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedStrict) (Rec0 Text) :: S1 ('MetaSel ('Just "database") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedStrict) (Rec0 Text))))))
type AWSResponse DescribeTable Source #
Instance details Defined in Amazonka.RedshiftData.DescribeTable type AWSResponse DescribeTable = DescribeTableResponse

newDescribeTable Source #

Arguments

:: Text	`$sel:clusterIdentifier:DescribeTable'`
-> Text	`$sel:database:DescribeTable'`
-> DescribeTable

Create a value of DescribeTable with all optional fields omitted.

Use generic-lens or optics to modify other optional fields.

The following record fields are available, with the corresponding lenses provided for backwards compatibility:

$sel:dbUser:DescribeTable', describeTable_dbUser - The database user name. This parameter is required when authenticating using temporary credentials.

$sel:connectedDatabase:DescribeTable', describeTable_connectedDatabase - A database name. The connected database is specified when you connect with your authentication credentials.

$sel:schema:DescribeTable', describeTable_schema - The schema that contains the table. If no schema is specified, then matching tables for all schemas are returned.

$sel:nextToken:DescribeTable', describeTable_nextToken - A value that indicates the starting point for the next set of response records in a subsequent request. If a value is returned in a response, you can retrieve the next set of records by providing this returned NextToken value in the next NextToken parameter and retrying the command. If the NextToken field is empty, all response records have been retrieved for the request.

$sel:secretArn:DescribeTable', describeTable_secretArn - The name or ARN of the secret that enables access to the database. This parameter is required when authenticating using Secrets Manager.

$sel:table:DescribeTable', describeTable_table - The table name. If no table is specified, then all tables for all matching schemas are returned. If no table and no schema is specified, then all tables for all schemas in the database are returned

$sel:maxResults:DescribeTable', describeTable_maxResults - The maximum number of tables to return in the response. If more tables exist than fit in one response, then NextToken is returned to page through the results.

$sel:clusterIdentifier:DescribeTable', describeTable_clusterIdentifier - The cluster identifier. This parameter is required when authenticating using either Secrets Manager or temporary credentials.

$sel:database:DescribeTable', describeTable_database - The name of the database that contains the tables to be described. If ConnectedDatabase is not specified, this is also the database to connect to with your authentication credentials.

Request Lenses

describeTable_dbUser :: Lens' DescribeTable (Maybe Text) Source #

The database user name. This parameter is required when authenticating using temporary credentials.

describeTable_connectedDatabase :: Lens' DescribeTable (Maybe Text) Source #

A database name. The connected database is specified when you connect with your authentication credentials.

describeTable_schema :: Lens' DescribeTable (Maybe Text) Source #

The schema that contains the table. If no schema is specified, then matching tables for all schemas are returned.

describeTable_nextToken :: Lens' DescribeTable (Maybe Text) Source #

A value that indicates the starting point for the next set of response records in a subsequent request. If a value is returned in a response, you can retrieve the next set of records by providing this returned NextToken value in the next NextToken parameter and retrying the command. If the NextToken field is empty, all response records have been retrieved for the request.

describeTable_secretArn :: Lens' DescribeTable (Maybe Text) Source #

The name or ARN of the secret that enables access to the database. This parameter is required when authenticating using Secrets Manager.

describeTable_table :: Lens' DescribeTable (Maybe Text) Source #

The table name. If no table is specified, then all tables for all matching schemas are returned. If no table and no schema is specified, then all tables for all schemas in the database are returned

describeTable_maxResults :: Lens' DescribeTable (Maybe Natural) Source #

The maximum number of tables to return in the response. If more tables exist than fit in one response, then NextToken is returned to page through the results.

describeTable_clusterIdentifier :: Lens' DescribeTable Text Source #

The cluster identifier. This parameter is required when authenticating using either Secrets Manager or temporary credentials.

describeTable_database :: Lens' DescribeTable Text Source #

The name of the database that contains the tables to be described. If ConnectedDatabase is not specified, this is also the database to connect to with your authentication credentials.

Destructuring the Response

data DescribeTableResponse Source #

See: newDescribeTableResponse smart constructor.

Constructors

DescribeTableResponse'

Fields

columnList :: Maybe [ColumnMetadata]
A list of columns in the table.
nextToken :: Maybe Text
A value that indicates the starting point for the next set of response records in a subsequent request. If a value is returned in a response, you can retrieve the next set of records by providing this returned NextToken value in the next NextToken parameter and retrying the command. If the NextToken field is empty, all response records have been retrieved for the request.
tableName :: Maybe Text
The table name.
httpStatus :: Int
The response's http status code.

Instances

Instances details

Eq DescribeTableResponse Source #
Instance details Defined in Amazonka.RedshiftData.DescribeTable Methods (==) :: DescribeTableResponse -> DescribeTableResponse -> Bool # (/=) :: DescribeTableResponse -> DescribeTableResponse -> Bool #
Read DescribeTableResponse Source #
Instance details Defined in Amazonka.RedshiftData.DescribeTable Methods readsPrec :: Int -> ReadS DescribeTableResponse # readList :: ReadS [DescribeTableResponse] # readPrec :: ReadPrec DescribeTableResponse # readListPrec :: ReadPrec [DescribeTableResponse] #
Show DescribeTableResponse Source #
Instance details Defined in Amazonka.RedshiftData.DescribeTable Methods showsPrec :: Int -> DescribeTableResponse -> ShowS # show :: DescribeTableResponse -> String # showList :: [DescribeTableResponse] -> ShowS #
Generic DescribeTableResponse Source #
Instance details Defined in Amazonka.RedshiftData.DescribeTable Associated Types type Rep DescribeTableResponse :: Type -> Type # Methods from :: DescribeTableResponse -> Rep DescribeTableResponse x # to :: Rep DescribeTableResponse x -> DescribeTableResponse #
NFData DescribeTableResponse Source #
Instance details Defined in Amazonka.RedshiftData.DescribeTable Methods rnf :: DescribeTableResponse -> () #
type Rep DescribeTableResponse Source #
Instance details Defined in Amazonka.RedshiftData.DescribeTable type Rep DescribeTableResponse = D1 ('MetaData "DescribeTableResponse" "Amazonka.RedshiftData.DescribeTable" "libZSservicesZSamazonka-redshift-dataZSamazonka-redshift-data" 'False) (C1 ('MetaCons "DescribeTableResponse'" 'PrefixI 'True) ((S1 ('MetaSel ('Just "columnList") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedStrict) (Rec0 (Maybe [ColumnMetadata])) :: S1 ('MetaSel ('Just "nextToken") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedStrict) (Rec0 (Maybe Text))) :: (S1 ('MetaSel ('Just "tableName") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedStrict) (Rec0 (Maybe Text)) :*: S1 ('MetaSel ('Just "httpStatus") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedStrict) (Rec0 Int))))

newDescribeTableResponse Source #

Arguments

:: Int	`$sel:httpStatus:DescribeTableResponse'`
-> DescribeTableResponse

Create a value of DescribeTableResponse with all optional fields omitted.

Use generic-lens or optics to modify other optional fields.

The following record fields are available, with the corresponding lenses provided for backwards compatibility:

$sel:columnList:DescribeTableResponse', describeTableResponse_columnList - A list of columns in the table.

$sel:nextToken:DescribeTable', describeTableResponse_nextToken - A value that indicates the starting point for the next set of response records in a subsequent request. If a value is returned in a response, you can retrieve the next set of records by providing this returned NextToken value in the next NextToken parameter and retrying the command. If the NextToken field is empty, all response records have been retrieved for the request.

$sel:tableName:DescribeTableResponse', describeTableResponse_tableName - The table name.

$sel:httpStatus:DescribeTableResponse', describeTableResponse_httpStatus - The response's http status code.

Response Lenses

describeTableResponse_columnList :: Lens' DescribeTableResponse (Maybe [ColumnMetadata]) Source #

A list of columns in the table.

describeTableResponse_nextToken :: Lens' DescribeTableResponse (Maybe Text) Source #

A value that indicates the starting point for the next set of response records in a subsequent request. If a value is returned in a response, you can retrieve the next set of records by providing this returned NextToken value in the next NextToken parameter and retrying the command. If the NextToken field is empty, all response records have been retrieved for the request.

describeTableResponse_tableName :: Lens' DescribeTableResponse (Maybe Text) Source #

The table name.

describeTableResponse_httpStatus :: Lens' DescribeTableResponse Int Source #

The response's http status code.