I am trying to load data from excel to Snowflake using Python.

Below is my code so far:

config = ConfigParser()

# parse ini file
config.read('config.ini')

## Read excel
file = '/path/INTRANSIT.xlsx'

df_excel = pd.read_excel(file, engine='openpyxl')

# sqlalchemy to create DB engine
engine = create_engine(URL(
    account = config.get('Production', 'accountname'),
    user = config.get('Production', 'username'),
    password = config.get('Production', 'password'),
    database = config.get('Production', 'dbname'),
    schema = config.get('Production', 'schemaname'),
    warehouse = config.get('Production', 'warehousename'),
    role=config.get('Production', 'rolename'),
)
)
con = engine.connect()

df_excel.to_sql('transit_table',con, if_exists='replace', index=False) 

con.close()

But I am getting below error:

sqlalchemy.exc.InvalidRequestError: Could not reflect: requested table(s) not available in Engine(snowflake://username:***@account_identifier/): (db.schema.transit_table)

I have tried prefixing Database and schema to table and also tried passing table name alone. I have also tried passing uppercase and lowercase table name.

Still not able to resolve this error. Would really appreciate any help to resolve this!

Thank you.