Skip to main content

Steps involved in creating Snowflake profile connection

You are viewing archived Admin Console - Profiles documentation for Data Trust v2024.06 (previous version).
Go to the latest v7.6 documentation →

Steps involved in creating SNOW FLAKE profile connection

  • Click the ‘ADMIN CONSOLE’ tab.
  • Hover on the Profiles snippet from the left pane options.
  • Click the ‘Profiles’ option.

Path: ADMIN CONSOLE > Profiles

  • A ‘Profiles’ session page is displayed.
  • Click the plus ‘(+) Profile’ button.

  • A ‘Create Profile’ session page is displayed with two text fields such as ‘Profile Name’ and ‘Source Name.’

Path: ADMIN CONSOLE > Profiles > (+) Profile

  • Let’s suppose add ‘Snowflake profile’ text under the ‘Profile Name’ text field.
  • Select ‘SNOW FLAKE’ from ‘Source Name’ drop-down selection.

Note: Once the user selects the ‘Source Name’ drop-down selection, the ‘Type Of Connection, ‘Connection Parameters’(selected as default), and ‘Additional Settings’ options are enabled.

Note: By default, ‘Non JDBC’ is selected for the ‘Type Of Connection’. Users can also select ‘JDBC.’

  • Under the ‘Connection Parameters’ tab, the user is required to fill the required text field options such as the Schema, host, port, User, Password, account, db, schema, role, and warehouse.

  • Let’s suppose, fill in all the required details and click the ‘Additional Settings’ tab.

  • Under ‘Additional Settings tab, Default Parallelism, Max Parallelism, Default Packet Size, Max Packet Size, and User Groups text fields are displayed.

Note: By default, Default Parallelism, Max Parallelism, Default Packet Size, and Max Packet Size text fields are set to 1, 20, 5000, and 1000000.

Note: An info button is available for each text field which displays information when hovered.

  • Fill in the ‘User Groups’ text field to make this new profile visible to any User Group/User Groups.
  • Click the ‘Connection Parameters’ tab again.

  • Now, click the ‘Test Connection’ button.

Note: An info button is available for each text field which displays information when hovered.

  • A message ‘Test Connection Successful!’ is displayed if the ‘Connection Parameters’ related to that particular profile are correct.

  • Click the ‘Save’ button to save this profile.

  • The user is navigated to the ‘Profiles’ session page displaying the created profile details.

Was this article helpful?