Preview the contents of an external object store by using the READ_NOS table operator. In this example, the payload column contains the data.
The examples and results show a sample river flow data set. To use your own data, replace the table and column names, and authorization object.
- To run NOS-related commands, log on to the database as a user with the required privileges.
-
Sample the data in place:
SELECT TOP 2 payload.* FROM READ_NOS_FM ( ON ( SELECT CAST( NULL AS JSON ) ) USING LOCATION('YOUR-STORAGE-ACCOUNT') ) AS D;
See Variable Substitutions for Examples for the credentials and location values for the sample river flow data set.
Result:
Payload.* ------------------------------------------------------------------- ["09380000","2018-07-01 00:00","10000","8.65","11.6","662","0.00"] ["09380000","2018-06-28 00:00","15900","9.91","11.0","671","0.00"]