cancel
Showing results for 
Search instead for 
Did you mean: 
Data Engineering
cancel
Showing results for 
Search instead for 
Did you mean: 

i tried to pull the report from QuickBase but it is giving error report too large

ahana
New Contributor III

hi

i tried to pull the report from below query

%python

df = quickbasePull('b5zj8k_pbz5_0_cd5h4wbbp77n4nvp56b4u','bqmnP8jm7',24)

but it is giving me error report too large

then i tried below

%python

import pyqb

from pyspark.sql import *

import pandas as pd

qbc = pyqb.Client(url='https://tvcm.quickbase.com/',user_token='b5zj8k_pbz5_0_cd5h4wbbp77n4nvp56b4u',database='bq2ma8jm7')

result = qbc.doquery(qid=24,database='bqmnP8jm7',fields=["5","6","7","8"])

samp = result['record']

df = pd.DataFrame(samp)

df = spark.createDataFrame(df)

df.createOrReplaceTempView('otl')

iam getting below result instead of no of column

image.pngplz help to pull the large amount of data from quickbase

0 REPLIES 0
Welcome to Databricks Community: Lets learn, network and celebrate together

Join our fast-growing data practitioner and expert community of 80K+ members, ready to discover, help and collaborate together while making meaningful connections. 

Click here to register and join today! 

Engage in exciting technical discussions, join a group with your peers and meet our Featured Members.