Azure Databricks - reading tables with koalas

0 votes
I'm new to Databricks and am doing some basic data exploration using koalas.
When I connect into Databricks, I notice two primary tabs under DATA: DATABASE TABLES and DBFS. I was able to read csv files as koalas dataframes (ksdf=ks.read csv('/FileStore/tables/countryCodes.csv'), but I'm not sure how to read the tables listed under DATABASE TABLES as koalas dataframes. I'm guessing those are SQL tables because none of them have filename extensions.
Mar 29, 2022 in Azure by Edureka
• 12,690 points
758 views

1 answer to this question.

0 votes

You just need to use 

read_table

EX:
ksdf = ks.read_table('my_database.my_table')

answered Mar 30, 2022 by Edureka
• 13,620 points

Related Questions In Azure

0 votes
1 answer
0 votes
1 answer
0 votes
1 answer

Azure analytics insight - issue with user flow display

As far as I know, and according ...READ MORE

answered Mar 26, 2022 in Azure by Edureka
• 12,690 points
421 views
0 votes
1 answer

How to create a service connection for Azure in Azure Devops (with pictures)

to create a service connection for Azure ...READ MORE

answered Mar 29, 2022 in Azure by Edureka
• 12,690 points

edited Jul 4, 2023 by Khan Sarfaraz 8,817 views
0 votes
1 answer

How do disconnect to Azure SQL database if I can't access it?

Based on info  from Microsoft, I think ...READ MORE

answered Apr 26, 2019 in Azure by Prerna
• 1,960 points
1,295 views
0 votes
1 answer
0 votes
0 answers

creating an output variable azure devops from the Azure SQL InlineSqlTask task

 YAML content : - task: SqlAzureDacpacDeployment@1 displayName: ...READ MORE

Apr 21, 2022 in Other DevOps Questions by Kichu
• 19,050 points
763 views
0 votes
1 answer

Azure Front Door with Azure Signal R

Yes, utilizing the Azure SignalR managed service, ...READ MORE

answered Mar 19, 2022 in Azure by Edureka
• 13,620 points
1,786 views
0 votes
1 answer

Error with Azure AD Authentication in Unity for Android

Depending on the version, Unity uses UnityPlayerActivity ...READ MORE

answered Mar 24, 2022 in Azure by Edureka
• 13,620 points
872 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP