Add primary key to view from Designer

[dvallabh_doi]

I'm having difficulty trying to figure out how to add a primary key to a model view table when in designer.

I followed the instructions from the following two discussions:

• Any source as an OData feed using Data Virtualization
• Integrate Amazon SimpleDB with Teiid

Adding the row_number() function and then reconciling the SQL does not generate the PK column and there is no option to manually create as suggested in the first link ( Rt-Click > New Child > Primary Key). The only two options that appear are "Access Pattern" and "Column". And without the primary key it cannot be queried via the Odata protocol

Not sure if I'm missing something or simply looking at the wrong place. Currently using the latest JBoss Dev Studio (11.1.0) with Teiid Designer 11.1

Thanks

[rareddy]

First, create a new column on the view say "id" and in the transformation use "row_number()" function to generate the unique ids, then add PrimaryKey and select the "id" column you created as the column to create the Primary Key on.

[dvallabh_doi]

Followed the steps you mentioned, but still don't the see the option to add the primary key.

[rareddy]

Try adding transformation for the View first, I believe the option then shows up (hopefully)

[dvallabh_doi]

I think the screen below is what you referring to. It's only time I can get the PK column to be configured is at the initial creation screen.