---
name: netezza-netezza-cos-userexperience
title: User experience
description: ''
last-updated: 2025-09-19
---

> ## Documentation Index
> The table of contents for this documentation set is at https://cloud.ibm.com/docs/netezza?format=markdown
> The index for all IBM Cloud docs is at: https://cloud.ibm.com/docs/llms.txt
> Use these files to discover more information as needed.

{:external: target="_blank" .external}
{:shortdesc: .shortdesc}
{:tip: .tip}
{:important: .important}
{:note: .note}
{:codeblock: .codeblock}
{:screen: .screen}
{:caption: .caption}

# User experience
{: #user_exp}

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](https://cloud.ibm.com/docs/netezza?topic=netezza-netezzacossql&format=markdown).

## How to enable object storage
{: #htuos}

1. Login to the Console.
2. Navigate to `Settings`.
3. Locate Object Storage Settings and click **Add a bucket**.
4. Choose an option in Configure Storage Bucket menu (Amazon S3 or Azure Blob storage).
5. Follow the on-screen instructions. For details, see [Setting up a cloud object storage bucket](https://cloud.ibm.com/docs/netezza?topic=netezza-cloudobjectstorage&format=markdown).
6. 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
{: #htuos}

### Create a database with object storage
{: #cadwos}

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

Example:
 ```bash
CREATE DATABASE <database_name> STORAGETYPE 'OBJECT';
```
{: codeblock}

- For detailed instructions on creating databases using the web console, see [Creating databases](https://cloud.ibm.com/docs/netezza?topic=netezza-databases&format=markdown).
- For a complete reference on SQL commands, see [CREATE DATABASE](https://www.ibm.com/docs/en/netezza?topic=nscr-create-database).

### Create a table with object storage
{: #catwos}

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

Example:
 ```bash
CREATE TABLE <table_name> (
    <column_name> <data_type>
) STORAGETYPE 'OBJECT';
```
{: codeblock}

- For detailed instructions on creating databases using the web console, see [Creating tables](https://cloud.ibm.com/docs/netezza?topic=netezza-create-tables&format=markdown#creating-tables).
- For a complete reference on SQL commands, see [CREATE TABLE](https://www.ibm.com/docs/en/netezza?topic=nscr-create-table).


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

Additional reference: [SQL syntax for storage type specification](https://cloud.ibm.com/docs/netezza?topic=netezza-netezzacossql&format=markdown).

## Object naming and deletion
{: #obj_naming_del}

**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.