Before you create a catalog source, ensure that you have the information required to connect to the source system.
Perform the following tasks:
•Assign the required permissions.
• To scan procedures and functions, set the following roles depending on permissions:
- With administrator permission. In the JDBC connect string, use: role=<procedure owner> orrole=SYSADMIN
Only the SYSADMIN can scan procedures or functions defined with the EXECUTE AS OWNER statement.
- Without administrator permission. Set the USAGE privileges for all procedures and functions. Create procedures with the EXECUTE AS CALLER statement.
•Configure a connection to the Snowflake source system in Administrator.
•Optionally, if you want to identify pairs of similar columns and relationships between tables within a catalog source, import a relationship inference model.