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 * FROM ( LOCATION='YOUR-OBJECT-STORE-URI' AUTHORIZATION=authorization_object ) AS D;
See Variable Substitutions for Examples for the credentials and location values for the sample river flow data set.
Example: Sampling External Data In Place Using READ_NOS
SELECT TOP 2 * FROM ( LOCATION='/s3/td-usgs-public.s3.amazonaws.com/CSVDATA/' AUTHORIZATION=MyAuthObj ) AS D;
Your result will be similar to the following:
Location /S3/s3.amazonaws.com/td-usgs-public/CSVDATA/09429070/2018/07/ GageHeight2 ? Flow ? site_no 9429070 datetime 2018-07-02 14:35 Precipitation 1.16 GageHeight ? Location /S3/s3.amazonaws.com/td-usgs-public/CSVDATA/09400815/2018/07/ GageHeight2 ? Flow .00 site_no 9400815 datetime 2018-07-10 00:00 Precipitation .00 GageHeight -.01
The output is displayed vertically for readability.