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 Parquet file format in Snowflake to load Parquet file data

Create the Parquet file format in Snowflake to load Parquet 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 Parquet file format in Snowflake to load Parquet file data

“

- [Instructor] To load the orders data, we need to create a separate file format. The reason is the orders data is available in the Parquet file format. Now, for that, let us create one more worksheet, and let's call it a orders load. Now, just keep one thing in the mind. We cannot create a table and anything with the order because order is a reserve keyword. So, that's why I'm choosing us orders. Okay, select the database, Pacific TB and Bronze as in is schema. Now, let's create our file format using this command, create or replace file format and give the file format name. The important is type. Now, this time I'm saying that the type is equal to Parquet, so this file format would be smart enough to read the Parquet file format. And let just execute this, and it worked perfectly fine. Now, to just verify that everything is correct or not, let us just go and test this Parquet file format via this command. I would say, select start from our stage name that is a DLS stage and the…

Contents