In reply to Ross.

Hi Ross, here are a couple links to assist you in your SAS + Snowflake journey:
- SAS/ACCESS to Snowflake documentation (https://go.documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/acreldb/p19i7uzcbso1szn1pczxn88co3g1.htm)
- An Insider’s Guide to SAS/ACCESS® Interface to Snowflake (whitepaper) (https://support.sas.com/resources/papers/proceedings20/4103-2020.pdf)

With SAS/ACCESS, there is the capability to push SAS functions and joins down into Snowflake without moving data.
If you have SAS/ACCESS to the respective database on Azure, you could use SAS for various data manipulation tasks between Snowflake and the other database.
Depending on the nature of the workflow tasks, you could use Enterprise Guide, for example, to orchestrate the tasks.
I'll ping some colleagues to chime in as well. Do you have a SAS rep or technical contact you are working with?