SQreamDB Documentation

SQreamDB is a columnar analytic SQL database management system. SQreamDB supports regular SQL including a substantial amount of ANSI SQL, uses serializable transactions, and scales horizontally for concurrent statements. Even a basic SQreamDB machine can support tens to hundreds of terabytes of data. SQreamDB 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 SQreamDB			Set up your local machine according to SQreamDB’s recommended pre-installation configurations.
Executing Statements in SQreamDB			Provides more information about the available methods for executing statements in SQreamDB.
Performing Basic SQream Operations			Provides more information on performing basic operations.
Hardware Guide | Describes SQreamDB’s mandatory and recommended hardware settings, designed for a technical audience.
Installation Guides
Installing and Launching SQreamDB			Refers to SQreamDB’s installation guides.
Installing SQream Studio			Refers to all installation guides required for installations related to Studio.
Ingesting Data
CSV	Avro
Parquet	ORC
JSON	SQLoader As a Service
Connecting to SQreamDB
Client Platforms			Describes how to install and connect a variety of third party connection platforms and tools.
Client Drivers			Describes how to use the SQreamDB client drivers and client applications with SQreamDB.
External Storage Platforms
Amazon Web Services			Describes how to insert data over a native S3 connector.
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 SQreamDB’s support portal for additional support.