The methods for loading external data into the database are as follows:
| Method | Description |
|---|---|
| CREATE TABLE AS … WITH DATA | Accesses table definitions and data from an existing foreign table and creates a new permanent table inside the database |
| CREATE TABLE AS … FROM READ_NOS | Accesses data directly from the object store and creates a permanent table inside the database |
| INSERT ... SELECT | Stores values from external data in a persistent database table using an INSERT ... SELECT statement |