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?
Hi @Lo96 , The SQL triggers are indeed licenses-based and typically require Bussiness or Enterprise. https://doc.dataiku.com/dss/latest/scenarios/triggers.html#sql-triggers 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.
