In this lesson we will:
- Learn about the various eans of encrypting data in ClickHouse.
We recommend using a free ClickHouse Cloud Account when studying this lesson
Encrypting Data
ClickHouse includes a few ways which can be used to encrypt data at rest.
Encrypted Storage Policy
The first is to create tables with a storage policy of encyrpted.
create table xxx
Encryption Functions
function which allows you to encrypt data prior to it being inserted into the database.
This isn't particularly transparent to the user as it has to be included in your SQL statements.
insert into