Load parquet file to qliksense desktop

[balajisj30]

Hi People

I have downloaded parquet file to my desktop. I have to load this parquet file to qliksense desktop. Please need your suggestions.

[devarasu07]

Hi,

is it big data hbase source file? if so then u can try this article steps, Thanks,

https://www.simba.com/drivers/hbase-odbc-jdbc/

Using Qlik Sense with Drill - Apache Drill

[balajisj30]

can we load parquet files from Amazon S3 to qliksense

[devarasu07]

Hi,

yes. have you checked this article?

Using Amazon S3 with Qlik Sense

[petter]

To read Parquet files you could use Apache Drill and the Windows ODBC-driver for Drill:

Installing the Driver on Windows - Apache Drill

It will give you support for both Parquet and Amazon S3.

[cookiejest]

Hi! We recently built a tool to do direct streaming of data to Qlik from Parquet files using the standard Qlik REST connector called Cloudslurp.

Just create an account and link your S3 bucket, Dropbox or upload your Parquet file. Then you can start doing SQL based queries to the file and then use the standard REST connector in Qlik to load data into your app. It has the added benefit of being able to filter down large Parquet files to smaller data sets so you can significantly reduce your app reload time.

The API call you use in the Qlik REST connector looks like this:

https://api.cloudslurp.com/data?token=YOURTOKENHERE&query=SELECT * FROM cldslp1."yellow_tripdata_2022-01.parquet";

You can copy and paste this for your exact data set by clicking on the 'Code' button: