You can run mappings on the Spark engine.
You can configure key range partitioning when you read data from Microsoft Azure SQL Data Warehouse objects.
You can override the SQL query and define constraints when you read data from a Microsoft Azure SQL Data Warehouse object.
You can configure pre-SQL and post-SQL queries for source and target objects in a mapping.
You can configure the native expression filter for the source data object operation.
You can perform update, upsert, and delete operations against Microsoft Azure SQL Data Warehouse tables.
You can configure a cached lookup operation to cache the lookup table on the Spark engine and an uncached lookup operation in the native environment.