Skip to main content

Snowflake Username and Password

Basic Auth is the fastest way to connect your target database platform to Coalesce, and the credential can be stored either in your local browser's storage (not recommended) or in Coalesce's cloud secrets vault.

  1. Select the Project you want to create the Workspace in.

  2. Click Create Workspace.

  3. Give your Workspace a Name and Description(optional).

    Step 1 of 5 workspace creation interface for Coalesce, showing fields for workspace name and description, with explanation that workspaces allow development of data transformations without impacting team members
  4. Enter your Snowflake Account URL.

    Snowflake connection setup page showing URL input field with https:// prefix and .snowflakecomputing.com suffix, OAuth toggle currently disabled, and Previous/Next navigation buttons. Link provided for finding Snowflake Account URL.
    1. Obtain your Snowflake URL, by opening the account selector in Snowflake.

      Add your Snowflake credentials in the build settings
  5. Add your username and password. If authentication fails the first time, add in your Role and Warehouse then try again.

    Snowflake credentials input form with fields for authentication type (set to Username and Password Cloud), username, password, optional role and warehouse settings, and a test connection button. Form includes explanation that credentials remain private to workspace.
  6. Workspaces let you work on a branch. You will need to select a branch and commit to make a new branch. For example, if you want to create a branch off main, select main, then select the commit in main to create your branch from.

  7. Next, add Storage Locations and Storage Mappings to your Workspace. If you have any existing Storage Locations and Storage Mappings from Git, they will be listed here.

    Storage Locations and Mappings configuration interface showing two locations (WORK and EDW), with EDW expanded to display database mapping to EDW_APAC and schema mapping to DEV_EDW. Interface includes toggle for manual mapping and option to set WORK as default storage location.
  8. Click Create Workspace. You've just created your Workspace. Get started by adding some data.