question about virtual-warehouses

[hillbun]

https://byconity.github.io/docs/deployment/deploy-k8s#add-new-virtual-warehouses

CREATE WAREHOUSE IF NOT EXISTS `my-new-vw-default` SETTINGS num_workers = 0, type = 'Read';
CREATE WAREHOUSE IF NOT EXISTS `my-new-vw-write` SETTINGS num_workers = 0, type = 'Write';

1. why the num_workers is 0, but not 1 or others?
2. If I create table without SETTINGS cnch_vw_default = 'my-new-vw-default', cnch_vw_write = 'my-new-vw-write';
   , what's default value?

[Clark0]

1. The number of workers in the warehouse does not determined by num_workers setting here, but dynamically determined by the heartbreaks send from workers to the resource manager. so here num_workers can leave it as 0.
2. the default value will be vw_default and vw_write

[hillbun]

if WAREHOUSE type = 'Default', that means both Read and write?

select * from system.virtual_warehouses;
┌─name───────┬─uuid─────────────────────────────────┬─type────┬─active_worker_groups─┬─active_borrowed_worker_groups─┬─active_lent_worker_groups─┬─last_borrow_timestamp─┬─last_lend_timestamp─┬─auto_suspend─┬─auto_resume─┬─num_workers─┬─min_worker_groups─┬─max_worker_groups─┬─max_concurrent_queries─┬─max_queued_queries─┬─max_queued_waiting_ms─┬─vw_schedule_algo─┬─max_auto_borrow_links─┬─max_auto_lend_links─┬─cpu_threshold_for_borrow─┬─mem_threshold_for_borrow─┬─cpu_threshold_for_lend─┬─mem_threshold_for_lend─┬─cpu_threshold_for_recall─┬─mem_threshold_for_recall─┬─cooldown_seconds_after_auto_link─┬─cooldown_seconds_after_auto_unlink─┐
│ vw_default │ 6f77204e-439a-4192-8522-d460cd16f1b9 │ Default │                    1 │                             0 │                         0 │   1970-01-01 00:00:00 │ 1970-01-01 00:00:00 │            0 │           1 │           1 │                 0 │                 0 │                      0 │                  0 │                  5000 │ Random           │                     0 │                   0 │                      100 │                      100 │                      0 │                      0 │                      100 │                      100 │                              300 │                                300 │
│ vw_write   │ 644e07a3-6a24-4c03-8875-0d50d57adc41 │ Write   │                    1 │                             0 │                         0 │   1970-01-01 00:00:00 │ 1970-01-01 00:00:00 │            0 │           1 │           1 │                 0 │                 0 │                      0 │                  0 │                  5000 │ Random           │                     0 │                   0 │                      100 │                      100 │                      0 │                      0 │                      100 │                      100 │                              300 │                                300 │
└────────────┴──────────────────────────────────────┴─────────┴──────────────────────┴───────────────────────────────┴───────────────────────────┴───────────────────────┴─────────────────────┴──────────────┴─────────────┴─────────────┴───────────────────┴───────────────────┴────────────────────────┴────────────────────┴───────────────────────┴──────────────────┴───────────────────────┴─────────────────────┴──────────────────────────┴──────────────────────────┴────────────────────────┴────────────────────────┴──────────────────────────┴──────────────────────────┴──────────────────────────────────┴────────────────────────────────────┘

[Clark0]

type = Default means read worker

[WillemJiang]

@Adora627 Can we move it to the discussion with answer marked?

[Adora627]

@Adora627 Can we move it to the discussion with answer marked?

sure, I'm migrating frequent asked questions to discussion. Feel free to do it if you're sure about answer as well