1

I am quite new to Databricks, and I am trying to do some basic data exploration with koalas.
When I log into Databricks, under DATA I see 2 main tabs, DATABASE TABLES and DBFS. I managed to read csv files as koalas dataframes (ksdf=ks.read_csv('/FileStore/tables/countryCodes.csv'), but I do not know how I could read as koalas dataframe the tables I see under the DATABASE TABLES. None of those tables have filename extensions, I guess those are SQL tables? Sorry if my question is too basic, and thanks very much for your help.

Alex Ott
  • 80,552
  • 8
  • 87
  • 132
Brigi Szabo
  • 11
  • 1

1 Answers1

0

You just need to use read_table function as pointed in the documentation:

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

P.S. It's a part of so called Metastore API

Alex Ott
  • 80,552
  • 8
  • 87
  • 132