Update database directives to point to SnowflakeOpen your agent.xml file in a text editing application. Then, locate the <task> directive(s) within your <subscribe> directive, and update the following database-related directives: Directive | Value to enter |
---|
<database_type> | snowflake | <database_server> | URL for your Snowflake database | <database_port> | 1433 | <database_user> | Username used to access your Snowflake database | <database_password> | Password used to access your Snowflake database |
NOTE: If you want to send data to specific warehouses or schemas in Snowflake, you will need to request the databases.xml file for your DataSync Agent by contacting Perspectium Support. Once you've received the databases.xml file, follow these steps: - Open the file in a text-editing application and locate the configurations for <database_type>snowflake</database_type>. Within the parent <database> directive, locate the <database_uri> directive and delete the schema=public& from within this directive's value.
- Locate the <database_uri_database_parms> directive and replace the ? within this directive's value with &
- Open your DataSync Agent agentSave the databases.xml file and put the file from within the conf directory that was created upon installation of your DataSync Agent.
- Still within the DataSync Agent conf directory, locate and then open the agent.xml file in a text-editing application.
- Within the agent.xml file, locate the <database_parms> directive and add the following for this directive's value: warehouse=MY_WAREHOUSE&schema=MY_SCHEMA (where MY_WAREHOUSE is the Snowflake warehouse you want to share data to and MY_SCHEMA is the Snowflake schema you want to share data to).
|