🕸️Webhooks
Guide to create a Webhook in Sprinkle
Sprinkle Webhook is a special type of data import that creates a Webhook endpoint in sprinkle to receive data from external sources.
Webhook data imports are available only in Enterprise Plan. Check with the Sprinkle Support team for more details.
Watch Video 📺
Data Import Concepts
Before setting up the data import, learn about data import concepts here
Step-by-Step Guide
Step 1: Configure Webhook data import
Log into the Sprinkle application.
Navigate to the Ingest Tab -> Data Imports -> Webhooks.
Click on the Create Webhook button.
Step 2: Create a Dataset
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'.
Step 3: Run and schedule Ingestion
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