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

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Published
January 2021
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
ncd1596241368722.ditamap
dita:ditavalPath
hoy1596145193032.ditaval
dita:id
mdr1472255012272
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'