Channels
pulumi-ai
package-authoring
pulumi-cdk
oracle-cloud-infrastructure
learn-pulumi-events
linen
registry
built-with-pulumi
pulumi-cloud
contribex
testingtesting321
hacktoberfest
cloudengineering
yaml
pulumi-crosscode
content-share
finops
multi-language-hackathon
office-hours
workshops
blog-posts
localstack
welcome
gitlab
pulumi-kubernetes-operator
jobs
aws
pulumi-deployments
dotnet
golang
announcements
java
pulumiverse
python
install
getting-started
cloudengineering-support
testingtesting123
hackathon-03-19-2020
typescript
google-cloud
contribute
azure
kubernetes
docs
automation-api
status
general
Title
i
icy-laptop-27867
02/21/2023, 4:52 PMHi community,
Has anyone dealt with slow Snowflake table updates via pulumi?
For instance, our database has around 300 tables where some tables have very many columns. Sometimes when we add new columns to these tables, the process may take a long time to complete (2 hours) or the process may ultimately time out. Some of these tables that take a long time have little to no records.
Executing SQL commands to add new columns are instant, so we were wondering what could be the difference? I'm wondering if it's the number of tables that need to be updated concurrently that is the limiting factor.
We're using
v4.0.0I think I may have found the issue. Screenshot shows five spans. Each span refers to a table being updated. As you can see it's occurring synchronously. Is there a way to execute this update in parallel?