I am trying to read nested data from json file to put it into streaming table using dlt

zero234 — Wed, 21 Feb 2024 16:29:20 GMT

So i have this nested data with more than 200+columns and i have extracted this data into json file
when i use the below code to read the json files, if in data there are few columns which have no value at all it doest inclued those columns in schema .

from pyspark.sql import SparkSession
spark = (
SparkSession.builder.master("local[1]")
.config("spark.sql.jsonGenerator.ignoreNullFields", "false")
).getOrCreate()
# Create a SparkSession

df=spark.read.option("multiline","true").option("inferschema","true").json("file.json")
df.printSchema()

i can create schema and read it that will solve the issue i guess
but wanted to know if there is any alternate approach to this
Also can anyone help me with how to write this nested data to streaming table in bronze layer

Re: I am trying to read nested data from json file to put it into streaming table using dlt

zero234 — Wed, 21 Feb 2024 18:57:30 GMT

replying to my above question
we cannot use inferschema on streaming table we need to externally specify schema
can anyone please suggest a way to write data in nested form to streaming table and if this is possible?

topic I am trying to read nested data from json file to put it into streaming table using dlt in Data Engineering

I am trying to read nested data from json file to put it into streaming table using dlt

Re: I am trying to read nested data from json file to put it into streaming table using dlt