title: Is there a walk around for 1000 char limit set for defining table structure while creating a source end point for S3 in AWS Data migration Service
body: <p>I want to create an end point for s3 bucket in aws dms for migrating data from s3 to redshift. When defining table structure in JSON format, I am getting an error that character limit is set to 1000 characters. Is there a walk around for this or am I doing something wrong?
  Json template shared on aws dms website also has more then 1000 characters. I am thinking how to have a walk around if table structure has more then 20 columns.</p>
  
  <p>Also, if some one has created a dms task for sql server to s3 to redshift. I want to understand how update files which gets created in s3 bucket when you enable replication are loaded to redshift as an updated rather then new table or row.</p>
  
  <p>Thank you in advance.</p>
  
  <p>I tried removing space and <code>eol</code> characters</p>
  
  <pre><code>{
      "TableCount": "1",
      "Tables": [
          {
              "TableName": "employee",
              "TablePath": "hr/employee/",
              "TableOwner": "hr",
              "TableColumns": [
                  {
                      "ColumnName": "Id",
                      "ColumnType": "INT8",
                      "ColumnNullable": "false",
                      "ColumnIsPk": "true"
                  },
                  {
                      "ColumnName": "LastName",
                      "ColumnType": "STRING",
                      "ColumnLength": "20"
                  },
                  {
                      "ColumnName": "FirstName",
                      "ColumnType": "STRING",
                      "ColumnLength": "30"
                  },
                  {
                      "ColumnName": "HireDate",
                      "ColumnType": "DATETIME"
                  },
                  {
                      "ColumnName": "OfficeLocation",
                      "ColumnType": "STRING",
                      "ColumnLength": "20"
                  }
              ],
              "TableColumnsTotal": "5"
          }
      ]
  }
  </code></pre>
  
  <p>Error : Must be no longer than 1000 characters</p>