Page History

Versions Compared

Key

This line was added.
This line was removed.
Formatting was changed.

Version

HTML
<style> .version { height: 25px; width: 200px; border-radius: 5px; border: 1px solid #ddd; } </style> <select class="version" id="version" onchange="showContent()"> <option value="6.1.13">6.1.13</option> <option value="6.1.12" selected>6.1.12</option> <option value="6.1.11">6.1.11</option> <option value="6.1.10">6.1.10</option> <option value="6.1.9">6.1.9</option> <option value="6.1.8">6.1.8</option> <option value="6.1.7">6.1.7</option> <option value="6.1.6">6.1.6</option> <option value="6.1.5">6.1.5</option> <option value="6.1.4">6.1.4</option> <option value="6.1.3">6.1.3</option> <option value="6.1.2">6.1.2</option> <option value="6.1.1">6.1.1</option> <option value="6.1.0">6.1.0</option> <option value="6.0.0">6.0.0</option> </select> <script> function showContent() { var dropdown = document.getElementById("version"); var tabs = document.getElementsByClassName("rwui_tab_content"); for (var i = 0; i < tabs.length; i++) { if (tabs[i].getAttribute("data-name") == dropdown.value) { tabs[i].style.display = ""; } else { tabs[i].style.display = "none"; } } } </script>

HTML

<style> 
.version {
	height: 25px;
    width: 200px;
    border-radius: 5px;
    border: 1px solid #ddd;
}
</style>
<select class="version" id="version" onchange="showContent()">                     
	<option value="6.1.13">6.1.13</option>
	<option value="6.1.12" selected>6.1.12</option>
	<option value="6.1.11">6.1.11</option>
    <option value="6.1.10">6.1.10</option>
    <option value="6.1.9">6.1.9</option> 
	<option value="6.1.8">6.1.8</option> 
    <option value="6.1.7">6.1.7</option>
    <option value="6.1.6">6.1.6</option> 
	<option value="6.1.5">6.1.5</option>     
  	<option value="6.1.4">6.1.4</option>    
	<option value="6.1.3">6.1.3</option>     
  	<option value="6.1.2">6.1.2</option>    
	<option value="6.1.1">6.1.1</option>
	<option value="6.1.0">6.1.0</option>
    <option value="6.0.0">6.0.0</option>
</select>
<script> 
function showContent() {
	var dropdown = document.getElementById("version"); 
	var tabs = document.getElementsByClassName("rwui_tab_content");
	for (var i = 0; i < tabs.length; i++) {
		if (tabs[i].getAttribute("data-name") == dropdown.value) {
			tabs[i].style.display = "";
		}
		else {
			tabs[i].style.display = "none";
		}
	}
}
</script>

UI Tab

title	6.1.1213

Release Date: August 15, 2023TBD

Note
If upgrading from a version prior to Helium 6.1.12 and newer , you will require need a new databaseConfig.json. Contact Perspectium Support to get the latest version of this file.

Bug Fixes

Load custom fields added to local schema files with useLocalSchema feature when the meshlet is restarted.

Show If

special	@authenticated

Jira

server	JIRA
columnIds	issuekey,summary,issuetype,created,updated,duedate,assignee,reporter,priority,status,resolution
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	e15725ca-3b2b-32f6-914c-89477a90901d
key	DEV-27194

UI Tab

title	6.1.12

Release Date: August 15, 2023

Note
Helium 6.1.12 and newer will require a new databaseConfig.json. Contact Perspectium Support to get the latest version of this file for more information.

Enhancements

Optimize to use SELECT LIMIT 1 statement as part of querying if table exists in Snowflake database prior to taking action.

Show If

special	@authenticated

Jira

server	JIRA
columnIds	issuekey,summary,issuetype,created,updated,duedate,assignee,reporter,priority,status,resolution
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	e15725ca-3b2b-32f6-914c-89477a90901d
key	DEV-27143

Updated to use CREATE TABLE to prevent overwriting tables that already exists in Snowflake database and handle response if table exists to continue processing records. Added CREATE TABLE to databaseConfig.json configuration file to allow updating of configuration outside of meshlet.

Show If

special	@authenticated

Jira

server	JIRA
columnIds	issuekey,summary,issuetype,created,updated,duedate,assignee,reporter,priority,status,resolution
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	e15725ca-3b2b-32f6-914c-89477a90901d
key	DEV-27143

Bug Fixes
Handle messages with empty or undefined value field without looping.

UI Tab

title	6.1.11

Release Date: April 10, 2023

Enhancements

Add loadSchemasOnStart configuration to create table in Snowflake database from local schemas only when a record for the table is received.

Show If

special	@authenticated

Jira

server	JIRA
columnIds	issuekey,summary,issuetype,created,updated,duedate,assignee,reporter,priority,status,resolution
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	e15725ca-3b2b-32f6-914c-89477a90901d
key	DEV-27016

UI Tab

title	6.1.10

Release Date: January 9, 2023

Enhancements

Support OAuth for accessing ServiceNow instance to get table schema.

Show If

special	@authenticated

Jira

server	JIRA
columnIds	issuekey,summary,issuetype,created,updated,duedate,assignee,reporter,priority,status,resolution
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	e15725ca-3b2b-32f6-914c-89477a90901d
key	DEV-26760

UI Tab

title	6.1.9

Release Date: December 28, 2022

Bug Fixes

Added additional recovery logic if Meshlet's Rabbit listener to MBS queue goes idle.

Show If

special	@authenticated

Jira

server	JIRA
columnIds	issuekey,summary,issuetype,created,updated,duedate,assignee,reporter,priority,status,resolution
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	e15725ca-3b2b-32f6-914c-89477a90901d
key	INC-5614

UI Tab

title	6.1.8

Release Date: November 14, 2022

Enhancements

Meshlets support for Java 18

Show If

special	@authenticated

Jira

server	JIRA
columnIds	issuekey,summary,issuetype,created,updated,duedate,assignee,reporter,priority,status,resolution
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	e15725ca-3b2b-32f6-914c-89477a90901d
key	QA-1209

UI Tab

title	6.1.7

Release Date: October 20, 2022

New Features

Support filtering messages to only read messages from one instance (key)

Show If

special	@authenticated

Jira

server	JIRA
columnIds	issuekey,summary,issuetype,created,updated,duedate,assignee,reporter,priority,status,resolution
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	e15725ca-3b2b-32f6-914c-89477a90901d
key	INC-5599

Support DB views to skip null values for the compound sys_id and order *_sys_id values in alphabetical order.

Show If

special	@authenticated

Jira

server	JIRA
columnIds	issuekey,summary,issuetype,created,updated,duedate,assignee,reporter,priority,status,resolution
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	e15725ca-3b2b-32f6-914c-89477a90901d
key	INC-5600

UI Tab

title	6.1.6

Release Date: September 23, 2022

Bug Fixes

Fix for processing message and improperly pushing to error queue.

Show If

special	@authenticated

Jira

server	JIRA
columnIds	issuekey,summary,issuetype,created,updated,duedate,assignee,reporter,priority,status,resolution
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	e15725ca-3b2b-32f6-914c-89477a90901d
key	DEV-26441

UI Tab

title	6.1.5

Release Date: September 13, 2022

Enhancements

Extend column to max size if content is larger than current size. Requires the extendColumnsMaxLength configuration.

Show If

special	@authenticated

Jira

server	JIRA
columnIds	issuekey,summary,issuetype,created,updated,duedate,assignee,reporter,priority,status,resolution
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	e15725ca-3b2b-32f6-914c-89477a90901d
key	DEV-26829

Log which column is being truncated when insert/update a record into Snowflake and the data is too large for the column. Requires the truncateColumns configuration.

Show If

special	@authenticated

Jira

server	JIRA
columnIds	issuekey,summary,issuetype,created,updated,duedate,assignee,reporter,priority,status,resolution
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	e15725ca-3b2b-32f6-914c-89477a90901d
key	DEV-26854

Bug Fixes

Fix for Numeric value 'true' is not recognized , Numeric value 'false' is not recognized error when translating boolean values for newly adding custom columns using the translateBooleans configuration.

Show If

special	@authenticated

Jira

server	JIRA
columnIds	issuekey,summary,issuetype,created,updated,duedate,assignee,reporter,priority,status,resolution
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	e15725ca-3b2b-32f6-914c-89477a90901d
key	INC-5580

UI Tab

title	6.1.4

Release Date: Jun 10, 2022

Enhancements

Fix to truncate text if its over a column's length and log if record fails being inserted/updated in Snowflake.

Show If

special	@authenticated

Jira

server	JIRA
columnIds	issuekey,summary,issuetype,created,updated,duedate,assignee,reporter,priority,status,resolution
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	e15725ca-3b2b-32f6-914c-89477a90901d
key	INC-5568

UI Tab

title	6.1.3

Release Date: May 12, 2022

Enhancements

Fields such as password can now be encrypted for the meshlet using the meshlet install script.

Show If

special	@authenticated

Jira

server	JIRA
columnIds	issuekey,summary,issuetype,created,updated,duedate,assignee,reporter,priority,status,resolution
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	e15725ca-3b2b-32f6-914c-89477a90901d
key	DEV-26125

UI Tab

title	6.1.2

Release Date: March 24, 2022

Enhancements

Snowflake DataSync meshlet now supports the mapping of Boolean type to Number.

Show If

special	@authenticated

Jira

server	JIRA
columnIds	issuekey,summary,issuetype,created,updated,duedate,assignee,reporter,priority,status,resolution
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	e15725ca-3b2b-32f6-914c-89477a90901d
key	DEV-26050

UI Tab

title	6.1.1

Release Date: October 4, 2021

Bug Fixes

When quotedColumns is configured to false, adding columns in ServiceNow will now get reflected in Snowflake.

Show If

special	@authenticated

Jira

server	JIRA
columnIds	issuekey,summary,issuetype,created,updated,duedate,assignee,reporter,priority,status,resolution
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	e15725ca-3b2b-32f6-914c-89477a90901d
key	DEV-24322

UI Tab

title	6.1.0

Release Date: September 10, 2021

New Features

You can now add custom columns in your Snowflake tables with configuring the databasesConfig.json file. To read more information, see add custom fields.

Show If

special	@authenticated

Jira

server	JIRA
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	e15725ca-3b2b-32f6-914c-89477a90901d
key	DEV-18791

Snowflake meshlet now supports using table compare.

Show If

special	@authenticated

Jira

server	JIRA
columnIds	issuekey,summary,issuetype,created,updated,duedate,assignee,reporter,priority,status,resolution
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	e15725ca-3b2b-32f6-914c-89477a90901d
key	DEV-11106

Snowflake meshlet now supports local schema files.

Show If

special	@authenticated

Jira

server	JIRA
columnIds	issuekey,summary,issuetype,created,updated,duedate,assignee,reporter,priority,status,resolution
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	e15725ca-3b2b-32f6-914c-89477a90901d
key	DEV-20325

Snowflake meshlet now supports using Microsoft Azure as an external stage for bulk loading.

Show If

special	@authenticated

Jira

server	JIRA
columnIds	issuekey,summary,issuetype,created,updated,duedate,assignee,reporter,priority,status,resolution
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	e15725ca-3b2b-32f6-914c-89477a90901d
key	DEV-20750

Snowflake meshlet supports soft deletes (updating fields to indicate the record is deleted and leaving the record intact in the database table).

Show If

special	@authenticated

Jira

server	JIRA
columnIds	issuekey,summary,issuetype,created,updated,duedate,assignee,reporter,priority,status,resolution
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	e15725ca-3b2b-32f6-914c-89477a90901d
key	DEV-21515

Enhancements

Meshlets now support reading multibyte_encrypted messages.

Show If

special	@authenticated

Jira

server	JIRA
columnIds	issuekey,summary,issuetype,created,updated,duedate,assignee,reporter,priority,status,resolution
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	e15725ca-3b2b-32f6-914c-89477a90901d
key	DEV-20616

Snowflake meshlet recovers by recreating the table when the table is dropped while the Meshlet is running and processing messages.

Show If

special	@authenticated

Jira

server	JIRA
columnIds	issuekey,summary,issuetype,created,updated,duedate,assignee,reporter,priority,status,resolution
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	e15725ca-3b2b-32f6-914c-89477a90901d
key	DEV-20726

UI Tab

title	6.0.0

Release Date: TBD

Enhancements

Specifying the maximum string size for the entire collection is available through maxStringSize key. See Meshlet Configurations for Snowflake.

Show If

special	@authenticated

Jira

server	JIRA
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	e15725ca-3b2b-32f6-914c-89477a90901d
key	DEV-14043

Adding parameters to your connectionUrl to leverage other forms of authentication is available through useConnectionProperties key. See Meshlet Configurations for Snowflake.

Show If

special	@authenticated

Jira

server	JIRA
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	e15725ca-3b2b-32f6-914c-89477a90901d
key	DEV-16804

HTML

<script>
	var tabs = document.getElementsByClassName("rwui_tab_content");
	for (var i = 0; i < tabs.length; i++) {
		if (tabs[i].getAttribute("data-name") == "6.1.12") {
			tabs[i].style.display = "";
		}
		else {
			tabs[i].style.display = "none";
		}
	}
</script>

Content

Space Tools

Versions Compared

Old Version 52

New Version 53

Key