> ## Documentation Index
> 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.

# Netezza Performance Server

Welcome to the Netezza Performance Server for Cloud Pak for Data as a Service product documentation.

## Get started

- [Release notes for NPSaaS](https://cloud.ibm.com/docs/netezza?topic=netezza-my-service-relnotes1123x&format=markdown)
- [Getting started with NPSaaS](https://cloud.ibm.com/docs/netezza?topic=netezza-getstarted&format=markdown)
- Connecting to Netezza Performance Server with private and public endpoints
   - [Connecting to NPSaaS](https://cloud.ibm.com/docs/netezza?topic=netezza-connecting-overview&format=markdown)
   - [Configuring private endpoints](https://cloud.ibm.com/docs/netezza?topic=netezza-creating-private-endpoints&format=markdown)
- [Loading data to Netezza Performance Server](https://cloud.ibm.com/docs/netezza?topic=netezza-load-dbs&format=markdown)
- Netezza Performance Server web console
   - [Getting started with the web console](https://cloud.ibm.com/docs/netezza?topic=netezza-getstarted-console&format=markdown)
   - [Managing users and groups](https://cloud.ibm.com/docs/netezza?topic=netezza-users-groups&format=markdown)
   - [Using the Netezza database assistant](https://cloud.ibm.com/docs/netezza?topic=netezza-database-assistant&format=markdown)
   - Databases
      - [Databases](https://cloud.ibm.com/docs/netezza?topic=netezza-databases&format=markdown)
      - [Schemas](https://cloud.ibm.com/docs/netezza?topic=netezza-create-schemas&format=markdown)
      - [Tables](https://cloud.ibm.com/docs/netezza?topic=netezza-create-tables&format=markdown)
      - [Views](https://cloud.ibm.com/docs/netezza?topic=netezza-create-views&format=markdown)
      - [Sequences](https://cloud.ibm.com/docs/netezza?topic=netezza-create-sequences&format=markdown)
      - [Synonyms](https://cloud.ibm.com/docs/netezza?topic=netezza-create-synonyms&format=markdown)
      - [Libraries](https://cloud.ibm.com/docs/netezza?topic=netezza-create-libraries&format=markdown)
      - [Functions](https://cloud.ibm.com/docs/netezza?topic=netezza-create-functions&format=markdown)
      - [Aggregates](https://cloud.ibm.com/docs/netezza?topic=netezza-create-aggregates&format=markdown)
      - [Procedures](https://cloud.ibm.com/docs/netezza?topic=netezza-create-procedures&format=markdown)
      - [Managing owners](https://cloud.ibm.com/docs/netezza?topic=netezza-managing_owners&format=markdown)
   - [Query editor](https://cloud.ibm.com/docs/netezza?topic=netezza-query-editor&format=markdown)
   - [History](https://cloud.ibm.com/docs/netezza?topic=netezza-history&format=markdown)
   - [Current activity](https://cloud.ibm.com/docs/netezza?topic=netezza-current-activity&format=markdown)
   - [Resource monitoring](https://cloud.ibm.com/docs/netezza?topic=netezza-resource_mon&format=markdown)
   - Administration
      - [Administration settings](https://cloud.ibm.com/docs/netezza?topic=netezza-adm-settings&format=markdown)
      - [Scheduler rules](https://cloud.ibm.com/docs/netezza?topic=netezza-scheduler-rules&format=markdown)
   - Workload patterns
      - [Workload patterns](https://cloud.ibm.com/docs/netezza?topic=netezza-patterns&format=markdown)
      - [Pausing and resuming](https://cloud.ibm.com/docs/netezza?topic=netezza-pnr-console&format=markdown)
      - [Auto-pausing and auto-resuming](https://cloud.ibm.com/docs/netezza?topic=netezza-autopnr-console&format=markdown)
      - [Scaling](https://cloud.ibm.com/docs/netezza?topic=netezza-scaling-console&format=markdown)
      - [Smart scaling](https://cloud.ibm.com/docs/netezza?topic=netezza-smartscaling&format=markdown)
   - Backup and restore
      - [Overview](https://cloud.ibm.com/docs/netezza?topic=netezza-bnr-overview&format=markdown)
      - [Backup and restore with the web console](https://cloud.ibm.com/docs/netezza?topic=netezza-bnr-webconsole&format=markdown)
      - [Configuring recommended backup flows](https://cloud.ibm.com/docs/netezza?topic=netezza-configure-flow&format=markdown)
   - Preferences
      - [Preferences overview](https://cloud.ibm.com/docs/netezza?topic=netezza-preferences&format=markdown)
- Netezza dbt adaptor
   - [Getting started with Netezza dbt adapter](https://cloud.ibm.com/docs/netezza?topic=netezza-nzdbt-intro&format=markdown)
- Netezza cloud object storage
   - [Introduction to Object Storage on Netezza](https://cloud.ibm.com/docs/netezza?topic=netezza-netezzacosobjstrge&format=markdown)
   - [User experience](https://cloud.ibm.com/docs/netezza?topic=netezza-user_exp&format=markdown)
   - [Getting started](https://cloud.ibm.com/docs/netezza?topic=netezza-netezzacosgetstarted&format=markdown)
   - Environment setup
      - [Setting up a cloud object storage bucket](https://cloud.ibm.com/docs/netezza?topic=netezza-cloudobjectstorage&format=markdown)
   - Database object management
      - [SQL syntax for storage type specification](https://cloud.ibm.com/docs/netezza?topic=netezza-netezzacossql&format=markdown)
   - [Netezza Cloud Object Storage Utilization](https://cloud.ibm.com/docs/netezza?topic=netezza-netezza_cososm&format=markdown)
   - [Compatibility and upgrade considerations](https://cloud.ibm.com/docs/netezza?topic=netezza-netezzacompatibility&format=markdown)

## Tutorials

- [Migrating on-premises backups to cloud](https://cloud.ibm.com/docs/netezza?topic=netezza-migrating-onprem-cloud&format=markdown)

## How to

- Administering
   - [Retrieving information about endpoints](https://cloud.ibm.com/docs/netezza?topic=netezza-next-endpoints&format=markdown)
   - [Managing credentials](https://cloud.ibm.com/docs/netezza?topic=netezza-managing-credentials&format=markdown)
   - [Resetting history user password](https://cloud.ibm.com/docs/netezza?topic=netezza-reset-password&format=markdown)
   - [Deleting your deployment and removing your data](https://cloud.ibm.com/docs/netezza?topic=netezza-deprovisioning&format=markdown)
   - [Pausing and resuming instances](https://cloud.ibm.com/docs/netezza?topic=netezza-pauseresume&format=markdown)
   - [Auto-pausing and Auto-resuming](https://cloud.ibm.com/docs/netezza?topic=netezza-autopause&format=markdown)
   - [Scaling](https://cloud.ibm.com/docs/netezza?topic=netezza-scaling-topic&format=markdown)
   - [Smart scaling](https://cloud.ibm.com/docs/netezza?topic=netezza-smartscaling_intro&format=markdown)
   - [AutoMaint](https://cloud.ibm.com/docs/netezza?topic=netezza-autoadmin&format=markdown)
- Managing authentication methods
   - [Managing authentication methods](https://cloud.ibm.com/docs/netezza?topic=netezza-authenticating&format=markdown)
   - Setting IBM IAM authentication
      - [Setting IBM IAM authentication](https://cloud.ibm.com/docs/netezza?topic=netezza-ibmiamauth&format=markdown)
      - [Managing IAM access for NPSaaS](https://cloud.ibm.com/docs/netezza?topic=netezza-iam-docs&format=markdown)
   - Setting AWS IAM authentication
      - [AWS IAM authentication](https://cloud.ibm.com/docs/netezza?topic=netezza-awsiamauth&format=markdown)
      - [Login AWS IAM user](https://cloud.ibm.com/docs/netezza?topic=netezza-loginawsiamauth&format=markdown)
      - [Usage of nzcli with AWS IAM authentication](https://cloud.ibm.com/docs/netezza?topic=netezza-usage_nzcli_w_aws_auth&format=markdown)
      - [AWS IAM Policy Permissions](https://cloud.ibm.com/docs/netezza?topic=netezza-awsiampolicypermission&format=markdown)
   - Setting SAML authentication
      - [Overview](https://cloud.ibm.com/docs/netezza?topic=netezza-samloverview&format=markdown)
      - [Enabling SAML authentication](https://cloud.ibm.com/docs/netezza?topic=netezza-samliamauth&format=markdown)
      - [Configuring SAML authentication in IdP](https://cloud.ibm.com/docs/netezza?topic=netezza-saml-docs&format=markdown)
      - [Usage of nzcli with SAML authentication](https://cloud.ibm.com/docs/netezza?topic=netezza-usage_nzcli_w_saml_auth&format=markdown)
   - Setting Azure OIDC authentication
      - [Overview](https://cloud.ibm.com/docs/netezza?topic=netezza-oidcoverview&format=markdown)
      - [Enabling Azure OIDC authentication](https://cloud.ibm.com/docs/netezza?topic=netezza-enable_oidciamauth&format=markdown)
      - [Configuring Azure OIDC authentication in an external IdP](https://cloud.ibm.com/docs/netezza?topic=netezza-oidc-docs&format=markdown)
      - [Usage of nzcli with OIDC authentication](https://cloud.ibm.com/docs/netezza?topic=netezza-usage_nzcli_w_oidc_auth&format=markdown)
      - [Usage of ODBC driver with OIDC authentication](https://cloud.ibm.com/docs/netezza?topic=netezza-usage-odbc-oidc&format=markdown)
   - [Setting Azure AD authentication](https://cloud.ibm.com/docs/netezza?topic=netezza-azureadauth&format=markdown)
   - [Setting LDAP authentication](https://cloud.ibm.com/docs/netezza?topic=netezza-ldapauth&format=markdown)
   - [External authentication](https://www.ibm.com/docs/en/netezza?topic=reference-register-external-authentication-system)
- [NPSaaS and Kafka](https://cloud.ibm.com/docs/netezza?topic=netezza-netezzakafka&format=markdown)
- REST catalog
   - [Managing Iceberg tables with IBM Netezza REST catalog](https://cloud.ibm.com/docs/netezza?topic=netezza-netezza_manage_iceberg&format=markdown)
- Querying data from data lakes
   - [Querying data from data lakes](https://cloud.ibm.com/docs/netezza?topic=netezza-querying_singularity&format=markdown)
   - [Ingesting data from data lakes](https://cloud.ibm.com/docs/netezza?topic=netezza-ingest_singularity&format=markdown)
   - [Merging and querying data](https://cloud.ibm.com/docs/netezza?topic=netezza-merging_singularity&format=markdown)
   - [External tables](https://www.ibm.com/docs/en/netezza?topic=dl-external-tables-2)
- Querying data from watsonx.data
   - [Overview](https://cloud.ibm.com/docs/netezza?topic=netezza-overview_watsonx.data&format=markdown)
   - [Integrating NPSaaS with watsonx.data](https://cloud.ibm.com/docs/netezza?topic=netezza-integratenps_watsonx.data&format=markdown)
   - [Querying data from watsonx.data](https://cloud.ibm.com/docs/netezza?topic=netezza-querying_watsonx.data&format=markdown)
   - [Ingesting data from watsonx.data](https://cloud.ibm.com/docs/netezza?topic=netezza-ingest_watsonx.data&format=markdown)
   - [Merging and querying data from watsonx.data](https://cloud.ibm.com/docs/netezza?topic=netezza-merging_watsonx.data&format=markdown)
   - [Supported SQL commands](https://cloud.ibm.com/docs/netezza?topic=netezza-sqlcommands_watsonx.data&format=markdown)
   - [Schema names in Hive Metastore (HMS) that are NPS reserved keywords](https://cloud.ibm.com/docs/netezza?topic=netezza-hms_npskeywords.data&format=markdown)
   - [Known issues](https://cloud.ibm.com/docs/netezza?topic=netezza-watsonx.data_knownissues&format=markdown)
   - [Time travel for Iceberg table](https://cloud.ibm.com/docs/netezza?topic=netezza-timetravel_watsonxdata&format=markdown)
- Querying data from watsonx.data Software as a Service
   - [Overview](https://cloud.ibm.com/docs/netezza?topic=netezza-overview_watsonx.data_mcsp&format=markdown)
   - [Integrating NPSaaS with watsonx.data](https://cloud.ibm.com/docs/netezza?topic=netezza-integratenps_watsonx.data_mcsp&format=markdown)
   - [Querying data from watsonx.data](https://cloud.ibm.com/docs/netezza?topic=netezza-querying_watsonx.data_mcsp&format=markdown)
   - [Ingesting data from watsonx.data](https://cloud.ibm.com/docs/netezza?topic=netezza-ingest_watsonx.data_mcsp&format=markdown)
   - [Merging and querying data from watsonx.data](https://cloud.ibm.com/docs/netezza?topic=netezza-merging_watsonx.data_mcsp&format=markdown)
   - [watsonx.data SQL commands](https://cloud.ibm.com/docs/netezza?topic=netezza-sqlcommands_watsonx.data_mcsp&format=markdown)
   - [Schema names in Hive Metastore (HMS) that are NPS reserved keywords](https://cloud.ibm.com/docs/netezza?topic=netezza-hms_npskeywords.data_mcsp&format=markdown)
- Monitoring and alerts
   - [Overview](https://cloud.ibm.com/docs/netezza?topic=netezza-nzalert_overview&format=markdown)
   - [Nzalerts on AWS](https://cloud.ibm.com/docs/netezza?topic=netezza-nzalert_aws_setup&format=markdown)
   - [Nzalerts on Azure](https://cloud.ibm.com/docs/netezza?topic=netezza-nzalert_setup&format=markdown)
- Time travel and historical data
   - [Getting started with NPSaaS time travel](https://cloud.ibm.com/docs/netezza?topic=netezza-introducing_tt&format=markdown)
   - [Creating and altering objects for time travel](https://cloud.ibm.com/docs/netezza?topic=netezza-enablingdisabling_tt&format=markdown)
   - [Managing time travel space usage](https://cloud.ibm.com/docs/netezza?topic=netezza-managing_tt&format=markdown)
   - [Managing the default retention time interval for the system and viewing retention time intervals](https://cloud.ibm.com/docs/netezza?topic=netezza-dataretentioninterval_tt&format=markdown)
   - Querying historical database
      - [Time travel query syntax and timestamps](https://cloud.ibm.com/docs/netezza?topic=netezza-runningqueries_tt&format=markdown)
      - [Querying historical data](https://cloud.ibm.com/docs/netezza?topic=netezza-queryingdata_tt&format=markdown)
   - [Time travel SQL commands](https://cloud.ibm.com/docs/netezza?topic=netezza-sqlcommands_tt&format=markdown)

## Reference

- Command-line interface
   - [The nz tool](https://cloud.ibm.com/docs/netezza?topic=netezza-nztool&format=markdown)
   - [Timezone management](https://cloud.ibm.com/docs/netezza?topic=netezza-timezn_mngmnt&format=markdown)
   - [Netezza Performance Server commands](https://www.ibm.com/docs/en/netezza?topic=interfaces-command-line-interface)
   - [The nzsql command](https://www.ibm.com/docs/en/netezza?topic=sc-nzsql-command)
   - [SQL commands](https://www.ibm.com/docs/en/netezza?topic=dud-netezza-performance-server-sql-command-reference-2)
- Backup and restore
   - [Overview](https://cloud.ibm.com/docs/netezza?topic=netezza-bnr-overview&format=markdown)
   - [Backup and restore with the web console](https://cloud.ibm.com/docs/netezza?topic=netezza-bnr-webconsole&format=markdown)
   - [Configuring recommended backup flows](https://cloud.ibm.com/docs/netezza?topic=netezza-configure-flow&format=markdown)
   - [Backup and restore performance improvements](https://www.ibm.com/docs/en/netezza?topic=npscpdas-backup-restore-performance-improvements-many-tables-views-procedures)
   - [Backup and restore best practices](https://www.ibm.com/docs/en/netezza?topic=service-backup-restore-best-practices)
- Security
   - Security compliance
      - [Overview](https://cloud.ibm.com/docs/netezza?topic=netezza-security_compliance_overview&format=markdown)
   - [Learning about NPSaaS architecture and workload isolation](https://cloud.ibm.com/docs/netezza?topic=netezza-compute-isolation&format=markdown)
   - [Endpoints](https://cloud.ibm.com/docs/netezza?topic=netezza-endpoints&format=markdown)
   - [Data security and encryption](https://cloud.ibm.com/docs/netezza?topic=netezza-data-encryption&format=markdown)
   - [Steps to acquire SSL certificates for netezza](https://cloud.ibm.com/docs/netezza?topic=netezza-step_acq_sslcert&format=markdown)
   - [Managing IAM access for NPSaaS](https://cloud.ibm.com/docs/netezza?topic=netezza-iam-docs&format=markdown)
   - [Network policies](https://cloud.ibm.com/docs/netezza?topic=netezza-network-policies&format=markdown)
   - [For security experts](https://www.ibm.com/docs/en/netezza?topic=service-netezza-performance-server-security-experts)
- [Analytics](https://www.ibm.com/docs/en/netezza?topic=service-netezza-performance-server-analytics-acceleration-developers)
- [Understanding high availability for NPSaaS](https://cloud.ibm.com/docs/netezza?topic=netezza-ha&format=markdown)
- [Understanding business continuity and disaster recovery for NPSaaS](https://cloud.ibm.com/docs/netezza?topic=netezza-understanding-bc-dr&format=markdown)

## Help

- [FAQs for NPSaaS](https://cloud.ibm.com/docs/netezza?topic=netezza-netezza-faqs&format=markdown)
- [Opening tickets](https://cloud.ibm.com/docs/netezza?topic=netezza-tickets&format=markdown)
