Microsoft Azure SQL Data Warehouse V2 Lookups in Mapping Tasks
In a mapping, you can configure a Lookup transformation to represent an Microsoft Azure SQL Data Warehouse object.
When you use Microsoft Azure SQL Data Warehouse object as a lookup, you need to specify the Azure Blob Container Name, Field Delimiter, and Number of Concurrent Connections to Blob Store properties. You cannot use Binary, Varbinary, and Datetimeoffset datatypes columns as lookup conditions.
When you use a cache lookup with Microsoft Azure SQL Data Warehouse V2 connection, the lookup condition is ignored if the lookup condition contains a NULL value.