RG - Crunchtime Data Streaming Download PDF
REFERENCE GUIDE

Data Streaming

Reference Guide

Document Details

Document #: 160_CR1100_251027
Release Version: 11.00.00.00
Version Release Date: Oct 2025

System Requirements

Overview

This document explains how set up Data Streaming for your Crunchtime data in Inventory, Labor, and Crunchtime Ops Execution

QR code — scan to download the latest version of this guide
Download the latest version of this document here: https://links.crunchtime.com/RG-CrunchtimeDataStreaming

… or scan the QR code to the left.


Database

Data Streaming

Overview

Crunchtime Data Steaming gives restaurant brands access to raw operational data for reporting and analysis in their own tools.

Data Streaming is one of four ways in which customers are able to access, analyze, and/or export their data outside of Crunchtime; the other options are:

Requirements for Inventory & Labor (See Pg. 3):

The customer is expected to…

Crunchtime will administer…

Snowflake reference materials are all available online including a Snowflake: Getting Started Guide. Links to the Snowflake documentation are provided as part of the implementation steps for easy reference.

Requirements for Ops Execution (See Pg. 5):

The customer is expected to…

Crunchtime will…

Implementation Steps for Inventory and Labor

The following the steps should be executed by the customer in their Snowflake environment.

  1. 1
    Create a DATABASE named “CRUNCHTIME”.
1 CREATE DATABASE CRUNCHTIME

Snowflake Reference: CREATE DATABASE

  1. 2
    Create a WAREHOUSE named “COMPUTE_CT_INGRESS “. The minimum size is “medium”, but this may be required to be of a larger size for some customers where the “medium” sizing will not be able to keep up with the volume of data being streamed.
1 CREATE WAREHOUSE COMPUTE_CT_INGRESS WITH
2  warehouse_size                       = "medium"
3  warehouse_type                       = "STANDARD"
4  auto_resume                          = true
5  auto_suspend                         = 60
6  enable_query_acceleration            = true
7  query_acceleration_max_scale_factor  = 10;

Snowflake Reference: CREATE WAREHOUSE

  1. 3
    Create a ROLE named “R_CT_INGRESS” and apply permissions.
1 CREATE ROLE R_CT_INGRESS COMMENT = 'This role has all privileges on schemas associated with Crunchtime.';
2
3 GRANT USAGE ON WAREHOUSE COMPUTE_CT_INGRESS TO ROLE R_CT_INGRESS ;
4
5 GRANT USAGE ON DATABASE CRUNCHTIME TO ROLE R_CT_INGRESS ;
6
7 GRANT CREATE SCHEMA ON DATABASE CRUNCHTIME TO ROLE R_CT_INGRESS ;
8
9 GRANT MONITOR ON DATABASE CRUNCHTIME TO ROLE R_CT_INGRESS ;
10
11 GRANT IMPORTED PRIVILEGES ON DATABASE SNOWFLAKE TO ROLE R_CT_INGRESS ;

Snowflake Reference: CREATE ROLE

  1. 4
    Open a Crunchtime Support Ticket, and do the following:
    1. Request the generation of a key-pair for authentication related to Data Streaming
    2. Provide the full URL of your Snowflake environment.

For example: "Hi Support, I am a new Data Streaming customer and I've reached Step 4 in the implementation. Can you please generate the keypair for authentication? My Snowflake URL is {customer enter full url here}"

Snowflake Reference: KEY-PAIR AUTHENTICATION AND ROTATION

  1. 5
    Create a USER named “CTSERVICEACCT”
1 CREATE OR REPLACE USER CTSERVICEACCT
2 LOGIN_NAME = 'ctserviceacct'
3 EMAIL = 'tyod@crunchtime.com'
4 TYPE = SERVICE
5 DEFAULT_WAREHOUSE = COMPUTE_CT_INGRESS
6 DEFAULT_ROLE = R_CT_INGRESS;
7
8
9
ALTER USER CTSERVICEACCT SET RSA_PUBLIC_KEY='the-value-provided-by-crunchtime';
GRANT ROLE R_CT_INGRESS TO USER CTSERVICEACCT;

Snowflake Reference: CREATE USER

  1. 6
    In the same Crunchtime Support Ticket opened in Step 4, request Crunchtime to confirm connectivity of the CTSERVICEACCT account.
    For example: “Hi Support, I have configured the CTSERVICEACCT account. Can you please confirm connectivity?”
  2. 7
    You’re all set! Crunchtime will proceed with the remaining steps of creating the SCHEMA, tables and instantiating the data streaming.

Implementation Steps for Ops Execution

After provisioning a Snowflake instance, the following the steps should be executed by the customer in their Snowflake environment.

Snowflake > Profile
Screenshot: Snowflake > Profile
A

Expand your profile menu

B

Select your account

C

Choose View account details

  1. 1
    Navigate to view your account details as shown:
  1. 2
    Copy the value in your Data Sharing Account Identifier field. It should be in the format: <orgname>.<account_name>
  2. 3
    Create a Crunchtime Support Ticket to send Crunchtime this Data Sharing Account Identifier value, and our team will grant you access to a private listing.