Skip to main content

stream_pools

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

Overview​

Namestream_pools
TypeResource
Idoci.streaming.stream_pools

Fields​

The following fields are returned by SELECT queries:

NameDatatypeDescription
idstringThe OCID of the stream pool. (example: ocid1.streampool.realm.region.mnopqr789)
namestringThe name of the stream pool. (example: MyStreamPool)
compartmentIdstringCompartment OCID that the pool belongs to. (example: ocid1.compartment.oc1..aaaaaaaa2byuam5ewxzrcs2iqzh7okx84jae6j4uhkih5wdbrkkwuxv3qgpa)
customEncryptionKeyobjectCustom Encryption Key which will be used for encryption by all the streams in the pool.
definedTagsobjectDefined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see [Resource Tags](/Content/General/Concepts/resourcetags.htm). Example: `{"Operations": {"CostCenter": "42"}}'
endpointFqdnstringThe FQDN used to access the streams inside the stream pool (same FQDN as the messagesEndpoint attribute of a [Stream](#/en/streaming/20180418/Stream) object). If the stream pool is private, the FQDN is customized and can only be accessed from inside the associated subnetId, otherwise the FQDN is publicly resolvable. Depending on which protocol you attempt to use, you need to either prepend https or append the Kafka port.
freeformTagsobjectFree-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. Exists for cross-compatibility only. For more information, see [Resource Tags](/Content/General/Concepts/resourcetags.htm). Example: {"Department": "Finance"}
isPrivatebooleanTrue if the stream pool is private, false otherwise. If the stream pool is private, the streams inside the stream pool can only be accessed from inside the associated subnetId.
kafkaSettingsobjectSettings for the Kafka compatibility layer.
lifecycleStatestringThe current state of the stream pool. (CREATING, ACTIVE, DELETING, DELETED, FAILED, UPDATING)
lifecycleStateDetailsstringAny additional details about the current state of the stream.
privateEndpointSettingsobjectOptional settings if the stream pool is private.
securityAttributesobjectSecurity attributes for this resource. Each key is predefined and scoped to a namespace. For more information, see [Resource Tags](/iaas/Content/General/Concepts/resourcetags.htm). Example: {"Oracle-ZPR": {"MaxEgressCount": {"value": "42", "mode": "enforce"}}}
timeCreatedstring (date-time)The date and time the stream pool was created, expressed in in [RFC 3339](https:​//tools.ietf.org/rfc/rfc3339) timestamp format. Example: 2018-04-20T00:00:07.405Z

Methods​

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectstreamPoolId, regionopc-request-idGets detailed information about the stream pool, such as Kafka settings.
listselectcompartmentId, regionid, name, limit, page, sortBy, sortOrder, lifecycleState, opc-request-idList the stream pools for a given compartment ID.
createinsertregion, name, compartmentIdopc-request-id, opc-retry-tokenStarts the provisioning of a new stream pool.<br />To track the progress of the provisioning, you can periodically call GetStreamPool.<br />In the response, the lifecycleState parameter of the object tells you its current state.<br />
updateupdatestreamPoolId, regionopc-request-id, if-matchUpdates the specified stream pool.<br />
deletedeletestreamPoolId, regionopc-request-id, if-matchDeletes a stream pool. All containing streams will also be deleted.<br />The default stream pool of a compartment cannot be deleted.<br />
change_compartmentexecstreamPoolId, region, compartmentIdif-match, opc-request-idMoves a resource into a different compartment. When provided, If-Match is checked against ETag values of the resource.

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
compartmentIdstringThe OCID of the compartment.
regionstringOCI region identifier (e.g. us-ashburn-1, ap-sydney-1); resolves from OCI_REGION when not supplied in the query. (default: us-ashburn-1, x-stackQL-envVar: OCI_REGION)
streamPoolIdstringThe OCID of the stream pool.
idstringA filter to return only resources that match the given ID exactly.
if-matchstringFor optimistic concurrency control. In the PUT or DELETE call for a resource, set the if-match parameter to the value of the etag from a previous GET or POST response for that resource. The resource will be updated or deleted only if the etag you provide matches the resource's current etag value.
lifecycleStatestringA filter to only return resources that match the given lifecycle state. The state value is case-insensitive.
limitintegerThe maximum number of items to return. The value must be between 1 and 50. The default is 10.
namestringA filter to return only resources that match the given name exactly.
opc-request-idstringThe unique Oracle-assigned identifier for the request. If you need to contact Oracle about a particular request, please provide the request ID.
opc-retry-tokenstringA token that uniquely identifies a request so it can be retried in case of a timeout or server error without risk of executing that same action again. Retry tokens expire after 24 hours, but can be invalidated before then due to conflicting operations (for example, if a resource has been deleted and purged from the system, then a retry of the original creation request may be rejected).
pagestringThe page at which to start retrieving results.
sortBystringThe field to sort by. You can provide no more than one sort order. By default, TIMECREATED sorts results in descending order and NAME sorts results in ascending order.
sortOrderstringThe sort order to use, either 'asc' or 'desc'.

SELECT examples​

Gets detailed information about the stream pool, such as Kafka settings.

SELECT
id,
name,
compartmentId,
customEncryptionKey,
definedTags,
endpointFqdn,
freeformTags,
isPrivate,
kafkaSettings,
lifecycleState,
lifecycleStateDetails,
privateEndpointSettings,
securityAttributes,
timeCreated
FROM oci.streaming.stream_pools
WHERE streamPoolId = '{{ streamPoolId }}' -- required
AND region = '{{ region }}' -- required
AND opc-request-id = '{{ opc-request-id }}'
;

INSERT examples​

Starts the provisioning of a new stream pool.<br />To track the progress of the provisioning, you can periodically call GetStreamPool.<br />In the response, the lifecycleState parameter of the object tells you its current state.<br />

INSERT INTO oci.streaming.stream_pools (
compartmentId,
customEncryptionKeyDetails,
definedTags,
freeformTags,
kafkaSettings,
name,
privateEndpointDetails,
securityAttributes,
region,
opc-request-id,
opc-retry-token
)
SELECT
'{{ compartmentId }}' /* required */,
'{{ customEncryptionKeyDetails }}',
'{{ definedTags }}',
'{{ freeformTags }}',
'{{ kafkaSettings }}',
'{{ name }}' /* required */,
'{{ privateEndpointDetails }}',
'{{ securityAttributes }}',
'{{ region }}',
'{{ opc-request-id }}',
'{{ opc-retry-token }}'
RETURNING
id,
name,
compartmentId,
customEncryptionKey,
definedTags,
endpointFqdn,
freeformTags,
isPrivate,
kafkaSettings,
lifecycleState,
lifecycleStateDetails,
privateEndpointSettings,
securityAttributes,
timeCreated
;

UPDATE examples​

Updates the specified stream pool.<br />

UPDATE oci.streaming.stream_pools
SET
customEncryptionKeyDetails = '{{ customEncryptionKeyDetails }}',
definedTags = '{{ definedTags }}',
freeformTags = '{{ freeformTags }}',
kafkaSettings = '{{ kafkaSettings }}',
name = '{{ name }}',
securityAttributes = '{{ securityAttributes }}'
WHERE
streamPoolId = '{{ streamPoolId }}' --required
AND region = '{{ region }}' --required
AND opc-request-id = '{{ opc-request-id}}'
AND if-match = '{{ if-match}}'
RETURNING
id,
name,
compartmentId,
customEncryptionKey,
definedTags,
endpointFqdn,
freeformTags,
isPrivate,
kafkaSettings,
lifecycleState,
lifecycleStateDetails,
privateEndpointSettings,
securityAttributes,
timeCreated;

DELETE examples​

Deletes a stream pool. All containing streams will also be deleted.<br />The default stream pool of a compartment cannot be deleted.<br />

DELETE FROM oci.streaming.stream_pools
WHERE streamPoolId = '{{ streamPoolId }}' --required
AND region = '{{ region }}' --required
AND opc-request-id = '{{ opc-request-id }}'
AND if-match = '{{ if-match }}'
;

Lifecycle Methods​

Moves a resource into a different compartment. When provided, If-Match is checked against ETag values of the resource.

EXEC oci.streaming.stream_pools.change_compartment
@streamPoolId='{{ streamPoolId }}' --required,
@region='{{ region }}' --required,
@if-match='{{ if-match }}',
@opc-request-id='{{ opc-request-id }}'
@@json=
'{
"compartmentId": "{{ compartmentId }}"
}'
;