Two persons with same roles (sysadmin) trying to change warehouse size ata same time? Which user instructions will execute first?
What will happen same role persons are trying to change the warehouse size at same time in snowflake?
97 Views Asked by Chanikya At
1
There are 1 best solutions below
Related Questions in SNOWFLAKE-CLOUD-DATA-PLATFORM
- Snowflake subquery
- Error in granting ownership in snowflake tables
- Snowflake - Performance when column size is not specified
- snowflake json lateral subquery
- Looking to either Explode or unnest into an array in Snowflake SQL
- I am getting a Pipe Notifications bind failure
- How does run queue work in Snowflake? Is there a concept timeslice at all?
- TO_CHAR and SSSS (hours past midnight)
- Snowflake warehouse cache
- Power bi snowflake Default_role setting
- Error when installing `snowflake-connector-python` to GCP Cloud Composer
- How to Restart & Run All code if there is a Key Error during a ! pip install in Google Colab?
- Count number of records based on last updated date + null
- Task without Virtual Warehouse: Is the query failing or the task not starting?
- Need to include the offset value as expr in LAG functions
Related Questions in WAREHOUSE
- TFS2015 modified Scrum Template Tfs_Warehouse DimWorkItem System_WorkItemType always null
- SQL server - realtime and historical dashboard reading form tables
- Data warehouse Architecture for multiple SQL database
- Snowflake - Warehouse Node Utilization data?
- access barcode scanners output?
- SSIS staging truncate warehouse
- Why I'm getting '000606 (57P03): No active warehouse selected in the current session. Select an active warehouse with the 'use warehouse' command.'
- What will happen same role persons are trying to change the warehouse size at same time in snowflake?
- Is single table with multiple updates better than multiple tables inserted at different times in Redshift
- MySQL - COUNT for rows with the same name
- Automation of Oracle cloud application (like OTM,CPQ, WHM etc)
- TFS Data Warehouse Problem extracting Test Run history - extra rows in FactTestResult table (PointID, ChangeNumber)
- dbload vs insert in db2wh, which is better to use for loading data and what are the differences between these two
- What JS library would you use to create an interactive custom map
- how are Updates and Deletes handled in both Data Warehouses and Data Lakes?
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
like every one else, there is no same time...
But also the warehouse resize is handled by the service layer, so there is an order there. I would assume the resize command for the second would be ignored, as it is "already in the process of a resize to the same size" if the sizes are different I would assume/hope the "last wins" but also could see the second getting an error with a resize is underway.
This is all based on the fact, that a resize leave the existing servers running while they complete, and starts queued/new queries on the new servers. Which firstly has to be spun up. So this is really a slow (in computer time) operation. And thus it's not a wild +1 type thing, as you explicitly set the size to something.