Skip to main content Skip to complementary content

Reading data from an Iceberg table

The second step of this scenario is to read the data from the newly created Iceberg table. Let's take the example of the marketing_iceberg Iceberg table.

About this task

For this task, the Reading subJob is used.

Procedure

  1. From the Basic settings view of tIcebergInput called marketing, configure the parameters as follows:
    tIcebergInput component parameters.
    1. In the Sql query field, enter the SQL query to perform. In this example it is "SELECT * from marketing_iceberg order by total_spend desc" which enables you to read the data by ordering them according to the total amount spent.
    2. From the Connection drop-down list, select the connection component to be used. In this example it is tIcebergConnection_1.
    3. Leave the other parameters as is.
  2. From the Basic settings view of tLogRow called marketing, configure the parameters as follows:
    1. Select the Table (print values in cells of table) option from the Mode section.
    2. Leave the other parameters as is.
  3. Execute the subJob by clicking the Run button from the Run tab.

Results

The results appear in the Execution console of your Job.
Results of the Reading subJob in the console.

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