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

error too large report

ahana
New Contributor III

hi i am trying to pull the data from quick base but it is giving me error-: too large report

below are the code i used

@%python

df = quickbasePull('b5zj8k_pbz5_0_cd5h4wbb77n4nvp95b4u','bq2nq8jm7',4)

2)

i tried below code but its not displaying in correct format

%python

import pyqb

from pyspark.sql import *

import pandas as pd

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

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

samp = result['record']

df = pd.DataFrame(samp)

df = spark.createDataFrame(df)

df.createOrReplaceTempView('otl')

i am getting wrong report

image 

plz help.....

i need report to display like below

image

1 REPLY 1

Aviral-Bhardwaj
Esteemed Contributor III

Hey @ahana ahana​ ,

this code is not working

image

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.