question

PeterRogersAdmin-4089 avatar image
0 Votes"
PeterRogersAdmin-4089 asked ThungiwePercyMkhize-2819 answered

Elastic Query on a table with encrypted columns

Is it possible to set up an elastic query to a table with encrypted columns?

When I try and create the external table it does not allow me to specify the column is encrypted

azure-sql-database
· 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.

@PeterRogersAdmin-4089 We are checking this and will get back to you.

0 Votes 0 ·
NavtejSaini-MSFT avatar image
0 Votes"
NavtejSaini-MSFT answered

@PeterRogersAdmin-4089

Always Encrypted does not support external tables, hence if the elastic queries uses the external table it will not work either.

Please get back to us for any further questions.

Regards
Navtej S


· 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.

@peterrogersadmin-4089

Please let us know if you need any further info.

Regards
Navtej S

0 Votes 0 ·
ThungiwePercyMkhize-2819 avatar image
0 Votes"
ThungiwePercyMkhize-2819 answered

Hi @NavtejSaini-MSFT, what can we do to run queries on encrypted columns using external tables?

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.