How Can I Use An External Python Module With Sql 2017 Sp_execute_external_script?

I'm testing out the SQL 2017 machine learning services that allow you to run python scripts in a stored procedure. I see plenty of examples of how to run a python script when the

Solution 1:

Yes you may do this by extending the sys.path environment variables by the adding the location of test module in your code like this

EXEC sp_execute_external_script
@language = N'Python',
@script = N'
import sys
sys.path += ['D:\\path_to_your_test_module']
from test import sample as sa
x = sa.SomeClass()
x.SomeFunction()
'