How to get metadata for View in db?

[i3draven]

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

[rareddy]

If you are looking OData metadata, once you start the application considering on localhost, use the address "http://localhost:8080/odata/vertica/$metadata" or simply http://localhost:8080/odata/vertica/$metadata the second only applicable when there is a single source.

[i3draven]

I checked both

http://localhost:8080/odata/vertica/$metadata
http://localhost:8080/odata/$metadata

We have tables and views in db

But only tables found in metadata (Edm)

<?xml version="1.0" encoding="UTF-8"?>

<edmx:Edmx Version="4.0"

  xmlns:edmx="http://docs.oasis-open.org/odata/ns/edmx">

  <edmx:Reference Uri="http://localhost:8080/static/org.teiid.v1.xml">

    <edmx:Include Namespace="org.teiid.v1" Alias="teiid"></edmx:Include>

  </edmx:Reference>

  <edmx:Reference Uri="http://localhost:8080/static/org.apache.olingo.v1.xml">

    <edmx:Include Namespace="org.apache.olingo.v1" Alias="olingo-extensions"></edmx:Include>

  </edmx:Reference>

  <edmx:DataServices>

    <Schema

      xmlns="http://docs.oasis-open.org/odata/ns/edm" Namespace="spring.1.0.0.vertica" Alias="vertica">

      <EntityType Name="account">

......and more tables, no views

[rareddy]

To be exposed through OData the tables or view MUST have a primary key defined on them, without it will ignore those.