This reference provides default data-type mappings for relational sources and Amazon Redshift, Databricks, Google BigQuery, Microsoft Azure Synapse Analytics, Microsoft SQL Server, Oracle, PostgreSQL, and Snowflake targets. When Database Ingestion and Replication generates the target tables, it uses these mappings.
When you configure a target, you can optionally define custom data-type mapping rules to override the default mappings of source data types to target data tables for the job. For more information, see the target-specific topics accessed from Task Details: Configure how to replicate data to the target.
If a source data type is not listed, Database Ingestion and Replication either cannot extract data from the source columns with this data type or cannot apply the extracted data to any appropriate target data type.