Your database probably doesn't have a location set in the Glue catalog. Try creating a database with a specified location.:

CREATE DATABASE mydatabase
LOCATION 's3://mybucket/mydatabase/';