![]() ![]() s (Optional): The file you wish to read a custom valid SQL WHERE clause from. f: The S3 key at which the file will be placed Here are a few of the runtime options: -t: The table you wish to UNLOAD This will also export a header row as well, something that is a little more complicated to undertake. You can set the delimiter, dates and ad hoc SQL via run-time configuration. ![]() All the code is on Github so you can use it as-is or grab the underlying Python code to create your own version: Since this topic comes up in many places we decided to package up the UNLOAd/extract process into a Docker service. For example, you can use this option to escape the delimiter character, a quote, an embedded newline, or the escape character itself when any of these characters is a legitimate part of a column value. The character that immediately follows the backslash character is loaded into the table as part of the current column value, even if it is a character that normally serves a special purpose.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |