Compare tables from ServiceNow to Snowflake 

Table Compare allows you to compare tables from one ServiceNow instance to Snowflake. This is useful because you can see each table's record count, as well as a list of record discrepancies by sys_id between the two tables you're comparing—in other words, you can see which records exist in one table but not the other. To get started with comparing your ServiceNow tables to Snowflake, see Table Compare: ServiceNow to database table compare.  

 NOTE: This requires version Helium and above Perspectium Core update set. 

↑ Go to top of page

Load Schema Files 

This feature allows you to load your ServiceNow table schemas to the meshlet when a connection cannot be made to the originating ServiceNow instance.  Schema files are used to create and update tables in Snowflake. Enabling this feature will force the meshlet to read schemas via files exclusively from the local file storage and disable all calls to ServiceNow. Any new tables shared will require table schemas to be added to the local file storage.

perspectium:  
	auth:    
		useLocalSchema: true

↑ Go to top of page

Azure External Storage

To start using Microsoft Azure as an external stage for bulk loading, follow these steps:

perspectium:  
	azure:    
		url: azure://pspsnowflaketest.blob.core.windows.net/snowflakedev

perspectium:  
	azure:    
  		sasString: ?sv=2020-08-04&ss…..ejl%2BTE%3D

perspectium:  
	azure:    
    	connectionUrl: DefaultEndpointsProtocol=.....EndpointSuffix=core.windows.net

perspectium:  
	azure:    
		destinationContainer: snowflakedev

perspectium:  
	fileSubscriber:    
 		deleteFiles: true

↑ Go to top of page

Soft Deletes

This feature allows you to add a column or columns, either boolean and/or a date time field, that gets updated when a delete record is processed. The field will update said columns appropriately and will not delete the record in Snowflake. At least 1 of the following table columns are required to achieve softDeletes, if neither column has been added to the configurations, no delete will occur. This is to prevent deletion of records when there is an intention of using soft deletes.

perspectium:    
	snowflake:       
		softDelete: true

"delete": {
 	"columnName":"is_delete"
 }

"IODateTime": {
	"insert":["psp_per_insert_dt"],
	"update":["psp_per_update_dt"],
	"delete" :["psp_per_delete_dt"]
}

↑ Go to top of page