Kinesis Data Analytics for SQL Applications

Danger

Amazon Kinesis Data Analytics for SQL Applications will be retired on 27 January 2026. It will be removed from LocalStack soon after this date.

Introduction

Kinesis Data Analytics for SQL Applications is a service offered by Amazon Web Services (AWS) that enables you to process and analyze streaming data in real-time. It allows you to apply transformations, filtering, and enrichment to streaming data using standard SQL syntax.

LocalStack allows you to use the Kinesis Data Analytics APIs in your local environment. The supported APIs is available on our API Coverage section.

Getting started

This guide is designed for users new to Kinesis Data Analytics and assumes basic knowledge of the AWS CLI and our awslocal wrapper script.

Start your LocalStack container using your preferred method. We will demonstrate how to create a Kinesis Analytics application using AWS CLI.

Create an application

You can create a Kinesis Analytics application using the CreateApplication API by running the following command:

awslocal kinesisanalytics create-application \
    --application-name test-analytics-app

Output

{
    "ApplicationSummary": {
        "ApplicationName": "test-analytics-app",
        "ApplicationARN": "arn:aws:kinesisanalytics:us-east-1:000000000000:application/test-analytics-app",
        "ApplicationStatus": "READY"
    }
}

Describe the application

You can describe the application using the DescribeApplication API by running the following command:

awslocal kinesisanalytics describe-application \
    --application-name test-analytics-app

Output

{
    "ApplicationDetail": {
        "ApplicationName": "test-analytics-app",
        "ApplicationARN": "arn:aws:kinesisanalytics:us-east-1:000000000000:application/test-analytics-app",
        "ApplicationStatus": "READY",
        "CreateTimestamp": 1718194721.567,
        "InputDescriptions": [],
        "OutputDescriptions": [],
        "ReferenceDataSourceDescriptions": [],
        "CloudWatchLoggingOptionDescriptions": [],
        "ApplicationVersionId": 1
    }
}

Tag the application

Add tags to the application using the TagResource API by running the following command:

awslocal kinesisanalytics tag-resource \
    --resource-arn arn:aws:kinesisanalytics:us-east-1:000000000000:application/test-analytics-app \
    --tags Key=test,Value=test

You can list the tags for the application using the ListTagsForResource API by running the following command:

awslocal kinesisanalytics list-tags-for-resource \
    --resource-arn arn:aws:kinesisanalytics:us-east-1:000000000000:application/test-analytics-app

Output

{
    "Tags": [
        {
            "Key": "test",
            "Value": "test"
        }
    ]
}

Limitations

• LocalStack supports basic emulation for Kinesis Data Analytics for SQL Applications. However, the queries are not fully supported and lack parity with AWS.

API Coverage

Operation ▲	Implemented	Image

PreviousPage 1 of 0Next