Updating an Iceberg table
The third step of this scenario is to update the data from the
marketing_iceberg Iceberg table.
About this task
For this task, the Updating subJob is used.
Procedure
-
From the Basic settings view of tIcebergRow called
update, configure the parameters as follows:
- From the Connection drop-down list, select the connection component to be used. In this example it is tIcebergConnection_1.
- In the Sql query enter the SQL query you want to execute. In this example it is "UPDATE marketing_iceberg SET membership_type = 'Gold' WHERE total_spend > 800" which enables you to assign the gold membership to all the members who spent more than 800$.
-
From the Basic settings view of the two tIcebergInput
called count gold members, configure the parameters as
follows:
- In the Sql query field, enter the SQL query to perform. In this example it is "SELECT count (*) as total from marketing_iceberg where membership_type='Gold'" which enables you to count all the members that have the gold membership.
- From the Connection drop-down list, select the connection component to be used. In this example it is tIcebergConnection_1.