https://community.databricks.com/t5/data-engineering/error-too-large-report/m-p/34765#M25484 <P>hi i am trying to pull the data from quick base but it is giving me error-: too large report</P><P>below are the code i used</P><P></P><P>@%python</P><P>df = quickbasePull('b5zj8k_pbz5_0_cd5h4wbb77n4nvp95b4u','bq2nq8jm7',4)</P><P></P><P>2) </P><P> i tried below code but its not displaying in correct format</P><P></P><P></P><P>%python</P><P>import pyqb</P><P>from pyspark.sql import *</P><P>import pandas as pd</P><P>qbc = pyqb.Client(url='<A href="https://tvcm.quickbase.com/',user_token='b5zj8k_pbz5_0_cd5h4wbb77n4nvp95b4u',database='bq2nq8jm7" alt="https://tvcm.quickbase.com/',user_token='b5zj8k_pbz5_0_cd5h4wbb77n4nvp95b4u',database='bq2nq8jm7" target="_blank">https://tvcm.quickbase.com/',user_token='b5zj8k_pbz5_0_cd5h4wbb77n4nvp95b4u',database='bq2nq8jm7</A>')</P><P>result = qbc.doquery(qid=24,database='bq2nq8jm7',fields=["5","6","7","8"])</P><P>samp = result['record']</P><P>df = pd.DataFrame(samp)</P><P>df = spark.createDataFrame(df)</P><P>df.createOrReplaceTempView('otl')</P><P></P><P>i am getting wrong report</P><P><span class="lia-inline-image-display-wrapper" image-alt="image"><img src="https://community.databricks.com/t5/image/serverpage/image-id/1620i7E29DF5A63719CA6/image-size/large?v=v2&amp;px=999" role="button" title="image" alt="image" /></span>&nbsp;</P><P>plz help.....</P><P></P><P><B><U>i need report to display like below</U></B></P><P></P><P><span class="lia-inline-image-display-wrapper" image-alt="image"><img src="https://community.databricks.com/t5/image/serverpage/image-id/1618i45F832932841C12A/image-size/large?v=v2&amp;px=999" role="button" title="image" alt="image" /></span></P> Fri, 12 Aug 2022 06:57:40 GMT ahana 2022-08-12T06:57:40Z https://community.databricks.com/t5/data-engineering/error-too-large-report/m-p/34765#M25484 <P>hi i am trying to pull the data from quick base but it is giving me error-: too large report</P><P>below are the code i used</P><P></P><P>@%python</P><P>df = quickbasePull('b5zj8k_pbz5_0_cd5h4wbb77n4nvp95b4u','bq2nq8jm7',4)</P><P></P><P>2) </P><P> i tried below code but its not displaying in correct format</P><P></P><P></P><P>%python</P><P>import pyqb</P><P>from pyspark.sql import *</P><P>import pandas as pd</P><P>qbc = pyqb.Client(url='<A href="https://tvcm.quickbase.com/',user_token='b5zj8k_pbz5_0_cd5h4wbb77n4nvp95b4u',database='bq2nq8jm7" alt="https://tvcm.quickbase.com/',user_token='b5zj8k_pbz5_0_cd5h4wbb77n4nvp95b4u',database='bq2nq8jm7" target="_blank">https://tvcm.quickbase.com/',user_token='b5zj8k_pbz5_0_cd5h4wbb77n4nvp95b4u',database='bq2nq8jm7</A>')</P><P>result = qbc.doquery(qid=24,database='bq2nq8jm7',fields=["5","6","7","8"])</P><P>samp = result['record']</P><P>df = pd.DataFrame(samp)</P><P>df = spark.createDataFrame(df)</P><P>df.createOrReplaceTempView('otl')</P><P></P><P>i am getting wrong report</P><P><span class="lia-inline-image-display-wrapper" image-alt="image"><img src="https://community.databricks.com/t5/image/serverpage/image-id/1620i7E29DF5A63719CA6/image-size/large?v=v2&amp;px=999" role="button" title="image" alt="image" /></span>&nbsp;</P><P>plz help.....</P><P></P><P><B><U>i need report to display like below</U></B></P><P></P><P><span class="lia-inline-image-display-wrapper" image-alt="image"><img src="https://community.databricks.com/t5/image/serverpage/image-id/1618i45F832932841C12A/image-size/large?v=v2&amp;px=999" role="button" title="image" alt="image" /></span></P> Fri, 12 Aug 2022 06:57:40 GMT https://community.databricks.com/t5/data-engineering/error-too-large-report/m-p/34765#M25484 ahana 2022-08-12T06:57:40Z https://community.databricks.com/t5/data-engineering/error-too-large-report/m-p/34766#M25485 <P>Hey @ahana ahana​&nbsp;,</P><P></P><P>this code is not working</P><P></P><P><span class="lia-inline-image-display-wrapper" image-alt="image"><img src="https://community.databricks.com/t5/image/serverpage/image-id/1609i979623B6D4807002/image-size/large?v=v2&amp;px=999" role="button" title="image" alt="image" /></span></P> Sun, 18 Dec 2022 05:27:59 GMT https://community.databricks.com/t5/data-engineering/error-too-large-report/m-p/34766#M25485 Aviral-Bhardwaj 2022-12-18T05:27:59Z