Skip to main content

key_encryption_keys

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

Overview​

Namekey_encryption_keys
TypeResource
Idconfluent.encryption_keys.key_encryption_keys

Fields​

The following fields are returned by SELECT queries:

The kek info

NameDatatypeDescription
namestringName of the kek
deletedbooleanWhether the kek is deleted
docstringDescription of the kek
kmsKeyIdstringKMS key ID of the kek
kmsPropsobjectProperties of the kek
kmsTypestringKMS type of the kek
sharedbooleanWhether the kek is shared
tsinteger (int64)Timestamp of the kek

Methods​

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
get_kekselectnamedeleted
get_kek_namesselectdeleted
create_kekinserttestSharing
put_kekreplacenametestSharing
delete_kekdeletenamepermanent
undelete_kekexecname
test_kekexecname

Parameters​

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

NameDatatypeDescription
namestringName of the kek
deletedbooleanWhether to include deleted keys
permanentbooleanWhether to perform a permanent delete
testSharingbooleanWhether to test kek sharing

SELECT examples​

The kek info

SELECT
name,
deleted,
doc,
kmsKeyId,
kmsProps,
kmsType,
shared,
ts
FROM confluent.encryption_keys.key_encryption_keys
WHERE name = '{{ name }}' -- required
AND deleted = '{{ deleted }}'
;

INSERT examples​

No description available.

INSERT INTO confluent.encryption_keys.key_encryption_keys (
name,
kmsType,
kmsKeyId,
kmsProps,
doc,
shared,
deleted,
testSharing
)
SELECT
'{{ name }}',
'{{ kmsType }}',
'{{ kmsKeyId }}',
'{{ kmsProps }}',
'{{ doc }}',
{{ shared }},
{{ deleted }},
'{{ testSharing }}'
RETURNING
name,
deleted,
doc,
kmsKeyId,
kmsProps,
kmsType,
shared,
ts
;

REPLACE examples​

No description available.

REPLACE confluent.encryption_keys.key_encryption_keys
SET
kmsProps = '{{ kmsProps }}',
doc = '{{ doc }}',
shared = {{ shared }}
WHERE
name = '{{ name }}' --required
AND testSharing = {{ testSharing}}
RETURNING
name,
deleted,
doc,
kmsKeyId,
kmsProps,
kmsType,
shared,
ts;

DELETE examples​

No description available.

DELETE FROM confluent.encryption_keys.key_encryption_keys
WHERE name = '{{ name }}' --required
AND permanent = '{{ permanent }}'
;

Lifecycle Methods​

No Content

EXEC confluent.encryption_keys.key_encryption_keys.undelete_kek
@name='{{ name }}' --required
;