24 Aug 20 · jgrover · #Snowflake ·   Bookmark   ×

How to schedule loading of excel file into snowflake?

One of my client is having daily excel data (approx 1 million records). This file need to be loaded into database.Client does not have any IT infrastructure available . I was thinking to recommend snowfalke but bit skeptical about this decision. What you recommend? Also, how data loading for these daily excel can be schedule on snowflake.

jgrover

posted on 24 Aug 20

Enjoy great content like this and a lot more !

Signup for a free account to write a post / comment / upvote posts. Its simple and takes less than 5 seconds




  • The easiest way is to save the excel as csv file
  • Install the snow SQL client on the laptop
  • create a script to load the CSV file into snowflake table

vinaygupta-net-gmail-com

Hi J Grover,

I would suggest please reach out to Snowflake support team - they will provide you the good answer of it. Why I am saying this thing is as you are thinking about to Implement Snowflake in your project or solutions. Or also you may refer Snowflake Document section.

https://docs.snowflake.com/en/user-guide/data-pipelines-examples.html
https://docs.snowflake.com/en/user-guide/tasks.html.

Hope this help (y)


Community Software by Hittly