## UPDATE ioda vendors for   label_view


##
##
##
##  2016-March -- I am not sure if this file is still used.  Might be old. 
##
##
##    Use this file insted:
##         "~/git/orch/src/ETL/track_artist concated.r"    <----~~~~~~~~~~~~~~~~~~~~~~~~~~
##
##
##
##
##
##
##
##







































wh <- "SCIENCE"
dbname <- "prod"

setScience(proj="DeNormalizing", subProj="MySQLTables")
setGitBranchToSystem(); .g()
try(dbDisconnectAll(), silent=TRUE)

schema <- "art_relations"
tbl <- "track_artist"

schema.sf <- schema

setDBall("MySQL")
showDBsettings()
con <- giveMeACon(verbose=TRUE)

DT.dump <- runQry(makeQry(schema=schema, tbl=tbl, limit=NULL, colsToPull="*", expandStar=FALSE), connex=con, verbose=TRUE)

ingestIntoSQL(tbl=tbl, schema=schema.sf, DT=DT.dump, wh=wh, dbname=dbname, over=TRUE)

## LOOKER FILE
sourceSupportFns(proj="Looker")
f.lookml <- create_lookml_from_tbl(tbl=tbl, schema=schema.sf)