cloud – Issue while writing data from azure notebook to dedicated sql pool
I’m trying to send data in a dataframe from azure synapse notebook to a already created table in dedicated SQL pool table
df.to_sql(‘dbo.table1’, conn, if_exists=”append”, index=False)
conn is using ODBC driver and py odbc but I’m getting the following error :
Execution failed on sql: SELECT name FROM sqlite_master WHERE type=”table” AND name=?;
(’42S02′, “[42S02] [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Invalid object name ‘sqlite_master’. (208) (SQLExecDirectW)”)
unable to rollback
Read more here: Source link
