### CREATE A SINGLE EXCEL FILE FROM A FOLDER OF CSVs

  ## EXAMPLE 1: 
  setScience(proj="Looker", subProj="FileExport", subl=FALSE, load=FALSE)

  folder <-  "~/Downloads/Reports/YouTube"
  combine_exports_to_excel(folder, basename="YouTube with Video in USD")

  ## EXAMPLE 2: 
  combine_looker_exports_to_excel(folder="/Users/rsaporta/Dropbox/The Orchard/Analytics Department/Outbound Reports/Spotify Biz Review Data/Cosmos Music 20325")


==================================================================================================================


### CREATE LOOKML FILES FROM A TABLE
sourceSupportFns(proj="Looker")

dbname <- "dev"
schema <- "shazam"
tbls <- sfShowTables(schema=schema, dbname=dbname, justnames=TRUE, verbose=FALSE)

f.outs <- sapply(tbls, create_lookml_from_tbl, dbname=dbname, schema=schema)

dirname(f.outs) %>% unique %>% path.unexpand %>% sprintf("\n\nbringmeFolder('%s', recursive.folder=FALSE)\n\n", .) %>% catn
"Then copy and paste the output"

bringmeFolder('~rsaporta/git/orch/out/DeNormalizing/auto_generated_lookmls', rsync=TRUE, recursive.folder=FALSE)
.o('~rsaporta/git/orch/out/DeNormalizing/auto_generated_lookmls')