User experience

Netezza Performance Server offers seamless integration with Native Cloud Object Storage (NCOS), enabling a straightforward path for adoption. To create a table that utilizes object storage, see SQL syntax for storage type specification.

How to enable object storage

Login to the Console.
Navigate to Settings.
Locate Object Storage Settings and click Add a bucket.
Choose an option in Configure Storage Bucket menu (Amazon S3 or Azure Blob storage).
Follow the on-screen instructions. For details, see Setting up a cloud object storage bucket.
Once the bucket is configured, the button will change to Enable Object Storage.

Important

During the enabling process, all console operations will be suspended. You will not be able to navigate or perform any other actions.
After configuring the bucket, wait for sometime before enabling object storage. This delay ensures proper synchronization between Netezza processes.
Once enabled, object storage cannot be disabled.

How to use object storage

Create a database with object storage

Go to the Database page.
Click Create Database.
Set Storage Type to Object.

Example:

CREATE DATABASE <database_name> STORAGETYPE 'OBJECT';

For detailed instructions on creating databases using the web console, see Creating databases.
For a complete reference on SQL commands, see CREATE DATABASE.

Create a table with object storage

Go to the Tables page.
Click Create Table.
Set Storage Type to Object.

Example:

CREATE TABLE <table_name> (
   <column_name> <data_type>
) STORAGETYPE 'OBJECT';

For detailed instructions on creating databases using the web console, see Creating tables.
For a complete reference on SQL commands, see CREATE TABLE.

Existing tables will remain on Block Storage. To change the system-wide default to object storage, contact support.

Additional reference: SQL syntax for storage type specification.

Object naming and deletion

Object naming: Each object saved in the object store has a prefix /nps/<instance name>/<dbuuid>/<dsid>.

Object deletion: An asynchronous garbage cleaner performs object deletion. Metadata objects are automatically deleted from version 11.3.0.5-IF1 onwards.