How to pass string arguments with spaces to SQL notebook in databricks?

Question

I have a SQL notebook(notebookA) where I want to pass arguments from another notebook(notebookB).

---notebookA---
SELECT $v as $c

When I do this from notebook B, it is giving me result.

---notebookB---
%run ./notebookA $v='james' $c=name

But when there is a space in value it is giving me error like below

---notebookB---
%run ./notebookA $v='james potter' $c=name

Failed to parse %run command: string matching regex `\$[\w_]+' expected but `p' found)

What would be the solution then?

simon_dmorias · Accepted Answer · 2019-06-16 13:26:01Z

1

Magic commands do not allow variables to be passed. Instead you can use dbutils.

Python:

dbutils.notebook.run("notebookA", 60, {"v": "james potter", "c": name})

Reference: https://docs.databricks.com/user-guide/notebooks/notebook-workflows.html

answered Jun 16, 2019 at 13:26

simon_dmorias

2,4933 gold badges23 silver badges38 bronze badges

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

1 Comment

Anirban Nag 'tintinmj' Over a year ago

magic commands do allow variable to pass. You can see that from my first example. I am getting error when there is a space in value. Also I think "c":name} will give me an error.

Collectives™ on Stack Overflow

How to pass string arguments with spaces to SQL notebook in databricks?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related