It's missing connection statement, could you please try:

CREATE FOREIGN CATALOG redshift_catalog

USING CONNECTION com.databricks.spark.redshift

OPTIONS (

  dbtable '<table>',

  forward_spark_s3_credentials 'true',

  aws_iam_role 'arn:aws:iam::<your-role>',

  url 'jdbc:redshift://<hostname>:5439/<database>?ssl=false&autoEnableSSL=false'

);