You do not have to create all the partition folders yourslef.

You just need to specify the parent folder like 

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

some more read - https://docs.databricks.com/en/tables/external-partition-discovery.html#manually-specify-paths-for-o...