How do I handle semi-structured JSON data in my data warehouse?

How do I handle semi-structured JSON data in my data warehouse?