🕸️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 📺

Webhooks : Explanation & Feature Walkthrough

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