Related Documentation Download this Manual
PDF (US Ltr) - 2.1Mb
PDF (A4) - 2.1Mb


HeatWave User Guide  /  ...  /  Manually Loading Data from External Storage

5.2.3.1 Manually Loading Data from External Storage

Manually Loading Data with Pre-Authenticated Requests
Note

PARs can be used for any Object Storage data stored in any tenancy in the same region.

mysql> CREATE TABLE `CUSTOMER` (`C_CUSTKEY` int NOT NULL PRIMARY KEY, `C_NATIONKEY` int NOT NULL)
ENGINE=lakehouse
SECONDARY_ENGINE = RAPID
ENGINE_ATTRIBUTE='{"dialect": {"format": "csv”},
                   "file": [{"par": "https://objectstorage.../n/some_bucket/customer.tbl"}]}';
ALTER TABLE `CUSTOMER` SECONDARY_LOAD;
Manually Loading Data with Resource Principals
mysql> CREATE TABLE `CUSTOMER` (`C_CUSTKEY` int NOT NULL PRIMARY KEY,`C_NATIONKEY` int NOT NULL)
ENGINE=lakehouse
SECONDARY_ENGINE = RAPID
ENGINE_ATTRIBUTE='{"dialect": {"format": "csv”},
                   "file": [{"region": "regionName", "namespace": tenancyNamespace",
                   "bucket": "bucketName", "name": "customer.tbl"}]}';   
ALTER TABLE `CUSTOMER` SECONDARY_LOAD;