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
rajanisqldev-42
221
Reputation points
Hi,
I have csv files on Amazon S3 bucket.
How can I load files from S3 bucket to Sql Server DB or query from SSMS?
Thanks
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,343 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,705 questions
Accepted answer
-
Erland Sommarskog 121.9K Reputation points MVP Volunteer Moderator
2023-01-24T22:31:57.62+00:00
2 additional answers
Sort by: Most helpful
-
Bruce (SqlWork.com) 78,006 Reputation points Volunteer Moderator
2023-01-24T16:46:32.6833333+00:00 no support in SSMS. you can use SSIS.
[https://www.sqlshack.com/data-import-from-amazon-s3-ssis-bucket-using-an-integration-service-ssis-package/
-
ZoeHui-MSFT 41,496 Reputation points
2023-01-25T01:29:00.1033333+00:00 You may try with SSIS to load data from Amazon S3 bucket to SQL Server database.
Check this for details.
Regards,
Zoe Hui
If the answer is helpful, please click "Accept Answer" and upvote it.