Bulk Actions

Introduction

Rivery's Bulk Actions feature allows you to manage multiple tables simultaneously, streamlining workflows and enhancing productivity when working with multi-table rivers. This feature is available in both create and edit modes for multi-table configurations.

Steps for Using Bulk Actions

Step 1: Select Tables

1. Access the Tables View:

   • Navigate to the Tables View in your multi-table river.

2. Activate Bulk Actions:

   • Click the "Bulk Actions" button.
   • This button becomes active once at least 2 table is selected.

3. Choose Selection Options:

   • All Tables in Selected Schemas: Select multiple schemas to include their respective tables.
   • All Tables: Apply actions to all selected tables in the river.

Step 2: Choose Properties

Once tables are selected, configure the desired properties for bulk operations:

Extract Method (Standard Extraction Only):

• Options:
  • Keep Original Settings (default): Retain the current settings for all selected tables.
  • Set to All: Apply a uniform extraction method across all selected tables.
  • Set to Incremental: Use a common incremental field for all tables and configure its values.
    • Incremental Field Type: Automatically detected based on the selected field (e.g., Timestamp, Date, Running Number, Epoch).

Set Time Period:

• For tables using date/timestamp-based incremental fields, specify a custom time range for data extraction.

CDC Initial Migration Options:

• Available for tables using Change Data Capture (CDC) mode:
  • Overwrite: Replace existing data in the target.
  • Merge: Integrate changes into existing target data.

Loading Mode (Not Applicable for CDC):

• Options:
  • Overwrite: Completely replace the target table's content.
  • Append: Add new data to the target table.
  • Upsert-Merge: Merge data into the target table, supporting the following database platforms:
    • Databricks
    • Postgres
    • Redshift
    • Snowflake

Create a Calculated Column:

• Add calculated columns to the selected tables:
  • Specify the expression type (Source Expression/Target Expression).
  • Define the target column name.
  • Choose the data type based on the target system's supported formats.

Step 3: Review and Confirm

Before applying the bulk actions, review a summary of the selected options:

1. Total Selected Tables: Displays the total number of tables included in the bulk action.
2. Selection Method: Indicates whether tables were chosen by schema or individually.

Once you have reviewed the summary and confirmed the settings, execute the bulk actions.