CODEWITHSUNDEEP
snowflake-cloud-data-platformsnowflake-schema
Nicky
Nicky

Reputation: 115

In Snowflake which interfaces can be used to create and/or manage Virtual Warehouses?

A. The Snowflake Web Interface (UI) B. SQL commands C. Data integration tools

Do Data Integration tools used for creating Virtual Warehouse. "A" and "B" are correct but for "C" I am little bit confused.

Upvotes: -1

Views: 1564

Answers (3)

Robert Long
Robert Long

Reputation: 6897

I think you might be studying for the SnowPro certification, and this is one of the "practice questions" ?

I think a little care might be needed with this one. Snowflake do put a few "trick" questions in these exams.

So, some data integration tools can create and manage Snowflake virtual warehouses. The answer by @MichaelGolos includes a link to PDI's documention:

In PDI, you can create, modify, and even delete a Snowflake virtual warehouse to help you automate your virtual warehouse scaling activities. These orchestration entries include:

Create Snowflake warehouse You can use this job entry to create a Snowflake virtual warehouse. You can set size, scaling, automated suspension, and other properties for your warehouse.

Modify Snowflake warehouse Once you create a warehouse, you can edit its settings using this job entry. Modifying a warehouse is useful if your users typically perform simple queries and only require a small warehouse. However, to meet your ETL service-level agreements (SLA), you may need a larger warehouse during the ETL process. Using this job entry, you can modify the warehouse at the beginning of the ETL process to scale it up, and then modify it to scale it back down when the ETL process is complete.

Delete Snowflake warehouse Use this job entry to delete virtual warehouses. Deleting unwanted virtual warehouses helps you clean up the Snowflake management console.

HOWEVER, pay careful attention to the wording of this question:

In Snowflake which interfaces can be used to create and/or manage Virtual Warehouses?

where I have added bold emphasis.

The kind of orchestration that PDI and other tools provide is not In Snowflake - it is a 3rd party tool, and therefore is outside Snowflake. So, in my opinion the answer to this question is NO.

Upvotes: 0

Michael Golos
Michael Golos

Reputation: 2069

Of course there are integration tools that support the management of Virtual Data Warehouses. One example might be Pentaho, please see this article in Hitachi documentation: PDI and Snowflake

Upvotes: 2

NickW
NickW

Reputation: 9798

I’m not entirely sure what the actual question is that you are asking but…

Could a data integration tool manage warehouses? Yes

Do some data integration tools actually do this? Yes

Do all data integration tools do this? No

Upvotes: 1

Related Questions