Note: You can modify the relational view only if your session uses REST files. For sessions that use internal memory to map the relational view (CreateMap=Session), the following functionality is not supported.
You can manually edit the resolved REST file to modify the relational view of your data, including adding/removing endpoints or updating the primary key. When you first issue a SQL command for a session, the driver overwrites the resolved REST file to the location specified by the SchemaMap. To persist your changes, you will need to move the edited REST file to the location specified by the Config property. This procedure will guide you through the process of modifying the REST file.
To modify your REST file:
1. Copy the REST file in the location specified by the SchemaMap property to a new location or the current location specified by the Config property. Note, if moving the file to a different location, the driver must have read access to the new directory.
2. Edit the contents of the copied REST file to do either of the following:
3. Set the Config property to specify the name and location of the edited REST file.
4. Set the CreateMap property to ForceNew.
Note: After completing this procedure, set the CreateMap property to your preferred setting.
5. Use the driver to execute any SQL command to regenerate the resolved REST file.
The resolved REST file, and therefore your relational view, now includes your modifications. If you need to make additional modifications, repeat the steps discussed in this procedure.
Designate the primary key for a table. See Designating the primary key for details.
