<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic i tried to pull the report from QuickBase but it is giving error report too large in Data Engineering</title>
    <link>https://community.databricks.com/t5/data-engineering/i-tried-to-pull-the-report-from-quickbase-but-it-is-giving-error/m-p/34772#M25491</link>
    <description>&lt;P&gt;hi&lt;/P&gt;&lt;P&gt;i tried to pull the report from below query&lt;/P&gt;&lt;P&gt;%python&lt;/P&gt;&lt;P&gt;df = quickbasePull('b5zj8k_pbz5_0_cd5h4wbbp77n4nvp56b4u','bqmnP8jm7',24)&lt;/P&gt;&lt;P&gt;but it is giving me error report too large&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;then i tried below&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;%python&lt;/P&gt;&lt;P&gt;import pyqb&lt;/P&gt;&lt;P&gt;from pyspark.sql import *&lt;/P&gt;&lt;P&gt;import pandas as pd&lt;/P&gt;&lt;P&gt;qbc = pyqb.Client(url='https://tvcm.quickbase.com/',user_token='b5zj8k_pbz5_0_cd5h4wbbp77n4nvp56b4u',database='bq2ma8jm7')&lt;/P&gt;&lt;P&gt;result = qbc.doquery(qid=24,database='bqmnP8jm7',fields=["5","6","7","8"])&lt;/P&gt;&lt;P&gt;samp = result['record']&lt;/P&gt;&lt;P&gt;df = pd.DataFrame(samp)&lt;/P&gt;&lt;P&gt;df = spark.createDataFrame(df)&lt;/P&gt;&lt;P&gt;df.createOrReplaceTempView('otl')&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;iam getting below result instead of no of column &lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper" image-alt="image.png"&gt;&lt;img src="https://community.databricks.com/t5/image/serverpage/image-id/1612i5511182EE32B1D14/image-size/large?v=v2&amp;amp;px=999" role="button" title="image.png" alt="image.png" /&gt;&lt;/span&gt;plz help to pull the large amount of data from quickbase&lt;/P&gt;&lt;P&gt;&lt;/P&gt;</description>
    <pubDate>Fri, 12 Aug 2022 06:50:18 GMT</pubDate>
    <dc:creator>ahana</dc:creator>
    <dc:date>2022-08-12T06:50:18Z</dc:date>
    <item>
      <title>i tried to pull the report from QuickBase but it is giving error report too large</title>
      <link>https://community.databricks.com/t5/data-engineering/i-tried-to-pull-the-report-from-quickbase-but-it-is-giving-error/m-p/34772#M25491</link>
      <description>&lt;P&gt;hi&lt;/P&gt;&lt;P&gt;i tried to pull the report from below query&lt;/P&gt;&lt;P&gt;%python&lt;/P&gt;&lt;P&gt;df = quickbasePull('b5zj8k_pbz5_0_cd5h4wbbp77n4nvp56b4u','bqmnP8jm7',24)&lt;/P&gt;&lt;P&gt;but it is giving me error report too large&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;then i tried below&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;%python&lt;/P&gt;&lt;P&gt;import pyqb&lt;/P&gt;&lt;P&gt;from pyspark.sql import *&lt;/P&gt;&lt;P&gt;import pandas as pd&lt;/P&gt;&lt;P&gt;qbc = pyqb.Client(url='https://tvcm.quickbase.com/',user_token='b5zj8k_pbz5_0_cd5h4wbbp77n4nvp56b4u',database='bq2ma8jm7')&lt;/P&gt;&lt;P&gt;result = qbc.doquery(qid=24,database='bqmnP8jm7',fields=["5","6","7","8"])&lt;/P&gt;&lt;P&gt;samp = result['record']&lt;/P&gt;&lt;P&gt;df = pd.DataFrame(samp)&lt;/P&gt;&lt;P&gt;df = spark.createDataFrame(df)&lt;/P&gt;&lt;P&gt;df.createOrReplaceTempView('otl')&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;iam getting below result instead of no of column &lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper" image-alt="image.png"&gt;&lt;img src="https://community.databricks.com/t5/image/serverpage/image-id/1612i5511182EE32B1D14/image-size/large?v=v2&amp;amp;px=999" role="button" title="image.png" alt="image.png" /&gt;&lt;/span&gt;plz help to pull the large amount of data from quickbase&lt;/P&gt;&lt;P&gt;&lt;/P&gt;</description>
      <pubDate>Fri, 12 Aug 2022 06:50:18 GMT</pubDate>
      <guid>https://community.databricks.com/t5/data-engineering/i-tried-to-pull-the-report-from-quickbase-but-it-is-giving-error/m-p/34772#M25491</guid>
      <dc:creator>ahana</dc:creator>
      <dc:date>2022-08-12T06:50:18Z</dc:date>
    </item>
  </channel>
</rss>

