Skip to main content
Best answer

Insert/Query to/from "Always Encrypted" SQL columns

  • June 10, 2021
  • 1 reply
  • 131 views

Hello,

I am wondering if anyone has tried and been successful in inserting data to an AWS RDS server that contains columns that are Always Encrypted and on the inverse, querying data out of an Always Encrypted table and retrieving the unencrypted value for use elsewhere in the zap.

Best answer by MarinaH

Hey @kpiercy!

Thanks for the question. We don't currently have support for reading or writing to encrypted columns for the SQL Server integration unfortunately.  

Looking at our records, I can see we have an open feature request for the functionality you’re after. I am going to let my team know that you were interested in this, too, and in the future should we be able to add this to our app, we will be happy to send you an email.

Sorry I couldn’t give you better news here! 

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

1 reply

Forum|alt.badge.img+9
  • Zapier Staff
  • Answer
  • June 14, 2021

Hey @kpiercy!

Thanks for the question. We don't currently have support for reading or writing to encrypted columns for the SQL Server integration unfortunately.  

Looking at our records, I can see we have an open feature request for the functionality you’re after. I am going to let my team know that you were interested in this, too, and in the future should we be able to add this to our app, we will be happy to send you an email.

Sorry I couldn’t give you better news here!