Python Write back source/view

How do I: 1. insert a Python results e.g. Python Pandas dataframe back to Denodo as a source and/or base view? 2. How do I insert a calculated array value/field from Python into an existing Denodo View? Thanks,
Q&A
user
07-11-2019 07:42:44 -0500

1 Answer

Hi, Regarding inserting a dataframe as a data source or base view in Denodo, assuming that those data frames come from an existing data source such as a database or CSV file what I would do is to store those data frames into that same data source or any other and create a base view from Denodo over it. Denodo does not store any data. In order to insert values back to an existing view in Denodo I would review the documentation on the [INSERT Statement](https://community.denodo.com/docs/html/browse/7.0/vdp/vql/inserts_updates_and_deletes_over_views/insert_statement/insert_statement) and on using [Using Notebooks for Data Science with Denodo](https://community.denodo.com/kb/view/document/Using%20Notebooks%20for%20Data%20Science%20with%20Denodo?category=Northbound+Connections). I was able to create a working connection where I could issue VQL statements from Python to Denodo. Hope this helps!
Denodo Team
08-11-2019 15:10:17 -0500
You must sign in to add an answer. If you do not have an account, you can register here