Is it possible to script out the creation of all the tables in dremio, so it can be replayed in another cluster ?
You can use our catalog REST API to walk all the sources and spaces and extract the definitions and then use the API to recreate.
thanks. I would have been super easy if the backup and restore service could do this. Also when I use the
GET /api/v3/catalog/{id}. ---> to retrieve the info
and then use
POST /api/v3/catalog/{id} -- > to recreate the object
Am I posting the exact same content from the GET output ?
You would not use the the ID when you POST to recreate, as the id would be regenerated. You should be able to POST the results of the GET, minus the id parameter.