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

Last updated