How can I use an external python module with SQL 2017 sp_execute_external_script?

Question

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 script is defined in the stored procedure itself, but I'd like to know how to import my own python modules. Something like this:

EXEC sp_execute_external_script
@language = N'Python',
@script = N'
from test import sample
x = sample.SomeClass()
x.SomeFunction()
'

Is this possible? Is there another method for my to run my own python scripts in SQL?

@MitchWheat, as far as I can tell this will only let me import a public module which I've installed to the server. I'm not sure if this method will allow me to import a private module I've written myself? — ErpaDerp
– ErpaDerp, Commented Jan 3, 2019 at 1:24

Shreyas Moolya · Accepted Answer · 2019-05-24 07:51:58Z

3

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()
'

answered May 24, 2019 at 7:51

Shreyas Moolya

3491 gold badge5 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

ErpaDerp Over a year ago

Great stuff, wish you were there when I needed you months ago! Joking aside, thank you. Hopefully this helps somebody else.

Collectives™ on Stack Overflow

How can I use an external python module with SQL 2017 sp_execute_external_script?

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related