You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
In many places in my code I do something like table.to_pandas().to_records(). It could be nice to have a method that goes straight there. IDK, not a huge deal, the existing solution is really not that bad. But just wanted to get an issue up for discussion.
Sorry for the late reply. Since ibis doesn't have upsert, our team uses the dataset library for inserts/updates/upserts. We do all our normal code in ibis, and then updates/upserts are done with:
importdatasetparams=f"{dialect}://{user}:{password}@{url}:{port}/{database}"# <-- sqlalchemy database uri stringwithdataset.connect(params) asdbx:
dbx[tablename].upsert_many(
list_of_dictionaries, # <-- each dict is a db entrycolumn_to_use_as_identifier,
)
The text was updated successfully, but these errors were encountered:
In many places in my code I do something like
table.to_pandas().to_records()
. It could be nice to have a method that goes straight there. IDK, not a huge deal, the existing solution is really not that bad. But just wanted to get an issue up for discussion.Based on @mw3i in #5391 (comment)_:
Sorry for the late reply. Since ibis doesn't have upsert, our team uses the dataset library for inserts/updates/upserts. We do all our normal code in ibis, and then updates/upserts are done with:
The text was updated successfully, but these errors were encountered: