Creating the Vplaydata View
The procedures you create later will all use this view—a simple mapping from one view to one table. (The absence of transformations or joins within the exposed view means you can add to and update it.)
Note: It is typical to wrap even simple tables in a Studio view to decouple the services and clients from the physical connection.
To create the Vplaydata view
1. From the Studio resource tree, create the playdata folder under the Shared folder.
2. Right-click the playdata folder and select New View.
3. Give the view the name “Vplaydata” and click OK.
4. In the View editor for Vplaydata, drag the playdata.csv object onto the Model tab.
5. Select the Grid tab and set the following values.
6. Validate that the SQL tab contains the following.
SELECT
playdata_csv.id,
playdata_csv.name,
playdata_csv.author
FROM
/shared/datasources/filebased/playdata/"playdata.csv" playdata_csv
7. Select the Indexes tab and set the values to match the following.
8. Save the definitions.
