Release Date: TBD Enhancements |
---|
Support deletes with Snowflake. Show If |
---|
| 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-27257 |
---|
|
|
| Support altering tables to add columns and increase column length for Snowflake. Show If |
---|
| 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 |
---|
maximumIssues | 20 |
---|
jqlQuery | key = DEV-27258 or key = DEV-27259 |
---|
serverId | e15725ca-3b2b-32f6-914c-89477a90901d |
---|
|
|
| Add Snowflake as selectable option into Agent Installer along with Snowflake configuration options for Role, Warehouse, Schema and Files Directory. Database, Role, Warehouse and Schema will allow be saved as uppercase from the Installer into the agent.xml configuration file. Show If |
---|
| 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-27260 |
---|
|
|
| Automatically create Java Additional Parameters Snowflake configuration options when using Agent Installer to install Agent with Snowflake as target database. Show If |
---|
| 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-27260 |
---|
|
|
| Check for valid values for Snowflake configuration options for files_directory, file_max_size, flush_interval and delete_files_interval, using default values if invalid values specified. Show If |
---|
| 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-27261 |
---|
|
|
| Send errors back to ServiceNow when we have validation errors testing records before using the COPY API to push to Snowflake database. Show If |
---|
| 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-27261 |
---|
|
|
| Add support for Table Compare, changing default flush_interval to 3 minutes so compare messages can be read properly. NOTE: You will need to update databases.xml to work with Table Compare. See Set up DataSync Agent to share to Snowflake for more information and contact Perspectium Support with any questions.
Show If |
---|
| 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-27262 |
---|
|
|
| Add support for IO Datetime plugin. NOTE: For deletes with the IODatetime plugin, the column specified as the update_column will also be updated with the datetime when the delete action happens due to how Snowflake updates records using the COPY API,
Show If |
---|
| 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-27257 |
---|
|
|
|
Bug Fixes |
---|
Fixed to save encoded sys_id when sharing ServiceNow database view to Snowflake so records can be queried for updating and deleting. Show If |
---|
| 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-27257 |
---|
|
|
|
|