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

SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Published
September 2020
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
wgr1555383704548.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1144
lifecycle
previous
Product Category
Teradata Vantage™
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'