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
;