Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-13-2023 07:13 PM
You should try using pyspark in all of your locations to verify with
df = spark.sql("select * from <catalog.schema.table>")
df.display()Do this after you make your managed table in your desired external location path ofcourse.
spark.sql("create schema if not exists <schema name> managed location <external location url path>")
spark.sql("create table if not exists <schema name>.<table name> managed location <external location url path>")https://docs.databricks.com/sql/language-manual/sql-ref-syntax-ddl-create-schema.html