How can we connect to a view in SQL Schema using JDBC connection

Raj2019

I am able to connect to table and see the columns using JDBC connection. How can I check the views in any schema.

Could someone please guide me through .

Katya Jermolina

Hello,

Sure, there are some additional options that can configured when creating a database connection. To include the views, click edit the existing database connection and click 'Show advanced options".

The window will expand and there will be an option to 'Include views'.

Click apply, and the database views will appear under the JDBC connections.

Hope that helps!

Katya

Raj2019

Thank you Katya. It worked

Appreciated your time and effort