Forum Discussion
passing sql query to notebook
Hi
My problem was concerned with the Sql Query itself in the .xlsx file
The flow of the data is not directly to the notebook but it goes throw stages
The excel file is a metadata config file so i use it to control the flow of the data from source to gold layer of the medallion architecture.
So the data goes through this flow:
lookup -> filter -> loop on filtered rows
So the metadata is passed to the notebook ,including the sql query,
I hade to remove the tabs , \n, extra spaces making the query on a single line as it is passed as a string.
that is how i solved the issue.
Hi
My problem was concerned with the Sql Query itself in the .xlsx file
The flow of the data is not directly to the notebook but it goes throw stages
The excel file is a metadata config file so i use it to control the flow of the data from source to gold layer of the medallion architecture.
So the data goes through this flow:
lookup -> filter -> loop on filtered rows
So the metadata is passed to the notebook ,including the sql query,
I hade to remove the tabs , \n, extra spaces making the query on a single line as it is passed as a string.
that is how i solved the issue.
Hi UsefGamal
Glad that you were able to find some insights and thank you for sharing the same with the community as it can be helpful to others.
Please continue using Fabric Community for further queries.
Thank you.