This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(275.2, 36%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER4%3C/text%3E%3C/svg%3E)
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
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.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(211.20000000000002, 61%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBS%3C/text%3E%3C/svg%3E)
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/
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.