Creating operational insights using SQL Engine
Streaming SQL builds on the concepts of Structured Query Language (SQL) commonly used in various relational databases. Building on top of SQL means that SQL streaming generally has a lower learning curve for those familiar with databases. While there is no standard streaming SQL syntax, KDA uses the ANSI 2008 SQL standard with extensions that allow us to create real-time stream processing solutions. The key difference compared with the SQL database is that streaming SQL operates on a continuous data flow (stream). The following are the crucial advantages of streaming SQL:
- It's easy to learn for those who have worked with a SQL database.
- Its behavior is well understood as it uses the concepts of tables, joins, and aggregate functions.
- There is a rich ecosystem of SQL tools and code generators.
If you are thinking, "this is great, I'm going to replace my database," that's not the case...
