https://community.databricks.com/t5/get-started-discussions/how-to-pass-a-dynamic-query-to-source-server-from-databricks/m-p/78431#M3395 <P>I have this usecase wherein i am supposed to pass a dynamic query to get data from source I have tried the query option but its giving error&nbsp;<BR /><SPAN class="">SparkConnectGrpcException: </SPAN><SPAN>(com.microsoft.sqlserver.jdbc.SQLServerException) Incorrect syntax near the keyword 'exec'.<BR />I have tried executing same query in sql server and it works fine.Does anyone know how can i acheive it?<BR /><BR />i have also tried the prepare_query option and tried to pass two queries it was helpful when i was passing cte but not when a dynamic query is created.<BR /><BR />can anyone help?<BR /><BR />#jdbc#databricks#dynamicQuery</SPAN></P><P>&nbsp;</P> Fri, 12 Jul 2024 02:43:14 GMT Rajani 2024-07-12T02:43:14Z https://community.databricks.com/t5/get-started-discussions/how-to-pass-a-dynamic-query-to-source-server-from-databricks/m-p/78431#M3395 <P>I have this usecase wherein i am supposed to pass a dynamic query to get data from source I have tried the query option but its giving error&nbsp;<BR /><SPAN class="">SparkConnectGrpcException: </SPAN><SPAN>(com.microsoft.sqlserver.jdbc.SQLServerException) Incorrect syntax near the keyword 'exec'.<BR />I have tried executing same query in sql server and it works fine.Does anyone know how can i acheive it?<BR /><BR />i have also tried the prepare_query option and tried to pass two queries it was helpful when i was passing cte but not when a dynamic query is created.<BR /><BR />can anyone help?<BR /><BR />#jdbc#databricks#dynamicQuery</SPAN></P><P>&nbsp;</P> Fri, 12 Jul 2024 02:43:14 GMT https://community.databricks.com/t5/get-started-discussions/how-to-pass-a-dynamic-query-to-source-server-from-databricks/m-p/78431#M3395 Rajani 2024-07-12T02:43:14Z https://community.databricks.com/t5/get-started-discussions/how-to-pass-a-dynamic-query-to-source-server-from-databricks/m-p/78734#M3411 <P>Hi&nbsp;&nbsp;<BR />thanks for your reply,<BR />I have used foreign catalouge to fetch required data from information schema&nbsp; then i am creating the dynamic query in databricks and then passing in query this is working for me!&nbsp;</P><P><BR /><BR /></P><P><a href="https://community.databricks.com/t5/user/viewprofilepage/user-id/9">@Retired_mod</a></P> Mon, 15 Jul 2024 03:46:34 GMT https://community.databricks.com/t5/get-started-discussions/how-to-pass-a-dynamic-query-to-source-server-from-databricks/m-p/78734#M3411 Rajani 2024-07-15T03:46:34Z