--- title: "Snowflake" slug: "snowflake-overview-replicate-cloud" updated: 2026-10-06T11:34:35Z published: 2026-10-06T11:34:35Z canonical: "skthelp.syniti.com/snowflake-overview-replicate-cloud" stale: true --- > ## Documentation Index > Fetch the complete documentation index at: https://skthelp.syniti.com/llms.txt > Use this file to discover all available pages before exploring further. # Snowflake ## Overview Replicate Preview enables streamlined data replication to and from **Snowflake**, supporting both source and target configurations. Users can rapidly define replication pipelines by selecting source datasets and configuring target destinations, enabling scalable and reliable data movement across cloud-based analytics environments. The platform simplifies pipeline deployment and management while reducing operational complexity for enterprise data workloads. > [!NOTE] > Note > > Snowflake is currently supported as both a **source and target endpoint** in Replicate Preview, limited to **Snapshot (full load) replication mode**, with Change Data Capture (CDC) and streaming replication not yet supported. ## User Permissions When you establish a connection from the Syniti Knowledge Platform (SKP) to Snowflake, it uses the default SYSADMIN user role on Snowflake. However, if your corporate security policy dictates that third-part applications should not have SYSADMIN privileges, it is possible to create a custom role with fewer privileges and use that instead. ```plaintext -Create a Role- use role public; create role replicationrole; -Create a User- create user password = '[your-password]' default_role = replicationrole must_change_password = false; -Set permissions for this role- grant all privileges on future tables in database [database-name] to role replicationrole; grant select, insert, update, delete, truncate on future tables in database [database-name] to role replicationrole; grant usage, modify, create table on all schemas in database [database-name] to role replicationrole; -Grant Role to the Replicate Preview user- grant role replicationrole to user ; ``` ## **Connection Considerations** If you do not have a datastore connection configured, refer to [Create a Connection](/v1/docs/create-a-connection) and [Connecting to Snowflake](/v1/docs/connecting-to-snowflake) for step-by-step instructions. When configuring and using a connection to **Snowflake**, consider the following: | Configuration | Details | | --- | --- | | Authentication Method | Snowflake connections support both Password and KeyPair authentication methods. Ensure that the selected authentication mechanism is properly configured and aligned with your organization's security policies. | | KeyPair Authentication Configuration | When using KeyPair (Private Key) authentication, the Snowflake user must be configured with an RSA public key, and the corresponding private key must be securely stored and accessible to the replication service. | | Connection Parameters | Ensure that all required connection properties are correctly defined, including: - Snowflake account identifier - Warehouse - Database - Schema - Username - Authentication credentials Incorrect connection parameters are a common cause of failed connections. | | Warehouse Availability | Verify that the configured Snowflake warehouse is available and has sufficient resources to support replication workloads. Suspended or undersized warehouses may cause replication delays or failures. | | Network and Security Configuration | Ensure that network policies, IP allowlists, private connectivity settings, or firewall rules do not block access between the Replicate Preview service and the Snowflake environment. | | SSL/TLS Connectivity | Snowflake connections use secure HTTPS/TLS communication. Ensure that your environment supports modern TLS protocols and that SSL inspection policies do not interfere with the connection. | | Retry and Failure Handling | Optional connection settings such as retry behavior and timeout configuration can impact replication reliability. Disabling retries may cause transient failures to terminate replication operations immediately. | | Object Naming and Case Sensitivity | Snowflake stores unquoted object names in uppercase by default. If databases, schemas, or tables were created using quoted identifiers with mixed or lowercase names, exact casing must be used to avoid object resolution issues. | | Large Dataset Considerations | For large Snapshot replications, consider warehouse sizing, staging performance, and network throughput to optimize load times and minimize execution delays. | ## Next Steps In Replicate Preview, configure your workspace using this system datastore and start replicating data. Refer to [Configure Workspace: Datastores](/v1/docs/configure-workspace-datastores) for more information. ## Related Articles - [Create a Connection](/v1/docs/create-a-connection) - [Configure Workspace: Datastores](/v1/docs/configure-workspace-datastores) - [Connecting to Snowflake](/v1/docs/connecting-to-snowflake)