Can dremio write back to the Source DB

Dremio University
1

Hi Team,

We’re using dremio community edition (4.0) for connecting to Mysql, we have a schema in Mysql containing 5 tables which need to be joined (as a virtual dataset in dremio) and written back to MySql or other DB as a new table, does dremio provide a functionality to do the same?

Thanks and Regards
Teja

2

@ravi

Dremio can only write back to file system sources like S3/ADLS/Azure Storage/HDFS etc. and only in columnar PARQUET format

Thanks
@balaji.ramaswamy

1 Like