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!
Hi PaxDataEngineer,
Eventstream name that contains underscores is currently not compatible with SQL operator.
Right now Eventstream throws an authoring error if Eventstream name has underscores and a SQL operator is added to the topology.
Please try creating a new Eventstream without underscores in the name, or rename the existing Eventstream artifact with no underscores in the name to resolves this issue.