Amazon Kinesis

This article describes how to create a connection to Amazon Kinesis using a SQL command.

To ingest data from your Amazon Kinesis stream into a table within SQLake, you must first create a connection that provides the appropriate credentials to access your topic.

Syntax

CREATE KINESIS CONNECTION 
    <connection_identifier> 
    [{ AWS_ROLE = '<role_arn>' 
       EXTERNAL_ID = '<external_id>'
     | AWS_ACCESS_KEY_ID = '<key_id>' 
       AWS_SECRET_ACCESS_KEY = '<key>' }]
    REGION = '<region>' 
    [ READ_ONLY = { TRUE | FALSE } ]
    [ MAX_WRITERS = <integer> ]
    [ STREAM_DISPLAY_FILTER[S] = { '<stream_name>' | ('<stream_name>' [, ...]) } ]
    [ COMMENT = '<comment>' ]

Jump to

Connection options

AWS_ROLE — editable

Type: text

(Optional) The AWS IAM role ARN. Used in conjunction with EXTERNAL_ID.

If omitted, the role created when integrating Upsolver with the AWS account is used.

EXTERNAL_ID — editable

Type: text

(Optional) The external ID of the role to assume. Used in conjunction with AWS_ROLE.

If omitted, the role created when integrating Upsolver with the AWS account is used.

AWS_ACCESS_KEY_ID — editable

Type: text

(Optional) The AWS access key ID. Used in conjunction with AWS_SECRET_ACCESS_KEY.

If omitted, the role created when integrating Upsolver with the AWS account is used.

AWS_SECRET_ACCESS_KEY — editable

Type: text

(Optional) The AWS secret key corresponding to the provided AWS_ACCESS_KEY_ID.

If omitted, the role created when integrating Upsolver with the AWS account is used.

REGION

Type: text

The AWS region to use.

READ_ONLY

Type: boolean

Default: false

(Optional) When true, the connection can only be used to read data from Kinesis and not for writing data to Kinesis.

MAX_WRITERS — editable

Type: integer

Default: 20

(Optional) The number of maximum parallel writers to Kinesis.

STREAM_DISPLAY_FILTER[S] — editable

Type: text | list

(Optional) A single stream or the list of streams to show. If left empty, all streams are visible.

COMMENT — editable

Type: text

(Optional) A description or comment regarding this connection.

Minimum example

CREATE KINESIS CONNECTION my_kinesis_connection
    REGION = 'us-east-1';

Note: This example uses the default credentials from Upsolver's integration with AWS.

See: Deploying Upsolver on AWS

Full example

CREATE KINESIS CONNECTION my_kinesis_connection
    AWS_ROLE = 'arn:aws:iam::123456789012:role/upsolver-sqlake-role'
    REGION = 'us-east-1'
    READ_ONLY = true
    MAX_WRITERS = 22
    STREAM_DISPLAY_FILTERS = ('stream1', 'stream2')
    COMMENT = 'kinesis connection example';

Last updated