jb8628

Thanks for your reply! It fails with: > Binder Error: No key with name "key128" exists. Add it with PRAGMA add_parquet_key('',''); on running a model using the source. This is...

Yes, that works. Gives a good option for ingesting more sensitive data. Thank you so much for your help.

In fact, following your pointer, I now seem to have this working without `keep_open: true` by specifying `+pre-hook: "PRAGMA add_parquet_key('key128', '0123456789112345');"` for the model resource.

Yup, thanks. I guess I was wondering whether using built-in SQL Server functionality could avoid having to create and manage column encryption in dbt (plus surrounding tools). Always Encrypted would...

My understanding is that anything that is written through an "Always Encrypted" configured connection will be encrypted where this is specified for the column in the SQL server. Thus, if...