databricks connect to SQL db

[@amitpandey1873]

Very nice representation of using JDBC for connecting Azure SQl DB from Azure Databricks.

[@JL-qc5gq]

We can do read and write to azure sql table and other tables in databricks via JDBC. But how can we do update or delete on the same tables?

[@paarveandankathirvel3891]

can we delete table in azure sql database from databricks using scala?

[@sheebapradhan2138]

Thanks for sharing. I want to delete records from azure sql which prior to 13 months. How can we implement that?

[@KnowledgeSharingjkb]

you can use the queries instead of table. i can provide the video later

[@roshandhamala6301]

Are you creating any videos reading data from REST api?

[@KnowledgeSharingjkb]

Yes it is there in my channel

[@ramum4684]

Hi sir thanks for the vedio. Now I have a scenario. We have multiple source and save all these source's login details in excel - which is called control table - with azure key vault name for pwd and security token. Now using a single pyspark script we have connect dynamically using the azure keyvalut details and load data into adls gen2. How we can. Need reply asap. Thanks in Advance Ram

[@lakshmigargipati784]

Hi,while iam trying to connect databricks to ssms iam getting error like this:The tcp/ip connection to the host and failed to port how to resolve this error.

[@KnowledgeSharingjkb]

looks like it is network issue. please make sure you have required access and ip whiltelisted

[@xxczerxx]

Is there a reason why you shouldn't do this? I am surprised this isn't encouraged as a best practice which makes me think I'm missing something

[@KnowledgeSharingjkb]

If the data volume is high, it may affect your program performance. ADF will be your best choice for such scenarios

[@ORARAR]

is there a way to connect databricks from Oracle SQL Developer ?

[@KnowledgeSharingjkb]

Didn’t try that. Should be there

[@kirankts7253]

How do you write this in Pyspark?

[@KnowledgeSharingjkb]

Will provide that soon

[@sumayaparvin3631]

can u plz share that code in description

[@KnowledgeSharingjkb]

updated

[@y.c.breddy3153]

Hi Bro How can I connect azure data studio from databricks and databricks to data lake then datalake to snowflake can you help me

[@KnowledgeSharingjkb]

can I know the reason to connect to azure data studio from databricks? I didnt try this method as I dont have any use case

[@tanushreenagar3116]

best