Why does SELECT not offer real time data or high frequency batches?

Cost to you

If we were to keep an Extra Small warehouse constantly running to load your data in real time, that would be very costly in terms of Snowflake credits. Here's an example.

$3 / credit x 24 hours x 365 days = $26,280 per year.

We don't want to cause this much spend in your Snowflake account!

Cost to us

The data loading and transformation in our Snowflake account is very expensive. For this reason, we need to charge if a customer requires refreshes more than once per day.

Alternatives

Keep in mind, Custom SQL Monitors may meet your needs for intraday monitoring.