From the course: End-to-End Real-World Data Engineering Project with Snowflake

Unlock this course with a free trial

Join today to access over 24,700 courses taught by industry experts.

Create the JSON file format in Snowflake to load JSON file data

Create the JSON file format in Snowflake to load JSON file data - Snowflake Tutorial

From the course: End-to-End Real-World Data Engineering Project with Snowflake

Start my 1-month free trial Buy for my team

Create the JSON file format in Snowflake to load JSON file data

“

- To load our product data, we need to create a different file format because the customer data was of the CSV type, and product is of a JSON type. So in this case, I cannot reuse the CSV file format. So to create another file format, let's create one more worksheet, and give the name as Product_load. Product_load. Now, we need to select the database that is PACIFICRETAIL, and schema as the BRONZE. To create the file format, we again going to use the command. And the command is pretty simple, create or replace the file format and give the name of the file format. I have given it json_file_format only. Importantly, I have set it that type is equal to JSON. And let's just execute this. And done! Our JSON_FILE_FORMAT got created. Now, the file format creation got done, but you wanted to see how it is working. So let's just quickly do a one quick check, where we have said that select dollar one, that is the first column from our adls/Product result, our JSON data is available into the…

Contents