Creating the Iceberg target table in CDW

Before you can ingest data into your Cloudera DataWarehouse (CDW) target in CDP Private Cloud Data Services, make sure that the table where you want to send data with NiFi is already created when you start building your data flow.

The following example shows how to create a table with Hive:

CREATE TABLE customer (id int, name string, created_at timestamp) 
PARTITIONED BY (country_code string) 
STORED BY ICEBERG;

Note that Iceberg v2 is also supported. The following example shows how to create a table using Iceberg v2:

CREATE TABLE customer (id int, name string, created_at timestamp) 
PARTITIONED BY (country_code string) 
STORED BY ICEBERG
TBLPROPERTIES ('format-version' = '2');