{"id":600,"date":"2025-01-30T05:49:08","date_gmt":"2025-01-30T05:49:08","guid":{"rendered":"https:\/\/datadandies.nl\/?p=600"},"modified":"2025-01-30T05:49:08","modified_gmt":"2025-01-30T05:49:08","slug":"using-snowsql-to-load-larger-files-from-your-local-machine","status":"publish","type":"post","link":"https:\/\/datadandies.nl\/index.php\/2025\/01\/30\/using-snowsql-to-load-larger-files-from-your-local-machine\/","title":{"rendered":"Using SnowSQL to load larger files from your local machine"},"content":{"rendered":"\n<p>SnowSQL is the Command Line client for connecting with Snowflake.<\/p>\n\n\n\n<p>After connecting, you can use SnowSQL to execute SQL queries and perform DDL and DML operations.<\/p>\n\n\n\n<p>However, with SnowSQL being a CLI, it is not as easy to use as SnowSight (the browser-based UI of Snowflake).<\/p>\n\n\n\n<p>That being said, a recent course taught me a good reason to use SnowSQL: when uploading a file (from your local computer) using SnowSight, there is a file limit of 250 MB\/file.<\/p>\n\n\n\n<p>When using SnowSQL, that file limit is not there! You can upload a file using SnowSQL and the PUT command to a staging area and the file size can exceed 250 MB!<\/p>\n\n\n\n<p>This can prove useful in some cases. As a sidenote: remember that if you would like the best load performance, file sizes of 100-250 MB are recommended in order to optimize the number of parallel operations.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>SnowSQL is the Command Line client for connecting with Snowflake. After connecting, you can use SnowSQL to execute SQL queries and perform DDL and DML operations. However, with SnowSQL being a CLI, it is not as easy to use as SnowSight (the browser-based UI of Snowflake). That being said, a recent course taught me a&hellip;<\/p>\n<p class=\"more-link\"><a href=\"https:\/\/datadandies.nl\/index.php\/2025\/01\/30\/using-snowsql-to-load-larger-files-from-your-local-machine\/\" class=\"themebutton\">Read More<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[40,59],"class_list":["post-600","post","type-post","status-publish","format-standard","hentry","category-blog","tag-snowflake","tag-snowsql"],"_links":{"self":[{"href":"https:\/\/datadandies.nl\/index.php\/wp-json\/wp\/v2\/posts\/600","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/datadandies.nl\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/datadandies.nl\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/datadandies.nl\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/datadandies.nl\/index.php\/wp-json\/wp\/v2\/comments?post=600"}],"version-history":[{"count":1,"href":"https:\/\/datadandies.nl\/index.php\/wp-json\/wp\/v2\/posts\/600\/revisions"}],"predecessor-version":[{"id":601,"href":"https:\/\/datadandies.nl\/index.php\/wp-json\/wp\/v2\/posts\/600\/revisions\/601"}],"wp:attachment":[{"href":"https:\/\/datadandies.nl\/index.php\/wp-json\/wp\/v2\/media?parent=600"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datadandies.nl\/index.php\/wp-json\/wp\/v2\/categories?post=600"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datadandies.nl\/index.php\/wp-json\/wp\/v2\/tags?post=600"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}