Guides

This section has concept and features guides, and task focused guides.

Recommended guides

• Optimization and best practices in SQream DB
• Using third party tools
• Client drivers for SQream DB

Full list of guides

• Inserting data
  • Insert from CSV
  • Insert from Parquet
  • Insert from ORC
  • Migrating from Oracle
• Client drivers for v2021.1
  • Python (pysqream)
    • pysqream API reference
  • C++ Driver
  • JDBC
  • ODBC
  • Node.JS
• Third party tools
  • Connecting SQream Using SQL Workbench
  • Connecting to Tableau
  • Connecting to SQream Using Pentaho Data Integration
  • Connecting with R
  • Connecting with PHP
  • Connecting to SAS Viya
• Operations
  • Optimization and Best Practices
  • Installing Monit
  • Launching SQream with Monit
  • Installing SQream Using Binary Packages
  • Monitoring query performance
  • Logging
  • Configuration
  • Troubleshooting
  • Gathering information for SQream support
  • Creating or cloning a storage cluster
  • Installing Studio on a Stand-Alone Server
  • SQream Acceleration Studio 5.3.2
  • Using the statement editor (deprecated)
  • Hardware Guide
  • Security
  • Setting up SQream DB
    • Before you begin
    • Start a local SQream DB cluster with Docker
    • Recommended Pre-Installation Configuration
• Features guides
  • Access control
  • Concurrency and locks
  • Concurrency and scaling in SQream DB
  • Metadata system
  • Chunks and extents
  • Compression
  • Data clustering
  • Deleting Data
  • Time based data management
  • Foreign Tables
  • Working with External Data
    • Amazon S3
    • Using SQream in an HDFS Environment
  • Transactions
  • Workload Manager
  • Python UDF (user-defined functions)
  • Saved queries
  • Seeing system objects as DDL
• Architecture
  • Internals and architecture
  • Filesystem and usage