setScience("DeNormalizing", subProj="3rdParty")
setGitBranchToSystem(); .g()


setDBall("MySQL")
DT.third_party_publisher <- runQry("select t.id, t.isrc, t.track_name, t.upc, t.third_party_publisher FROM track t;")

jesusForData(DT.third_party_publisher)

## Recovering from error
if (FALSE)
  loadFromJesus("DT.third_party_publisher")


wh <- "CRON_JOBS_SMALL"
dbname <- "prod"
schema <- "BI"
tbl <- "third_party_publisher"
setSnowflake(wh=wh, dbname=dbname)


## Clean track names before ingesting
s.t(DT.third_party_publisher[, track_name := escape_the_escape(track_name)], title="escape the escape for track name")

## Ingest
ingestIntoSQL(DT.third_party_publisher, tbl=tbl, schema=schema, dbname=dbname, wh=wh, dont_take_copy_of_DT=TRUE, intColsToCoerce=NULL, datetime_type='TIMESTAMP_NTZ', snowflake_inuse=TRUE, drop=TRUE)


if (FALSE) 
{
  sourceSupportFns(proj="Looker")
  create_lookml_from_tbl(tbl=tbl, schema=schema, dbname=dbname, wh=wh, snowflake_inuse=TRUE)
}