ADF Dataflow does not allow tables with sensitivity classification columns

Guaracy Dias 96 Reputation points
2021-09-01T16:45:31.497+00:00

Hi!

Since I decided to add sensitivity classification to some columns of my DW tables (Synapse Analytics), my dataflows stopped working.

Even when I try to import projection it fails.

The error message does not help much:

Error code:
DFExecutorUserError
Activity ID:
cdfcb347-35a3-439c-ad0d-13ac2eb6c612
Details:
at Source 'source1': java.lang.IndexOutOfBoundsException: Index: 65535, Size: 0

Does anybody know what is going on?

Thanks in advance!

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,696 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,196 questions
{count} votes

Accepted answer
  1. Guaracy Dias 96 Reputation points
    2021-09-08T14:26:01.813+00:00

    The issue was solved.

    After added the parameter INFORMATION_TYPE my dataflow started to recognize my table.

    Code example:
    ADD SENSITIVITY CLASSIFICATION TO dbo.XXX WITH (LABEL='Confidential - GDPR', INFORMATION_TYPE='[n/a]')


0 additional answers

Sort by: Most helpful