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 Answer
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
answered a month ago
profile picture
EXPERT
reviewed a month ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions