Road to Snowflake SnowPro Core Certification: File Formats & Sequences

Chapter 19: Other Snowflake Objects. File Formats & Sequences

Snowflake SnowPro Core Certification: File Formats and Sequences

As we saw in the chapter on Snowflake architecture, there were several types of objects in Snowflake. Tables, views, stages, pipes, stored procedures, UDFs… We have seen all of them during this course, although we missed two file formats and sequences. In this chapter, we will see these two new objects!

1. File Formats
2. Sequences
3. Typical Exam Questions

Remember that all the chapters from the course can be found at the following link:

Road to SnowFlake SnowPro Core Certification: Complete Course

FILE FORMATS

A named file format object describes and stores the format information required to load data into Snowflake tables. You can specify different parameters, for example, the file’s delimiter, if you want to skip the header or not, etc.