Load data in Snowflake without writing code

At Snowflake, we know that you need to quickly and confidently load your data so you can analyze it. With just a few clicks in the Snowsight web interface, you can load local files or files from cloud storage directly into a table. In this blog, I’ll show you three major features available today in Snowsight.

Create a table from a file (public preview)

When experimenting with new data, you don’t want to slow down and manually create a table with data types for each column. Using new capabilities in Snowflake, all you need to do is upload the file — Snowflake does the rest, so you can get back to exploring.

Snowflake infers the schema and creates the table for you, but you’re always in control of your schema. You can still change column names and data types before creating the table.

Load local files into a table (general availability)

Getting data files from your laptop into a Snowflake table is easy with the Load Data feature in Snowsight. Navigate to the table you want to add data to, select the files to upload, pick a file format, and load the table.

Load files from cloud storage (general availability)

Loading data from cloud providers like AWS, Azure, and GCP is also a breeze. Leave your files where they are and connect Snowflake to them by creating an external stage. Now, you can load the files into a new or existing table or reference them directly using SQL.

When it comes to simplifying data ingestion, we are just getting started! Stay tuned for more updates.

Interested in joining our growing team? Apply for a position on our team here.