Great articles. Thanks for sharing.

Why are you using Language Tag and not "pure" python script ? It's so much convient to work with native python script than python code in cls classes.

Hi,

If i remember correctly, the default behavior of the to_sql method is to use a transaction to insert the data.

What i do is using with statement to ensure that the transaction is commited and closed after the insert:

with engine.connect() as conn:
    train_df.to_sql(name='table1', con=conn, if_exists='replace', index=False)

Otherwise, you can commit the transaction manually:

conn = engine.connect()
train_df.to_sql(name='table1', con=conn, if_exists='replace', index=False)
conn.commit()
conn.close()

That's what i do, hope it helps.

Hi, i guess you are looking for Flexible Python Runtime Feature

https://docs.intersystems.com/iris20242/csp/docbook/DocBook.UI.Page.cls?...

Unfortunately, this feature is only available starting IRIS 2024.1+