Home

Welcome to the SNAP User Documentation!

Introduction

• Overview
• Approaching a SNAP project
• FAQ

User Guides and Tutorials

• Getting Started and Connecting to SNAP
• Creating a SNAP Cube on a flattened dataset
• Creating a SNAP Cube on a star schema
• Sample end to end Notebook with SNAP
• Designing SNAP Cubes from Transaction normalized tables
• Optimizing for count distinct queries

SNAP Indexing Guides

• Quick Into to Ingesting Data Into SNAP
• Indexing Overview
• Optimizing the Indexing Process
• Optimizing the SNAP File Format
• Update-able Indexes
• Understanding Metric Binning
• Using Double Precision Datatypes

Managing the SNAP Segment Cache

• The Segment Cache Lifecycle
• Segment Cache Views
• Segment Query Cache

SQL Reference

• Segment Cache Manager View
• Tuning the Segment Cache

Star Schema Commands

• Create Star Schema
• Analyze Star Schema
• Drop Star Schema
• Refresh Star Schema

SNAP Index Commands

• Create SNAP Index
• Insert SNAP Index
• Update SNAP Index
• Alter SNAP Index
• Drop SNAP Index
• Describe SNAP Index

SNAP Index Segment Commands

• Clear SNAP Segments
• Show SNAP Segments
• Recover SNAP Segments cache state

SNAP Model Commands

• Export Model
• Import Model

Misc Commands

• Analyze OLAP Table
• Analyze Star Schema
• SNAP VERSION
• Invalidate Session Metadata Cache

Runtime Views

• Segment Cache View
• SegmentCacheManager View
• OLAP Index Design Views

Segment Cache

• Segment cache metrics
• Segment cache lifecycle

Query Cache

• Segment Query cache metrics
• Segment Query cache

---

SNAP Configuration

• SNAP Configuration parameters
• SNAP Metrics
• SNAP with Kerberos/JDBC
• SNAP Thriftserver Startup Script

SNAP on Oracle Cloud Infrastructure (OCI)

• SNAP access OCI ObjectStore
• SNAP on Oracle BDC

Performance

• Tuning SNAP Segment Cache
• SNAP Performance - Things to consider

TPCDS Benchmark

• Benchmark scripts