SOLVED! The text from this error comes straight from Snowflake and has been seen in other platforms connecting to Snowflake. In this case it occurred because the Snowflake ‘Role’ (termed ‘Default access control role’ in the KNIME Snowflake connector) was set to PUBLIC in KNIME, however in Snowflake PUBLIC role had no access to the warehouse. Once changed to ACCOUNTADMIN in KNIME (a role which had warehouse access in Snowflake) the DB Table Selector worked.
2 Likes