Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

BUG: Can't alter parameter initially_suspended after warehouse creation. #99

Closed
aleenprd opened this issue Aug 26, 2024 · 3 comments
Closed
Assignees
Labels
bug Something isn't working

Comments

@aleenprd
Copy link

invalid property 'initially_suspended' for 'WAREHOUSE'
snowflake.connector.errors.ProgrammingError: 001420: failed to execute sql, [ALTER WAREHOUSE TITAN_TEST_WH SET initially_suspended = True]

Also, why would titan want to modify this warehouse since it was already created in the previous apply, and I didn't change anything on it?
SHOW PARAMETERS FOR WAREHOUSE TITAN_TEST_WH (3 rows, 0.12s)

@aleenprd
Copy link
Author

@neehhaa06 as a suggestion, I think Titan should have the following workflow. If warehouse exists, exclude initially_suspended parameter. That's point 1. Point number 2 is: why does it want to alter the existing warehouse when I didn't modify its resource definition in the first place? This seems like a bug to me.

@aleenprd
Copy link
Author

aleenprd commented Aug 27, 2024

@neehhaa06 what configuration can I check precisely? There are no logs to check for debugging purposes, as far as I can tell. And there is no configuration for the blueprint other than run_mode which is set to create-or-update.

This is my existing warehouse:
image
And these are the logs from the plan:

~ urn::XXX:warehouse/TITAN_TEST_WH {
  ~ query_acceleration_max_scale_factor = None -> 1
}

~ urn::XXX:warehouse/TITAN_TEST_WH {
  ~ scaling_policy = None -> "STANDARD"
}

~ urn::XXX:warehouse/TITAN_TEST_WH {
  ~ min_cluster_count = None -> 1
}

~ urn::XXX:warehouse/TITAN_TEST_WH {
  ~ max_cluster_count = None -> 1
}

However, if I also run SHOW PARAMETERS FOR WAREHOUSE TITAN_TEST_WH; we can only see:
image
which is probably not sufficient for Titan to know what the actual rest of the parameters of the warehouse are.

@teej teej added the bug Something isn't working label Sep 4, 2024
@teej teej self-assigned this Sep 4, 2024
@teej
Copy link
Collaborator

teej commented Sep 27, 2024

Fixed in v0.9.

@teej teej closed this as completed Sep 27, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

4 participants
@teej @aleenprd and others