Hi,
Is there a way to save the modified data (virtual datasets) to one of the source databases?
You can write the data from a Virtual Dataset (VDS) to a filesystem source with a CREATE TABLE AS (“CTAS”) statement if you’ve enabled CTAS for the source. See our docs for more information on this:
https://docs.dremio.com/sql-reference/sql-commands/tables.html#creating-tables
That being said, the VDS are views of your physical datasets. The are lightweight and don’t persist any records. If the datasets are not changing, then the VDS will not change, and you want have to “save” the results of a query by running a CTAS.
What are you trying to achieve?
The CTAS option isn’t available in my datasource.
Is that an installation error?