PATHPATTERN Option | CREATE FOREIGN TABLE | Teradata Vantage - 17.00 - PATHPATTERN - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Advanced SQL Engine
Teradata Database
Release Number
Release Date
September 2020
Content Type
Programming Reference
Publication ID
English (United States)
Specifies access information for key filtering as a series of variables delimited by slash (/) characters in the format:

You must specify a variable name after the slash character. Variable names must begin with the dollar sign ($) symbol. You cannot specify duplicate variable names in the pathpattern string category.

To differentiate levels in key, you use the slash characters as a delimiter. The pathpattern string cannot end with a slash. The variables in the path pattern align with the entries in the key prefix location string. The first variable in the key prefix corresponds to first entry after the bucket name, for example:


would correspond to a key prefix of:

The default value is as follows: