Qlik Compose vs Snowflake Datawarehouse

[deepaksahirwar]

Dear All ,

Subject: Qlik Compose vs Snowflake Datawarehouse

Scenario: For particular business,  Qlik Compose is implemented as an ETL tool . Where target datawarehouse is Snowflake.

Snowflake itself provides ETL services and have all abilities of Datawarehouse. It also provides Softwares As a Services where we no need to worry about infrastructure nor any setup and installations.

Where in Qlik Compose, we do requires the high ruggedized servers,installation, maintenance & licensing.

Query: Why though most of the business use Qlik Compose as Datawarehouse instead of Snowflake ?

Thanks in advanced.

Regards,

Deepak

[Nanda_Ravindra · Accepted solution]

@deepaksahirwar  While you can do all of those you mentioned manually, our Qlik Compose can automatically generate the task statements, data warehouse structures, and documentation your team needs to efficiently execute projects while tracking data lineage and ensuring integrity. Also, Qlik Compose supports both Data Warehouse and Data Lake in one product, where you can ingest data from multiple sources to your data lake for further downstream processing.

Qlik Compose uses a model-driven approach to quickly design and builds data warehouses on-premises or in the cloud. You can leverage our tool to provide fast, flexible delivery of information for Big Data Analytics and Business Intelligence (BI) projects such as:

• Building a new data warehouse
• Migrating an existing data warehouse to a new platform
• Expanding an existing data warehouse with new data feeds
• Generating data marts for lines of business

If you need more information and like to have a product demo, please visit our website or contact your account representative for a demo.

Here is a link for a quick demo on the product:

https://www.qlik.com/us/data-warehouse-automation

Thanks,

Nanda

[deepaksahirwar]

Hello @Nanda_Ravindra ,

The content you posted is  helpful and also accepted it as a solution.

But still wants to understand bit more "Does Snowflake don't have that capacity what Qlik Compose have?"

For compose we need high commodity hardware for installations and licenses where snowflake will provide "Softwares as a Services" .

I mean does processing of data and ETL activites , operations speed differs lot when comparing both?

[Nanda_Ravindra · Accepted solution]

@deepaksahirwar yes, our Compose has some of the capabilities that snowflake doesn't provide like automated ETL and DataMart generation and documentation your team needs for downstream applications. You cannot do these in snowflake without doing some additional work.

I agree that our Compose needs ruggedized servers, installation, and maintenance. That being said we also provide Qlik compose as Saas. It is not available for the general audience yet. The services are still under development and are only available as a technical preview.  I recommend reaching out to your account representative to learn more.

Hope this helps!

Thanks,

Nanda

Nanda

[deepaksahirwar]

Dear @Nanda_Ravindra ,

Thank you for great clarifications on my query.

Best Regards,

Deepak Ahirwar