Although Snowpipe is continuous, it's not real-time. Data might not be available for querying until minutes after it's staged. Throughput can also be an issue with Snowpipe. The writes queue up if too much data is pushed through at one time.