Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Suggest an Idea

Announcements
This page is no longer in use. To suggest an idea, please visit Browse and Suggest.

Replicate Synapse Endpoint: Support for Compression

joseph_jbh
Contributor III
Contributor III

Replicate Synapse Endpoint: Support for Compression

When doing a full load to Synapse, Replicate should compress the text file before sending it, similar to the way it can do with a Databricks endpoint.

Synpase supports compression: Here's the doc of COPY INTO: https://docs.microsoft.com/en-us/sql/t-sql/statements/copy-into-transact-sql?view=azure-sqldw-latest

 

Currently, Replicate->Synapse loads take MUCH longer than Replicate->Databricks, and the 90x longer upload speeds of large tables seem to be the biggest culprit.

Tags (1)
3 Comments
Ola_Mayer
Employee
Employee
 
Status changed to: Open - Collecting Feedback
Meghann_MacDonald

From now on, please track this idea from the Ideation portal. 

Link to new idea

Meghann

NOTE: Upon clicking this link 2 tabs may open - please feel free to close the one with a login page. If you only see 1 tab with the login page, please try clicking this link first: Authenticate me! then try the link above again. Ensure pop-up blocker is off.

Ideation
Newbie
Newbie
 
Status changed to: Closed - Archived