How to pass variable from Azure Synapse notebook to a copy data task in pipeline?

Question

I have a synapse notebook that makes a var:

  testvar = '6/26/2023'

I can run this from a pipeline in Azure but how do I pass the variable from the notebook to something else, like a copy data task? I know the following sql in the image below doesn't work, I'm just not sure what I need to do to pass this variable

Answer 1

To pass variable from Azure Synapse notebook Add exit value to the notebook using below code:

mssparkutils.notebook.exit(testvar)

Run Notebook activity in Synapse pipeline add set variable activity to the notebook activity. Create variable with below dynamic content.

@activity('Notebook1').output.status.Output.result.exitValue

Above variable will give the variable of notebook as output.

Pass the above variable value into the copy activity with below query.

SELECT * FROM data where date > '@{variables('testvar')}'

It will copy data from source to sink according to the query. Data preview of above query: