Snowflake VIEWs (including views over regular tables) are not found by Calcite when creating a JDBC Virtual Graph. Error: Object 'VW_EQUIPMENT_DIM_G'
▎ not found. Regular tables work fine with the same connection. Need the correct connection property to make Calcite include VIEW-type objects in its JDBC
▎ metadata scan.
Hi Rajaram,
Assuming that the connection can see the views, and that the views are in the same schema as the tables that you can see, what's probably happening is that the data source has cached the table/view information before the views were created. If you can use the CLI apps, the command for refreshing metadata is stardog-admin data-source refresh-metadata. If you can't, then you can re-save the data source in Stardog Studio. (You can make some change to a property and then change it back.)
If the views are in a different schema, you may need to add the schema to the data source using the sql.schemas data source property.
You can confirm that the connection can see the views by using the stardog-admin virtual source_metadata command. Note that this is a client-side utility – it will need its own access to the Snowflake JDBC driver and it will make the connection to Snowflake from the client directly, without going through the Stardog server. This utility makes the same JDBC calls as Stardog, so you can be sure that if the client app can see the views, Stardog will be able to, also.
-Paul