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 in Azure by Edureka
• 9,540 points
62 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 by Edureka
• 8,240 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 in Azure by Edureka
• 9,540 points
29 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
523 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 in Other DevOps Questions by Kichu
• 19,040 points
72 views
0 votes
1 answer

Azure Front Door with Azure Signal R

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

answered Mar 19 in Azure by Edureka
• 8,240 points
140 views
0 votes
1 answer
webinar REGISTER FOR FREE WEBINAR X
Send OTP
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP