Amazon Kinesis Knowledge Analytics for SQL is a knowledge stream processing engine that helps you run your personal SQL code in opposition to streaming sources to carry out time collection analytics, feed real-time dashboards, and create real-time metrics. AWS has made the choice to discontinue Kinesis Knowledge Analytics for SQL, efficient January 27, 2026. On this publish, we clarify why we plan to finish assist for Kinesis Knowledge Analytics for SQL, different AWS choices, and how you can migrate your SQL queries and workloads.
Overview of Kinesis Knowledge Analytics for SQL
The next diagram illustrates the workflow for utilizing Kinesis Knowledge Analytics for SQL.
Kinesis Knowledge Analytics for SQL has been denoted a legacy providing since 2021 on our advertising pages, the AWS Administration Console, and public documentation. On this time, we haven’t added new performance or expanded Kinesis Knowledge Analytics for SQL to new AWS Areas. Nonetheless, we proceed to actively preserve and patch the providing and assist clients utilizing the service. We’ll proceed to undertake these actions.
That can assist you plan and migrate away from Kinesis Knowledge Analytics for SQL, we’ll discontinue the providing progressively:
- On October 15, 2025, you received’t be capable of create new Kinesis Knowledge Analytics for SQL purposes from this time, however will be capable of run any current purposes as regular.
- We’ll delete any remaining buyer purposes on January 27, 2026. You received’t be capable of begin or function your Kinesis Knowledge Analytics for SQL purposes and assist will not be out there for Kinesis Knowledge Analytics for SQL from this time.
Overview of Managed Service for Apache Flink and Apache Flink Studio
Kinesis Knowledge Analytics for SQL, which was launched in 2016, predates a number of in style AWS information stream processing choices, equivalent to Amazon Managed Service for Apache Flink and Amazon Managed Service for Apache Flink Studio. We’ve discovered that clients usually wish to use these newer choices over Kinesis Knowledge Analytics for SQL.
Amazon Managed Service for Apache Flink is a serverless, low-latency, extremely scalable, and extremely out there real-time stream processing service. Apache Flink is a distributed open supply engine for processing information streams. These managed Flink-based choices present performance not out there in Kinesis Knowledge Analytics for SQL and will help you construct end-to-end streaming pipelines and preserve the accuracy and timeliness of knowledge. For instance, Amazon Managed Service for Apache Flink helps built-in scaling, exactly-once processing semantics, multi-language assist (together with SQL), over 40 supply and vacation spot connectors, sturdy software state, and extra
We see clients migrating their Kinesis Knowledge Analytics for SQL workloads to benefit from the superior options out there with managed Flink choices. Clients operating SQL queries sometimes choose Amazon Managed Service for Apache Flink Studio. Amazon Managed Service for Apache Flink Studio lets you create a pocket book, which is a web-based growth setting. With notebooks, you get a easy interactive growth expertise mixed with the superior capabilities supplied by Flink. Amazon Managed Service for Apache Flink Studio makes use of Apache Zeppelin because the pocket book, and makes use of Flink because the stream processing engine. Amazon Managed Service for Apache Flink Studio notebooks seamlessly mix these applied sciences to make superior analytics on information streams accessible to builders of all talent units. Notebooks are provisioned rapidly and supply a method so that you can immediately view and analyze your streaming information. Zeppelin supplies your Amazon Managed Service for Apache Flink Studio notebooks with a whole suite of analytics instruments, together with the next capabilities:
- Visualizing information
- Exporting information to recordsdata
- Controlling the output format for simple evaluation
- Turning the pocket book right into a scalable, manufacturing software
The next diagram illustrates a standard workflow for Managed Service for Apache Flink.
Not like Kinesis Knowledge Analytics for SQL, Managed Service for Apache Flink provides the following SQL assist:
- Becoming a member of stream information between a number of streams in Amazon Kinesis Knowledge Streams, or between a Kinesis information stream and an Amazon Managed Streaming for Apache Kafka (Amazon MSK) matter
- Actual-time visualization of reworked information in a knowledge stream
- Utilizing Python scripts or Scala packages throughout the similar software
- Altering offsets of the streaming layer
One other good thing about Amazon Managed Service for Apache Flink is the improved scalability of the answer post-deployment, as a result of you may scale the underlying sources to fulfill demand. In Kinesis Knowledge Analytics for SQL, scaling is carried out by including extra pumps to steer the appliance into including extra sources.
Migrate to Managed Service for Apache Flink
For extra details about migrating Kinesis Knowledge Analytics for SQL to Amazon Managed Service for Apache Flink Studio, see Migrate from Amazon Kinesis Knowledge Analytics for SQL Functions to Amazon Managed Service for Apache Flink Studio. Moreover, we now have supplied steering in our public documentation, together with pattern code for how you can recreate 17 frequent Kinesis Knowledge Analytics for SQL queries in Amazon Managed Service for Apache Flink Studio, which we’ll proceed to develop over time. We’ve created step-by-step migration steering for patrons utilizing Amazon Knowledge Firehose as a supply, or who wish to use user-defined capabilities in Amazon Managed Service for Apache Flink . We additionally present documentation to assist clients migrating machine studying workloads from Kinesis Knowledge Analytics for SQL to Amazon Managed Service for Apache Flink.
Conclusion
On this publish, we outlined how we plan to discontinue Kinesis Knowledge Analytics for SQL and why we’re taking these steps. We advocate migrating your Kinesis Knowledge Analytics for SQL workloads to Amazon Managed Service for Apache Flink or Apache Flink Studio, and we now have supplied sources that can assist you get began together with your migration. In the event you want extra assist, you may ask questions in  re:Publish, ensuring to tag Kinesis Knowledge Analytics for SQL.
Concerning the writer
Julian Payne is a Principal Product Supervisor at AWS. He’s obsessed with constructing merchandise and options to assist clients innovate utilizing real-time information processing purposes within the cloud. Exterior of labor he writes and illustrates graphic novels.
