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
• 11,450 points
195 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
• 12,890 points

Related Questions In Azure

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
• 11,450 points
106 views
0 votes
1 answer
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
648 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,040 points
299 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
• 12,890 points
581 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
• 12,890 points
278 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