SQream DB Documentation

SQream DB is a columnar analytic SQL database management system. SQream DB supports regular SQL including a substantial amount of ANSI SQL, uses serializable transactions, and scales horizontally for concurrent statements. Even a basic SQream DB machine can support tens to hundreds of terabytes of data. SQream DB easily plugs in to third-party tools like Tableau comes with standard SQL client drivers, including JDBC, ODBC, and Python DB-API.

Topic

Description

Getting Started

Preparing Your Machine to Install SQream

Set up your local machine according to SQream’s recommended pre-installation configurations.

Executing Statements in SQream

Provides more information about the available methods for executing statements in SQream.

Performing Basic SQream Operations

Provides more information on performing basic operations.

Hardware Guide

Describes SQream’s mandatory and recommended hardware settings, designed for a technical audience.

Installation Guides

Installing and Launching SQream

Refers to SQream’s installation guides.

Installing SQream Studio

Refers to all installation guides required for installations related to Studio.

Ingesting Data

Inserting Data from a CSV File

Inserting Data from Avro

Inserting Data from a Parquet File

Inserting Data from an ORC File

Connecting to SQream

Client Platforms

Describes how to install and connect a variety of third party connection platforms and tools.

Client Drivers

Describes how to use the SQream client drivers and client applications with SQream.

External Storage Platforms

Inserting Data Using Amazon S3

Describes how to insert data over a native S3 connector.

Using SQream in an HDFS Environment

Describes how to configure an HDFS environment for the user sqream and is only relevant for users with an HDFS environment.

Need help?

If you couldn’t find what you’re looking for, we’re always happy to help. Visit SQream’s support portal for additional support.