Home » Snowflake

Bookmark · Report · More actions.. Lock comments · Pin thread

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

Post Comment

nVector25-Aug-20

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

ReplyMore..ReportDelete

vinaygupta-net-gmail-com29-Aug-20

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)

ReplyMore..ReportDelete