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 Risposta
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
con risposta un mese fa
profile picture
ESPERTO
verificato un mese fa

Accesso non effettuato. Accedi per postare una risposta.

Una buona risposta soddisfa chiaramente la domanda, fornisce un feedback costruttivo e incoraggia la crescita professionale del richiedente.

Linee guida per rispondere alle domande