This script will create Hive metastore table in Databricks Catalog

create_databricks_hive_metastore.md

Create Hive metastore table

# Create database schema
spark.sql("CREATE DATABASE IF NOT EXISTS csgci")


# Create Hive Internal table
df.write.mode("overwrite").option("overwriteSchema", "true").saveAsTable("csgci.drug_ic")

# Check if the table is created

%sql
select * from drug_ic