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 multiple 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 agent.xml file from within the conf directory that was created upon installation of your Agent. 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.
|