Replibyte icon indicating copy to clipboard operation
Replibyte copied to clipboard

Published 20 hours ago • verified publisher icon Qovery

Show the source database schema

Open evoxmusic opened this issue 3 years ago • 3 comments

As a user, I need to know what tables and columns are available if I need to set up the transformers and subset. It will be super convenient to show the source database schema with a command.

replibyte -c conf.yaml source schema

|    table    |    column    | 
...

Then we can analyze the table structure with potentially sensitive data and relations between tables.

evoxmusic avatar May 16 '22 09:05 evoxmusic

I'm working on this.

realtimetodie avatar May 20 '22 07:05 realtimetodie

I created myself a little Python script to give me a default configuration containing all the tables in my database.

https://gist.github.com/timkrins/ebfa00ce220439d7c3dbe2a309c1a426

It would certainly be handy to have this functionality built in.

timkrins avatar Jul 27 '22 10:07 timkrins

Awesome @timkrins - I will take a deeper look but from what I see it's easily portable. Do you have in mind the limitations of what you did?

evoxmusic avatar Jul 27 '22 10:07 evoxmusic