You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 15 Next »


DataSync for Snowflake is a single-direction (ServiceNow to Snowflake) integration that Bulk Shares and Dynamic shares to synchronize data for the collection of ServiceNow data into a Snowflake data warehouse.

NOTE:

  • If you will be setting up the DataSync Agent to also connect to the same database, you will want to configure the Agent to use the same column cases. By default, the Snowflake Bulk Load Meshlet uses lowercase for the column names. Also, the QUOTED_IDENTIFIERS_IGNORE_CASE setting in Snowflake should be kept with its default value of false.
  • The meshlet uses the TIMEZONE session parameter to connect to Snowflake in order to save all timestamps in UTC . By default, glide_date_time field is mapped to the TIMESTAMP_LTZ(9) column type. This allows you to query using a local timezone as needed. 


Prerequisites


(warning) The provided user must have the role of SYSADMIN or a custom role of equivalent privileges in order to create objects (tables) and write records.

See Snowflake's list of default roles here.

Related to the meshlet's minimum database user requirements, the following Snowflake access control privileges are needed by the meshlet:



Procedure

To set up a DataSync for Snowflake integration, follow these steps:


Create database in Snowflake 

In the Databases page in Snowflake, click Create... to create a new database. Then, fill in the Name field and click Finish. 

No valid Data Center license found

Please go to Atlassian Marketplace to purchase or evaluate Refined Toolkit for Confluence Data Center.
Please read this document to get more information about the newly released Data Center version.