Encrypting columns

When writing columns to Snowflake using Polytomic's Model Syncs (for example if you're using enrichment), you can specify certain destination columns to be encrypted in Snowflake with a passphrase of your choosing. Here are the steps to do so:

  1. Click Show field details in your sync mapping:
  1. For each column you'd like to encrypt, click the Plaintext button underneath it and change it to Encrypted. Note: Only BINARY fields can be encrypted. New fields will be created as BINARY columns, and this option will only show up on existing BINARY fields.
  1. Enter your Snowflake encryption passphrase: