LOB column data is getting truncated while source_lookup

[gayatri235]

Hello folks,

we are doing fullload but the data is getting truncated at target.

Source: Postgresql

Target: Synapse Analytics

We did source_lookup for LOB columns , but the data is not complete at target  .

[Anonymous]

Hi @gayatri235 

Please ensure if the column datatypes in source db matches with target db.

Also, please ensure that the source_lookup is configured appropriately for LOB columns to retrieve complete data

Thanks
Naren

[john_wang]

Hello @gayatri235 ,

Not sure what's the data type in Synapse, and what's the task settings, however please make sure:

1. The column length should be big enough to store the LOB

2. Replication of records exceeding 1 MB is not supported

3. Full LOB replication is not supported

4. The Limit LOB size in task setting

Hope this helps.

John.