As part of our modeling and data pipeline processes I need to publish DML/DDL SQL scripts automatically, say once per day.
My model export pipeline is based on PostgresSQL DML/DDL, I wrote a tool which parses these files and generate dynamically DML/DDL for all databases which we need to support:
- Huawei Cloud Data Lake Insight - Carbon Data layer
- Huawei Cloud Data Lake Insight - Hive layer - not support all data types, bound to specific fork
- Huawei DWS - Scalable Postgres db with specific language dialect
Yeah, its quite complex
But I need some API in VP which I can call and will give me all SQL statements for all SELECTED diagrams in selected SQL database language.
Would be really useful, so I can release automatically all scripts from modeling tool into GIT for all users to consume.
Thank you for hints.
The functionality can be based on VP client, but maybe its better to introduce some RESP API compatible with Team Server which will provide such functionality, not sure what is better in terms of business feature from your perspective…