---
name: netezza-data_lakehouse_overview
title: Overview
description: ''
last-updated: 2023-12-04
---

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

{:new_window: target="_blank"}
{:shortdesc: .shortdesc}
{:screen: .screen}
{:pre: .pre}
{:table: .aria-labeledby="caption"}
{:codeblock: .codeblock}
{:note: .note}
{:download: .download}
{:important: .important}
{:caption: .caption}

# Overview
{: #overview_watsonx.data}

With IBM® Netezza® Performance Server for IBM Cloud Pak® for Data as a Service and watsonx.data you can connect to the Hive Metastore (HMS) which is a data lake metastore server and query from Apache Iceberg tables that live on your data lake S3 object store.

- You must use Apache Iceberg tables with the `parquet` file format.
- **SELECT** and **INSERT** operations are supported.
- LZ4 data compression format is supported.
- **NETEZZA_SCHEMA** is the default schema when you connect to a data lake database. It is a regular schema which contains Netezza objects like tables, external tables, and sequences. **NETEZZA_SCHEMA**, **DEFINITON_SCHEMA**, and **INFORMATION_SCHEMA** schema names are all reserved, and schemas of those names in the metastore are not exposed to NPSaaS users.
- The following datatypes are not supported:
    - `timestamptz`
    - `uuid`
    - `struct`
    - `list`
    - `map`

Use cases for watsonx.data include:

- [Integrating NPSaaS with watsonx.data](https://cloud.ibm.com/docs/netezza?topic=netezza-integratenps_watsonx.data&format=markdown).
- [Running queries against data that is stored in watsonx.data](https://cloud.ibm.com/docs/netezza?topic=netezza-querying_watsonx.data&format=markdown).
- [Ingesting data from watsonx.data into NPSaaS](https://cloud.ibm.com/docs/netezza?topic=netezza-ingest_watsonx.data&format=markdown).
- [Querying both local and remote data from watsonx.data](https://cloud.ibm.com/docs/netezza?topic=netezza-merging_watsonx.data&format=markdown).