Sisense CLI Commands

Applicable to Sisense on Linux

In addition to the REST API, Sisense includes a CLI (Command Line Interface) commands that support executing various Sisense-related commands using the Linux command line.

Accessing the Sisense CLI

To access the Sisense CLI: 

  1. Connect to your Linux host using SSH.
  2. Run the command "source add_completion-ns-sisense.sh".

After running the command, you can then run Sisense commands in the format si <group name> <command> <parameters>.

For example, if your command is part of the DataGroups group, your command would like this: si datagroups list

The table below lists the Sisense commands, descriptions, related parameters, and examples.

DataGroups

Commands Description Parameters
list

Displays a list of all data groups.

Example:

si datagroups list

 
create

Create a new data group.

Example:

si datagroups create -name example

Mandatory:

name

Optional:

connector-mode
index-size
default
query-instances
query-cpu-limit
query-cpu-request
query-memory-limit
query-memory-request
query-cores-usage-percentage
build-cpu-limit
build-cpu-request
build-memory-limit
build-memory-request
build-cores-usage-percentage
enable-recycler

rename

Rename a data group.

Example:

si datagroups create -name example -new-name example

Mandatory:

name
new-name

update

Update a data group.

Example:

si datagroups update -name example

Mandatory:

name

Optional:

connector-mode
index-size
default
query-instances
query-cpu-limit
query-cpu-request
query-memory-limit
query-memory-request
query-cores-usage-percentage
build-cpu-limit
build-cpu-request
build-memory-limit
build-memory-request
build-cores-usage-percentage
enable-recycler

assign

Assigns an ElastiCube to a data group.

Example:

si datagroups assign -name example -cube examplecube

Mandatory:

name
cube

attach

Attaches a node to a data group.

Example:

si datagroups attach -name example -node myhost -roles BUILD,QUERY

Mandatory:

name
node
roles

detach

Detaches a node to a data group.

Example:

si datagroups detach -name example -node myhost

Mandatory:

name
node

delete

Deletes a data group.

Example:

si datagroups detach -name example

Mandatory:

name

ElastiCube

Commands Description Parameters
list

Displays a list of all ElastiCubes.

Example:

si elasticubes list

 
start

Starts an ElastiCube.

Example:

si elasticubes start -name example

Mandatory:

name

stop

Stops an ElastiCube.

Example:

si elasticubes stop -name example

Mandatory:

name

delete

Deletes an ElastiCube.

Example:

si elasticubes delete -name example

Mandatory:

name

detach

Detaches an ElastiCube.

Example:

si elasticubes detach [-name example] [-delete false]

Mandatory:

name

Optional:

delete

attach

Attaches an ElastiCube.

Example:

si elasticubes attach -path /path/to/cube/files

Optional:

path
title

build

Builds an ElastiCube.

Example:

si elasticubes build -name example -type full -sync true [< ecm_model.json]

Mandatory:

type

Optional:

sync
name

import

Import an ElastiCube.

Example:

si elasticubes import -path \"/opt/sisense/storage/path/to/NameOfCube.ecdata\" -start false

Optional:

path
start

reset

Deletes all ElastiCubes from a database and storage

Example:

si elasticubes reset

 
export

Exports an ElastiCube.

Example:

si elasticubes export -name EC2

This command exports the ElastiCube to /opt/sisense/storage/backups/EC3.sdata

Parameters

  • (Mandatory) name <CubeName>
  • (Optional) file <FileName>

Optional:

name
path
file

console

Starts mclient console for a specific Elasticube.

Example:

si elasticubes console -name xxx -language sql or elasticube console -name xxx -language mal

Optional:

language
name

Deployment

Commands Description Parameters
list

Displays a list of all nodes.

Example:

si deployment list

Optional:

id

add

Adds a node to the system.

Example:

si deployment add -id myhost -hostname myhost -roles BUILD,QUERY

Mandatory:

id
hostname
roles

remove

Removes a node from the system.

Example:

si deployment remove -id myhost

Mandatory:

id

instances

Lists all instances in the deployment.

Example:

si deployment instances

 

version

List all the deployment nodes' versions.

Example:

si deployment version

 

Datasources

Commands Description Parameters
list

Displays a list of all data sources.

Example:

si datasources list

Optional:

id

query

Query JAQL on data source.

Example:

cat myJaql.txt | si datasources query -name myEcube

Mandatory:

name

Optional:

format

sql

Executes an SQL query on data source.

Example:

echo 'select * from MyTable' | si datasources sql -name myEcube

Mandatory:

name

System

Commands Description Parameters
list

Displays versions of your services.

Example:

si system

Backup

Backs up Sisense metadata stored in the Sisense application database, system configuration information, and if you include your farms, Sisense ElastiCube data is backed up. The command below generates an archive of all these files in the following location: /opt/sisense/storage/system_backups/sisense_assets_collector_[date].tar.gz

Note: Files you configured on shared storage, such as automated emails, plugins, language files, branding files and custom connectors are not backed up.

si system backup [-include-farm]

To a log of the back up, enter the following command:

kubectl -n sisense logs sisense-backup-[tab]

 
Restore

Restores Sisense from an archive file created with the Back UP command described above.

si system restore -name [-include-farm] /opt/sisense/storage/system_backups/sisense_assets_collector_[date].tar.gz

 

Configuration

Commands Description Parameters
get

Gets the configuration value.

Example:

si configuration get -key category.entry -type key

Mandatory:

key

Optional:

type

set

Sets a configuration value.

Example:

si configuration set -key category.entry -new-value 1412

Mandatory:

key
new-value

reset

Resets a configuration to the default value if possible.

Example:

si configuration reset -key category.entry, or to reset all configuration of a sepecific category: configuration reset -key category, to change all configurations: configuration reset -key ALL

Optional:

key