Skip to main content

Snowflake warehouse configuration

Configure your Snowflake warehouses following these best practices to achieve optimal performance and reliability for Atlan data workflows. These recommendations establish predictable resource allocation and maximize workflow efficiency.

Configure warehouse allocation

  • Use a dedicated warehouse for Atlan workflows: Assign a dedicated warehouse exclusively for Atlan operations. This approach separates warehouse performance from other workloads, enables precise cost tracking for Atlan operations, and provides consistent workflow performance.

  • One warehouse per connection: Provision one Snowflake warehouse for each Atlan connection to maintain scoped capacity and predictable resource allocation.

Configure statement timeout

  • Set appropriate timeout values: If your account enforces timeouts, configure both STATEMENT_TIMEOUT_IN_SECONDS and STATEMENT_QUEUED_TIMEOUT_IN_SECONDS to at least 6 hours (21,600 seconds) for the Atlan user to accommodate comprehensive data cataloging workflows.

  • Default values work well: By default, both parameters are set to 0 (no limit), which is optimal for Atlan operations. Only adjust if your organization requires specific timeout enforcement.

  • Apply at user level: Configure timeouts at the user level for consistent behavior across all Atlan sessions rather than at warehouse or session level.