question

GuaracyDias-2475 avatar image
0 Votes"
GuaracyDias-2475 asked ShaikMaheer-MSFT commented

ADF Dataflow does not allow tables with sensitivity classification columns

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-data-factoryazure-synapse-analytics
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @GuaracyDias-2475 ,

Welcome to Microsoft Q&A Platform. Thank you for posting your query here.

  • Could you please help to understand which sensitivity classifications or labels you added? So we can repro scenario to help you better.

  • Are you able to import schema for that table at Dataset level?

  • Is your projection failing at Source transformation level?

1 Vote 1 ·

Hi @ShaikMaheer-MSFT ,

Could you please help to understand which sensitivity classifications or labels you added? So we can repro scenario to help you better:
I am using the following script to add labels to my columns:
ADD SENSITIVITY CLASSIFICATION TO dbo.XXX.Column1 WITH (LABEL='Confidential - GDPR')


Are you able to import schema for that table at Dataset level?
Yes. But the problem happens when I try to run or import projection of tables with labelled columns in the data flows (source object).


Is your projection failing at Source transformation level?
Yes!

Thanks in advance.


0 Votes 0 ·

1 Answer

GuaracyDias-2475 avatar image
0 Votes"
GuaracyDias-2475 answered ShaikMaheer-MSFT commented

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]')

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @GuaracyDias-2475 ,

Glad to know your issue resolved. Thank you so much for sharing your resolution.

0 Votes 0 ·