Sprinkle

Sprinkle

  • Docs
  • Tutorials
  • API
  • FAQ's
  • Blog
  • Go to sprinkledata.com

›Storage

Data Warehouse

  • Why the warehouse?
  • Amazon Athena
  • Apache Hive
  • Databricks
  • BigQuery
  • Snowflake
  • Redshift

Storage

  • Why the storage?
  • AWS S3 Bucket
  • Google Cloud Storage
  • Azure Blob Storage

Data Sources

  • Overview and Creating Data Source
  • Ingestion Mode
  • How Sprinkle handles the ingestion if there is a change in schema in the client DB?
  • Flattening JSON columns in DB
  • Column excluding and masking in DB table
  • Ingestion via SSH Tunnel
  • Configurable Destination Schema and table name
  • PostgreSQL
  • Salesforce
  • MySQL
  • MongoDB
  • Mixpanel
  • Hubspot
  • CosmosDB
  • CSV
  • AppsFlyer
  • CleverTap
  • SQL
  • Kafka
  • Amazon Kinesis
  • Azure Event Hub
  • Azure Table Storage
  • Zoho CRM
  • Freshsales
  • Google Analytics
  • GoogleSheet
  • Google Cloud Storage
  • Azure Blob
  • S3
  • Webhook
  • Sendgrid
  • Segment
  • Google Ads
  • Google Analytics MCF
  • Zendesk Support
  • Zendesk Chat
  • Google Search Console
  • Shopify
  • Facebook Ads
  • Mailchimp
  • WebURL
  • Klaviyo
  • SAP S4
  • Intercom
  • Marketo
  • Freshdesk
  • Leadsquared
  • Bigquery
  • MongoDB Atlas
  • Paytm
  • HDFS
  • FTPS
  • FTP

CDC Setup

  • MySQL
  • Postgres
  • Mongo

Transform

  • Schema Browser
  • Overview and Creating Flow
  • Advanced Features in Flow

KPI

    Models

    • Overview
    • Creating Model
    • Joins
    • Hierarchical Filters
    • Default Date Filters
    • Column Description in reports

    Segments

    • Overview
    • Creating Segment
    • Publish segment as table
    • Transpose
    • Show Labels Annotations on Charts
    • Tooltips
    • Fixed Columns
    • Conditional Builders
    • Cumulative Sum and Percentages
    • Embed Segment

    Metric Alerts

    • Overview and Creating Metric Alerts

Dashboards

  • Overview and Creating Dashboard
  • Embed Dashboard
  • Restricting filters
  • Sharing resources

Drill Down

  • Drill Down Feature In Segments And Dashboards
  • Drill Down Hierarchical Dimensions
  • Drill Down Expression Hierarchical Dimensions

Explores

  • Overview and Creating Explore
  • Show Labels Annotations on Charts
  • Tooltips

Machine Learning

  • Jupyter
  • Notebook Setup Guide

Sharing

  • Sharing Segments and Explore Reports
  • Share folders with users or groups

Scheduling

  • Schedule Timeline
  • Autorun

Notifications

  • Email Notifications
  • Slack Notifications

View Activity

  • View Activity

Admin

  • Admin -> usage
  • User Permissions & Restrictions
  • Github Integration

Launch On Cloud

  • AWS
  • Azure
  • Setup Sprinkle

Security

  • Security at Sprinkle
  • GDPR

Feedback

  • Option to take feedback from UI

Release Notes

  • Release Notes

AWS S3 Bucket

AWS S3

This document will help you to create a S3 bucket and a IAM user with full access to this bucket, and configure Storage driver in Sprinkle

Steps to create S3 bucket

  1. Sign in to the AWS Management Console and open the Amazon S3 console
  2. Click on Create bucket to create a bucket .
  3. Provide bucket name (this cannot be changed after creating bucket and it must be unique across all the buckets) and region (data center nearer to your location).
  4. Provide the configuration settings and required permissions to this bucket (recommended is to keep it default).
  5. Review the setting and click on the Create bucket.
  6. This will create a new bucket and it will be shown in the bucket list.

You can refer to AWS Documentation for naming conventions or any required help.

There are three ways to provide Sprinkle access to this bucket

  1. Use default full access policy.

    Create an IAM user with Programmatic Access and attach S3 access policy.

    1. Select Users from the left side and click on Add user.

    2. Provide User name and check the Programmatic Access from the access type.

    3. Click on Next and click on attach existing policies directly tab from the Set Permissions.

    4. Search for the S3FullAccess policy and click on Next.

    5. Review the user and policy details and click on Create User.

    6. This will create a new user and show the access click and secret key.

    7. Click on Download .csv to store this secret and access key (secret access will not be visible after this).

    You can refer to the AWS documentation for IAM user creation.

  2. Create a new policy to provide full access to particular user

    In this way, you can create a new policy for granting access to the specific bucket and then create the new user using this policy. You can refer to the AWS Documentation for creating a new policy for S3.

    After creating a new policy, follow the same steps for creating a new IAM user as in the previous option and in step 4, select the new policy creating for S3 bucket instead of S3FullAccess.

  3. Provide access to the VM directly

    This way is helpful if you have deployed Sprinkle in on-premise setup. You can refer to the AWS Documentation for providing S3 bucket access directly to the VM instance.

Steps to Configure S3 Storage Driver in the Sprinkle

  1. Select Driver from Admin from the left panel
  2. Click on Create New Storage and select type AWS S3 from the popup
  3. The driver configuration page will open to provide the required information.
  4. Provide the Distinct Name for easy identification of the storage.
  5. Provide access key and secret key which is generated in the previous section. (Not required if access is provided to the VM directly).
  6. Provide region which is specified at the time of bucket creation
  7. Provide the bucket name, the name which is provided at the time of bucket creation.

AWS Storage

  1. You can whitelist the IP(S) shown in Sprinkle IP(S) to white list, if you want to give access to specific IPs.
  2. After providing all the information, you can click on Test Connection. If there is any issue with the connection, it will show an error message. Do the required changes and click on Test Connection again, if all good it will show a Test Connection Succeeded message.
  3. Click on Create to update the storage details and create storage.
  4. This storage will appear in the list of storage drivers.
← Why the storage?Google Cloud Storage →
  • AWS S3
    • Steps to create S3 bucket
    • Steps to Configure S3 Storage Driver in the Sprinkle

Product

FeaturesHow it worksIntegrationsDeploymentPricing

Industries

Retail & EcommerceUrban MobilityFinanceEducation

Departments

MarketingOperationsTechnology

Connect

Free trialAbout Us

Actionable Insights. Faster.

Sprinkle offers self-service analytics by unlocking enterprise scale data via simple search and powerful reporting service.


Copyright © 2021 Sprinkle data