Amazon Kinesis Knowledge Analytics for SQL is an information stream processing engine that helps you run your individual SQL code towards streaming sources to carry out time sequence 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 put up, we clarify why we plan to finish help for Kinesis Knowledge Analytics for SQL, different AWS choices, and easy methods to 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. Nevertheless, we proceed to actively preserve and patch the providing and help clients utilizing the service. We’ll proceed to undertake these actions.
That will help you plan and migrate away from Kinesis Knowledge Analytics for SQL, we are going to discontinue the providing regularly:
- On October 15, 2025, you gained’t be capable to create new Kinesis Knowledge Analytics for SQL purposes from this time, however will be capable to run any current purposes as regular.
- We’ll delete any remaining buyer purposes on January 27, 2026. You gained’t be capable to begin or function your Kinesis Knowledge Analytics for SQL purposes and help will not be accessible 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 common AWS knowledge stream processing choices, corresponding to Amazon Managed Service for Apache Flink and Amazon Managed Service for Apache Flink Studio. We now have 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 accessible real-time stream processing service. Apache Flink is a distributed open supply engine for processing knowledge streams. These managed Flink-based choices present performance not accessible in Kinesis Knowledge Analytics for SQL and might 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 help (together with SQL), over 40 supply and vacation spot connectors, sturdy utility state, and extra
We see clients migrating their Kinesis Knowledge Analytics for SQL workloads to make the most of the superior options accessible with managed Flink choices. Clients operating SQL queries sometimes choose Amazon Managed Service for Apache Flink Studio. Amazon Managed Service for Apache Flink Studio permits you to 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 offered 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 knowledge 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 knowledge. Zeppelin offers your Amazon Managed Service for Apache Flink Studio notebooks with a whole suite of analytics instruments, together with the next capabilities:
- Visualizing knowledge
- Exporting knowledge to recordsdata
- Controlling the output format for simple evaluation
- Turning the pocket book right into a scalable, manufacturing utility
The next diagram illustrates a typical workflow for Managed Service for Apache Flink.
Not like Kinesis Knowledge Analytics for SQL, Managed Service for Apache Flink provides the following SQL help:
- Becoming a member of stream knowledge between a number of streams in Amazon Kinesis Knowledge Streams, or between a Kinesis knowledge stream and an Amazon Managed Streaming for Apache Kafka (Amazon MSK) subject
- Actual-time visualization of remodeled knowledge in an information stream
- Utilizing Python scripts or Scala applications inside the identical utility
- 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’ll be able to scale the underlying assets to satisfy demand. In Kinesis Knowledge Analytics for SQL, scaling is carried out by including extra pumps to steer the appliance into including extra assets.
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 have now offered steerage in our public documentation, together with pattern code for easy methods to recreate 17 frequent Kinesis Knowledge Analytics for SQL queries in Amazon Managed Service for Apache Flink Studio, which we are going to proceed to increase over time. We now have created step-by-step migration steerage for patrons utilizing Amazon Knowledge Firehose as a supply, or who wish to use user-defined features 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 put up, 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 have now offered assets that can assist you get began along with your migration. When you want extra assist, you’ll be able to ask questions in re:Put up, ensuring to tag Kinesis Knowledge Analytics for SQL.
In regards to the creator
Julian Payne is a Principal Product Supervisor at AWS. He’s keen about constructing merchandise and options to assist clients innovate utilizing real-time knowledge processing purposes within the cloud. Exterior of labor he writes and illustrates graphic novels.