Running sql queris with snowflake

sunilkumarnagoore · August 28, 2020, 9:11am

i have writen a code to connect snowflake

i have a query one
sql_query = “copy into table1 from table2”

like this query i am unable to run i am getting below error
Malformed SQL Statement: Unexpected token encountered: [copy].

please help me how can i run this type of query

specious · August 28, 2020, 3:24pm

You have to give it valid SQL. copy isn’t an SQL statement.

sunilkumarnagoore · August 29, 2020, 12:39pm

and also when i do truncate a table then also i am getting same error.
i ran the below query
sql = truncate table employee

specious · August 29, 2020, 9:06pm

And your error message is?

sunilkumarnagoore · September 1, 2020, 5:22am

Malformed SQL Statement: Unexpected token encountered: [truncate].

this one errror