0 votes
1 view
in Azure by (3.8k points)

I have already set up an Azure SQL Database and loaded results into it from my local machine via R (RODBC) successfully. I can do queries in R Studio with no problem.

However, when I use the same code in the Execute R Script module in the ML studio, I get an error that the connection is not open.

The reason Reader or Import Data module is not working for my case is that I am creating an API that provides me with the information to query the database before doing analytics. The database is very big and I do not want to load the whole table and then use project columns, etc.

What do I need to change? I have tried different strings for the driver with no avail.

Any help is really appreciated

1 Answer

0 votes
by (7.9k points)

1. Use an Import Data module

2. Mark the query string as a web service parameter

3. You can dynamically inject the query.

...