Hi,
If you need a no-code solution, you should use some third-party ETL tools. As for me, it’s the easiest way to do this kind of integration. You can use Skyvia (HubSpot & Snowflake Integration - Connect, Sync - Skyvia) or similar ETL tools. Skyvia is rather easy to use and it allows you to integrate data between Snowflake and HubSpot in any direction.
I hope it helps