In iShare Studio with the Data Share Connections selected:
...
The following is an example for the streetdescriptor_latest view.
Name
Enter a name for your connection to correctly reflect the data so in this case we have used streetdescriptor_latest.
SQL
Here you need to enter the SQL to select the data that you wish to include. In this example we are selecting everything from the streetdescriptor_latest view and by using * it will return all the fields e.g.
| Code Block |
|---|
SELECT * FROM “streetdescriptor_latest” |
Click OK.
Now you have the option to select some additional details.
Query Field
Select record_seq as the query field for each of the four views.
...