topic I am trying to use SQL join to combine 3 tables but the execution does not go beyond 93 million rows in Data Engineering https://community.databricks.com/t5/data-engineering/i-am-trying-to-use-sql-join-to-combine-3-tables-but-the/m-p/46297#M28037 <P>Hi all,</P><P>I ran a code to join 3 tables in Azure Databricks using SQL. When I run the code it is indicated "93 million rows read (1GB).&nbsp;</P><P>It will be showing me "<span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="SQL Join Query.JPG" style="width: 515px;"><img src="https://community.databricks.com/t5/image/serverpage/image-id/4037i2E1790498186EA03/image-size/large/is-moderation-mode/true?v=v2&amp;px=999" role="button" title="SQL Join Query.JPG" alt="SQL Join Query.JPG" /></span><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="State.JPG" style="width: 694px;"><img src="https://community.databricks.com/t5/image/serverpage/image-id/4038iBEB38C80FFFFD15D/image-size/large/is-moderation-mode/true?v=v2&amp;px=999" role="button" title="State.JPG" alt="State.JPG" /></span> and does not go beyond this. Who knows what the issue could be?</P><P>&nbsp;</P><P>&nbsp;</P> Tue, 26 Sep 2023 16:51:54 GMT space25 2023-09-26T16:51:54Z I am trying to use SQL join to combine 3 tables but the execution does not go beyond 93 million rows https://community.databricks.com/t5/data-engineering/i-am-trying-to-use-sql-join-to-combine-3-tables-but-the/m-p/46297#M28037 <P>Hi all,</P><P>I ran a code to join 3 tables in Azure Databricks using SQL. When I run the code it is indicated "93 million rows read (1GB).&nbsp;</P><P>It will be showing me "<span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="SQL Join Query.JPG" style="width: 515px;"><img src="https://community.databricks.com/t5/image/serverpage/image-id/4037i2E1790498186EA03/image-size/large/is-moderation-mode/true?v=v2&amp;px=999" role="button" title="SQL Join Query.JPG" alt="SQL Join Query.JPG" /></span><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="State.JPG" style="width: 694px;"><img src="https://community.databricks.com/t5/image/serverpage/image-id/4038iBEB38C80FFFFD15D/image-size/large/is-moderation-mode/true?v=v2&amp;px=999" role="button" title="State.JPG" alt="State.JPG" /></span> and does not go beyond this. Who knows what the issue could be?</P><P>&nbsp;</P><P>&nbsp;</P> Tue, 26 Sep 2023 16:51:54 GMT https://community.databricks.com/t5/data-engineering/i-am-trying-to-use-sql-join-to-combine-3-tables-but-the/m-p/46297#M28037 space25 2023-09-26T16:51:54Z