diff --git a/databases/py-snowflake-connector-python/Makefile b/databases/py-snowflake-connector-python/Makefile
index d6693a8d8b05..9e5531eae8cd 100644
--- a/databases/py-snowflake-connector-python/Makefile
+++ b/databases/py-snowflake-connector-python/Makefile
@@ -1,40 +1,45 @@
 PORTNAME=	snowflake-connector-python
-DISTVERSION=	3.12.3
-PORTREVISION=	1
-DISTNAME=	snowflake_connector_python-${DISTVERSION}
+DISTVERSION=	4.0.0
 CATEGORIES=	databases python
 MASTER_SITES=	PYPI
 PKGNAMEPREFIX=	${PYTHON_PKGNAMEPREFIX}
+DISTNAME=	snowflake_connector_python-${DISTVERSION}
 
 MAINTAINER=	pat@patmaddox.com
 COMMENT=	Snowflake Connector for Python
 WWW=		https://github.com/snowflakedb/snowflake-connector-python
 
 LICENSE=	APACHE20
 
+BUILD_DEPENDS=	${PYTHON_PKGNAMEPREFIX}setuptools>=40.6.0:devel/py-setuptools@${PY_FLAVOR} \
+		${PYTHON_PKGNAMEPREFIX}wheel>0:devel/py-wheel@${PY_FLAVOR}
+
 RUN_DEPENDS=	${PYTHON_PKGNAMEPREFIX}asn1crypto>0.24.0<2.0.0:devel/py-asn1crypto@${PY_FLAVOR} \
-		${PYTHON_PKGNAMEPREFIX}cffi>=1.9<2:devel/py-cffi@${PY_FLAVOR} \
-		${PYTHON_PKGNAMEPREFIX}openssl>=16.2.0:security/py-openssl@${PY_FLAVOR} \
+		${PYTHON_PKGNAMEPREFIX}openssl>=22.0.0:security/py-openssl@${PY_FLAVOR} \
 		${PYTHON_PKGNAMEPREFIX}pyjwt<3.0:www/py-pyjwt@${PY_FLAVOR} \
 		${PYTHON_PKGNAMEPREFIX}pytz>0:devel/py-pytz@${PY_FLAVOR} \
 		${PYTHON_PKGNAMEPREFIX}requests<3.0:www/py-requests@${PY_FLAVOR} \
 		${PYTHON_PKGNAMEPREFIX}packaging>0:devel/py-packaging@${PY_FLAVOR} \
 		${PYTHON_PKGNAMEPREFIX}charset-normalizer>=2<4:textproc/py-charset-normalizer@${PY_FLAVOR} \
 		${PYTHON_PKGNAMEPREFIX}idna>=2.5<4.0:dns/py-idna@${PY_FLAVOR} \
 		${PYTHON_PKGNAMEPREFIX}certifi>=2017.4.17:security/py-certifi@${PY_FLAVOR} \
 		${PYTHON_PKGNAMEPREFIX}typing-extensions>=4.3<5.0:devel/py-typing-extensions@${PY_FLAVOR} \
 		${PYTHON_PKGNAMEPREFIX}filelock>=3.5<4.0:sysutils/py-filelock@${PY_FLAVOR} \
 		${PYTHON_PKGNAMEPREFIX}sortedcontainers>=2.4.0:devel/py-sortedcontainers@${PY_FLAVOR} \
 		${PYTHON_PKGNAMEPREFIX}platformdirs>=2.6.0<5.0.0:devel/py-platformdirs@${PY_FLAVOR} \
 		${PYTHON_PKGNAMEPREFIX}tomlkit>0:textproc/py-tomlkit@${PY_FLAVOR}
 
 USES=		python
-USE_PYTHON=	autoplist concurrent cryptography cython3 distutils
+USE_PYTHON=	autoplist concurrent cryptography cython3 pep517
 
 .include <bsd.port.pre.mk>
 
 .if ${PYTHON_REL} < 31000
-RUN_DEPENDS+=	${PYTHON_PKGNAMEPREFIX}urllib3>=1.21.1:net/py-urllib3@${PY_FLAVOR}
+RUN_DEPENDS+=	${PYTHON_PKGNAMEPREFIX}urllib3>=1.21.1<2:net/py-urllib3@${PY_FLAVOR}
 .endif
 
+post-install:
+	${STRIP_CMD} \
+		${STAGEDIR}${PYTHONPREFIX_SITELIBDIR}/snowflake/connector/nanoarrow_arrow_iterator.cpython-${PYTHON_SUFFIX}.so
+
 .include <bsd.port.post.mk>
diff --git a/databases/py-snowflake-connector-python/distinfo b/databases/py-snowflake-connector-python/distinfo
index 72d97770d52e..57026579ebb8 100644
--- a/databases/py-snowflake-connector-python/distinfo
+++ b/databases/py-snowflake-connector-python/distinfo
@@ -1,3 +1,3 @@
-TIMESTAMP = 1733302256
-SHA256 (snowflake_connector_python-3.12.3.tar.gz) = 02873c7f7a3b10322e28dddc2be6907f8ab8ecad93d6d6af14c77c2f53091b88
-SIZE (snowflake_connector_python-3.12.3.tar.gz) = 742358
+TIMESTAMP = 1760767754
+SHA256 (snowflake_connector_python-4.0.0.tar.gz) = 4b10a865c4a5e1fa60c365c7fe41e0433605e6e5edc824e8730a9038f330b3a6
+SIZE (snowflake_connector_python-4.0.0.tar.gz) = 813937