@James Bonding, you can use Session Parameters, docs.snowflake.com/en/user-guide/tasks-intro.html#setting-session-parameters-for-tasks. Perhaps a bit different from INFA and I don't think you can load a file into it. But in combination with Snowpark and functions or procedures you could probably get a similar result to what you're doing with INFA.
Thanks for this, I need to work on fix tomorrow involving tasks.
Please let us know if you have any questions 🙂
Very good video
Thanks! Please let us know if you're interested in learning about anything else in Snowflake and we'll see if we can help.
appreciate your efforts
What else would you consider using besides tasks to setup your dw fact and dims?
Hi Ray, we like to use dbt to setup facts and dimensions. SQS and SNS pipes also work in certain instances. However, this depends on the use case.
updation in table task can active and called a procedure it is my work plz help
Hi Akshay, please contact us via the form on out website and we'll do our best to answer your question > www.datalakehouse.io/contact-us/
Can you pass a parameter to a task ? in Informatica you can load a parameter file
@James Bonding, you can use Session Parameters, docs.snowflake.com/en/user-guide/tasks-intro.html#setting-session-parameters-for-tasks. Perhaps a bit different from INFA and I don't think you can load a file into it. But in combination with Snowpark and functions or procedures you could probably get a similar result to what you're doing with INFA.
@@aicg thanks -'ll try