Snowflake Custom SQL: Native queries are not supported by this value

I have come accross a few posts in relation to this error but none worked in our case hence trying in a new post.

We are continuously running into Native queries not supported issue when trying to run Custom SQL against a Snowflake datasource. We are currently on October 2022 version.

We have tried fully qualified names for tables and no semi-colons in the end but nothing works.

Any help is appreciated.