Sprinkle Docs
  • What is Sprinkle?
  • Quick Start
  • Analysing your data
    • 🔭Analytics Overview
    • 💠Data Models
      • *️Variables
      • 🌲Hierarchies
      • 🤿Column Mask
    • 🎉Switch to New Reports & Dashboards
    • 🆕Reports
      • Overview
      • Build Using Tables
        • Create a new Report
        • Layout and options
        • Build and Format - Overview
        • Apply Row Limits
        • Identify Date Columns
        • Filter your data
        • Visualizations
          • Table
          • Pivot
          • Line Chart
          • Bar Chart
          • Column Chart
          • Area Chart
          • Combo Chart
          • Scatter & Bubble Plot
          • Pie Chart
          • Funnel Chart
          • Stat Card
          • Point Map
          • Heat Map
          • Radial gauge chart
        • Advanced Features
          • Custom Analysis
          • Variables
          • Table & Quick Calculations
          • Drill - Hierarchical & Date
          • Break Out
          • RLS in Table reports
          • Scheduled Exports
          • Embedding Table Reports
      • Build Using Models
        • Create a new report
        • Layout and options
        • Visualizations
        • Advanced Features
      • Build SQL Reports
        • Create a new Report
        • Layout and options
        • Writing a SQL Code on Editor
        • Visualizations
        • Variables in SQL Reports
    • 🆕Dashboards
      • 🌀Filters
      • 👆Click Behaviour
      • ⏰Data Alerts
      • 🗓️Date Drill
      • 📤Scheduled Exports
      • 🔗Embed link
      • 🖥️Dashboard layout
      • 📱Mobile Dashboards
  • Transforming your data
    • 🔰SQL Transform
    • 📓Python Notebooks
  • Integrating your data
    • ☁️Destination Warehouses
      • AWS Athena
        • Manage storage of Flow tables
      • AWS Redshift
      • Azure Synapse
      • Databricks
      • Google BigQuery
      • MySQL
      • Postgres
      • Snowflake
      • SQL Server
      • K8 Setup
        • AWS EKS
        • Google GKE
        • Azure AKS
    • ⚙️Warehouse & Storage Setup
  • Ingesting your data
    • ☄️Data Imports
      • Databases
        • Azure Cosmos DB
        • Azure Table Storage
        • Google BigQuery
        • Mongo DB
        • MySQL DB
        • Oracle DB
        • Postgres DB
        • SQL Server DB
        • Features
          • Ingestion Modes
          • Add Multiple Datasets
          • CDC Setup
            • CDC setup in Mysql
            • CDC setup in Postgres
            • CDC setup in Mongo
            • CDC setup in SQL Server
          • Destination Create Table Clause
          • SSH Tunnel Setup
      • Files
        • AWS S3
        • AWS S3 External
        • Azure Blob
        • FTP
        • Google Cloud Storage
        • Google Sheet
        • SFTP
      • Applications
        • Apple Search Ads
        • Appsflyer
        • Branch
        • Clevertap
        • Facebook Ads
        • Freshdesk
        • Freshsales
        • Google Ads
        • Google Ads V2
        • Google Analytics
        • Google Analytics 4
        • Google Analytics MCF
        • Google Search Console
        • Hubspot
        • Impact Ads
        • Intercom
        • Klaviyo
        • Leadsquared
        • LinkedIn Ads
        • Magento
        • Mailchimp
        • Marketo
        • Mixpanel
        • MoEngage
        • Rocketlane
        • Salesforce
        • SAP S4
        • Shopify
        • Snapchat Marketing
        • TikTok Ads
        • WooCommerce
        • Zendesk Chat
        • Zendesk Support
        • Zoho Analytics
        • Zoho Books
        • Zoho CRM
        • Zoho Desk
        • Zoho Invoice
        • Zoho Subscription
      • Events
        • Apache Kafka
        • AWS Kinesis
        • Azure EventHub
    • 📤File Uploads
    • 🤖API Pulls
    • 🕸️Webhooks
  • Collaborating on data
    • 📤Sharing
    • 💬Comments
    • ⚡Activity
    • 🏷️Labels
  • Managing Schedules and Data Refreshes
    • ⏱️Schedules
    • 🔔Notifications
  • User Management
    • 🔑Access Management
    • 🧑‍🤝‍🧑Groups
    • 📂Folders
    • 🔄Syncing users, groups and RLS
    • 📧Azure AD Integration
  • Data Security & Privacy
    • 🔐Security at Sprinkle
    • 📄GDPR
    • 📄Privacy Policy
  • Release Notes
    • 📢Release Notes
      • 🗒️Release Notes - v12.1 (New)
      • 🗒️Release Notes - v12.0
      • 🗒️Release Notes - v11.0
      • 🗒️Release Notes - v10.8
      • 🗒️Release Notes - v10.7
      • 🗒️Release Notes - v10.6
      • 🗒️Release Notes - v10.5
      • 🗒️Release Notes - v10.4
      • 🗒️Release Notes - v10.3
      • 🗒️Release Notes - v10.2
      • 🗒️Release Notes - v10.1
      • 🗒️Release Notes - v10.0
      • 🗒️Release Notes - v9.31
      • 🗒️Release Notes - v9.30
      • 🗒️Release Notes - v9.29
      • 🗒️Release Notes - v9.28
      • 🗒️Release Notes - v9.27
      • 🗒️Release Notes - v9.25
      • 🗒️Release Notes - v9.24
      • 🗒️Release Notes - v9.23
      • 🗒️Release Notes - v9.22
      • 🗒️Release Notes - v9.21
      • 🗒️Release Notes - v9.20
      • 🗒️Release Notes - v9.19
      • 🗒️Release Notes - v9.18
      • 🗒️Release Notes - v9.17
      • 🗒️Release Notes - v9.16
      • 🗒️Release Notes - v9.14
      • 🗒️Release Notes - v9.13
      • 🗒️Release Notes - v9.12
      • 🗒️Release Notes -v9.8
      • 🗒️Release Notes - v9.7
      • 🗒️Release Notes - v9.6
      • 🗒️Release Notes - v9.5
      • 🗒️Release Notes - v9.4
      • 🗒️Release Notes - v9.3
      • 🗒️Release Notes - v9.2
      • 🗒️Release Notes - v9.1
      • 🗒️Release Notes - v9.0 (Major)
      • 🗒️Release Notes - v7.23
      • 🗒️Release Notes - v7.21
      • 🗒️Release Notes - v7.20
      • 🗒️Release Notes - v7.15
      • 🗒️Release Notes - v7.14
      • 🗒️Release Notes - v7.13
Powered by GitBook
On this page
  • Built for modern databases and cloud warehouses
  • Integrating your data
  • #1: Real-time Ingestion Pipelines
  • #2: Automatic Schema Mapping
  • #3: Live monitoring and control
  • #4: Datasources
  • Transforming your data
  • #1: Transform data using SQL
  • #2 Transform data using Python
  • #2: Transform data using Python
  • Analyzing your data
  • #1: Build business metrics using data models.
  • #2: Drag and Drop Analysis Using Reports
  • #3: Create dashboards combining multiple reports.
  • Managing Schedules and Data Refreshes
  • #1: Scheduling data sources and reports
  • #2: Automatic data dependencies
  • User Management
  • Data Security
  • Data Security

Quick Start

This page covers all the basics you need to know before starting to use Sprinkle

PreviousWhat is Sprinkle?NextAnalytics Overview

Last updated 1 year ago

Built for modern databases and cloud warehouses

Sprinkle is designed for modern .

Good to know: Sprinkle does not store your data; all your data is stored and processed within your data warehouse.

A list of all supported data warehouses and the setup instructions are given below:

Optimized for Performance: Sprinkle is built natively for cloud warehouses. Underneath, Sprinkle does optimizations like caching of data in low-cost storage, partitioning, etc., to deliver high performance at optimal warehouse cost.

Integrating your data

In case you don't have a data warehouse or your data is fragmented in different systems, Sprinkle helps you unify all your data into your data warehouse using the Datasource connectors. These connectors ingest data into your data warehouse, and these ingestion pipelines can be setup in just a few clicks via the Sprinkle web console.

#1: Real-time Ingestion Pipelines

Ingest data in real-time into your data warehouse using incremental mode, where only changed or new data is ingested.

Sprinkle ingestion connectors are battle-tested, ingesting billions of rows on a daily basis in real-time.

#2: Automatic Schema Mapping

Sprinkle automatically maps the source schema to the destination (data warehouse) schema.

JSON data is handled and flattened automatically. Any changes in the source schema are discovered and applied to the destination on the fly.

#3: Live monitoring and control

Sprinkle console shows live replication stats like the number of rows and data size moved.

A list of all supported data sources and the setup instructions are given below.

#4: Datasources

Read more about datasources here.

Transforming your data

Before the data is used for analysis, we sometimes need to transform it to make it more analytics-friendly. Transforming your data means creating a derived table from the set of input (mostly raw data) tables.

Good to know: Sprinkle follows a modern ELT approach. The data is transformed after arriving at your data warehouse, decoupling the transformation logic from data ingestion. This provides you with the agility to change the transformation logic easily and independently. Also, you have both raw and derived tables in your central data warehouse, providing you the flexibility to use the data in other tools and for data science purposes.

Sprinkle provides two ways to do data transformations:

#1: Transform data using SQL

SQL Transform helps you write SQL queries using the SQL dialect supported by the warehouse. Whatever SQL you write gets executed on the warehouse directly.

Simply put, SQL Transform is the advanced SQL Editor where you can write queries, see the results, and schedule the SQL script.

#2 Transform data using Python

#2: Transform data using Python

The Python code gets executed on the Kubernetes cluster in the data plane. You can schedule the entire notebook to run your Python code at regular intervals.

Analyzing your data

Got 2 mins? Check out the video:

#1: Build business metrics using data models.

Business metrics standardize analytics across the organization, eliminating the need to write and optimize queries manually.

#2: Drag and Drop Analysis Using Reports

Unlike traditional BI tools, you can analyze data at any granularity without being a data expert. Data consumers can dive deeper into the data by building their own custom analyses and reports.

Sometimes you may quickly want to build a report for which there isn't a model defined yet. In that case, you can use SQL to build the report and create visualizations. You get a powerful SQL editor with an inbuilt Schema browser.

You can also build reports directly using tables with our intuitive report builder UI.

"Sprinkle helped us become data enablers from the data providers."

"Easy understanding of the product is a top-most requirement and it takes very less amount of time for a user to get familiarised with basics in sprinkle. The Product gives multiple options to users to get and analyze the data either using Reports or custom queries. Integration with external products and dashboards is super easy."

- Rajat Jain, Data Analyst, Udaan

#3: Create dashboards combining multiple reports.

  • You can combine multiple reports to create dashboards.

  • You can filter the data in one go easily across all the reports within a dashboard.

  • You can share the dashboard with others, download it as a PDF, schedule refreshes, and do drill-downs and drill-ups.

Managing Schedules and Data Refreshes

#1: Scheduling data sources and reports

Sprinkle lets you schedule your data ingestion or report refreshes as per the desired frequency interval. You can schedule data sources, reports, etc., to run periodically.

#2: Automatic data dependencies

User Management

Data Security

Sprinkle is fully secure.

Learn more about security at Sprinkle here.

Data Security

We do not store your data on our servers. All data is stored and processed within your private cloud network.

If you already have a data warehouse and all your required data is present in it, you can skip to the next section, .

For creating a derived table from a set of input tables, you can use .

In certain cases, you want to use python libraries for data manipulation and preparation. Sprinkle provides a feature, via which you can write Python code and do data exploration within the Notebook editor itself. The python code gets executed on the Kubernetes cluster in the Data Plane. You can schedule the entire Notebook to run your python code at regular intervals.

In certain cases, you want to use Python libraries for data manipulation and preparation. Sprinkle provides a feature, via which you can write Python code and do data exploration within the Notebook editor itself.

help analysts build business metrics and dimensions via a visual interface. Analysts can join tables, create custom expressions, and validate data all from the visual console. This reduces the manual work that would otherwise be needed from analysts for building reports. You can create models directly on warehouse tables without any data loading, unlike traditional BI tools.

Sprinkle help data consumers analyze data with drag-and-drop functionality and build visualizations.

You can also set up email notifications if a schedule fails, succeeds, or is delayed. Learn more about .

Sprinkle finds out all the dependencies across different transformations and reports automatically, and it schedules all the data refreshes in a pipeline. You can learn more about data .

Sprinkle provides fine-grained access controls. Specific data can be shared with only a specific set of users. Refer to for more details.

Sprinkle is fully secure. Learn more about .

databases and warehouses
AWS Athena
AWS Redshift
Azure Synapse
Databricks
Google BigQuery
MySQL
Postgres
Snowflake
SQL Server
SQL Transform
Notebook
Notebook
Data models
Reports
notifications here
dependencies here
User Management
security at Sprinkle here
Transforming Your Data
No-code Analytics Product Tour
Live monitoring of data ingestion
Sprinkle SQL Transform
Join warehouse tables visually without any coding
Define business measures and dimensions directly on warehouse table
Drag and Drop Interface
SQL based Report Builder