Loading VARCHAR(Max) columns from on-prem to Azure SQL Datawarehouse using ADF V2


  • Hi Everyone,

    I am planning to load data with varchar(max) columns from on-premesis sql server to Azure sql datawarehouse. I am using Azure data factory v2 with Polybase and pipeline is keep failing with some data type conversion issue. I did some research and found that varchar(max) with polybase is not currently supported. Is their any work around to load varchar(max) data using polybase? Any help would be appreciated.


    Sunday, July 22, 2018 11:57 PM

All replies

  • Hi, 

    Polybase does not work with varchar(max) because Polybase uses external table to reference data in other data stores, and external table does not support varchar(max). I believe this is a hard limit hence no workaround.

    Monday, July 23, 2018 8:52 AM