CODEWITHSUNDEEP
snowflake-cloud-data-platform
Rajesh
Rajesh

Reputation: 21

Tools to create and update snowfalke tables

Is there any tool to compare a table with a base table and generate an alter script? once the alter script is generated, using the same alter script it should update the base table.

Thanks in advance.

Upvotes: 0

Views: 94

Answers (1)

Bryan
Bryan

Reputation: 158

I wish there was. A lot of us are looking for that magic tool right now. As of right now, there are no tools that do true Schema compare. At least not very well. There are some tools that attempt to do this but make some assumptions under the hood that are sometimes not good assumptions. DBeaver does a little bit of this Data Grip is another tool. There are a couple more out there but again, many of these tools are assuming Snowflake is like all the other databases, which leads to bad scripts.

Upvotes: 1

Related Questions