This guide describes the functionality and benefits of the SQream Dashboard and is designed for SQream DB administrators and support team members.

1. The SQream Dashboard

The SQream Dashboard is your central monitoring and administration tool for the SQream database. It provides an overview on the health and availability of the SQream server components, including CPU, GPU, memory and disk usage.

It shows all current and historical activities running at the SQream DB server, such as query statements and their performance, possible locks, or database errors. All database related information is captured to internal log files for later and further analysis.

In addition, the SQream Dashboard allows you to manage users and their permissions to access either the SQream database or the SQream Dashboard.

SQream Dashboard is a web-application and currently supports the Chrome browser only.

2. Login

Open your browser and navigate to the URL of your SQream Dashboard. Typically this is port 3001 of your primary host machine of the SQream DB. http://<SQream DB primary host IP>:3001.

This is your login screen:

Login Modal
Figure 1. Login Screen

Enter the credentials of your dashboard user and click LOG IN.

Dashboard users are configured in the Dashboard User Management module.

3. The Dashboard

The main module of the dashboard provides an overview of various components in the system. Typically all components show information in nearly real time. The refresh rate can be configured on the Dashboard Setup page.

3.1. Hosting Server

Hosting Panel
Figure 2. Hosting Panel

The Hosting Server panel displays information about the machine, OS and SQream DB services. The information includes:

  • SQream DB component status

  • System uptime

  • CPU usage

  • GPU utilization

  • Memory usage

Click the green Manage link to stop or start the SQream DB server.

These markers do not log historical data, and will only show information from the moment the dashboard page has been opened in your browser.

3.2. Database Disk Distribution

The Database Disk Distribution panel shows the disk-space used by each database in the SQream DB storage.

3.3. Disk Usage

Disk Usage
Figure 3. Disk Usage

The Disk Usage panel shows the total disk-space used and available for the entire SQream DB storage.

3.4. Active Statements

The Active Statements panel shows the currently running statements, along with basic details like: Statement ID, the User running the statement, Start Time, Status and more.

Active Statements
Figure 4. Active Statements

There are 2 icons for each active statement:

  • Stop Statement - Allows you to stop a currently runnning statement.

  • Show Node Info - Allows you to bring up query statistics such as the query’s execution plan and performance metrics during execution.

Show Node Info

Click the Show Node Info icon to review the query statistics. They can be saved to a file using the Save to File option. This feature is an advanced monitoring tool. It is typically used when you encounter performance issues and you want to send more information to the SQream support team.

Show Node Info
Figure 5. Show Node Info

3.5. Last Statements

The Last Statements panel shows the last 30 statements (default configuration), as they appear in the SQream DB Log. This includes both successful and failed statements.

Last Statements
Figure 6. Last Statements

From the top right corner of the Last Statement panel you can perform the following actions:

  • Open SQream DB Log - Jumps to the SQream DB Log page.

  • Download all log files - Allows you to download and save all log files. This includes information about the SQream server activity, logins, statements, execution and exceptions.

  • Refresh - Refresh the list of Last Statements.

Use the Copy icon at the statement line to copy the single query statement to the clipboard.

The number of statements in this list is configurable in the Dashboard Setup page.

4. Import Data from a CSV File

The Import CSV tool assists in uploading data from CSV files into the SQream DB. It is designed as a 4-step wizard:

Import CSV
Figure 7. Import CSV

4.1. Select Source

You can import data using one of the following options:

  • File upload - Allows you to upload a CSV file from your local computer and import the data. For this option you can either drag and drop the file or select it using the Open File dialog.

  • Local file - Allows you to import data from a CSV file, located on your server machine. Specify the full file path, including folder and file name.

Select the Directory checkbox to import all CSV file located in a specific directory. This option is relevant only for imports from a Local file.

4.2. Import Setting

Under Import Setting you configure the layout of the CSV file you want to import.

Basic settings include:

  • Delimiter - Specify the correct column delimiter, like ,, \t, |, or any other single character. Comma is the default delimiter.

  • Header line - Check this checkbox to skip the first line of the file.

More advanced settings are accessible via Advanced Settings link. Refer to SQream SQL Reference Guide under the "COPY FROM (bulk import)” section for more information about these settings.

Click Next to move to the next step.

4.3. Select Target

In the Select Target step you can preview the first few rows of the CSV file and then specify the target database and table for the import.

Selecting the correct target for bulk import
  1. Select the target database

  2. Select target table

  3. Map the columns
    Once the table is specified, the columns are displayed on the left-hand list (under All columns). You must select the columns and their order to be populated by the CSV file.

    1. Select a single column by clicking the + icon, or select all columns by using SELECT ALL.

    2. You can search for specific columns by using the search bar.

  4. Remove columns or reorder columns:

    1. After selecting columns, you can remove them with the X icon.

    2. To reorder drag and drop the selected columns up or down.

Click Next to start the import.

4.4. Results

Once the import process started the Results step opens. It shows the progress of the import process and finally the status: Success or Error.

In addition you can see the executed statement and in case of an error, it allows you to download the error log file.

The error log file is generated in same directory as the csv file.

4.5. Save and Load Import CSV Settings

Import CSV options

From the top right corner of the Import CSV wizard you can perform the following actions:

  • Save Import CSV Setting - Allows you to save the setting of your last import activity, including the file name (if you loaded data from a local file), the Import settings, and Target configuration.

  • Load Import CSV Setting - Allows you to perform a CSV import based on a previously saved setting.

  • RESTART - Starts a new Import CSV process from scratch.

5. Documentation


Use the documentation icon at your top right corner to open the list of available SQream support documentation.

6. SQream DB Logs

The SQream DB Logs module allows you to review the last 500,000 query statements that were performed by the various clients. Statements that failed are shown in red.

SQream DB Log
Figure 8. SQream DB Log

6.1. Filter the Statements

Use the various filter options to narrow down the displayed statements. You can use one or multiple filter options offered in the top part of the screen:

  • Search - Search for a key word in the Query Statement or Error Message.

  • Filter by database - From the dropdown list select a specific database.

  • From …​ to …​ - Use the calender and time icons to set the start and end time of your filter condition.

  • Status - From the dropdown list select a specific status.

6.2. Copy

Use the Copy icon at the statement line to copy the single query statement or the error message to the clipboard.

7. Roles and Permissions

The Roles and Permissions module allows you to create and manage SQream DB users/roles and their permissions. These are the users/roles to access the SQream database.

More information about SQream DB’s roles and permissions system can be found in our SQL Reference Guide under the "Managing Database Roles and Permissions" section.

Role Management
Figure 9. Roles and Permissions

7.1. Add a New Role

Click the ADD NEW link to add a new role.

Fill in the required details and click SAVE.

7.2. Update an Existing Role

From the list of existing roles click the Edit link to open the Update SQream Role dialog.

If you do not want to change the password leave the password fields unchanged.

Click SAVE to save the changes.

7.3. Update Role Permissions

The Permissions link in the roles table opens the SQream Role Management dialog.

SQL Preview

To preview the SQL query for the upcoming changes, click the SHOW SQL link.

Click SAVE to save the changes.

Changing permissions generates one or more SQL statements. These statements are shown on the screen. Successful statements are show in green, failed statements are red.

7.3.1. Role Inheritance

To inherit one role to the other. Edit the role. You can assign roles to other roles (inherit one role to other). In the role sections, check or uncheck roles that you would like to inherit from, to the current role.

7.3.2. Databases, Schemas, Tables

In this section, you can GRANT and REVOKE permissions on the database level.

Upon selecting a database and schemas, all tables will be shown - allowing GRANT and REVOKE operations.

7.4. Drop a Role

From the list of existing roles click the Drop link. If this role is used by other roles, the system will show you the dependant roles.

If a role is used by other roles you can force a drop. Use the DROP ROLE button.

More information about SQream DB’s roles and permissions system can be found in our SQL Reference Guide under the "Managing Database Roles and Permissions" section.

8. Show Locks

The Show Locks module allows you to review database locks that currently occur in your system, also referred to as active locks. If required you can release a lock by stopping the statement.

Show Locks
Figure 10. Show Locks

8.1. Show Locks and Filter

Show Locks
  • Show Locks - Select a specific database from the dropdown list and click FETCH.

  • Filter - Use additional filter conditions per table and/or user to filter for specific locks.

8.2. Release a Lock

To release a lock you can stop a query statement by using the STOP link at the statement line.

9. Dashboard Users

The Dashboard Users module allows you to add and maintain users that can access the SQream Dashboard.

Dashboard Users
Figure 11. Dashboard Users

Click the ADD NEW link to add a new dashboard user.

Fill in the required details and click SAVE.

Dashboard users typically do not have access to data in the SQream DB. The list of dashboard users is therefore handled as a seperate and independant list. Dashboard users are different than the SQream DB users.

10. Dashboard Setup

The Dashboard Setup module allows you to configure dashboard related settings.

Dashboard Setup
Figure 12. Dashboard Setup
  • Dashboard Refresh Rate: For each element in the dashboard configure how often to refresh the data. Select a specific refresh rate or allow Manual refresh only.

  • Hosting Server Ticks: This parameter is used by the Host Server panel on the main module. It has an impact on the displayed line interval (for CPU, GPU and memory).

  • Number of statements to show in history: This is the number of statements to show in the Last X Statements pane of the main module.

  • SQream DB Log: System internal statements performed by the dashboard can be shown and/or logged to the system log files. By default these parameters are set to NO.

11. About Window

The About Window shows information about:

  • Installed Versions: Installed versions of SQream database, SQream dashboard and SQream Editor.

  • License Information

Dashboard About
Figure 13. About Window

Click the CHECK FOR SOFTWARE UPDATES link to check if a newer version is available.

Copyright © 2010-2018. All rights reserved.

This document is provided for information purposes only and the contents hereof are subject to change without notice. This document is not warranted to be error-free, nor subject to any other warranties or conditions, whether expressed orally or implied in law, including implied warranties and conditions of merchant- ability or fitness for a particular purpose.

We specifically disclaim any liability with respect to this document and no contractual obligations are formed either directly or indirectly by this document.

This document may not be reproduced in any form, for any purpose, without our prior written permission.