Forum Discussion
Solved
Eventstream custom SQL code not working due to an invalid input name
Eventstream has a custom SQL code capability. This capability always fails due to an "invalid input name", most likely due to a hyphen in the stream name. The problem is that there's no option to ren...
Hi PaxDataEngineer ,
Looks like you havent added the destination. In this case, Lakehouse1 or
wrapping stream names with special characters (like hyphens/underscore) in square brackets is causing the error.
Try using the stream name without hyphen and then validate and check.
Please refer-
From Clicks to Code: SQL Operator under Fabric Eventstream (Preview)
Hope this helps!
So it does say "no problem detected" when just using the simple "SELECT * INTO [Output] FROM..." but after saving it you can see the error specifying that the stream name is invalid.
Ah yes. I see that.
I guess you are right with the small bug.
My guess it is due to the underscore in your stream name.
Let's see what the Microsoft team here in the community says 😀