Watch the 7.3 Webinar On-Demand
This new release brings updates to Universal Storage, query optimization, and usability that you won’t want to miss.

Augmenting Your Data Warehouse to Accelerate BI

Welcome to SingleStore Managed Service! We put together a guide to help you augment your data warehouse by migrating some of your BI workloads to SingleStore. Use this guide to follow a top-down approach to:

  • Preparing your data from your existing data warehouse
  • Interacting with SingleStore
  • Designing your SingleStore tables to accelerate your dashboards
  • Incorporating streaming data with SingleStore
  • Optimizing your queries for your dashboards
  • Connecting your dashboard to SingleStore

Tutorial Outline

This tutorial is divided into the following sections:

Getting Started

  • Benefits of leveraging SingleStore Managed Service for your BI dashboard
    • Why users leverage SingleStore to augment their existing data warehouse technologies
  • What to consider when bringing your data from:
    • Snowflake, Redshift, BigQuery, Synapse
    • AWS S3, Google CS, Azure, Kafka
  • What to consider when designing your database coming from:
    • MySQL, MariaDB, Postgres

Sample Architectures

Preparing Your Data for SingleStore

Database Administration

  • SingleStore Portal
  • Drivers
  • MySQL Workbench
  • MySQL Command Line

Designing Your Tables

  • Data types
  • Designing a schema for an application
    • Sharding for application workloads
    • Sort keys for application workloads
    • Reference Tables

Ingesting Data for BI

  • How this may be different from ingesting directly to the data warehouse
  • Using SingleStore Pipelines
  • Using INSERT Statements

Testing Your Queries

  • Run queries
  • Visual Explain
  • Concurrency test your queries using dbench based on app expectations

Writing Your Data Back to Your Data Warehouse for Long-Term Storage (optional)

Connecting to Your BI Tools

  • Connectivity samples for Tableau, Power BI, Looker