Omni Loader Docs
  • OVERVIEW
    • About
    • Getting Started
    • Databases
    • Performance considerations
    • Prerequisites
  • Project Wizard
    • General
    • Database List
    • Favorites
    • Review
  • Project types
    • Full Table Copy
    • Data Compare & Sync
    • Change Data Capture
    • Overview
  • Project Options
    • General
    • Performance
    • Databases
    • Mapping
    • Logging
    • Troubleshooting
  • Table Options
    • Columns
    • WHERE clause
    • Partitioning
    • Cut-off
    • Options Override
  • Global Settings
    • Overview
  • Automations
    • Overview
    • JSON job specification
  • Connections
    • Amazon RedShift
    • Analytics Platform System
    • Synapse Dedicated Pool
    • CockroachDB
    • CSV
    • Databricks
    • DB2 iSeries
    • DB2 LUW
    • DB2 zOS
    • Greenplum
    • Google AlloyDB
    • Google BigQuery
    • MariaDB
    • MySQL
    • Netezza
    • NuoDB
    • ODBC
    • Oracle
    • Parquet
    • PostgreSQL
    • Snowflake
    • Sybase ASE
    • Sybase IQ
    • SQL Server
    • Teradata
    • Vertica ODBC
    • Fabric Lakehouse
    • Fabric Warehouse
    • Azure SQL Database
    • V-ORDER Fabric Lakehouse Optimization
Powered by GitBook
On this page
  • Fetch source
  • No partitioning
  • Match source
  • Monthly
  • Yearly
  1. Table Options

Partitioning

PreviousWHERE clauseNextCut-off

Last updated 10 months ago

Fetch source

Read the source table metadata to find its partitioning information.

No partitioning

Remove the partitioning information from the target table, leaving distribution and other table options in place.

Match source

Generate target paritioning to match the source. If source and target are of a different type, we will translate the partitioning info if possible.

Monthly

You can collapse source partitions into less granular ones. For example, if you have daily partitions, this option will generate monthly target partitions based on the source ranges.

Yearly

You can collapse source partitions into less granular ones. For example, if you have daily partitions, this option will generate yearly target partitions based on the source ranges.