With NOS you can do the following:
- Analyze data stored on an external object store.
- Read data in CSV, JSON, or Parquet format stored on an external object store.
- Join or aggregate external data to relational data stored in SQL Engine
- Query cold data offloaded to an external object store.
- Load data from external object store into the database using one SQL request.
- Write SQL Engine data to an external object store. The data to be written can come from a table, derived results, another object store, QueryGrid federated query, and so on.
You can use WRITE_NOS to transform CSV and JSON data without having to write it locally to a relational table. Read the CSV or JSON data using CREATE FOREIGN TABLE or READ_NOS, then use WRITE_NOS to write the data in Parquet format.