I'm going with an F 2 SKU which costs €0.407/hour or €296.625/month. Onelake storage costs €0.0222/GB/month.
Now, what I'm not sure about is if I need to run the capacity continuously or can I pause it? If so, will this pausing happen automatically when the service is idle or do I have to manually do this?
I'm looking to scrape a website (takes 5 minutes) schedule this every day and store the results. Later I want to use Streamlit to query this data an show it on a public website. Does this mean I only use 5 minutes of Fabric capacity per day? Do we get charged for the reads and writes to the Onelake storage? Or can I query my database 24/7 with 1000s of users and still only pay €0.0222/GB/month? Or does querying the onelake storage also use the capacity?