---
name: netezza-ingesting_datalakehouse
title: Ingesting data from watsonx.data
description: ''
last-updated: 2023-07-21
---

> ## 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}
{:tip: .tip}
{:download: .download}
{:important: .important}
{:caption: .caption}
{:tip: .tip}
{:note: .note}

# Ingesting data from watsonx.data
{: #ingest_watsonx.data}

Learn how to ingest data into your local NPSaaS table.

## Before you begin
{: #prereqsdlh2}

In the examples, the publicly available [*New York taxi trip* record data](https://www.nyc.gov:443/site/tlc/about/tlc-trip-record-data.page) {: external} for yellow taxis in January 2022 is used. To follow this example, make sure that the data is in an accessible S3 bucket and the table was loaded into watsonx.data into an Apache Iceberg table in the Hive Metastore server (HMS).

## 1. Connect to NPSaaS database.
{: #connect_dlh}

```sql
MYLAKE.TAXIDATA(ADMIN)=> \c localdb
```
{: codeblock}

You are now connected to **localdb** database.

## 2. Run a CTAS query with a cross database **select** on the data lake database.schema.table.
{: #runctas_dlh}

Example:

```sql
LOCALDB.ADMIN(ADMIN)=> CREATE TABLE YELLOW_TAXI_JANUARY_2022_LOADED AS SELECT * FROM MYLAKE.TAXIDATA.YELLOW_TAXI_JANUARY_2022;
INSERT 0 2463931
```
{: codeblock}