Need help in GIT Repository
Hello Team,
Is it possible to connect GIT repository from SnapLogic? If yes, please let me know how to connect it. I know that there is no separate snap pack for this. Just wanted to know.
Thanks...
Forum Discussion
Thank you so much for help š it works now
Hello @darshthakkar.
You can get the output schema by opening the second output view, and if your goal is to proceed with executing downstream even if there are no rows selected you can achieve that by using the Gate Snap and a Router afterwards to route to the corresponding branch.
Please refer to the attached sample pipeline.
-SL-comm-snowflake-select-empty_2023_03_22.slp (12.8 KB)Hope it helps. š
BR,
Aleksandar.Thank you, @AleksandarAngelevski for sharing this.
I feel like it involves a lot of processing just to record the counts.I thought of it in the interim and planning to use a snowflake - execute with the query that fetches the counts (as Iām not concerned with the data), once I get that number, I can pass it to the last snap I use for notifying it via an email.
So, it will save me from using different snaps and at the end of the day, I get my desired result. Thanking you again for your help and time on this one.
The whole point of reading data from an empty table in
snowflake - select snapwas to record the counts, as there is no easier way to do that when the table is empty, we can leverage thesnowflake - execute snapand modify the query to get the counts ONLY.Return data type is an integer for me which I donāt have any concern with and, if need be, that can be converted to a String. Thus, the easiest solution is to use a
Snowflake - Executesnap instead of a Snowflake - Select and modify the query.P.S.: All snowflake snaps trying to fetch data in an empty table wouldnār return anything. Not even Null or 0.
Closing this thread now. Thank you.
