Add Parquet data format as input & output

[Cristian]

Please add Parquet data format (https://parquet.apache.org/) as read-write option for Alteryx.

Apache Parquet is a columnar storage format available to any project in the Hadoop ecosystem, regardless of the choice of data processing framework, data model or programming language.

Thank you.

Regards,

Cristian.

[DurgaS]

@RM1

I posted version2 of the solution in the KB.

It uses the Post Create SQL Statement to alter the table to parquet format  "ALTER TABLE table_name SET FILEFORMAT PARQUET;"

Try that.

[DurgaS]

 @RM1

https://community.alteryx.com/t5/Alteryx-Knowledge-Base/Access-Data-in-Parquet-Format/ta-p/80941

[ks3lam]

I tried to access the information DurgaS shared above, but failed.  

Will product team review this and see if we can make this part of Alteryx Roadmap?  Cheers!

[rrikkala]

Please add Alteryx ability to read .parquet files from apache spark. 

[simonaubert_bd]

Hello,

Just to say that Qlik Sense is now able to read and write parquet file while Alteryx is still unable to do it.

Frankly, that's a shame since parquet has became a standard widely used these last years.

[harsh_alang]

We are looking into adding support for Parquet in 24.1

[simonaubert_bd]

Hello @harsh_alang great news, thanks

[SeanAdams]

That is an important and valuable addition!

[vcarey]

This feature would be very much appreciated.

Using the Python tool for export is at this point unwieldy as you have to have the file loaded in Alteryx then load again in the Python tool, which is very memory intensive

[GRogers2]

This is a valuable addition but why was support for this format not added to the S3 connector tools?  Parquet is a common format on S3.  S3 connectors seem neglected overall and are missing more than one QoL feature that the input/output tools have.  (Dynamic file name by appending a field, parquet, etc.).  Support for these features for AWS users with data in S3 would be appreciated.