GET_LICENSE_INFO

GET_LICENSE_INFO displays information related to data size limitations, expiration date, and type of license currently used by the SQream cluster.

Permissions

No special permissions are required.

Syntax

The following is the correct syntax for running the GET LICENSE INFO statement:

get_license_info_statement ::=
 SELECT GET_LICENSE_INFO()
 ;

Returns

The following table shows the GET_LICENSE_INFO license information in the order that it is returned:

Parameter

Description

Example

compressed_cluster_size

Shows the compressed size (GB) of the cluster.

10

uncompressed_cluster_size

Shows the uncompressed size (GB) of the cluster.

10

compress_type

Shows the compression type (compressed, uncompressed).

compressed

cluster_size_limit

Shows the cluster size limit (GB) of the current license.

20

expiration_date

Shows the expiration date of the current license.

2024-03-18

is_date_expired

Shows whether the date has expired or not (0 - No, 1 - Yes).

0

is_size_exceeded

Shows whether the cluster size has exceeded the license size limit or not (0 - No, 1 - Yes).

0

cluster_size_left

Shows the remaining available cluster size (GB) in the license.

10

Example

The following is an example of the returned license information described in the Returns section above:

compressed_cluster_size | uncompressed_cluster_size | compress_type | cluster_size_limit | expiration_date | is_date_expired | is_size_exceeded | cluster_size_left
------------------------+---------------------------+---------------+--------------------+-----------------+-----------------+------------------+------------------
10                      | 100                       | compressed    | 20                 | 2045-03-18      | 0               | 0                | 10