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 réponse
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
répondu il y a un mois
profile picture
EXPERT
vérifié il y a un mois

Vous n'êtes pas connecté. Se connecter pour publier une réponse.

Une bonne réponse répond clairement à la question, contient des commentaires constructifs et encourage le développement professionnel de la personne qui pose la question.

Instructions pour répondre aux questions