|
Field |
Description |
|---|---|
| {" "} Role ARN{" "} | {" "} Enter the Amazon Resource Name (ARN) of the role you want to assume.{" "} |
| {" "} Role Session Name{" "} | {" "} Enter the identifier for the assumed role session.{" "} |
| {" "} External ID{" "} | {" "} Enter the unique identifier used by third parties when assuming roles in their customers' accounts.{" "} |
| {" "} Bucket{" "} | {" "} Enter the Amazon S3 Bucket you want to pull files from.{" "} |
| {" "} Region{" "} | {" "} Select the S3 Bucket Region where your file is located.{" "} |
|
Menu |
Description |
|---|---|
| {" "} What File Type would you like to import?{" "} | {" "} Select the file type that you would like to parse and import, either CSV, JSON, TSV, TXT, XML, XLS, or XLSX.{" "} |
| {" "} Prefix{" "} | {" "} Enter a prefix to filter results by. A prefix limits the results to only those keys that begin with the specified prefix.{" "} |
| {" "} File Name{" "} | {" "} Enter the name of the Amazon S3 Object(file) that you would like to import.{" "} |
| {" "} File Name Match Type{" "} | {" "} Specify whether the file you want to retrieve starts with or contains the text you entered under File Name .{" "} |
| {" "} File Compression Type{" "} | {" "} Select the compression type of your file, either Gzip, zip, or none.{" "} |
| {" "} Subfile Name{" "} | {" "} Enter the name or a portion of the name of the subfiles that you would like to import.{" "} |
| {" "} Add Filename Column{" "} | {" "} Specify if the *BATCH\_FILE\_NAME* column should be added to the final output or not.{" "} |
| {" "} Select the Delimiting Character{" "} | {" "} Select the delimiting character used in your file. If your delimiter is not listed select 'Other.'{" "} |
| {" "} Specify your Delimiter{" "} | {" "} Enter the character used to delimit your character separated values (CSV) text.{" "} |
| {" "} Quote Character{" "} | {" "} Select the desired quote character for parsing CSV files. Double quote is the default quote character for CSV standard.{" "} |
| {" "} Custom Quote Character{" "} | {" "} Enter the desired CSV Quote character.{" "} |
| {" "} Escape Character{" "} | {" "} Select the desired escape character for parsing CSV files.{" "} |
| {" "} Custom Escape Character{" "} | {" "} Enter the desired CSV escape character.{" "} |
| {" "} Are Headers present in CSV file?{" "} | {" "} Select YES if the file contains headers, else select NO.{" "} |
| {" "} Date Columns and Formats{" "} |
{" "}
Enter the desired date column names and their respective formats as specified below, in the same order they exist
in the file. Example: columnName1:dateFormat1,columnName2:dateFormat2 columnName1:dd-MM-yyyy,columnName2:MM-dd-yyyy{" "} |
| {" "} Session Duration In Hours{" "} | {" "} Enter the role session duration (in hours). Note that this value can range from 1 to 12 hours, and it must be less than or equal to the maximum session duration set for the role.{" "} |
| {" "} Ensure Consistent Column Count Across Rows (checkbox){" "} | {" "} Terminates the execution if malformed data with inconsistent column values is detected.{" "} |
| {" "} Enable parsing for large JSON files?{" "} | {" "} Select Yes to enable parsing large JSON files.{" "} |
| {" "} Does your JSON text require a line reader?{" "} | {" "} Select Yes if your JSON text includes multiple lines that should be read.{" "} |
| {" "} Should the backslash be escaped?{" "} | {" "} Select Yes if your JSON text has backslash characters that need to be escaped.{" "} |
| {" "} Enter your data tag{" "} | {" "} Enter the tag for the data in your file.{" "} |
| {" "} Enter your sub list to flatten{" "} | {" "} Enter the comma-separated lists that you would like to flatten out in your data.{" "} |
| {" "} Enter fields to exclude{" "} | {" "} Provide a comma-separated list of fields you want to exclude from the import.{" "} |
| {" "} Enter your header tag{" "} | {" "} Enter the tag for the header in your JSON text.{" "} |
| {" "} Header Start Row{" "} | {" "} Enter the header start row number in the file.{" "} |
| {" "} Data Start Row{" "} | {" "} Enter the data start row number in the file.{" "} |
| {" "} Footer Rows to Skip{" "} | {" "} Enter the number of rows at the end of the file to skip. For example, to skip the last two rows you would enter 2.{" "} |
| {" "} Sheet Name{" "} | {" "} Enter the sheet name you want to retrieve from the specified spreadsheet be sure to check sheet name for accidental spaces, first sheet of the workbook will be used if the field is left blank.{" "} |
| {" "} Enter XPath Expression{" "} | {" "} Enter your XPath expression.{" "} |
| {" "} Do you require Attributes in Data?{" "} | {" "} Select 'Yes' if you require attributes values as a part of data.{" "} |