This demonstration shows how simple it is to load data from JSON files and REST API calls into your data warehouse using WhereScape RED.
In this video, you’ll learn:
– How to use the built-in file parsing capabilities in WhereScape RED.
– Step-by-step instructions to load a JSON file into your data warehouse.
– Parsing JSON files into table and column definitions, regardless of the nested structure.
– Creating load tables and generating Python scripts for parsing data. – Loading data into various targets like Snowflake, Databricks, Synapse, SQL Server, and Oracle.
– Setting up and using REST API connections to pull in data.
– Configuring API call parameters and parsing the returned data into tables. Watch as Brad guides you through these processes with practical examples, ensuring that even complex JSON and API data can be efficiently integrated into your data warehouse.
Whether you’re dealing with government vehicle data or university data, WhereScape RED makes it easy and automated.
