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
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,
)
Creating this URL is currently a bit difficult if you just have the backend connection. Could we make some dataclass like
Originally posted by @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:
Creating this URL is currently a bit difficult if you just have the backend connection. Could we make some dataclass like
and you could get access to it like
backend.connection_params
? This isn't a huge blocker, just a nice-to-have for the ux.The text was updated successfully, but these errors were encountered: