https://community.databricks.com/t5/data-engineering/how-to-specify-directory-when-reading-table/m-p/31122#M22641 <P>spark.read.table reads table registered in catalog/metastore. If you have multiple databases in metastore, just prefix table name with <I>database name db.table</I></P> Thu, 22 Sep 2022 09:22:12 GMT Hubert-Dudek 2022-09-22T09:22:12Z https://community.databricks.com/t5/data-engineering/how-to-specify-directory-when-reading-table/m-p/31121#M22640 <P>Hi, </P><P></P><P>Assume that I have created several tables in Databricks workspace. If two tables have similar names but stored in different folders, how I can read them by "<A href="https://spark.apache.org/docs/latest/api/python/reference/pyspark.sql/api/pyspark.sql.DataFrameReader.table.html#pyspark-sql-dataframereader-table" alt="https://spark.apache.org/docs/latest/api/python/reference/pyspark.sql/api/pyspark.sql.DataFrameReader.table.html#pyspark-sql-dataframereader-table" target="_blank">spark.read.table</A>". </P><P></P><P>I ask this question because input to the "spark.read.table" is only table name not location. </P><P></P> Thu, 22 Sep 2022 09:05:33 GMT https://community.databricks.com/t5/data-engineering/how-to-specify-directory-when-reading-table/m-p/31121#M22640 Mado 2022-09-22T09:05:33Z https://community.databricks.com/t5/data-engineering/how-to-specify-directory-when-reading-table/m-p/31122#M22641 <P>spark.read.table reads table registered in catalog/metastore. If you have multiple databases in metastore, just prefix table name with <I>database name db.table</I></P> Thu, 22 Sep 2022 09:22:12 GMT https://community.databricks.com/t5/data-engineering/how-to-specify-directory-when-reading-table/m-p/31122#M22641 Hubert-Dudek 2022-09-22T09:22:12Z