jcornelius
New Contributor III
Joined 6 years ago
User Profile
User Widgets
Contributions
Re: Reusable pipeline- Unable to fetch variable value in child pipeline -Snowflake Snap
You need to set _name if you are going to use “Pipeline Parameter” You can use “Document Parameters” and they are referenced with $. Lokk at the output of Snowflake - Execute by clicking the Red doc icon, this will show into the next snap. ie is output is “tableName”: “table1” then change select to "select * from " $tableName2.3KViews0likes0CommentsRe: Reusable pipeline- Unable to fetch variable value in child pipeline -Snowflake Snap
Why not have the output on Master pipeline be a document list where each document is a command. Then the child pipe runs 1 command, they will all get called and the output will results in ach documents which can be processed separately or merged into 1 doc4.2KViews0likes0CommentsRe: Pad field with zero
This is the one I always use Where 9 is the size you want and text2 is you data (-9 negative of size you want) ‘0’.repeat(9).concat(text2).slice(-9) Explain: text1 = “000000000”; //length you want text2 = “1234”; result = “000000000”.concat(text2); 0000000001234 //returns last number of characters let result2 = result.slice(-9); //length you want 000001234 ‘0’.repeat(9).concat(text2).slice(-9)900Views4likes0Comments