Snowflake can be used as Target Server (subject to Licencing)
Note that currently Precision Bridge can only insert records into tables that have a primary key field named UID. The Precision Bridge Archiving Wizard can be used to generate target tables.
Snowflake can also be used as an external lookup server or reporting target (see related links below)
To use Snowflake as the Target Server, select Snowflake DB from the Target Server Type dropdown.
Pre-requisites:
- Snowflake JDBC Driver; First check that you have setup the path to the corresponding JDBC driver. See Configuring Access to a Snowflake Database for more details.
The connection details will be displayed and must be completed as follows:
Data Source: The name, or IP Address, of the Snowflake Server
Database: The name of the database you want to connect to
Port: The Listening Port configured for Snowflake on the server. The default is 443
User Name: The database user you will be connecting with. This user should have the required read/write privileges to the tables you will be working with. To be able to use Precision Bridge to generate tables for archiving, the user will also need CREATE privileges on the schema/database.
Password: The password for the above user
Schema:
Warehouse:
If you want to retain the login details for each instance, select the Save Authentication option. After selecting this option, the username and password are stored and do not need to be entered again the next time you open the same project from the same client machine. Otherwise you will need to re-enter them each time you open the project.
In order to check that the relevant servers can be accessed using the credentials provided, click on the Test button on the right for each connection.
If the selected server is reachable then a confirmation message will be displayed. If the server is not reachable then a failure/timeout message will be displayed.
Related Articles:
Configuring Access to a Snowflake Database
The Precision Bridge Archiving Wizard
Configuring an External Lookup Server Connection
Writing Migration Reports to Database Tables
Comments
0 comments
Please sign in to leave a comment.