Snowflake connection fails with error Could not obtain connection from data source

SYMPTOM

Message               : Could not obtain connection from data source
Element               : kpi_snowflake_pocFlow/processors/0 @ kpi-snowflake-poc-dev:kpi_snowflake_poc.xml:21 (Select)
Element DSL           : <snowflake:select doc:name="Select" doc:id="dd5921a7-0984-4499-a420-88477fe8c6d4" config-ref="Snowflake_Config">
<snowflake:sql><![CDATA[
SELECT GRPNUM, MAX(Payers) AS GrpPayers, MAX(ELIGIBLES) AS GrpEligibles
FROM LAB_ACT_EXTERNAL_SHARE.GROUP_ANALYTICS.ACTUARIAL_INFORCE
WHERE VALUATION = :vDate
GROUP BY 1
]]></snowflake:sql>
<snowflake:input-parameters><![CDATA[
#[{vDate : attributes.queryParams.valuationdate}]
]]></snowflake:input-parameters>
</snowflake:select>
Error type            : SNOWFLAKE:CONNECTIVITY
FlowStack             : at kpi_snowflake_pocFlow(kpi_snowflake_pocFlow/processors/0 @ kpi-snowflake-poc-dev:kpi_snowflake_poc.xml:21 (Select))
Payload Type          : org.mule.runtime.core.internal.streaming.bytes.ManagedCursorStreamProvider
--------------------------------------------------------------------------------
Root Exception stack trace:
java.sql.SQLException: Cannot get connection for URL jdbc:snowflake://<jdbcurl>&application=mulesoft-snowflake-connector : IP <ip address> is not allowed to access Snowflake.  Contact your local security administrator.
	at com.mulesoft.connector.snowflake.internal.connection.SnowflakeJdbcConnectionFactory.createConnection(SnowflakeJdbcConnectionFactory.java:31)
	at com.mulesoft.connector.snowflake.internal.connection.provider.SnowflakeConnectionProvider.connect(SnowflakeConnectionProvider.java:104)
	at com.mulesoft.connector.snowflake.internal.connection.provider.SnowflakeConnectionProvider.connect(SnowflakeConnectionProvider.java:61)
	at org.mule.runtime.module.extension.internal.runtime.config.ClassLoaderConnectionProviderWrapper.connect(ClassLoaderConnectionProviderWrapper.java:60)
	at org.mule.runtime.core.internal.connection.ConnectionUtils.connect(ConnectionUtils.java:52)
	at org.mule.runtime.core.internal.connection.AbstractConnectionProviderWrapper.connect(AbstractConnectionProviderWrapper.java:63)
	at org.mule.runtime.core.internal.connection.ErrorTypeHandlerConnectionProviderWrapper.connect(ErrorTypeHandlerConnectionProviderWrapper.java:64)
	at org.mule.runtime.core.internal.connection.ConfigNameResolverConnectionProviderWrapper.connect(ConfigNameResolverConnectionProviderWrapper.java:50)
	at org.mule.runtime.core.internal.connection.ConnectionUtils.connect(ConnectionUtils.java:52)
	at org.mule.runtime.core.internal.connection.AbstractConnectionProviderWrapper.connect(AbstractConnectionProviderWrapper.java:63)
	at org.mule.runtime.core.internal.connection.DefaultConnectionProviderWrapper.connect(DefaultConnectionProviderWrapper.java:52)
	at org.mule.runtime.core.internal.connection.NullConnectionManagementStrategy.getConnectionHandler(NullConnectionManagementStrategy.java:40)
	at org.mule.runtime.core.internal.connection.DefaultConnectionManager.getConnection(DefaultConnectionManager.java:247)
	at org.mule.runtime.core.internal.connection.DelegateConnectionManagerAdapter$EagerConnectionManagerAdapter.getConnection(DelegateConnectionManagerAdapter.java:160)
	at org.mule.runtime.core.internal.connection.DelegateConnectionManagerAdapter.getConnection(DelegateConnectionManagerAdapter.java:82)
	at org.mule.runtime.module.extension.internal.runtime.connectivity.ExtensionConnectionSupplier.getTransactionlessConnectionHandler(ExtensionConnectionSupplier.java:112)
	at org.mule.runtime.module.extension.internal.runtime.connectivity.ExtensionConnectionSupplier.getTransactedConnectionHandler(ExtensionConnectionSupplier.java:72)
	at org.mule.runtime.module.extension.internal.runtime.connectivity.ExtensionConnectionSupplier.getConnection(ExtensionConnectionSupplier.java:62)
	at org.mule.runtime.module.extension.internal.runtime.streaming.PagingProviderProducer$StickyConnectionSupplierFactory$1.getChecked(PagingProviderProducer.java:268)
	at org.mule.runtime.module.extension.internal.runtime.streaming.PagingProviderProducer$StickyConnectionSupplierFactory$1.getChecked(PagingProviderProducer.java:264)
	at org.mule.runtime.core.api.util.func.CheckedSupplier.get(CheckedSupplier.java:25)
	at org.mule.runtime.api.util.LazyValue.get(LazyValue.java:75)
	at org.mule.runtime.module.extension.internal.runtime.streaming.PagingProviderProducer$StickyConnectionSupplierFactory.getConnectionSupplier(PagingProviderProducer.java:275)
	at org.mule.runtime.module.extension.internal.runtime.streaming.PagingProviderProducer.getConnectionSupplier(PagingProviderProducer.java:224)
	at org.mule.runtime.module.extension.internal.runtime.streaming.PagingProviderProducer.withConnection(PagingProviderProducer.java:154)
	at org.mule.runtime.module.extension.internal.runtime.streaming.PagingProviderProducer.withConnection(PagingProviderProducer.java:150)
	at org.mule.runtime.module.extension.internal.runtime.streaming.PagingProviderProducer.performWithConnection(PagingProviderProducer.java:141)
	at org.mule.runtime.module.extension.internal.runtime.streaming.PagingProviderProducer.produce(PagingProviderProducer.java:100)
	at org.mule.runtime.module.extension.internal.runtime.streaming.PagingProviderProducer.produce(PagingProviderProducer.java:54)
	at org.mule.runtime.core.api.streaming.iterator.ListConsumer.loadNextPage(ListConsumer.java:81)
	at org.mule.runtime.module.extension.internal.runtime.operation.OperationMessageProcessorBuilder.lambda$transformPagingDelegate$0(OperationMessageProcessorBuilder.java:93)
	at org.mule.runtime.core.api.util.func.CheckedBiFunction.apply(CheckedBiFunction.java:19)
	at org.mule.runtime.module.extension.internal.runtime.operation.DefaultExecutionMediator$TransformingExecutionCallbackDecorator.complete(DefaultExecutionMediator.java:333)
	at org.mule.runtime.module.extension.internal.runtime.execution.CompletableMethodOperationExecutor.doExecute(CompletableMethodOperationExecutor.java:26)
	at org.mule.runtime.module.extension.internal.runtime.execution.AbstractCompletableMethodOperationExecutor.execute(AbstractCompletableMethodOperationExecutor.java:61)
	at org.mule.runtime.module.extension.internal.runtime.operation.DefaultExecutionMediator.executeCommand(DefaultExecutionMediator.java:233)
	at org.mule.runtime.module.extension.internal.runtime.operation.DefaultExecutionMediator.executeWithInterceptors(DefaultExecutionMediator.java:217)
	at org.mule.runtime.module.extension.internal.runtime.operation.DefaultExecutionMediator.lambda$execute$1(DefaultExecutionMediator.java:136)
	at org.mule.runtime.core.internal.execution.ExecuteCallbackInterceptor.execute(ExecuteCallbackInterceptor.java:15)
	at org.mule.runtime.core.internal.execution.BeginAndResolveTransactionInterceptor.execute(BeginAndResolveTransactionInterceptor.java:76)
	at org.mule.runtime.core.internal.execution.SuspendXaTransactionInterceptor.execute(SuspendXaTransactionInterceptor.java:46)
	at org.mule.runtime.core.internal.execution.ValidateTransactionalStateInterceptor.execute(ValidateTransactionalStateInterceptor.java:43)
	at org.mule.runtime.core.internal.execution.IsolateCurrentTransactionInterceptor.execute(IsolateCurrentTransactionInterceptor.java:37)
	at org.mule.runtime.core.api.execution.TransactionalExecutionTemplate.execute(TransactionalExecutionTemplate.java:139)
	at org.mule.runtime.module.extension.internal.runtime.operation.DefaultExecutionMediator.withExecutionTemplate(DefaultExecutionMediator.java:309)
	at org.mule.runtime.module.extension.internal.runtime.operation.DefaultExecutionMediator.execute(DefaultExecutionMediator.java:135)
	at org.mule.runtime.module.extension.internal.runtime.operation.ComponentMessageProcessor.executeOperation(ComponentMessageProcessor.java:570)
	at org.mule.runtime.module.extension.internal.runtime.operation.ComponentMessageProcessor.prepareAndExecuteOperation(ComponentMessageProcessor.java:795)
	at org.mule.runtime.module.extension.internal.runtime.operation.ComponentMessageProcessor.lambda$onEventSynchronous$16(ComponentMessageProcessor.java:472)
	at org.mule.runtime.module.extension.internal.runtime.operation.ComponentMessageProcessor.onEventSynchronous(ComponentMessageProcessor.java:479)
	at org.mule.runtime.module.extension.internal.runtime.operation.ComponentMessageProcessor.lambda$null$6(ComponentMessageProcessor.java:388)
	at reactor.core.publisher.FluxPeekFuseable$PeekFuseableConditionalSubscriber.onNext(FluxPeekFuseable.java:482)
	at reactor.core.publisher.FluxMapFuseable$MapFuseableConditionalSubscriber.onNext(FluxMapFuseable.java:287)
	at reactor.core.publisher.FluxPeekFuseable$PeekFuseableConditionalSubscriber.onNext(FluxPeekFuseable.java:496)
	at org.mule.runtime.core.privileged.processor.chain.AbstractMessageProcessorChain$2.onNext(AbstractMessageProcessorChain.java:490)
	at org.mule.runtime.core.privileged.processor.chain.AbstractMessageProcessorChain$2.onNext(AbstractMessageProcessorChain.java:485)
	at reactor.core.publisher.FluxHide$SuppressFuseableSubscriber.onNext(FluxHide.java:127)
	at reactor.core.publisher.FluxPeekFuseable$PeekFuseableSubscriber.onNext(FluxPeekFuseable.java:204)
	at reactor.core.publisher.FluxOnAssembly$OnAssemblySubscriber.onNext(FluxOnAssembly.java:351)
	at reactor.core.publisher.FluxSubscribeOnValue$ScheduledScalar.run(FluxSubscribeOnValue.java:178)
	at reactor.core.scheduler.SchedulerTask.call(SchedulerTask.java:50)
	at reactor.core.scheduler.SchedulerTask.call(SchedulerTask.java:27)
	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
	at org.mule.service.scheduler.internal.AbstractRunnableFutureDecorator.doRun(AbstractRunnableFutureDecorator.java:151)
	at org.mule.service.scheduler.internal.RunnableFutureDecorator.run(RunnableFutureDecorator.java:54)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	at java.lang.Thread.run(Thread.java:748)

CAUSE

• Snowflake is rejecting a connection to specific IP
• Please refer to the link - https://community.snowflake.com/s/article/Getting-error

SOLUTION

• Please make sure that the Snowflake accepts a connection from a specific IP
• For cloudhub, you can assign a Static IP to the worker and allow traffic from that IP to the Snowflake