You can also think of using Azure data factory. Create a pipeline, use Copy activity task and configure source Azure SQL and target Azure storage. Schedule this pipeline to run daily.
Reference: tutorial-incremental-copy-portal
----------
If the response helped, do "Accept Answer" and upvote it Vaibhav