KinesisAnalyticsV2.Client.discover_input_schema(**kwargs)¶Infers a schema for a SQL-based Kinesis Data Analytics application by evaluating sample records on the specified streaming source (Kinesis data stream or Kinesis Data Firehose delivery stream) or Amazon S3 object. In the response, the operation returns the inferred schema and also the sample records that the operation used to infer the schema.
You can use the inferred schema when configuring a streaming source for your application. When you create an application using the Kinesis Data Analytics console, the console uses this operation to infer a schema and show it in the console user interface.
See also: AWS API Documentation
Request Syntax
response = client.discover_input_schema(
ResourceARN='string',
ServiceExecutionRole='string',
InputStartingPositionConfiguration={
'InputStartingPosition': 'NOW'|'TRIM_HORIZON'|'LAST_STOPPED_POINT'
},
S3Configuration={
'BucketARN': 'string',
'FileKey': 'string'
},
InputProcessingConfiguration={
'InputLambdaProcessor': {
'ResourceARN': 'string'
}
}
)
[REQUIRED]
The ARN of the role that is used to access the streaming source.
The point at which you want Kinesis Data Analytics to start reading records from the specified streaming source discovery purposes.
The starting position on the stream.
NOW - Start reading just after the most recent record in the stream, and start at the request timestamp that the customer issued.TRIM_HORIZON - Start reading at the last untrimmed record in the stream, which is the oldest record available in the stream. This option is not available for an Amazon Kinesis Data Firehose delivery stream.LAST_STOPPED_POINT - Resume reading from where the application last stopped reading.Specify this parameter to discover a schema from data in an Amazon S3 object.
The ARN of the S3 bucket that contains the data.
The name of the object that contains the data.
The InputProcessingConfiguration to use to preprocess the records before discovering the schema of the records.
The InputLambdaProcessor that is used to preprocess the records in the stream before being processed by your application code.
The ARN of the Amazon Lambda function that operates on records in the stream.
Note
To specify an earlier version of the Lambda function than the latest, include the Lambda function version in the Lambda function ARN. For more information about Lambda ARNs, see Example ARNs: Amazon Lambda
dict
Response Syntax
{
'InputSchema': {
'RecordFormat': {
'RecordFormatType': 'JSON'|'CSV',
'MappingParameters': {
'JSONMappingParameters': {
'RecordRowPath': 'string'
},
'CSVMappingParameters': {
'RecordRowDelimiter': 'string',
'RecordColumnDelimiter': 'string'
}
}
},
'RecordEncoding': 'string',
'RecordColumns': [
{
'Name': 'string',
'Mapping': 'string',
'SqlType': 'string'
},
]
},
'ParsedInputRecords': [
[
'string',
],
],
'ProcessedInputRecords': [
'string',
],
'RawInputRecords': [
'string',
]
}
Response Structure
(dict) --
InputSchema (dict) --
The schema inferred from the streaming source. It identifies the format of the data in the streaming source and how each data element maps to corresponding columns in the in-application stream that you can create.
RecordFormat (dict) --
Specifies the format of the records on the streaming source.
RecordFormatType (string) --
The type of record format.
MappingParameters (dict) --
When you configure application input at the time of creating or updating an application, provides additional mapping information specific to the record format (such as JSON, CSV, or record fields delimited by some delimiter) on the streaming source.
JSONMappingParameters (dict) --
Provides additional mapping information when JSON is the record format on the streaming source.
RecordRowPath (string) --
The path to the top-level parent that contains the records.
CSVMappingParameters (dict) --
Provides additional mapping information when the record format uses delimiters (for example, CSV).
RecordRowDelimiter (string) --
The row delimiter. For example, in a CSV format, 'n' is the typical row delimiter.
RecordColumnDelimiter (string) --
The column delimiter. For example, in a CSV format, a comma (",") is the typical column delimiter.
RecordEncoding (string) --
Specifies the encoding of the records in the streaming source. For example, UTF-8.
RecordColumns (list) --
A list of RecordColumn objects.
(dict) --
For a SQL-based Kinesis Data Analytics application, describes the mapping of each data element in the streaming source to the corresponding column in the in-application stream.
Also used to describe the format of the reference data source.
Name (string) --
The name of the column that is created in the in-application input stream or reference table.
Mapping (string) --
A reference to the data element in the streaming input or the reference data source.
SqlType (string) --
The type of column created in the in-application input stream or reference table.
ParsedInputRecords (list) --
An array of elements, where each element corresponds to a row in a stream record (a stream record can have more than one row).
ProcessedInputRecords (list) --
The stream data that was modified by the processor specified in the InputProcessingConfiguration parameter.
RawInputRecords (list) --
The raw stream data that was sampled to infer the schema.
Exceptions
KinesisAnalyticsV2.Client.exceptions.InvalidArgumentExceptionKinesisAnalyticsV2.Client.exceptions.UnableToDetectSchemaExceptionKinesisAnalyticsV2.Client.exceptions.ResourceProvisionedThroughputExceededExceptionKinesisAnalyticsV2.Client.exceptions.ServiceUnavailableExceptionKinesisAnalyticsV2.Client.exceptions.InvalidRequestExceptionKinesisAnalyticsV2.Client.exceptions.UnsupportedOperationException