Glue job failing with Null Pointer Exception when writing df

Question

Running a job to fetch data from S3 and write to GCP BQ using Glue BQ connector by AWS.
Everything else is fine, but for one table the second runs seems to fail always with below error.
First time it runs fine, I have bookmarks enabled to fetch new data added in S3 and write to BQ.
**It fails with below error on write function.**

Unable to understand the null pointer exception thrown.
```
Caused by: java.lang.NullPointerException
	at com.google.cloud.bigquery.connector.common.BigQueryClient.loadDataIntoTable(BigQueryClient.java:532)
	at com.google.cloud.spark.bigquery.BigQueryWriteHelper.loadDataToBigQuery(BigQueryWriteHelper.scala:87)
	at com.google.cloud.spark.bigquery.BigQueryWriteHelper.writeDataFrameToBigQuery(BigQueryWriteHelper.scala:66)
	... 42 more

```

Answer

Hi,

if you have bookmark enabled, are you sure you have new data in S3 for the second run?

If not the read step will create an empty dataframe that might cause the write to BigQuery to fail.

Currently you might want to implement a try/catch or conditional logic to test if the dataframe you read has data and writes to bigquery only if true otherwise only log a message that there is no available input at the moment.

Hope this helps,

Glue job failing with Null Pointer Exception when writing df

Relevant content