Unable to run "test" when editing query and gives "Query Result To Scalar" message when running orchestration. Have tried a number of different queries, all of which run in Snowflake in the other window. and am also able to load data from this DF connection.
OK, well this is dumb, but I wanted to answer to help anyone else who gets this sort of misleading message. Semi-colon! Basically I left the ; at the end of the select. Took it off and everything good. Looking at Snowflake history very clearly shows a syntax error. How we got to the "Can't advance", I don't know!
SELECT COUNT(*) FROM (
select extract_from_date from control.raw.etl_run_ctl where process_type = 'CUSTOMER';)
Another possible cause, for anyone who ends up here, is that you can't end the query in advanced mode with a comment, as this will lead to the same error.
Thanks for this note, it helped solve my issue.
I was submitting an invalid query to Snowflake and getting this error.