Share via

Query csv file S3 bucket from SSMS

rajanisqldev-42 221 Reputation points
2023-01-24T16:40:27.6166667+00:00

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
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,705 questions
0 comments
Accepted answer
  1. Erland Sommarskog 122K Reputation points MVP Volunteer Moderator
    2023-01-24T22:31:57.62+00:00

    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.

    1 person found this answer helpful.
    0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Bruce (SqlWork.com) 78,236 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/

    1 person found this answer helpful.
    0 comments
  2. ZoeHui-MSFT 41,496 Reputation points
    2023-01-25T01:29:00.1033333+00:00

    Hi @rajanisqldev-42

    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.

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.