Skip to main content

data_encryption_keys

Creates, updates, deletes, gets or lists a data_encryption_keys resource.

Overview

Namedata_encryption_keys
TypeResource
Idconfluent.encryption_keys.data_encryption_keys

Fields

NameDatatypeDescription
algorithmstringAlgorithm of the dek
deletedbooleanWhether the dek is deleted
encryptedKeyMaterialstringEncrypted key material of the dek
kekNamestringKek name of the dek
keyMaterialstringRaw key material of the dek
subjectstringSubject of the dek
tsintegerTimestamp of the dek
versionintegerVersion of the dek

Methods

NameAccessible byRequired ParamsDescription
get_dekSELECTname, subject
get_dek_subjectsSELECTname
create_dekINSERTname
delete_dek_versionsDELETEname, subject
undelete_dek_versionsEXECname, subject

SELECT examples

SELECT
algorithm,
deleted,
encryptedKeyMaterial,
kekName,
keyMaterial,
subject,
ts,
version
FROM confluent.encryption_keys.data_encryption_keys
WHERE name = '{{ name }}';

INSERT example

Use the following StackQL query and manifest file to create a new data_encryption_keys resource.

/*+ create */
INSERT INTO confluent.encryption_keys.data_encryption_keys (
data__subject,
data__version,
data__algorithm,
data__encryptedKeyMaterial,
data__deleted,
name
)
SELECT
'{{ subject }}',
'{{ version }}',
'{{ algorithm }}',
'{{ encryptedKeyMaterial }}',
'{{ deleted }}',
'{{ name }}'
;

DELETE example

Deletes the specified data_encryption_keys resource.

/*+ delete */
DELETE FROM confluent.encryption_keys.data_encryption_keys
WHERE name = '{{ name }}'
AND subject = '{{ subject }}';