Guide to create a Webhook in Sprinkle
Sprinkle Webhook is a special type of Pipeline that creates a Webhook endpoint in sprinkle to receive data from external sources.
Webhook Pipeline are available only in Enterprise Plan. Check with the Sprinkle Support team for more details.
Before setting up the pipeline, learn about pipeline concepts here
Log into the Sprinkle application.
Navigate to the Ingest Tab -> Pipelines -> Webhooks.
Click on the Create Webhook button.
Name (Required): Enter the unique name for the webhook.
Webhook URL: Generated by Sprinkle. Configure this URL on the source to send events to Sprinkle.
Remove Duplicate Rows:
Unique Key: Unique key from the table to dedupe data across multiple ingestions
Time Column Name: Will be used to order data for deduping
Flatten Level (required): Select from One level or Multi levels. In one level, flattening will not be applied on complex types. They will be stored as strings. In multi-level, flattening will be applied to complex levels until they become simple.
Destination Schema (Required): Data warehouse schema where the table will be ingested into
Destination Table name (required): This is the table name to be created in the warehouse. If not given, Sprinkle will create like : ds_<datasourcename>_<tablename>.
Destination Create Table Clause: Provide additional clauses to warehouse-create table queries such as clustering, partitioning, and more, useful for optimizing DML statements (Learn more about how to use this field).
Click on 'Create'.
In the Ingestion Jobs tab:
Trigger the Job, using the Run button
To schedule, enable Auto-Run. Change the frequency to Realtime, if required
Last updated
