Notebook Parameter Issue

Question

I have passed the parameter in Notebook 1

%run /Development/Tickets/silver_object_lead_cdf_latest $VarA="source_full_object_name" $VarB="destination_full_object_name"

And I am trying to call the parameter $VarA in notebook 2 with following query :

SELECT * FROM $VarA

But i am getting error :

AnalysisException: Invalid usage of '*' in expression 'alias'.

Please advise.

Regards Rohit

Answer 1

Hi, Rohit!

To solve the error above In python, try this:
intead of:

salesforce_df = spark.sql(f"select Id,IsDeleted FROM $VarA")
display(salesforce_df)

do this:
salesforce_df = spark.sql(f"select Id,IsDeleted FROM {VarA}")
display(salesforce_df)
To call a variable in a f-string, in python, you have to use {}. Furthermore, you can use a normal string and .format(), like below: \ salesforce_df = spark.sql("select Id,IsDeleted FROM {}".format(VarA)) \ display(salesforce_df)

Hope it Helps!