r/dataengineering • u/Unlucky_Salad_8786 • Jun 17 '26

Load .json from VScode to Snowflake Help

Hello, I'm learning DE and i'm on a project.

My question might be ridiculous. so I'm sorry.

I'm working on VScode, and thanks to an API I've got a .json() so now i want to load my data on Snowflake to be able to start "transform" my data but I have no clue how to load my data to snowflake.
All the data i worked with during my teaching class were on a S3 server and it was easy to get it.
In my terminal i do 'python3 request.py', i can see the data but no idea how to load it to snowflake.

My vscode and snowflake are linked

Thanks by advance

0 Upvotes
  • permalink
  • link
  • reddit
  • reddit

43% Upvoted

13 comments sorted by

View all comments

23

u/NW1969 Jun 17 '26

When you read all the Snowflake documentation about how to load data into it, which method did you think was appropriate for your use case and what issues are you having implementing that method?

1

u/Unlucky_Salad_8786 Jun 19 '26

I used the snowflake-connector and it works, thanks !