stream_notifications
Schema: service_usage
Description
The stream_notifications table in the service_usage schema contains usage metrics for the LWorks Stream product. This includes information about organization IDs, event IDs, rule IDs, delivery times, and more. This data is useful for tracking the usage and performance of the LWorks Stream product.
Columns
| Name | Type | Description | Default |
|---|---|---|---|
| organization_id | uuid | The ID of the organization using the LWorks Stream product. | None |
| source_time | timestamptz | The time when the event occurred. | None |
| event_id | text | The ID of the event. | None |
| status | stream_notification_status | The status of the event. | None |
| attempt | smallint | The number of attempts made to deliver the event. | None |
| rule_id | uuid | The ID of the rule associated with the event. | None |
| rule_name | text | The name of the rule associated with the event. | None |
| rule_type | stream_notification_rule_type | The type of rule associated with the event. | None |
| delivery_time | timestamptz | The time when the event was delivered. | None |
| stream_time | timestamptz | The time when the event was streamed. | None |
| destination_type | stream_notification_destination | The type of destination for the event. | None |
Enums
service_usage.stream_notification_status
- Success
- Failure
- Pending
- Skipped
- Timeout
- GaveUp
- Batching
service_usage.stream_notification_rule_type
- HCSMessagesByTopicId
- TokenMintsByTokenId
- TokenBurnsByTokenId
- TokenTransfersByTokenId
- ContractCallsByContractId
- SourceAccountBasedSecurityRule
- AccountActivityByAccount
- MetricAlarmsByAlarmId
service_usage.stream_notification_destination
- Webhook
- Websocket
- KafkaTopic
How to Query
As an end user this table can be queried with the template function user_data_access.service_usage_stream_notifications.