Data Unload from Snowflake to ADLS gen 2 using adf
Hi Everyone,
I am trying to unload data from snowflake into our Azure ADLS Gen 2 container using ADF. In ADF, I am trying to create a new linked service for the sink on ADLS Gen 1 and using ADLS Gen 2 SAS URI, if I directly use the SAS credentials it gives me a warning saying it Will publish immediately to our main branch, to avoid this I even tried putting the SAS credentials under our key vault and retrieving from key vault this way it would not publish to the main branch immediately. But even after this, I get an error saying the SAS URI is not constructed in proper format in Key vault, have followed the syntax shown in the error as well. Still doesn’t work, any suggestions or help is greatly appreciated.
thank you!
Hi Everyone, I am trying to unload data from snowflake into our Azure ADLS Gen 2 container using ADF. In ADF, I am trying to create a new linked service for the sink on ADLS Gen 1 and using ADLS Gen 2 SAS URI, if I directly use the SAS credentials it gives me a warning saying it Will publish immediately to our main branch, to avoid this I even tried putting the SAS credentials under our key vault and retrieving from key vault this way it would not publish to the main branch immediately. But even after this, I get an error saying the SAS URI is not constructed in proper format in Key vault, have followed the syntax shown in the error as well. Still doesn’t work, any suggestions or help is greatly appreciated. thank you! Read More