Read/Write Data from Snowflake in Databricks

If you need any guidance you can book time here, topmate.io/bha...
Follow me on Linkedin
/ bhawna-bedi-540398102
Instagram
www.instagram....
You can support my channel at: bhawnabedi15@okicici
Data-bricks hands on tutorials
• Databricks hands on tu...
Azure Event Hubs
• Azure Event Hubs
Azure Data Factory Interview Question
• Azure Data Factory Int...
SQL leet code Questions
• SQL Interview Question...
Azure Synapse tutorials
• Azure Synapse Analytic...
Azure Event Grid
• Event Grid
Azure Data factory CI-CD
• CI-CD in Azure Data Fa...
Azure Basics
• Azure Basics
Data Bricks interview questions
• DataBricks Interview Q...

[@naren06938]

Amazing session....Rockz...

[@thedatamaster]

Thank You so much ma’am. Request you to start tutorial on snowflake.

[@100sabh]

For people who don't know , Snowflake is the direct competetor for Databricks and has created nighmares for it. It can do every thing what Databricks can do , and in much fashion better in every aspect . Just for ref, Amazon is moving its warehouse to Snowflake , even they own redshift . Now imaging how powerful and productive Snowflake is.

[@sabyasachipathak5390]

for DataWarehouse and BI workload Snowflakes maybe better fancy or equal , but for ML , AI workload Data bricks is much more matured and advanced.

[@sumansourav1992]

Lol..Databricks has gone beyond with time.

[@rajasekharhadoop5663]

Could please explain what is the feature of snowflake?

[@caiyu538]

Great. Great. Great.

[@padmsrikanth1672]

Thanks,your videos very much helped to me to got job

[@cloudfitness]

Congratulations

[@abhijeetsingh9730]

Question?- we can use databricks delta lakehouse as DWH then in what scenario we process using databricks and use snowflake as DWH

[@malodevinod07]

if you compare cost, you will get your ans.

[@2010saumya]

Very nice video.....but one request why not upload the notebook and put the link in the video description so that we can refer to that

[@kcsvenkat]

Hi,
I'm trying to select data from Snowflake
but getting the below error Please help me to resolve
df=spark.read.format("snowflake").options(**options).option("query", "select * from EMP").load()
display(df)
error :
java.sql.SQLException: Status of query associated with resultSet is FAILED_WITH_ERROR. Results not generated.

[@avuthusivavardhanareddy5178]

TypeError: option() got an unexpected keyword argument 'sfURL' showing this error while connecting through databricks community

[@dcraf14]

Hi, i'm getting the same error. How did you resolve it? Many thanks!

[@debajyotimukhopadhyay1080]

very useful

[@sujitunim]

Thank you for this awesome video. Could you please create video to understand how to read key value pair to manage hardcode from.properties file in azure databricks and log4j implementation to create daily abc_ddmmyy.log file for the job in azure databricks using Scala

[@hussainshaik5365]

hello sir, can you please tell me HOW TO CREATE CONNECT TO DATABRICKS WITH SNOWFLAKE

[@Yamini-rj2nq]

I don't see writing from snowflake, only see reading.

[@Kinnoshachi]

For the record Snowflake sucks and I don’t expect them to survive long term

[@MuideenMuibi]

Hey, what makes Snowflake suck? I think it is a phenomenal product and hands down the very best virtual data warehouse in the market today

[@perryliu6573]

Hello, thanks for your video. Your video really is very clear, instructive, and meaningful! I am following the step in your video. I can read data from Snowflake; however, I am facing an issue writing in Snowflake.
Bowler_Scores_df.write \
.format("snowflake") \
.options(**options) \
.mode("overwrite") \
.option("dbtable", "SAFEGRAPHGEOMETRY.PUBLIC.Bowler_Scores") \
.save()
error message: net.snowflake.client.jdbc.SnowflakeSQLException: SQL execution error: Creating stage on shared database 'SAFEGRAPHGEOMETRY' is not allowed.
Is there anything that I need to set up on the Snowflake side before writing?