@Jeremy Ber are you using it through the console via Studio notebooks?

Yes, currently on KDA your only option for using pure Flink SQL is through the Studio notebooks. You can deploy those notebooks to full KDA apps with checkpoints and autoscaling. You can wrap your Flink SQL in python or java by using the table API as well

Hmmm I was looking into https://docs.aws.amazon.com/kinesisanalytics/latest/apiv2/API_CreateApplication.html

I do not believe this would work for kda studio. I remember trying this awhile back

Thanks for the heads up! Will contact AWS support as well. Much appreciated 🙏

Studio does support this, however it will only work with a Zeppelin note file (.zpln). You cannot provide pure SQL. This mechanism is meant to provide default code for the editor, not to set your production code. If you have SQL ready for prod, it should be wrapped up in a Flink app using TableAPI. As Jeremy said, Studio can generate this for you from the notebook