Skip to main content Skip to complementary content

Creating a branch from an Iceberg table

The first step of this scenario is to create an Iceberg branch based on an Iceberg table.

Before you begin

You are connected to the Iceberg database using the Connect subJob. In this scenario, the connection is made with tIcebergConnection as follows:
tIcebergConnection Basic settings view.

About this task

For this task, the Create branch subJob is used. To create an Iceberg branch, you need to configure the properties from the Basic settings view of tIcebergTable as follows:
tIcebergTable Basic settings view.

Procedure

  1. From the Property Type drop-down list, select where you store the data. In this example, it is Built-In.
  2. From the Connection drop-down list, select the connection component to be used. In this example it is tIcebergConnection_1.
  3. In the Table name field, enter the name of the table from which you want to create a branch. In this example it is marketing_toclean.
  4. From the Action on table drop-down list, select Alter, and then from the Alter table action drop-down list, select Create branch to create a branch.
    Information noteNote: The branch is created using default properties as Using default properties is selected from the drop-down field.
  5. In the Branch field, enter the name of the branch to be created. In this example, it is cleaned_data.
  6. Execute the subJob by clicking the Run button from the Run tab.

Results

The cleaned_data Iceberg branch is created, based on the marketing_toclean Iceberg table. You can now start to work on the branch.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!

Leave your feedback here