PinnedMartin X.EXCEPTION handling for transaction with Snowflake Scripting(Stored Procedure/Anonymous block)Good news is that native stored procedure with SQL, no hassles writing procedure in JavaScript! See this post. Don’t get me wrong, I love…Apr 7, 2022Apr 7, 2022
PinnedMartin X.Snowflake: Nested Stored ProcedureIn my previous post, I explained how to use JavaScript features to store debug message in the return result.Feb 16, 20211Feb 16, 20211
Martin X.Code generation with ListAggYeah, I’m working on ̶a̶n̶o̶t̶h̶e̶r̶ ̶c̶o̶d̶e̶ ̶a̶u̶t̶o̶m̶a̶t̶i̶o̶n̶ ̶p̶r̶o̶j̶e̶c̶t another sql helper script.May 25, 2022May 25, 2022
Martin X.Thanks for sharing the nice trick, Sefedo.This is good to bake this enable/disable feature into a customised operator, what about the existing built-in operators?Sep 23, 2021Sep 23, 2021
Martin X.Snowflake: Call stored procedure in Azure Data Factory(In this post, Lookup activity is used in the final solution.)May 5, 20211May 5, 20211
Martin X.Snowflake: How to debug stored procedure efficientlyFrom Snowflake website below about stored procedure:Jan 22, 2021Jan 22, 2021
Martin X.Why AutoFlow?This series show how to visualize data linage of data pipelines and keep track on project/task progress at scale.Sep 10, 2020Sep 10, 2020
Martin X.ML.NET confusion matrix countersWhile developing wrapper for machine learning by using ML.NET, one thing bothered me was that:Oct 22, 2019Oct 22, 2019
Martin X.Simple java scripting tip with ES6: Class & ImportOver the weekend, I wanted to upgrade me javascripting skills with ES6 standard, where there are quite a lots features introduce.Oct 5, 2019Oct 5, 2019
Martin X.Embrace DevOps - automate SSIS deployment with PowerShellWhether you involves in data warehouse development or data integration project, you want to have a quick turn around and reliable…Jul 12, 20191Jul 12, 20191