I don't think you can do this from Azure SQL Database, but it is possible from SQL 2022 which has S3 support. Read further here.
Query csv file S3 bucket from SSMS
I have csv files on Amazon S3 bucket.
How can I load files from S3 bucket to Sql Server DB or query from SSMS?