{{ transformations:ImportApacheParquetAction.png}}
====== IMPORT FROM APACHE PARQUET (.parquet) ======
Category: Import / File\\

\\ 
=====Description=====
This action imports columns of data or key-value metadata from an Apache Parquet file (.parquet).

\\ 
=====Action settings=====
^ Setting  ^ Description  ^
|Load file<sup>*</sup>| Enter or browse to the fully-qualified file name of the Parquet file (relative or absolute path).  |
|Mode|Select the import mode to retrieve data from the file.  Options:  //Import columns// or //Import key-value metadata//.|
<sup>*</sup> Setting can be specified using a [[:parameters|parameter]].\\

\\ 
====Import columns settings====
^ Setting  ^ Description  ^
|Load only the first # rows<sup>*</sup>|Check this option and select or enter a number of rows to import only a //subset// of the data.|
|Load only selected columns| Check this to import only //specific// columns from the file.  Select the columns to import from the drop-list that will appear.|
|//**Advanced options settings**//||
|Use object paths as column names| Use property paths of complex objects as column names.  |
|Skip the first # rows|Check this and enter or select the number of rows at the start of the file to skip.  Use this option when the dataset does not start on the very first row in the file.|
|Convert Int96 values into|Choose whether time values will be imported as text-based timestamps (e.g., "2016-02-03 12:57:45 AM") or decimal numbers.  Options:  //Timestamps// or //Decimal numbers//.|
<sup>*</sup> Setting can be specified using a [[:parameters|parameter]].\\

\\ 
====Import key-value metadata mode====
There are no settings for the //Import key-value metatdata// mode of this action.  The resultant dataset will contain the columns //Keys// and //Values// that contain the key-value metadata pairs contained within the file, if any.

\\ 
=====Remarks=====
This action can import multiple files.  See [[import:fileimportmodes|Importing Multiple Files]] for more information.\\ 

\\ 
=====Shortcuts=====
Fast ways to create the action:
  * Press the "Add data" menu button. Pick "Import file" or "Import multiple files".
  * Drag an Apache Parquet file into the application window. Supported file extensions: .parquet
  * Drag a folder with Apache Parquet files into the application window.