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 2021.2
  • Python (pysqream)
    • pysqream API reference
  • C++ Driver
  • JDBC
  • ODBC
  • Node.JS
• Third Party Tools
  • Connecting to SQream Using TIBCO Spotfire
  • Connect to SQream Using SQL Workbench
  • Connecting to SQream Using Tableau
  • Connecting to SQream Using Informatica Cloud Services
  • Connect to SQream Using Pentaho Data Integration
  • Connect to SQream Using MicroStrategy
  • Connect to SQream Using R
  • Connect to SQream Using PHP
  • Connecting to SQream Using SAS Viya
  • Connecting to SQream Using Talend
• Operations
  • Optimization and Best Practices
  • Logging
  • Configuration
  • Troubleshooting
  • Gathering information for SQream support
  • Creating or Cloning a Storage Cluster
  • Using the statement editor (deprecated)
  • Hardware Guide
  • Security
  • SQream Acceleration Studio 5.4.3
    • Getting Started with SQream Acceleration Studio 5.4.3
    • Monitoring Workers and Services from the Dashboard
    • Executing Statements and Running Queries from the Editor
    • Viewing Logs
    • Creating, Assigning, and Managing Roles and Permissions
    • Configuring Your Instance of SQreams
• Feature 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