Automatically create/update a metastore view for silver tables

[Gateway1024]

I want to be able to query (SQL) silver tables created by foundation. to accommodate this I manually create a spark view using this function.

def createSilverTable(path: String, name: String): Unit ={ val statement = {f"DROP TABLE IF EXISTS silver.${name};" } spark.sql(f"DROP TABLE IF EXISTS silver.${name}") spark.sql(f"CREATE TABLE silver.${name} USING DELTA LOCATION '${path}'") }