Describes how to ingest data from webhook to RisingWave.
Parameter or clause | Description |
---|---|
CREATE SECRET | Securely stores a secret value in RisingWave for request validation. |
CREATE TABLE | Defines a table with a JSONB column to store webhook payload data. |
connector | Configures the table to accept incoming HTTP webhook requests. |
is_batched | Optional, set to true to enable batch ingestion of multiple JSON lines in a single request. |
VALIDATE SECRET...AS... | Authenticates requests using the stored secret and signature comparison. |
secure_compare() | Validates requests by matching the header signature against the computed signature, ensuring only authenticated requests are processed. Note secure_compare(...) is the only supported validation function for webhook tables. |
header_of_signature | Specifies which HTTP header contains the incoming signature. |
signature_generation_expressions | Expression to compute the expected signature using the secret and payload. |
is_batched
is added in v2.5.0 and is currently in technical preview stage.'secret_value'
to compute signature.
webhook source | Authentication methods |
---|---|
GitHub | SHA-1 HMAC, SHA-256 HMAC |
Segment | SHA-1 HMAC |
HubSpot | API Key, Signature V2 |
AWS EventBridge | Bearer Token |
Rudderstack | Bearer Token |