DBeaver is a SQL client software application and a database administration tool. I have started to use it to do my data work across the platforms like MS SQL Server, Snowflake, etc since last year. I really like its interface design (maybe becuase it looks like MS SQL studio’s which I am familiar with) and its data import/ export functionalities.
In this article, I am going to share how to import the data into Snowflake from MS SQL Sever.
Required Software/ Drivers:
- Dbeaver Community
- Snowflake / MS SQL Server connection
Steps (MS SQL Server -> Snowflake)
0.In Snowflake, create a table with the same structure of MS SQL server.
1.Right click on the created table and select “Import Data”
2.In “Source type and format”, double click on “Table” (Database table(s)).
3. In “Data Transfer”, double click on the “<none>” under “Source” and it will ask you to select a source table that resides in MS SQL Server.
4. You can save it as a task so it can be rerun automatically and regularly in the futrue.
5. Run it and check if the data is imported successfully.
Thank you and enjoy it :)
