"Execute failed: DROP TABLE is not part of the language" when using DB Writer node with Snowflake

Hello,

When I select check the “Remove Existing Table” in the DB Writer node, I get the following error msg:

Execute failed: DROP TABLE is not part of the language.

I am using Snowflake with JDBC drive. Please advise.

Thanks,
Saqib

Hi there @saqib,

can you check what happens if you use DB Table Remover? And if you use DB SQL Executor node with with written DROP statement?

Br,
Ivan

Table remover node produced the same error:
ERROR DB Table Remover 2:152 Execute failed: DROP TABLE is not part of the language.

However executing the DROP TABLE using the DB SQL Executor node is successful.

Thanks,
Saqib

Hi there @saqib,

try checking DROP TABLE Statement (configures whether DROP TABLE statements are part of the language) from DB Connector node under Advanced tab:

DropTableOpt

Br,
Ivan

5 Likes

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.