I have created my first Synapse notebook to get a value from a Delta table and use it in a subsequent step in a pipeline. As you can see in the below screenshot, "Display" returns the correct value (as does "Show") but "Exit" returns the data type (string) instead of the value. As a test, I changed the SQL query to use an integer field and the "Exit" function returned a data type of "integer" on this occasion (interesting but not useful at all). Does anybody possibly have a solution to this issue?
I have just found a solution. The alteration is in line 5 in the below screenshot. This is a solution based on the desperate searching of a novice so there are probably better ways to solve this.
I have just found a solution. The alteration is in line 5 in the below screenshot. This is a solution based on the desperate searching of a novice so there are probably better ways to solve this.
Helpful resources
Fabric Data Days
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Fabric Monthly Update - October 2025
Check out the October 2025 Fabric update to learn about new features.
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
