Survey banner
Switching to Dataiku - a new area to help users who are transitioning from other tools and diving into Dataiku! CHECK IT OUT

Update Dataset SQL server

Level 3
Update Dataset SQL server


I want to update a sql server table (dataset) . I understand that there are scenarios option that triggers update sql querry . As this feature is not included in my licence, what are the other options I may use? 



Operating system used: win

0 Kudos
1 Reply

Hi @Lo96 ,
The SQL triggers are indeed licenses-based and typically require Bussiness or Enterprise.
However, SQL triggers are not for updating SQL datasets; instead, they trigger a build/scenario when an SQL query changes.
If you want to update a SQL server table, you can just build a dataset /run a recipe that does the update.
You can trigger time-based scenarios with a Discover license as well.

0 Kudos