How about a new choice alongside csv, JSON etc…..add the “synch” feature elsewhere in the system and delete/insert/refresh a nominated table to store the copy. The copy is read-only.
If you do the match by Field name and not data type then we would have a complete “flat” record layout of all the datafields (just data types text, number, date, URL….could live without attachments). Saves me doing a csv and importing back so that I get all the data without the arrays, field numbers etc etc that make the data so hard to read externally with ODBC etc). Using the copy table (Name+READ-ONLY?) I can create a postgresql Metabase application that gives me a full reporting system on top of my Baserow.
hey @mikemitch, did I understand correctly — you’re looking for a feature that automatically creates a read-only copy of a table in Baserow?
Yes… but it needs to be fully flat… as if I used the CSV download and then imported it to a new table… I can then use ODBC on my self hosted postgresql tables…
Hey @mikemitch, got it, I’ll check the request with the team 