Skip to content

Instantly share code, notes, and snippets.

@tamiroze
Created June 20, 2019 21:38
Show Gist options
  • Save tamiroze/3d845df35c13b6523b6ceec675c43337 to your computer and use it in GitHub Desktop.
Save tamiroze/3d845df35c13b6523b6ceec675c43337 to your computer and use it in GitHub Desktop.
sample of copy command with date issue
copy into {0}{1}
from {2}
truncatecolumns = true
file_format =
(
field_optionally_enclosed_by='"'
escape_unenclosed_field='NONE'
type = csv
TRIM_SPACE = TRUE
field_delimiter = '|'
null_if = ('', '11457–11–09')
);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment