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.
-
To see sample rows without column names:
SELECT TOP 2 payload..* FROM READ_NOS_FM ( ON ( SELECT CAST( NULL AS DATASET STORAGE FORMAT CSV ) ) USING LOCATION('YOUR-STORAGE-ACCOUNT') RETURNTYPE('NOSREAD_RECORD') ) AS D;
See Variable Substitutions for Examples for the credentials and location values for the sample river flow data set.
Your result will be similar to the following:
Payload..* ------------------------------------------------------------------ ["11.6","10000","09380000","2018-07-01 00:00","662","0.00","8.65"] ["10.6","17600","09380000","2018-07-03 00:00","674","0.00","10.23"]