Snowflake - Build and Architect Data Pipelines Using AWS - Lab - Billing and Query History for Tasks

The video tutorial explains that while creating tasks in Snowflake does not incur direct costs, the compute resources and warehouse runtime do. It demonstrates how to query the task history using SQL, emphasizing the need to switch to the account admin role. The tutorial also suggests creating dashboards to visualize task execution history, noting that new accounts may initially show no task history.

What is the primary cost associated with tasks?

• Task deletion

• Task scheduling

• Compute and warehouse runtime

• Creating tasks

Before running the SQL query to check task history, what role should you switch to?

• Task admin

• System admin

• User admin

• Account admin

What does the SQL query for task history primarily retrieve?

• Task scheduling details

• Task deletion logs

• Task execution history

• Task creation times

How can you modify the SQL query to view task history for different durations?

• By switching the user role

• By updating the task names

• By altering the query parameters

• By changing the database

What might cause the task history to be empty?

• Tasks are deleted

• Tasks are completed

• Tasks are running

• Tasks are not scheduled