title: problems in creating external table for azure synapse analytics
body: <p>I am having difficulty creating external table in SMSS. I have the dataset stored in BLOB storage and try to load it from there in to external table. I keep getting this error:</p>
  
  <p>HdfsBridge::recordReaderFillBuffer - Unexpected error encountered filling record reader buffer: HadoopSqlException: Error converting data type NVARCHAR to INT</p>
  
  <p>i used the following query</p>
  
  <pre><code>CREATE EXTERNAL TABLE [ext].[klant](
  [number] [int] NOT NULL,
      [customer_id] [int] NOT NULL,
      [status] [nvarchar](50) NOT NULL,
      [shipping.postcode] [nvarchar](50) NOT NULL,
      [date_created] [datetime2](0) NOT NULL,
      [date_completed] [datetime2](0) NOT NULL,
      [shipping.address_1] [nvarchar](50) NOT NULL,
      [shipping.city] [nvarchar](50) NOT NULL
      )
  
  
  
  
  
  
  WITH (
  LOCATION='/customer/',
      DATA_SOURCE = storage,  
      FILE_FORMAT = fileformat,
      REJECT_TYPE = VALUE,
      REJECT_VALUE = 0
  
  
      );
  </code></pre>
  
  <p>I also tried to solve this problem in ADF by copying the data from source to table, but with no luck.
  I hope somebody could help me with this problem. thanks in advance</p>