Skip to main content
Version: 0.0.36

Snowflake

Integrating Snowflake with Lakehousecat enables seamless interaction with your Snowflake environment for efficient data management and analytics. This guide will walk you through the steps required to set up a Snowflake connection within the Lakehousecat workspace.

Prerequisites​

Ensure you have the following before starting the integration process:

  • Access to Lakehousecat as an admin or builder
  • An existing Snowflake account with connection credentials

Step-by-Step Guide​

  1. Start in the Workspace

    • Navigate to your Lakehousecat workspace where you manage data connections.

  2. Go to the Data Section

    • Click on the 'Data' menu to explore various data-related options within Lakehousecat.

  3. Select "Datasource Types"

    • To view available data sources, select the "Datasource Types" option.

  4. Choose "Snowflake Datasource Type"

    • Click on the "Snowflake Datasource Type" to initiate the configuration process.

Step 3: Configure the Snowflake Connection​

  • Connection Name: Enter a clear and descriptive name for your connection. This name will help in identifying the connection throughout Lakehousecat.
  • Snowflake Connection-Uri: Input the Snowflake connection URI in the correct format. Ensure this URI is complete and accurate to facilitate a successful connection.
  • Description (Optional): Provide an optional description to help other administrators understand the purpose or scope of this connection.

Step 4: Validate and Create the Connection​

  1. After entering the required information, click on the Create button.
  2. Lakehousecat will initiate validation of the connection parameters. Ensure that all details are correct to avoid validation errors.
  3. Once the validation is successful, your Snowflake connection will be established and ready for use.

Best Practices​

  • Naming Conventions: Use a consistent naming convention for connection names to enhance recognition and manageability.
  • Description Usage: Utilize the description field to provide insights into the connection's intended use, especially when multiple connections exist.

Troubleshooting​

If you encounter issues during the connection setup:

  • Validation Errors: Double-check the Snowflake Connection-Uri for correctness.
  • Access Issues: Ensure you have the necessary permissions within both Lakehousecat and Snowflake.