Love it. Like these short videos on a specific topic, makes it easy to reference back in the future when I inevitably will forget how to do something like this.
Love it. I am looking for some ideas on how I can trigger synapse notebooks/pipelines as soon as some messages come into Azure Service Bus Topic subscription. Does anyone have any ideas?
Why do you set the cell to a parameter cell? Aren't you simply creating a variable called "datetoload" and then using that variable in the next cell? This should be standard notebook behavior, and should not need a parameter cell.
Is there a way to pass an array of arrays as a parameter? The use case is converting a SQL Server stored procedure that takes in a table valued parameter into a Synapse notebook.
Fixed! Add a params `datetoload` in ADF first and set value `@getPastTime(1,'Day','yyyyMMdd')`, then set a base parameter in notebook activity with value `@variables('datetoload')`.
amazing. You guys make learning so easy. I always wanted to learn to code. I do it on & off because I do a lot of different things in my job. Slowly but Shirley I am getting there (stop calling you Shirley) LOL
Love it. Like these short videos on a specific topic, makes it easy to reference back in the future when I inevitably will forget how to do something like this.
Love it. I am looking for some ideas on how I can trigger synapse notebooks/pipelines as soon as some messages come into Azure Service Bus Topic subscription. Does anyone have any ideas?
Why do you set the cell to a parameter cell? Aren't you simply creating a variable called "datetoload" and then using that variable in the next cell? This should be standard notebook behavior, and should not need a parameter cell.
Is there a way to pass an array of arrays as a parameter? The use case is converting a SQL Server stored procedure that takes in a table valued parameter into a Synapse notebook.
question: what date is loaded? if I am EST and job runs at 9pm, is it tomorrow?
Thanks but not helps, just wondering is it possiable to pass a parameter from a data factory and how?
Fixed! Add a params `datetoload` in ADF first and set value `@getPastTime(1,'Day','yyyyMMdd')`, then set a base parameter in notebook activity with value `@variables('datetoload')`.
amazing. You guys make learning so easy. I always wanted to learn to code. I do it on & off because I do a lot of different things in my job. Slowly but Shirley I am getting there (stop calling you Shirley) LOL