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 ![]()
Hey @mikemitch, I checked your request with the team, and there’s one potential workaround. Would it work for you to use different views to keep only the fields you need, and then export that specific view so you can use the data in Metabase?
Thanks Olga….we are going to use webhooks to maintain a shadow postgresql database with Metabase on top. Will get there!!!
Thanks for your efforts.
Mike