snowflake connector SQL compilation error: maximum number of expressions in a list exceeded, expected at most 16,384
Solution 1:
I was able to insert > 16k recs using sqlalchemy and pandas as:
pandas_df.to_sql(sf_table, con=engine, index=False, if_exists='append', chunksize=16000)
where engine is sqlalchemy.create_engine(...)