Skip to main content

output_graylog_streams

Creates, updates, deletes, gets or lists an output_graylog_streams resource.

Overview​

Nameoutput_graylog_streams
TypeResource
Idovh.dbaas_logs.output_graylog_streams

Fields​

The following fields are returned by SELECT queries:

successful operation

NameDatatypeDescription
cluster_idstring (uuid)Cluster ID (wire: clusterId)
parent_stream_idstring (uuid)Parent stream ID (wire: parentStreamId)
retention_idstring (uuid)Retention ID (wire: retentionId)
stream_idstring (uuid)Stream ID (wire: streamId)
can_alertbooleanIndicates if the current user can create alert on the stream (wire: canAlert)
cold_storage_compressionstringCold storage compression method (DEFLATED, GZIP, LZMA, ZSTD) (wire: coldStorageCompression)
cold_storage_contentstringColdStorage content (ALL, GELF, PLAIN) (wire: coldStorageContent)
cold_storage_enabledbooleanIs Cold storage enabled? (wire: coldStorageEnabled)
cold_storage_notify_enabledbooleanNotify on new Cold storage archive (wire: coldStorageNotifyEnabled)
cold_storage_retentionintegerCold storage retention in year (wire: coldStorageRetention)
created_atstring (date-time)Stream creation (wire: createdAt)
descriptionstringStream description
encryption_keys_idsarrayEncryption keys used to encrypt stream archives (wire: encryptionKeysIds)
iamobjectIAM resource metadata
indexing_current_sizeintegerIndexing current size (in bytes) (wire: indexingCurrentSize)
indexing_enabledbooleanEnable ES indexing (wire: indexingEnabled)
indexing_max_sizeintegerMaximum indexing size (in GB) (wire: indexingMaxSize)
indexing_notify_enabledbooleanIf set, notify when size is near 80, 90 or 100 % of the maximum configured setting (wire: indexingNotifyEnabled)
is_editablebooleanIndicates if you are allowed to edit entry (wire: isEditable)
nb_alert_conditionintegerNumber of alert condition (wire: nbAlertCondition)
nb_archiveintegerNumber of coldstored archives (wire: nbArchive)
nb_subscriptionintegerNumber of subscriptions targeting this stream (wire: nbSubscription)
pause_indexing_on_max_sizebooleanIf set, pause indexing when maximum size is reach (wire: pauseIndexingOnMaxSize)
titlestringStream name
updated_atstring (date-time)Stream last update (wire: updatedAt)
web_socket_enabledbooleanEnable Websocket (wire: webSocketEnabled)

Methods​

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectservice_name, stream_idReturns the data stream.
listselectservice_nameiam_tags, x_pagination_modeReturns the data streams of the Logs Data Platform service.
createinsertservice_name, description, titleCreates a data stream on the Logs Data Platform service.
updateupdateservice_name, stream_id, description, titleUpdates the data stream.
deletedeleteservice_name, stream_idDeletes the data stream.

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
api_hoststringThe OVHcloud API host. Selected by OVH_ENDPOINT (ovh-eu, ovh-ca or ovh-us; default ovh-eu). (default: api.eu.ovhcloud.com, x-stackQL-envVarSelector: {"envVar":"OVH_ENDPOINT","default":"ovh-eu","values":{"ovh-eu":"api.eu.ovhcloud.com","ovh-ca":"api.ca.ovhcloud.com","ovh-us":"api.us.ovhcloud.com"}})
service_namestringService name (wire: serviceName)
stream_idstring (uuid)Stream ID (wire: streamId)
iam_tagsobjectFilter resources on IAM tags (wire: iamTags)
x_pagination_modestringSent as CachedObjectList-Pages by default so the list returns the full objects rather than their identifiers. (wire: X-Pagination-Mode)

SELECT examples​

Returns the data stream.

SELECT
cluster_id,
parent_stream_id,
retention_id,
stream_id,
can_alert,
cold_storage_compression,
cold_storage_content,
cold_storage_enabled,
cold_storage_notify_enabled,
cold_storage_retention,
created_at,
description,
encryption_keys_ids,
iam,
indexing_current_size,
indexing_enabled,
indexing_max_size,
indexing_notify_enabled,
is_editable,
nb_alert_condition,
nb_archive,
nb_subscription,
pause_indexing_on_max_size,
title,
updated_at,
web_socket_enabled
FROM ovh.dbaas_logs.output_graylog_streams
WHERE service_name = '{{ service_name }}' -- required
AND stream_id = '{{ stream_id }}' -- required
;

INSERT examples​

Creates a data stream on the Logs Data Platform service.

INSERT INTO ovh.dbaas_logs.output_graylog_streams (
cold_storage_compression,
cold_storage_content,
cold_storage_enabled,
cold_storage_notify_enabled,
cold_storage_retention,
description,
encryption_keys_ids,
indexing_enabled,
indexing_max_size,
indexing_notify_enabled,
parent_stream_id,
pause_indexing_on_max_size,
retention_id,
title,
web_socket_enabled,
service_name
)
SELECT
'{{ cold_storage_compression }}',
'{{ cold_storage_content }}',
{{ cold_storage_enabled }},
{{ cold_storage_notify_enabled }},
{{ cold_storage_retention }},
'{{ description }}' /* required */,
'{{ encryption_keys_ids }}',
{{ indexing_enabled }},
{{ indexing_max_size }},
{{ indexing_notify_enabled }},
'{{ parent_stream_id }}',
{{ pause_indexing_on_max_size }},
'{{ retention_id }}',
'{{ title }}' /* required */,
{{ web_socket_enabled }},
'{{ service_name }}'
RETURNING
alias_id,
dashboard_id,
encryption_key_id,
index_id,
input_id,
operation_id,
osd_id,
role_id,
stream_id,
subscription_id,
tenant_id,
token_id,
service_name,
created_at,
state,
updated_at
;

UPDATE examples​

Updates the data stream.

UPDATE ovh.dbaas_logs.output_graylog_streams
SET
cold_storage_compression = '{{ cold_storage_compression }}',
cold_storage_content = '{{ cold_storage_content }}',
cold_storage_enabled = {{ cold_storage_enabled }},
cold_storage_notify_enabled = {{ cold_storage_notify_enabled }},
cold_storage_retention = {{ cold_storage_retention }},
description = '{{ description }}',
encryption_keys_ids = '{{ encryption_keys_ids }}',
indexing_enabled = {{ indexing_enabled }},
indexing_max_size = {{ indexing_max_size }},
indexing_notify_enabled = {{ indexing_notify_enabled }},
pause_indexing_on_max_size = {{ pause_indexing_on_max_size }},
title = '{{ title }}',
web_socket_enabled = {{ web_socket_enabled }}
WHERE
service_name = '{{ service_name }}' --required
AND stream_id = '{{ stream_id }}' --required
AND description = '{{ description }}' --required
AND title = '{{ title }}' --required
RETURNING
alias_id,
dashboard_id,
encryption_key_id,
index_id,
input_id,
operation_id,
osd_id,
role_id,
stream_id,
subscription_id,
tenant_id,
token_id,
service_name,
created_at,
state,
updated_at;

DELETE examples​

Deletes the data stream.

DELETE FROM ovh.dbaas_logs.output_graylog_streams
WHERE service_name = '{{ service_name }}' --required
AND stream_id = '{{ stream_id }}' --required
;