Re: Question about exposing tables and columns

2024-03-28 Thread Dilip Patel
Also here is the client-side code: String sql = "select * from ddw_fact_realtime_metric"; Connection connection = null; Statement statement = null; try { connection = DriverManager.getConnection("jdbc:avatica:remote:url=http://localhost:9787;serialization=PROTOBUF;); statement =

Re: Question about exposing tables and columns

2024-03-28 Thread Francis Chuang
Hey Dilip, I don't think your attachment made it through, due to moderation. Can you try uploading it as a gist on GitHub? Francis On 29/03/2024 7:50 am, Dilip Patel wrote: Hi We have a data warehouse, and I want to expose only selected tables from the DW and create a virtual database. I

Question about exposing tables and columns

2024-03-28 Thread Dilip Patel
Hi We have a data warehouse, and I want to expose only selected tables from the DW and create a virtual database. I aim to allow the consumer to query these tables via the JDBC driver. I came across the Calcite and Avatica libraries and they seem to be capable of doing this. I was able to