search

feldera / feldera

The Feldera Incremental Computation Engine
https://feldera.com
Other
364 stars 35 forks source link

Generate mermaid code for SQL Program for Webconsole UI to render mermaid ER diagram #1147

Closed mohsinbeg closed 5 months ago

mohsinbeg commented 9 months ago

It would be nice to render a ER diagram for the SQL Program in the WebConsole UI. We can decide how to render the views also.

https://mermaid.js.org/syntax/entityRelationshipDiagram.html

cc: @gz

gz commented 9 months ago

@mihaibudiu I think we can generate this once we have the foreign key relationship in your json schema from the compiler

mihaibudiu commented 9 months ago

That should be easy

mihaibudiu commented 9 months ago

But notice that a table can have multiple foreign keys and each foreign key can have multiple columns