Recently, Snowflake has gained momentum in the cloud data warehousing space. Snowflake offers a cloud-based data storage and analytics service, generally known as “data warehouse-as-a-service”. It lets corporate users store and analyze data using cloud-based hardware and software. Snowflake table stores data and there are three types namely: permanent, transient, and transient table. Snowsql is a command-line client used to connect to Snowflake to execute SQL queries and perform all DDL and DML operations. These operations include loading data into and unloading data out of database tables.
You might be wondering how you can transfer data from your local machine into Snowflake. There are a few ways to load data from your computer into the Snowflake table but we would be using Snowsql in this article. Let’s jump right into it.
To use Snow SQL you will need to install it on your PC.
You can download SnowSQL for your platform from the Snowflake repository. It is available for Windows, Linux, and macOS.
Below is the index of SnowSQL
COPY INTO TESTING
FROM @cndro_stage
FILE_FORMAT = (type = csv field_optionally_enclosed_by=’”’)
PATTERN = ‘.*SnowflakeDatatesting.csv.gz’
ON_ERROR = ‘skip_file’;
You should have your table like this. We are working on the worksheet’s editor console, please see the screenshot.
Final Thoughts
In today’s guide, we walked through how you can load data into Snowflake table using SnowSQL Client. Kindly share and follow for more articles. Thanks for reading and see you next time.
No Comments