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 v2020.2
  • Python (pysqream)
    • pysqream API reference
  • C++ Driver
  • JDBC
  • ODBC
  • Node.JS
• Third party tools
  • Connecting to SQL Workbench
  • Connecting to Tableau
  • Connecting with R
  • Connecting with PHP
  • Connecting to SAS Viya
• Operations
  • Optimization and best practices
  • Monitoring query performance
  • Logging
  • Configuration
  • Troubleshooting
  • Gathering information for SQream support
  • Creating or cloning a storage cluster
  • SQream Acceleration Studio
  • Using the statement editor (deprecated)
  • Hardware Guide
  • Security
  • Setting up SQream DB
    • Before you begin
    • Start a local SQream DB cluster with Docker
    • Recommended post-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
    • S3
    • HDFS
  • Transactions
  • Workload manager
  • Python UDF (user-defined functions)
  • Saved queries
  • Seeing system objects as DDL
• Architecture
  • Internals and architecture
  • Filesystem and usage