Alteryx Designer Ideas

Share your Designer product ideas - we're listening!
Submitting an Idea?

Be sure to review our Idea Submission Guidelines for more information!

Submission Guidelines

Add Parquet data format as input & output

Please add Parquet data format ( 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.




7 - Meteor

Parquet format is getting increasingly popular in the hadoop world day by day.Ability to read/write this format from/onto NFS, HDFS storage adds a lot of value to the product.




6 - Meteoroid

Hi Guys.


Any progress since 2015?


You'll really benefit of supporting parquet for BDE.

17 - Castor
17 - Castor

Hey all,

Not sure about Parquet directly, but we have successfully tested using a Kudu database (which is also a columnar database in the Apache stack) and also using Spark SQL.   That may give you a route into Parquet?

5 - Atom

Hi we are just now evaluating Alteryx and I was curious as to how to add parquet as a file input/output format?



Alteryx Alumni (Retired)

Hi @Rajabhathor,


Data in parquet format can be stored in hive tables and accessed from the Alteryx Designer via the hive ODBC driver.

Create a table in hive with "STORED AS PARQUET" for hive 0.13 and later.
Alteryx can read and write data from these tables with the hive ODBC driver.

Check the create table syntax in this article

For files already stored in the "PARQUET" format in HDFS, use "LOAD DATA" to load the data in the HDFS file to a table in hive.

To write results of an Alteryx workflow back to a hive table in the PARQUET format, use ""hive.default.fileformat=PARQUET” in the Server Side Properties ODBC driver configuration


Hope these help.

6 - Meteoroid

Thank you, Durga S.

Unfortunately, this is a very weak suggestion. ODBC is capable of a simple things but the need is to upload cca 50 Gb file in compressed columnar storage format.

8 - Asteroid

Hi all, 


Do you have any updates about the subject ? We are looking forward to be able to read/write easily Parquet data format !



Alteryx Alumni (Retired)
Status changed to: Not Planned



Thanks for the idea. Other than the ODBC option mentioned by Durga we don't have plans to add parquet support as our engine is not optimized to handle columnar data at this time.




9 - Comet

"as our engine is not optimized to handle columnar data at this time"

Runs on all flavors of Windows, Linux, and mobile devices (iOS, Android) via Xamarin



5 - Atom



We tried setting up server side properties for PARQET but somehow its not working Alteryx still creating table with Text format and not Parquet. We are using Hive 1.2 version. I tried writing in tables using both way (through IN DB and through Out Tool).


Can you suggest if any thing else need to change.