title: AWS - migration failed with error Value of column '' in table '' was truncated to 32768 bytes
body: <p>I am using the AWS DMS service to migrate my Postgres database to Aurora Postgres but I got in some tables that error</p>
  <pre><code>Value of column 'ColumnName' in table 'TableName' was truncated to 32768 bytes, actual length: 110644 bytes
  </code></pre>
  <p>column type could be <code>text</code> or <code>jsonb</code></p>
  <p>I can fix it by changing <strong>include LOB option</strong> to be <code>Full LOB mode</code> instead of Limited one but that breaks other tables</p>
  <p><a href="https://i.stack.imgur.com/SOa91.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/SOa91.png" alt="enter image description here" /></a></p>
  <p>any hint on how I can customize that option to these specific tables only</p>