Learn how to create a JSON file format in Snowflake.

1. In the Snowflake application worksheet area, create a new SQL worksheet.
2. In the SQL worksheet:
   1. From the drop-down menu at the top of the page, select the database you previously created in Create a Snowflake database.
   2. From the drop-down menu at the top of the page, select the schema you previously created.in Create a Snowflake schema.
   3. Run this command:

      CREATE file format <file_format_name>
      type = 'JSON'
      COMPRESSION = GZIP
      STRIP_OUTER_ARRAY = TRUE;

      where:

      • <file_format_name>: Is the name of the file format, for example, zippedJson.

        Tip: Take note of this value. You'll need it when you Create a Snowpipe in Snowflake (Azure).

      • type: Is JSON.

      • COMPRESSION: Is GZIP.

      • STRIP_OUTER-ARRAY: Is TRUE.

3. In the SQL worksheet, view the Successfully created notification message.