3 Replies Latest reply on Oct 9, 2019 9:22 AM by Ramesh Reddy

    How to get metadata for View in db?

    Renat Eskenin Newbie

      Hi, All
      Can you help me with teiid-spring-boot and teiid-odata?


      1. We have vertica db and jdbc connection for it.

      2. teiid-spring-boot project with teiid-odata

       

      How we can get metadata for vertica Views? Now we have only for tables.

      Properties for connection

      spring.datasource.vertica.jdbc-url=jdbc:vertica://local:5433/test?SearchPath=bi

      spring.datasource.vertica.username=user

      spring.datasource.vertica.password=password

      spring.datasource.vertica.driver-class-name=com.vertica.jdbc.Driver

      spring.datasource.vertica.platform=vertica

      spring.datasource.vertica.importer.SchemaName=bi

      spring.datasource.vertica.importer.DatabaseTimeZone=UTC

      spring.datasource.vertica.importer.UseFullSchemaName=false

      spring.teiid.model.package=com.test.model