OpenQuestions

1. Apache HTTPClient Vs RestTemplate as the REST API client library

2. Use GenAI :

Auto generate the SQL query based on schema to: Create reports on Catalog Create queries on physical tables/views using curated assets in catalogs

Auto-generate SQL Query based on schema (i) to create reports on WKC, or (ii) to create queries on physical tables/views using curated assets in WKC. As a collaborator who need to create the Custom reports and Dashboards on metadata in catalogs reporting DB; he can put the query requirements using Natural language ; say Chat interface and GenAI will provide the SQL Query based on the db schema; thus the queries can be used further to create custom reports using tools as TableU for instance.

Use LangChain: https://www.baeldung.com/java-langchain-basics

3. OPEN API key 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

5. How to maintain scriots corresponding to DB versions/schema

6. Must DO LLD https://hashnode.com/@techlinks

7. when to use runtim getDeclaredConstructors as in extractor code

8. TO DO:

https://github.com/ctongfei/progressbar

LangChain equivalent in Java:** https://github.com/langchain4j/langchain4j