Question

What are the limitations of tasks in snaowflake?

Answer 1

Snowflake tasks have the following limitations:

1. Tasks cannot be run on demand. They can only be scheduled using a cron expression or triggered by another task.
2. Tasks cannot call UDFs containing Java or Python code, or stored procedures written in Scala. Nor can you call such a UDF.
3. Tasks cannot use primary and foreign key constraints, indexes, or partitions.
4. f you don't carefully monitor your storage size and usage, the task can have hidden costs.