Could you build out the schema dynamically by using something like this:
https://docs.databricks.com/aws/en/sql/language-manual/functions/schema_of_json
Perhaps there's a way to store your JSON in a variable and inject it into the function. I'm hopeful there'll be other routes aswell.
All the best,
BS
