https://community.databricks.com/t5/data-engineering/alternative-to-the-inbuilt-scan-method-of-the-databricks-sdk-for/m-p/3388#M438 <P>Hi @Shivansh Bhatnagar​&nbsp;</P><P></P><P>Great to meet you, and thanks for your question! </P><P></P><P>Let's see if your peers in the community have an answer to your question. Thanks.</P><P></P> Fri, 16 Jun 2023 06:05:50 GMT Anonymous 2023-06-16T06:05:50Z https://community.databricks.com/t5/data-engineering/alternative-to-the-inbuilt-scan-method-of-the-databricks-sdk-for/m-p/3387#M437 <P>The implementation of&nbsp;<B>Scan</B> method in the <B>Databricks SDK</B>&nbsp;.</P><P>If the default value of any column is&nbsp;<B><I>NULL</I></B>, in that case the&nbsp;Scan method return exception.</P><P>What can we use as the alternative to this?</P><P>While implementing the logic with&nbsp;Scan method as per the doc, it seems this method does not map NULL values and gives error if the fetched field value is NULL while querying and mapping.</P><P>Can you please suggest any alternative to this or if there’s any way so that NULL values can also be mapped or any NULL value is not taken without giving exception.</P><P>PFA ss for your reference.<span class="lia-inline-image-display-wrapper" image-alt="Screenshot 2023-06-07 at 9.43.34 PM"><img src="https://community.databricks.com/t5/image/serverpage/image-id/94i1ECB37A747BA283E/image-size/large?v=v2&amp;px=999" role="button" title="Screenshot 2023-06-07 at 9.43.34 PM" alt="Screenshot 2023-06-07 at 9.43.34 PM" /></span><span class="lia-inline-image-display-wrapper" image-alt="Screenshot 2023-06-08 at 11.31.17 AM"><img src="https://community.databricks.com/t5/image/serverpage/image-id/108iEAA8B87C4AC8449E/image-size/large?v=v2&amp;px=999" role="button" title="Screenshot 2023-06-08 at 11.31.17 AM" alt="Screenshot 2023-06-08 at 11.31.17 AM" /></span></P> Thu, 08 Jun 2023 09:10:03 GMT https://community.databricks.com/t5/data-engineering/alternative-to-the-inbuilt-scan-method-of-the-databricks-sdk-for/m-p/3387#M437 Being_Bane 2023-06-08T09:10:03Z https://community.databricks.com/t5/data-engineering/alternative-to-the-inbuilt-scan-method-of-the-databricks-sdk-for/m-p/3388#M438 <P>Hi @Shivansh Bhatnagar​&nbsp;</P><P></P><P>Great to meet you, and thanks for your question! </P><P></P><P>Let's see if your peers in the community have an answer to your question. Thanks.</P><P></P> Fri, 16 Jun 2023 06:05:50 GMT https://community.databricks.com/t5/data-engineering/alternative-to-the-inbuilt-scan-method-of-the-databricks-sdk-for/m-p/3388#M438 Anonymous 2023-06-16T06:05:50Z