Read SQL server Version 13 tables from Sagemaker

0

Can someone please provide me the steps to read SQL Server tables from Amazon Sagemaker Studio in detail please . Im using version 13

  1. Do I have to install driver?
  2. please address any code snippets for the same . Would be much helpful
1개 답변
0

With SageMaker you can read directly data from Amazon S3, Amazon EFS or Amazon FSx for Lustre. You could import the data from sql to S3 or try aws-data-wrangler which allows easy intergration with PostgreSQL, MySQL, SQLServer etc (https://docs.aws.amazon.com/sagemaker/latest/dg/data-wrangler-import.html) . If you wand to directly access from notebooks then you just install python packages and read using the python modules. For SQL server something like the below article should work - https://docs.devart.com/odbc/sqlserver/python.htm

AWS
답변함 한 달 전
profile picture
전문가
검토됨 한 달 전

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인