16.20 - SQL Interface to Ferret SHOWCOMPRESS - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ NewSQL Engine Release Summary

Teradata Database
Teradata Vantage NewSQL Engine
Release Number
March 2019
Content Type
Release Notes
Publication ID
English (United States)
Last Update

The Ferret SHOWCOMPRESS command displays compression information. This new feature provides an SQL interface that is equivalent.

The SQL SHOWCOMPRESS command makes it easy to get the compression information into a standard SQL table, making that information accessible through SQL queries. This gives you more options for using SHOWCOMPRESS output.


  • The resulting set of rows produced by the SQL function can easily be displayed or uploaded to other applications.
  • Unlike the Ferret utility, does not require console access privileges and is available to all users with correct privileges.


This feature does not include any new SQL macros. It can be used with these existing macros, which have two versions, one if you are using Teradata (BTET) session mode, and one if you are using ANSI session mode:
  • CreateFsysinfoTable


  • CreateFsysinfoTable_ANSI


Additional Information

  • For information on file system information macros, see File System Information Macros in Teradata Vantage™ SQL Operators and User-Defined Functions, B035-1210.
  • For information on the Ferret utility, see Teradata Vantage™ - Database Utilities , B035-1102 .