Update database directives to point to SnowflakeOpen your agent.xml file in a text editing application. Then, locate the <task> Add 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 have the following privileges granted to your Snowflake user account: - warehouse: usage
- database: usage
- schema: usage, create table
Then, 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 &
- Save the databases.xml file and put the file 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).
|