https://community.databricks.com/t5/data-engineering/a-usecase-to-query-millions-of-values/m-p/15410#M9741 <P>You can also create a temporary view with the output from python code (one id = one row) and then inner join the view to the table. IMO will improve readability of your code.</P> Thu, 22 Dec 2022 13:06:06 GMT daniel_sahal 2022-12-22T13:06:06Z https://community.databricks.com/t5/data-engineering/a-usecase-to-query-millions-of-values/m-p/15409#M9740 <P>have a small use case where we need to query the sql database with 1 million values(dynamically returned from python code) in the condition from python function. eg: select * from id in (1,2,23,33........1M).&nbsp;I feel this is very bad approach. Is there any better way to query the millions of values using select query.</P><P>Kindly suggest.</P> Wed, 21 Dec 2022 12:11:38 GMT https://community.databricks.com/t5/data-engineering/a-usecase-to-query-millions-of-values/m-p/15409#M9740 KVNARK 2022-12-21T12:11:38Z https://community.databricks.com/t5/data-engineering/a-usecase-to-query-millions-of-values/m-p/15410#M9741 <P>You can also create a temporary view with the output from python code (one id = one row) and then inner join the view to the table. IMO will improve readability of your code.</P> Thu, 22 Dec 2022 13:06:06 GMT https://community.databricks.com/t5/data-engineering/a-usecase-to-query-millions-of-values/m-p/15410#M9741 daniel_sahal 2022-12-22T13:06:06Z