QST: I am new to Python + Snowflake, please kindly help, thanks.
### 

- [X] I have searched the [[pandas] tag](https://stackoverflow.com/questions/tagged/pandas) on StackOverflow for similar questions.

- [X] I have asked my usage related question on [StackOverflow](https://stackoverflow.com).


### Link to question on StackOverflow

My code runs successfully, but nothing inserted to the table, only old records returned

### Question about pandas

import pandas as pd
from sqlalchemy import create_engine
from snowflake.sqlalchemy import URL
from config import config

engine = create_engine(URL(account=config.account, 
                  user=config.username, 
                  password=config.password, 
                  warehouse=config.warehouse, 
                  database=config.database, 
                  schema=config.schema,))

conn = engine.connect()

df = pd.DataFrame([('AAA', '1234'), ('BBB', '5678')], columns=['name', 'pswd'])
df.to_sql('demo_db.public.test_f1', con=engine, index=False, if_exists='append', index_label=None)
    
df = pd.read_sql_query('select * from demo_db.public.test_f1', conn)
print(df.head(5))

conn.close()
engine.dispose()