Can't call Snowflake GET_OBJECT_REFERENCES function

Question

I'm trying to run the following statement from an input tool in Alteryx (using actual object names):

SELECT * FROM TABLE(GET_OBJECT_REFERENCES(DATABASE_NAME => 'DATABASE_NAME', SCHEMA_NAME => 'SCHEMA_NAME', OBJECT_NAME => 'OBJECT_NAME'));

It runs as expected in the Snowflake UI, but when I run in Alteryx (using the same account/permissions) I get this error:

Does anyone know how to correct this?

Thanks!

dreldrel · Answer

You can try to remove the semicolon and see if that helps. Sometimes it helps me, which is pretty weird.

apathetichell · Answer

hypothesis --- alteryx didn't build for < or > in the sql query --- so this is breaking up the xml. You can test this by turning on logging your Snowflake driver in odbc64 (not in Alteryx) ---- and see what happens. some potential fixes:

1) try running in-db --- use connect in-db and drop this in. See if that works any better.