Add directive(s) for SnowflakeOpen your agent.xml file in a text editing application. Then, locate the <task> directive(s) within your <subscribe> directive, and nest the following directive: Directive | Description |
---|
<ensure_table_exists/> | Self-closing tag that runs a check to ensure the Snowflake database table exists |
NOTE: If using a DataSync for ServiceNow Agent, it is also recommended to nest the <use_cache/> directive within each <task> directive for <subscribe>. Your agent.xml file should look similar to the example shown below. Code Block |
---|
| <?xml version="1.0" encoding="ISO-8859-1" standalone="no"?>
<config>
<agent>
<share/>
<subscribe>
<task instances="4">
<task_name>OnDemandAgent_subscribe</task_name>
<message_connection password="encrypted:vlOtU71yu8N/EFIJH85SSPbQ5/gZDZBSjYcHe6gjfJI=" queue="psp.out.replicator.snowflakeexample" use_basic_consume="true" user="exampleuser">https://exampleperspectium.net</message_connection>
<instance_connection password="examplepassword" user="example.user">https://myinstance.service-now.com</instance_connection>
<handler>com.perspectium.replicator.sql.SQLSubscriber</handler>
<decryption_key>The cow jumped over the moon</decryption_key>
<database_type>snowflake</database_type>
<database_server>example.snowflakecomputing.com</database_server>
<database_user>exampleuser</database_user>
<database_password>examplepassword</database_password>
<database_params/>
<database>psp_repl</database>
<use_cache/>
<ensure_table_exists/>
</task>
</subscribe>
<max_reads_per_connect>4000</max_reads_per_connect>
<polling_interval>5</polling_interval>
<skip_message_set_processing/>
</agent>
</config> |
|