Create a ServiceNow bulk/dynamic share for Snowflake
To enable the sharing of ITSM data from your ServiceNow instance to your Snowflake instance, you will need to create a ServiceNow bulk share and/or dynamic share. A ServiceNow bulk share is a one-time transfer of data from your ServiceNow instance. A ServiceNow dynamic share allows for real time sharing of ServiceNow records as they are created, updated, and deleted. Creating a bulk share and/or dynamic share will share out your ServiceNow data immediately as well as share out subsequent data that is collected as ServiceNow records are created, updated, and deleted.
Prerequisites
You will first need to install the Perspectium Core update set. You can request a download link for this update set by contacting Perspectium Support.
You will also need to have a ServiceNow shared queue that points to your Snowflake instance. This queue should have been created by Perspectium Support upon initial configuration of your ServiceNow instance.
Procedure
To create a bulk share, follow these steps:
UI Steps |
---|
|
UI Step |
---|
Go to your ServiceNow instance. Then, navigate to Perspectium > DataSync > Bulk Share or simply type Bulk Share in the Filter Navigator on the upper left-hand side of the screen. |
UI Step |
---|
Click the New button next to Bulk Shares. In the resulting form's Cipher dropdown, select an encryption type to be used. Then, follow the remaining steps to create a ServiceNow bulk share for DataSync for ServiceNow (DataSync). |
|
To create a dynamic share, follow these steps:
UI Steps |
---|
|
UI Step |
---|
Go to your ServiceNow instance. Then, navigate to Perspectium > DataSync > Dynamic Share or simply type Dynamic Share in the Filter Navigator on the upper left-hand side of the screen. |
|
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.
UI Steps |
---|
|
UI Step |
---|
Unzip the folder that was created from the previous step. Then, put the folder in the static/config directoryClick the New button next to Bulk Shares. In the resulting form's Cipher dropdown, select an encryption type to be used. Then, follow the remaining steps to create a ServiceNow dynamic share for DataSync for ServiceNow (DataSync). |
|
↑ Go to top of page