Table Types

You define table types primarily to manage data changes appropriately, based on the business needs, and to keep the source data and target data warehouse in sync for accurate insights.

Data Augmentation Scripts supports these two main types of tables for refreshing data:

• Updated tables: Adds new records and updates modified data in the target table.
  Key characteristics of updated tables:

  • Default table type, if you don't specify one.
  • Retains deleted records in the Autonomous Data Warehouse.
  • Useful for managing large datasets that require current data and want to retain deleted data.
• Versioned tables: Truncates the target table during each incremental run and reinserts all the data from the source dataset.

  The key characteristic of versioned tables is that it's useful for smaller datasets that require current data but don't need to retain deleted data.

For detailed information on data refresh, see Incremental.