Using shared variables in magic commands

[andrerav]

Hi!

I wish to connect to a database using #!connect, but instead of specifying the connection string in a literal manner I would like to use a variable that contains a connection string defined earlier in my notebook. So I imagine something like this:

(C#)

var connectionString = "....";

(SQL)

#!share --from csharp connectionString 
#!connect mssql --kernel-name someDb connectionString

SELECT * ....

But alas, this does not work. Is there some way to share and use the connectionString variable in the #!connect magic command?

[huhubun]

I had the same problem and found the answer here #2523 (comment) 😀

[andrerav]

Perfect, thank you!