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

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

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

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:

 /$category/$filetype/$year/$month 

would correspond to a key prefix of:

 US-Crimes/csv-files/2001/Dec/ 
value
The default value is as follows:
'$Var1/$Var2/$Var3/$Var4/$Var5/$Var6/$Var7/$Var8/$Var9/$Var10
/$Var11/$Var12/$Var13/$Var14/$Var15/$Var16/$Var17/$Var18/$Var19/$Var20'