Snowflake Data Reader displays wrong number of warehouses

Question

Context: I am using trial version of Enterprise Edition of Snowflake;

1) Created a database and table with some data and warehouse COMPUTE_WH 2) created reader account and shared table to that reader account and warehouse to use as data consumer : TEST_WH

when i see as an Account admin logged in as in step1; i see two warehouses; count but displays only one warehouse and the same when i login as data consumer dispays 2 warehouses and dispays "TEST_WH"

in sceanrio : 1) I am provider of the data and data sharing to another reader account and created warehouse for the data consumer; I want to track how much Provider account warehoused used and also how much data consumers are spending credits;

There are 2 issues here : - Why the data consumer account displays two warehouses but as per that account it is only 1 warehouse being created and used; - Data Provider account says two warehouses but does not display warehouse "test_wh" credits usage. Has any observed this?

Answer 1

It is not clear how you can create a warehouse and share it with the consumer account. The Consumer account admin needs to create a warehouse and use it for data processing requests.

Can you kindly update this space with the steps that you performed in sharing the warehouse from the provider account?

In general, the virtual warehouses created by the consumer ma consume credits, which will be charged to your provider account. If you wish to control the amount of credits consumed monthly by the virtual warehouses in the reader account you can use the resource monitor to configure.

Ref : https://docs.snowflake.com/en/user-guide/data-sharing-reader-config.html#task-4-create-resource-monitors-optional