How can I setup real time replication between SQL Server DB and a Snowflake DB?

One method is to use a streaming platform like Apache Kafka for this purpose

Apache Kafka includes Debezium connector for SQLServer which can be used to connect to a source instance of SQLServer. Similarly Snowflake has a sink connector available for Kafka which can be used to create/populate a snowflake table based on the topic data. The data synchronization takes place close to real time by utilizing topic messages which gets emitted based on changes happening at SQLServer table.