Thanks for excellent video explaining sf connection to python env. below are my 2 cents cmds in video are outdated now. below cmds helped. pls pin this reply, could be helpful to others launch ur virtual env. Then fire below cmds ---- pip install pyarrow pip install snowflake-connector-python[pandas] pip freeze > requirements01.txt
Hi, I was wondering what are the trade offs between making an app using the snowflake ❄️ python connector and directly putting files on an internal stage from a server or taking a different approach and using an external stage like s3 instead?
Thank you very much for all your great videos ! 🙏 Can you please share your scripts & slides too .. That would be very helpful for the preparation & revision ! 🙏
when I'm trying to run pip install -r requirements.txt then not able to install getting the following error: --- note: This error originates from a subprocess, and is likely not a problem with pip. error: subprocess-exited-with-error × pip subprocess to install build dependencies did not run successfully. ----
while loading data via python and do some transformations (let's say for huge rows of data transactions), does it took so much cost, how do calculate/monitor it, so it could prevent for over billing.
added in my list... will make .. Data Modeling is a common topic, what challenges you are facing (if youtube comment box is small, you can share your thought via instagram instagram.com/learn_dataengineering/)
I'm trying to connect to Snowflake using python using RSA private key method. But I'm getting this error. Can you please help. OSError: [Errno 22] Invalid argument: '/rsa_key.p8'
Thanks for excellent video explaining sf connection to python env. below are my 2 cents
cmds in video are outdated now. below cmds helped. pls pin this reply, could be helpful to others
launch ur virtual env. Then fire below cmds
----
pip install pyarrow
pip install snowflake-connector-python[pandas]
pip freeze > requirements01.txt
The Snowflake tutorials are very helpful and developer friendly. Thanks for preparing such wonderful contents.
You're very welcome!
i have seen from chapter one to chapter 24 part 3 all your videos are very good, Thankyou so much for creating such a wonderful resource
Thanks and welcome
Very well explained.. Kudos to you and your commitment
Thank you so much 🙂
very informative video. do you give a quick tutoring session too?
Hi, I was wondering what are the trade offs between making an app using the snowflake ❄️ python connector and directly putting files on an internal stage from a server or taking a different approach and using an external stage like s3 instead?
Thank you very much for all your great videos ! 🙏 Can you please share your scripts & slides too .. That would be very helpful for the preparation & revision ! 🙏
How do I combine data that is in different roles in snowflake?
Hi Sir, Could you please work on Python file conversion concepts(file handling)
when I'm trying to run pip install -r requirements.txt then not able to install getting the following error:
---
note: This error originates from a subprocess, and is likely not a problem with pip.
error: subprocess-exited-with-error
× pip subprocess to install build dependencies did not run successfully.
----
while loading data via python and do some transformations (let's say for huge rows of data transactions), does it took so much cost, how do calculate/monitor it, so it could prevent for over billing.
Not exactly... the transformation happens in your local runtime... unless you push it to snowflake
Hi Sir, Which IDE is good to use python for snowflake ?
Depends.. VSCode is lighter.. and you can also use pycharm...
Hi Can you please create video for snowflake with Tableau/ PowerBI
will do it soon.. nobody has ever asked.. so never completed them..
Sir kindly ask you do one video Data modeling in snowflake
added in my list... will make ..
Data Modeling is a common topic, what challenges you are facing
(if youtube comment box is small, you can share your thought via instagram instagram.com/learn_dataengineering/)
Hello Sie,
Can you please provide that requirement.txt file. I stuck there
this is how it looks like
snowflake-connector-python
pandas
pyarrow=8.0.0
I'm trying to connect to Snowflake using python using RSA private key method. But I'm getting this error. Can you please help.
OSError: [Errno 22] Invalid argument: '/rsa_key.p8'