To load Parquet files to QlikSense in Qliksense Enterprise for Windows version May 2023

[VidyaSerudla]

Hi Team,

We have a requirement to load Parquet files to Qliksense. However since its a Qliksense Enterprise version, Qliksense native does not support parquet files by default.  After checking in the help documentation , there is a link provided to enable, however the link doesn't work and we get a message the page/link could have been deleted. If anyone has loaded Parquet files to Qliksense enterprise version, please share your notes on how can  achieve in our systems.

Thanks for the support.

Regards,

Vidya S

#Parquet file load

[hugo_andrade]

Hi @VidyaSerudla , 

That feature is available on more recent releases of Qlik. You are one release behind the first release that contained it.

If you upgrade to August 2023, you should be able to load Parquet without issues. I've added the store command reference so you can understand how to save into parquet.

Ideally, you would upgrade to the newest version of the software, so you could leverage all the bug fixes and new features. May 2023 release is out of support already. 

https://help.qlik.com/en-US/sense/August2023/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptRegula...

Please mark as solved if I manage to help you. Thanks

[VidyaSerudla]

Hi @hugo_andrade ,

Thank you for the quick reply. Sure, we will try to test with the Aug 2023 release.

Hope similar to the ''Store'' command ,''Load" also works with Parquet files.

Thanks and Regards,

Vidya S

[hugo_andrade]

Hi @VidyaSerudla ,

Yes, that will. The Load command has no secrets, just point it and load them. 👍

Here's an official note I've found to help you:

Qlik Sense Enterprise on Windows August 2023 has introduced support for parquet files. Support for parquet files is enabled by default but is only valid for newly generated apps.

To enable parquet files, they will need to be allowed as sources. We will use QlikSenseCLI in our example.  QlikSenseCLI is shipped with Qlik Sense Enterprise on Windows since May 2023. 

1. Open Powershell ISE as administrator

2. Import the QlikSenseCLI module in the current Powershell session:

   1. Open the folder within Powershell ISE: C:\Program Files\Qlik\Sense\Tools\qlik-installation-tools

   2. Open and run ImportQlikSenseCLIModule.ps1

   3. This will print an about API output on successful run:
      
      SchemaPath : About
      BuildVersion : 31.34.0.0
      BuildDate : 6/13/2023 10:08:17 AM
      DatabaseProvider : Devart.Data.PostgreSql
      NodeType : Central
      SharedPersistence : True
      RequiresBootstrap : False
      SingleNodeOnly : False
      ExtensionData :
      
      

3. Run the Parquet Whitelist Script: AddParquetExtentionWhitelistTable.ps1

You can now use parquet files in existing apps.

Reference: https://community.qlik.com/t5/Official-Support-Articles/Enable-parquet-file-support-for-existing-App...

Please mark as Solved if applicable.