Forum Discussion
Eventstream custom SQL code not working due to an invalid input name
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!
It's not the hyphen - it's the underscore.
Eventstream artifact names that include underscores (_) or dot (.) are not compatible with the SQL operator. For the best experience, please create a new Eventstream without using underscores or dots in the artifact name.
https://learn.microsoft.com/en-us/fabric/real-time-intelligence/event-streams/process-events-using-sql-code-editor