Road to Snowflake SnowPro Core Certification: File Formats & Sequences

Chapter 19: Other Snowflake Objects. File Formats & Sequences

Gonzalo Fernandez Plaza
4 min readNov 23, 2021

--

Snowflake SnowPro Core Certification: File Formats and 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:

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.

--

--

Gonzalo Fernandez Plaza

Computer Science Engineer & Tech Lead 🖥️. Publishing AWS & Snowflake ❄️ courses & exams. https://www.fullcertified.com