Snowflake initial setup

You need to establish proper network connectivity between your Striim environment and Snowflake. This involves configuring network access, firewall rules, and connection parameters to ensure reliable communication.

Configure security groups to allow access to Snowflake from your Striim instance.

Also consider network latency and bandwidth requirements, especially for high-volume CDC scenarios. For optimal performance, minimize the network latency between Striim and Snowflake.

Connections between Snowflake and Striim use TLS, by default 1.2. No additional configuration is required.

Security configuration for Snowflake integration involves multiple layers, including authentication, authorization, network security, and data protection measures.

You must implement proper authentication mechanisms between Striim and Snowflake. This includes creating dedicated database users with minimal required privileges following the principle of least privilege. You should avoid using administrative accounts and instead create specific users for Striim operations with only the necessary permissions for the tables and operations required. We recommend not using password authentication.

Connections between Snowflake and Striim use TLS, by default 1.2. No additional configuration is required.

You should implement access control at multiple levels, including database-level permissions, schema-level access controls, and table-level privileges. You should regularly review and audit the permissions granted to Striim users and implement proper password policies and rotation procedures for service accounts.