Hi @nwong,

Ensure that the Cloud Storage URI provided is complete and correct, including the scheme, since error looks to be complaining about it.

Can you try using this: https://docs.databricks.com/en/tables/external-partition-discovery.html

CREATE OR REPLACE TABLE <catalog>.<schema>.<table-name>
USING <format>
PARTITIONED BY (<partition-column-list>)
LOCATION 's3://<bucket-path>/<table-directory>';