I’m struggling to understand the best approach to load data FROM an on-premises SQL Server into SnowFlake FROM SnowFlake and not pushing data from the on-premises environment. We are hosted on AWS, however we do not have a dedicated VPC environment or any kind of private link setup, so I’m unsure how to talk between SnowFlake and on-premise. In tools like Power BI/Fabric, we have the Data Gateway installed on an on-premise server which allows me to use Fabric to PULL data from on-premises...
