1 Reply Latest reply on Mar 28, 2014 7:05 AM by shawkins

    Is it possible to connect to or set only one model to use in Teiid?

    brkim

      Hi, guys

       

      I found that it's necessary to specify modelName as a prefix to tableName in sql after connecting to vdb in Teiid.

      It's a little bit annoying when only work with one model.

      So I am wondering if there is any way that connect to only one model in a vdb or set.

      So that we can only use TableName instead of ModelName.TableName in sql.

        • 1. Re: Is it possible to connect to or set only one model to use in Teiid?
          shawkins

          You only have to qualify if the name is ambiguous.  You can also mark models as not visible, which will effectively resolve partially qualified names only against the visible models.  However the non visible models will also not show up in the system metadata.

           

          More generally it seems like you are looking for the concept of a default schema which we currently do not have, but you could log an enhancement for that.

           

          Steve