Dataframe to_sql

Hi ,
I am trying to write a dataframe to dremio by using the following code:

df.to_sql(name=‘people’, con=engine, schema=‘nessie1’,index = False,dtype={‘Name’: sqlalchemy.types.VARCHAR(length=255), ‘Age’: sqlalchemy.types.Integer})

the table is created but no data is written . ı am getting this error code:

TypeError: Cursor.executemany() takes 2 positional arguments but 3 were given

I s there any solution for this?
thanks
tolga