Hello, I'm using snowflake odbc driver + database package for inserting some rows to a "dummy" database. My snowflake database-schema-table is the following:
I'm trying to insert a row from A360 bot (I have installed the ODBC driver for it and the "select" query is working fine) and I always face the same issue. The query is this one:
INSERT INTO INGEST_AUTOMATION.products VALUES (2,'psp',FALSE,'2010-09-09')
The error is the following:
'''
There was a problem at line 2
This may be due to the following reason:
- There is a syntactical error in the SQL statement.
- SQL statement got timed out.
'''
Screenshot of the error:
Could anyone help me? Why the INSERT INTO query works perfectly from snowflake and it doesn't from AA bot? Thanks!