https://communities.sas.com/t5/SAS-Data-Management/Leveraging-Snowflake-s-Computational-Power-in-SAS-Data/m-p/899221#M20876 <P>Hello, I've established a connection between SAS Data Integration Studio and Snowflake, and I'm able to load tables from SAS DI into Snowflake. However, I'd like to leverage Snowflake's computational power when running the jobs in SAS DI Studio. How can I configure the transformations to execute on Snowflake? For example, I can set "Database Pass-Through" to "Yes" and "Target Table is Pass-Through" to "Yes" in the "Set Operators" transformation options, which displays a red "S" for "Snowflake Database" in the transformation icon on the diagram. However, this approach doesn't work for the "Extract" transformation, and the Snowflake icon isn't displayed. Does anyone have a solution or insights on how to achieve this?</P> Thu, 19 Oct 2023 11:42:05 GMT jozumhannes 2023-10-19T11:42:05Z https://communities.sas.com/t5/SAS-Data-Management/Leveraging-Snowflake-s-Computational-Power-in-SAS-Data/m-p/899221#M20876 <P>Hello, I've established a connection between SAS Data Integration Studio and Snowflake, and I'm able to load tables from SAS DI into Snowflake. However, I'd like to leverage Snowflake's computational power when running the jobs in SAS DI Studio. How can I configure the transformations to execute on Snowflake? For example, I can set "Database Pass-Through" to "Yes" and "Target Table is Pass-Through" to "Yes" in the "Set Operators" transformation options, which displays a red "S" for "Snowflake Database" in the transformation icon on the diagram. However, this approach doesn't work for the "Extract" transformation, and the Snowflake icon isn't displayed. Does anyone have a solution or insights on how to achieve this?</P> Thu, 19 Oct 2023 11:42:05 GMT https://communities.sas.com/t5/SAS-Data-Management/Leveraging-Snowflake-s-Computational-Power-in-SAS-Data/m-p/899221#M20876 jozumhannes 2023-10-19T11:42:05Z https://communities.sas.com/t5/SAS-Data-Management/Leveraging-Snowflake-s-Computational-Power-in-SAS-Data/m-p/899227#M20877 <P>It would be interesting to see what is actually happening if you have both source and target in Snowflake for the Extract transformation. In a best case scenario this would result in an implicit SQL pass through.</P> <P>If you activate these options you should be able to see how the SAS/ACCESS interface handles this:</P> <PRE><CODE class=" language-sas">options msglevel=i sastrace=',,,d' sastraceloc =saslog nostsuffx;</CODE></PRE> <P>Another option would be to replace the Extract transformation with Join (which funny enough doesn't require a join).</P> Thu, 19 Oct 2023 12:29:39 GMT https://communities.sas.com/t5/SAS-Data-Management/Leveraging-Snowflake-s-Computational-Power-in-SAS-Data/m-p/899227#M20877 LinusH 2023-10-19T12:29:39Z