In this example, all the data in the object store identified by the LOCATION is loaded into the database.
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.
- Create and load the table:
CREATE MULTISET TABLE multiset_table_name AS ( SELECT columnX, columnY, ...columnN FROM ( LOCATION='YOUR-OBJECT-STORE-URI' AUTHORIZATION=authorization_object ) AS d ) WITH DATA;
See Variable Substitutions for Examples for the credentials and location values for the sample river flow data set.
Example: Loading External Data into the Database Using READ_NOS and CREATE TABLE AS
Create and load the table:
CREATE MULTISET TABLE riverflowperm AS ( SELECT site_no, Flow, GageHeight, Precipitation, datetime, GageHeight2 FROM ( LOCATION='/s3/td-usgs-public.s3.amazonaws.com/CSVDATA/' AUTHORIZATION=MyAuthObj ) AS d ) WITH DATA;
Show the number of rows in the table:
SELECT COUNT (*) FROM riverflowperm;
Your result will be similar to the following:
Count(*) ----------- 17058