{ "auto_complete": { "selected_items": [ [ "f.", "f.in" ], [ "relea", "release_carveouts_country_code" ], [ "countr", "country_id" ], [ "label", "labelid" ], [ "f.in", "f.in.sql" ], [ "snowf", "snowflake_inuse" ], [ "verbose", "verboseMsg" ], [ "Sys.set", "Sys.setenv" ], [ "Sys.get", "Sys.getenv" ], [ "TEST", "TEST_VAR" ], [ "expand", "expanded_folders" ], [ "prod.", "prod.BI.label_view" ], [ "DT.ra", "DT.rates2" ], [ "desc_", "desc_confirm" ], [ "Snowfl", "snowflake_inuse" ], [ "parentup", "parent_upc" ], [ "release_", "release_name_cleaned" ], [ "PARENT_", "parent_upc" ], [ "displ", "display_upc" ], [ "DT.re", "DT.releases" ], [ "over", "overWrite" ], [ "locat", "location" ], [ "is.char", "is.char_of_length1" ], [ "qry", "Qry" ], [ "Fileforma", "FILE_FORMAT" ], [ "stage", "stage_name" ], [ "ifelse", "ifelseNULL" ], [ "schema", "schemaPaste" ], [ "whs_", "whs_found" ], [ "Cur", "currency_exchange_rates" ], [ "possib", "possible_wh" ], [ "poss", "possible_wh" ], [ "DT.ount", "DT.country" ], [ "DT.coun", "DT.countries_in_spotify" ], [ "DT.c", "DT.country" ], [ "country", "country_code" ], [ "setkey", "setkeyIfNot" ], [ "number", "number_of_rows" ], [ "numer_", "number_of_rows" ], [ "DT.", "DT.lookml" ], [ "look", "lookmlpieces" ], [ "lookml", "lookmlpieces" ], [ "primar", "primary_key" ], [ "prima", "primary_key" ], [ "view", "view_label" ], [ "view_l", "view_label_lasts" ], [ "view_", "view_label" ], [ "yesno", "yesnoCase" ], [ "integ", "integer" ], [ "DT.samp", "DT.sample" ], [ "sugges", "suggestable" ], [ "release", "releaseid" ], [ "day", "day_of_month" ], [ "day_", "day_of_week" ], [ "dime", "dimension_group" ], [ "integr", "integerFormat" ], [ "use", "use.names" ], [ "field", "field_name" ], [ "trans", "transac" ], [ "dimen", "dimension" ], [ "meas", "measure" ], [ "dimn_", "dimension_group" ], [ "paste", "paste0" ], [ "View", "Views" ], [ "dstbl", "dstbl_clone" ], [ "db", "dbname" ], [ "artist", "artistid" ], [ "source", "source_uri" ], [ "spoti", "staging_raw_spotify_V2" ], [ "downl", "download_date" ], [ "count", "country_group" ], [ "coun", "country_group" ], [ "cuntry", "country_group" ], [ "alph", "alpha_string" ], [ "valu", "values.colDotgroup" ], [ "ratio", "ratio_of_revenue" ], [ "rev", "Revenue" ], [ "country_", "country_group_name" ], [ "labe", "labels_revenue" ], [ "Pra", "P.ratio_of_revenue" ], [ "pr", "product_description" ], [ "key", "key.new" ], [ "prod", "product" ], [ "tmp_DT", "tmp_DT_all_countries" ], [ "Re", "revenue_share" ], [ ".SD", ".SDcols" ], [ "cols", "colsToScale" ], [ "vari", "variable.name" ], [ "by", "byCols.scale" ], [ ".Sd", ".SDcols" ], [ "pro", "product" ], [ "payabl", "payable_eur" ], [ "mind", "minDate.global" ], [ "pay", "payable" ], [ "paya", "payable_usd" ], [ "Eu", "EUR_to_USD" ], [ "EUR", "EUR_to_USD" ], [ "pyab", "payable_usd" ], [ "payable_", "payable_usd" ], [ "payable", "payable_usd" ], [ "payab", "payable_usd" ], [ "co", "currency_code" ], [ "DT.ex", "DT.exchangerates" ], [ "ass", "assign.to" ], [ "color", "colors.sc" ], [ "time", "times_info" ], [ "resu", "result_string" ], [ "vlin", "vline.color" ], [ "vline.", "vline.alpha" ], [ "vline", "vline.value" ], [ "face", "facet_scales" ], [ "alp", "alpha_dot" ], [ "label_a", "label_act" ], [ "SE_", "SE_USERS" ], [ "curr", "currency" ], [ "curre", "currency_rate" ], [ "curren", "currency_code" ], [ "smo", "smooth" ], [ "smoot", "smooth_se" ], [ "DT.month.per", "DT.monthly_cast.perc_incr" ], [ "cols.", "cols.monthly_cast_perc" ], [ "DT.s", "DT.monthly_cast" ], [ "total_", "total_streams" ], [ "lae", "labelcolor" ], [ "strea", "streams_scaled_MA3" ], [ "perce", "percent.y" ], [ "sre", "streams_as_perc_of_max" ], [ "top", "top50" ] ] }, "buffers": [ { "file": "/Users/rsaporta/git/orch/src/DeNormalizing/Additional Tables/carve_outs label level.r", "settings": { "buffer_size": 15985, "line_ending": "Unix" } }, { "file": "/Users/rsaporta/git/orch/src/DeNormalizing/Additional Tables/carve_outs.r", "settings": { "buffer_size": 9620, "line_ending": "Unix" } } ], "build_system": "", "build_system_choices": [ [ [ [ "Packages/R-Box/support/R-Box.sublime-build", "" ], [ "Packages/SublimeREPL/sublimerepl_build_system_hack.sublime-build", "" ] ], [ "Packages/R-Box/support/R-Box.sublime-build", "" ] ] ], "build_varint": "", "command_palette": { "height": 227.0, "last_filter": "path", "selected_items": [ [ "path", "File: Copy Path" ], [ "edit pr", "Project: Edit Project" ], [ "rext", "Set Syntax: R Extended" ], [ "revel", "File: Reveal" ], [ "reve", "File: Reveal" ], [ "ren", "File: Rename" ], [ "rn", "SublimeREPL: Node" ], [ "qui", "Git: Quick Commit" ], [ "push", "Git: Push" ], [ "quic", "Git: Quick Commit Current File" ], [ "add curr", "Git: Add Current File" ], [ "file", "File: Copy Name" ], [ "sql", "Set Syntax: SQL" ], [ "rex", "Set Syntax: R Extended" ], [ "source", "Snippet: Source" ], [ "rbox", "R-Box: Choose Program" ], [ "delete", "File: Delete" ], [ "word", "Word Wrap: Toggle" ], [ "move", "File: Move" ], [ "sh", "Set Syntax: Shell Script (Bash)" ], [ "shell", "SublimeREPL: Shell" ], [ "syntax she", "Set Syntax: Shell Script (Bash)" ], [ "rena", "File: Rename" ], [ "pull", "Git: Pull" ], [ "mov", "File: Move" ], [ "wor", "Word Wrap: Toggle" ], [ "revea", "File: Reveal" ], [ "r", "R-Box: Choose Program" ], [ "ptah", "File: Copy Path" ], [ "rap", "R Application Switch" ], [ "name", "File: Copy Name" ], [ "enh", "Set Syntax: Enhanced-R" ], [ "wro", "Word Wrap: Toggle" ], [ "nam", "File: Copy Name" ], [ "rev", "File: Reveal" ], [ "ra", "R Application Switch" ], [ "prett", "Pretty JSON: Format (Pretty Print) JSON" ], [ "js", "JSLint" ], [ "json", "Set Syntax: JSON" ], [ "qi", "Git: Quick Commit" ], [ "pus", "Git: Push Current Branch" ], [ "jslin", "JSLint" ], [ "insta", "Package Control: Install Package" ], [ "pretty", "Pretty JSON: Format (Pretty Print) JSON" ], [ "reinde", "JSON Reindent: reindent file or selection" ], [ "inden", "Indentation: Reindent Lines" ], [ "get package", "Package Control: Install Package" ], [ "package", "Preferences: Browse Packages" ], [ "enab", "Package Control: Enable Package" ], [ "ite", "Indentation: Convert to Spaces" ], [ "enha", "Set Syntax: Enhanced-R" ], [ "pul", "Git: Pull" ], [ "d", "File: Delete" ], [ "comcur", "Git: Quick Commit Current File" ], [ "w", "Word Wrap: Toggle" ], [ "add cu", "Git: Add Current File" ], [ "git chec", "Git: Checkout" ], [ "git check", "Git: Checkout" ], [ "syn shel", "Set Syntax: Shell Script (Bash)" ], [ "synt she", "Set Syntax: Shell Script (Bash)" ], [ "quick", "Git: Quick Commit Current File" ], [ "git ch", "Git: Checkout" ], [ "git stas", "Git: Pop Stash" ], [ "git sta", "Git: Stash" ], [ "add", "Git: Add Current File" ], [ "rapp", "R Application Switch" ], [ "git cur", "Git: Quick Commit Current File" ], [ "pat", "File: Copy Path" ], [ "quci", "Git: Quick Commit Current File" ], [ "ush", "SublimeREPL: Shell" ], [ "dele", "File: Delete" ], [ "del", "File: Delete" ], [ "psuh", "Git: Push" ], [ "puh", "Git: Push" ], [ "disable pack", "Package Control: Disable Package" ], [ "disa", "Package Control: Disable Package" ], [ "check", "Git: Checkout New Branch" ], [ "git com cur", "Git: Quick Commit Current File" ], [ "curr", "Git: Add Current File" ], [ "git comcu", "Git: Quick Commit Current File" ], [ "qucur", "Git: Quick Commit Current File" ], [ "qu", "Git: Quick Commit Current File" ], [ "com cu", "Git: Quick Commit Current File" ], [ "addcu", "Git: Add Current File" ], [ "quicad", "Git: Quick Add" ], [ "PAT", "File: Copy Path" ], [ "git comm", "Git: Commit" ], [ "synshe", "Set Syntax: Shell Script (Bash)" ], [ "shel", "SublimeREPL: Shell" ], [ "fil", "File: Copy Name" ], [ "nh", "Set Syntax: HTML" ], [ "fin", "File: Copy Name" ], [ "comm", "Git: Commit" ], [ "checkou", "Git: Checkout New Branch" ], [ "filena", "File: Copy Name" ], [ "com file", "Git: Quick Commit Current File" ], [ "quc", "Git: Quick Commit Current File" ], [ "qucomf", "Git: Quick Commit Current File" ], [ "comf", "Git: Quick Commit Current File" ], [ "wo", "Word Wrap: Toggle" ], [ "qucf", "Git: Quick Commit Current File" ], [ "commfil", "Git: Quick Commit Current File" ], [ "filen", "File: Copy Name" ], [ "branch", "Git: Checkout New Branch" ], [ "new br", "Git: Checkout New Branch" ], [ "branc", "Git: Checkout New Branch" ], [ "copy", "File: Copy Name" ], [ "RENA", "File: Rename" ], [ "ADD", "Git: Add Current File" ], [ "copnam", "File: Copy Name" ], [ "q", "Git: Quick Add" ], [ "renam", "File: Rename" ], [ "rep", "SublimeREPL: PHP" ], [ "enhg", "BracketHighlighter: Select Next Attribute (right)" ], [ "en", "Set Syntax: Enhanced-R" ], [ "WOR", "Word Wrap: Toggle" ], [ "pu", "Git: Push" ], [ "cop", "File: Copy Name" ], [ "delet", "File: Delete" ], [ "RA", "R Application Switch" ], [ "REV", "File: Reveal" ], [ "COPNA", "File: Copy Name" ], [ "ENH", "Set Syntax: Enhanced-R" ], [ "QUIC", "Git: Quick Commit" ], [ "co", "File: Copy Name" ], [ "COP", "File: Copy Name" ], [ "oath", "File: Copy Path" ], [ "copy na", "File: Copy Name" ] ], "width": 521.0 }, "console": { "height": 126.0, "history": [ "subprocess.Popen([Rscript, '-e', 'args(' + 'as.data.table' + ')', '--default-packages=data.table,ggplot2'], stdout=subprocess.PIPE).communicate()[0]", "subprocess.Popen([Rscript, '-e', 'args(' + 'data.table' + ')', '--default-packages=data.table,ggplot2'], stdout=subprocess.PIPE).communicate()[0]", "subprocess.Popen([Rscript, '-e', 'args(' + func + ')', '--default-packages=data.table,ggplot2'], stdout=subprocess.PIPE).communicate()[0]", "subprocess.Popen([Rscript, '-e', 'args(' + func + ')'], stdout=subprocess.PIPE).communicate()[0]", "subprocess.Popen([Rscript, '-e', '\"args(' + func + ')\"'], stdout=subprocess.PIPE).communicate()[0]", "subprocess.Popen([Rscript, '-e', '\"args(' + func + ')\" --default-packages=data.table,ggplot2'], stdout=subprocess.PIPE).communicate()[0]", "subprocess.Popen([Rscript, '-e', 'args(' + func + ') --default-packages=\"data.table,ggplot2\"'], stdout=subprocess.PIPE).communicate()[0]", "subprocess.Popen([Rscript, '-e', 'args(' + func + ') --default-packages=data.table,ggplot2'], stdout=subprocess.PIPE).communicate()[0]", "subprocess.Popen([Rscript, '-e', 'args(' + func + ')'], stdout=subprocess.PIPE).communicate()[0]", "subprocess.Popen(args + '', stdout=subprocess.PIPE).communicate()[0]", "subprocess.Popen(args + \"\", stdout=subprocess.PIPE).communicate()[0]", "subprocess.Popen(args, stdout=subprocess.PIPE).communicate()[0]", "args = [Rscript, '-e', 'args(' + func + ')']", "args", "subprocess.Popen(args, stdout=subprocess.PIPE).communicate()[0]", "args =[Rscript, '-e', 'args(' + func + ') --default-packages=data.table,ggplot2']", "subprocess.Popen([Rscript, '-e', 'args(' + 'data.table' + ')'], stdout=subprocess.PIPE).communicate()[0]", "subprocess.Popen([Rscript, '-e', 'args(' + 'data.frame' + ')'], stdout=subprocess.PIPE).communicate()[0]", "subprocess.Popen([Rscript, '-e', 'args(' + func + ')'], stdout=subprocess.PIPE).communicate()[0]", "subprocess.Popen(args, stdout=subprocess.PIPE).communicate()[0]", "import subprocess", "subprocess.Popen(args, stdout=subprocess.PIPE).communicate()[0]", "args", "args = [Rscript, '-e', 'args(' + func + ')']", "args <- [Rscript, '-e', 'args(' + func + ')']", "[Rscript, '-e', 'args(' + func + ')']", "output", "output = mycheck_output([Rscript, '-e', 'args(' + func + ')'])", "plat = sublime.platform()", "Rscript = \"Rscript\"", "Rscript = get(plat, \"Rscript\", \"Rscript\")", "plat", "help", "?", "{", "def get_Rscript():", "Rscript = get_Rscript()", "print(func in container)", "func", "func = m.group(1)", "print(func in container)", "m.group(1)", "m.group", "view.set_status(\"Enhanced-R\", \"\")", "not m", "if not m: return", "m", "m = re.match(r\".*?([a-zA-Z0-9.]+)\\($\", contentb)", "import re", "m = re.match(r\".*?([a-zA-Z0-9.]+)\\($\", contentb)", "contentb = view.substr(sublime.Region(view.line(point).begin(), point))", "contentb", "contentb = view.substr(sublime.Region(view.line(point).begin(), point))", "point", "point = view.sel()[0].end() if view.sel() else 0", " point = view.sel()[0].end() if view.sel() else 0", "point", "contentb", "contentb = view.substr(sublime.Region(view.line(point).begin(), point))", "sel[0].begin() != sel[0].end()", "len(sel)", "if len(sel)!=1: return", "sel = view.sel()", "this_row = view.rowcol(point)[0]", "sel[0].end()", "sel[0].begin()", "sel[0]", "len(sel)", "sel", "sel'", "sel = view.sel()", "this_row", "this_row = view.rowcol(point)[0]", "not view.score_selector(point, \"source.r\")", "view.score_selector(point, \"source.r\")", "point", "point = view.sel()[0].end() if view.sel() else 0", "import urllib.request,os; pf = 'Package Control.sublime-package'; ipp = sublime.installed_packages_path(); urllib.request.install_opener( urllib.request.build_opener( urllib.request.ProxyHandler()) ); open(os.path.join(ipp, pf), 'wb').write(urllib.request.urlopen( 'http://sublime.wbond.net/' + pf.replace(' ','%20')).read())" ] }, "distraction_free": { "menu_visible": true, "show_minimap": false, "show_open_files": false, "show_tabs": false, "side_bar_visible": false, "status_bar_visible": false }, "file_history": [ "/Users/rsaporta/git/orch/sublws/DeNormalizing/Carveouts.sublime-project", "/Users/rsaporta/.bash_profile", "/Users/rsaporta/Library/Application Support/Sublime Text 3/Packages/User/Preferences.sublime-settings", "/Users/rsaporta/git/orch/ingest/DeNormalizing/carveouts/Release Level - Countries.sql", "/Users/rsaporta/git/orch/ingest/DeNormalizing/carveouts/Label Level - [Single Qry with Joins].sql", "/Users/rsaporta/git/orch/ingest/DeNormalizing/carveouts/Label Level - Countries.sql", "/Users/rsaporta/git/orch/ingest/DeNormalizing/carveouts/Label Level - DMS Master.sql", "/Users/rsaporta/git/orch/ingest/DeNormalizing/carveouts/Release Level - [Single Qry with Joins].sql", "/Users/rsaporta/git/orch/ingest/DeNormalizing/carveouts/Label Level - DMS Substore.sql", "/Users/rsaporta/git/orch/ingest/DeNormalizing/carveouts/Release Level - DMS Master.sql", "/Users/rsaporta/git/orch/ingest/DeNormalizing/carveouts/Release Level - DMS Substore.sql", "/Users/rsaporta/git/orch/ingest/DeNormalizing/carveouts/Release_level_carveouts.sql", "/Users/rsaporta/git/orch/ingest/DeNormalizing/carveouts/Release_level_carveouts [old ?].sql", "/Users/rsaporta/git/orch/ingest/DeNormalizing/carveouts/Label_level_carveouts [Sinle File].sql", "/home/rsaporta/git/orch/ingest/DeNormalizing/carveouts/Label Level Carveouts - DMS, Substore DMS, Territory.sql", "/home/rsaporta/git/orch/ingest/DeNormalizing/carveouts/Label_level_carveouts [old ?].sql", "/home/rsaporta/git/orch/ingest/DeNormalizing/carveouts/Release_level_carveouts [old ?].sql", "/home/rsaporta/git/orch/ingest/DeNormalizing/carveouts/Release_level_carveouts.sql", "/Users/rsaporta/git/orch/src/misc/carveouts.r", "/Users/rsaporta/Dropbox/Documents_DropBox/christmascards 2015/cleaning up addresses.r", "/Users/rsaporta/git/misc/rscripts/utils/DB_Utils/SF_Utils - sfGetCon.r", "/Users/rsaporta/git/orch/src/AppleMusic/2015-07-07 Apple Music Export To Snowflake.r", "/Users/rsaporta/git/orch/src/Acc_vs_Anal_2015/supportFns/create_DT.iTunes.acc_v_anal.r", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables/Views/spotify_sos.sql", "/Users/rsaporta/git/orch/src/Spotify_Stream_Count/Add USER ID to spotify source of stream table.sql", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables/Views/store_view_snowflake.sql", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables/Views/release_view.sql", "/Users/rsaporta/git/misc/rscripts/utils/notify/notify.r", "/Users/rsaporta/git/orch/src/BunnyLee/01 BunnyLee Catalog Check.r", "/Users/rsaporta/git/!Projects/_find and replace_.sublime-project", "/Users/rsaporta/git/misc/rscripts/utils/DB_Utils/check_snowflake_redshift_switch.r", "/Users/rsaporta/git/misc/rscripts/utils/sys_variables.r", "/Users/rsaporta/git/misc/rscripts/utils/setScience.R", "/Users/rsaporta/git/misc/rscripts/utils/DB_Utils/SF zArchived Utils.r", "/Users/rsaporta/git/misc/rscripts/utils/DB_Utils/SF_Utils.R", "/Users/rsaporta/git/misc/rscripts/utils/DB_Utils/SF_Utils_Setters_and_Getters.r", "/Users/rsaporta/git/misc/rscripts/utils/DB_Utils/dbIsValid for RPostgreSQL.r", "/Users/rsaporta/git/orch/src/DeNormalizing/create client_managers tbl.r", "/Users/rsaporta/git/misc/rscripts/utils/workspace.R", "/Users/rsaporta/git/misc/rscripts/utils/fUtils.r", "/Users/rsaporta/git/orch/src/ContentAnalysis/2015-10-16 Quick Count for this week.r", "/Users/rsaporta/git/orch/src/ContentAnalysis/01 Hidden Content Modelling.r", "/Users/rsaporta/git/misc/rscripts/utils/DB_Utils/SF_Utils - Table Creations.r", "/Users/rsaporta/git/orch/src/AppleMusic/Trial Estimates.r", "/Users/rsaporta/git/orch/src/AppleMusic/applemusic.apple_music_rates.lookml", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables/zArchive 2015-08-20/Accounting/02_AC populate_aggregated_accounting_snowflake.sql", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables/Views/country_view.sql", "/Users/rsaporta/git/orch/src/Spotify_Streams_Per_Top_Artist/supportFns/Plot_Users_By_Country_and_Product.r", "/Users/rsaporta/git/misc/rscripts/learning R/regex - replacing chars.R", "/Users/rsaporta/git/orch/src/Looker/birngAndCopyLookerFiles.r", "/Users/rsaporta/git/orch/src/DeNormalizing/upcTypeForCompsTeam.r", "/Users/rsaporta/git/misc/rscripts/utils/DB_Utils/DB_Utils_Setters_and_Getters.r", "/Users/rsaporta/git/orch/src/MGMT_REPORT_FULL_AUTO.r", "/Users/rsaporta/git/orch/src/MgmtReport/supportFns/automate new.r", "/Users/rsaporta/git/misc/rscripts/utils/Orchard_Specific/AcctBIandProd_are_synced.r", "/Users/rsaporta/git/orch/src/Acc_vs_Anal_2015/Acc_vs_Anal_for_Spotify 20150413.r", "/Users/rsaporta/git/orch/src/Acc_vs_Anal_2015/Acc_vs_Anal_for_Spotify RAW 20150413.r", "/Users/rsaporta/git/orch/src/Acc_vs_Anal_2015/Files from 2014-12-16/Accounting_vs_Analytics_2015.r", "/Users/rsaporta/git/orch/src/DeNormalizing/Scratch Work/fact_sales fields.r", "/Users/rsaporta/git/orch/src/MgmtReport/supportFns/findMaxDate.r", "/Users/rsaporta/git/orch/src/misc/bullethead Richard Clayderman.r", "/Users/rsaporta/git/orch/src/misc/Holly_miranda.r", "/Users/rsaporta/git/orch/src/misc/Jedi Mind Tricks.r", "/Users/rsaporta/git/orch/src/misc/katie Classical GB.r", "/Users/rsaporta/git/orch/src/misc/spotify usa source comparison.r", "/Users/rsaporta/git/orch/src/Spotify Playlist Webscrape/00 Featured Playlist Setup.r", "/Users/rsaporta/git/orch/src/Spotify Playlist Webscrape/supportFns/get_CountryCodes.r", "/Users/rsaporta/git/orch/src/Spotify Playlist Webscrape/supportFns/get_DT.uris.r", "/Users/rsaporta/git/orch/src/Spotify_Accounting_ETL/20150415 ! Spotify Biz Review - User & Stream Counts.r", "/Users/rsaporta/git/orch/src/Spotify_Accounting_ETL/20150415 Spotify Biz Review - User Counts NEW.r", "/Users/rsaporta/git/orch/src/Spotify_Accounting_ETL/20150415 Spotify Biz Review - User Counts.r", "/Users/rsaporta/git/orch/src/Spotify_API_V2/SCRATCH 2015-03-21.R", "/Users/rsaporta/git/orch/src/Spotify_API_V2/streams per source.r", "/Users/rsaporta/git/orch/src/Spotify_Long_Tail/Long Tail.r", "/Users/rsaporta/git/misc/rscripts/utils/extract-type functions.r", "/Users/rsaporta/git/orch/src/misc/catalog_vs_frontline_labels.r", "/Users/rsaporta/git/orch/src/ContentAnalysis/Hidden Content - Simple.r", "/Users/rsaporta/git/misc/rscripts/utilsRS.r", "/Users/rsaporta/git/misc/rscripts/utils/format functions.r", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables/Views/transactiontype_view.sql", "/Users/rsaporta/git/orch/src/misc/samantha moore playlist analysis 20150819.r", "/Users/rsaporta/git/misc/rscripts/utils/makeSQLtable.r", "/Users/rsaporta/git/orch/src/MasterUPC/MasterUPC.r", "/Users/rsaporta/git/orch/src/MasterUPC/ManuallyUpdate.r", "/Users/rsaporta/git/misc/rscripts/utils/idcol.r", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables/Views/label_view_snowflake.sql", "/Users/rsaporta/git/orch/src/Looker/supportFns/create_lookml_from_tbl.r", "/Users/rsaporta/git/orch/src/DeNormalizing/currency_conversion_rates_ingestion.r", "/Users/rsaporta/git/orch/src/Snowflake_Scratch/spotify json conversion.sql", "/Users/rsaporta/git/misc/rscripts/utils/DB_Utils/sf create table as.r", "/Users/rsaporta/git/misc/rscripts/20150917 log for 0ddddbbd-5d7e-4fd3-88ee-06832465841a.txt", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables/Video Services Market Group.r", "/Users/rsaporta/git/misc/rscripts/utils/Orchard_Specific/region_group_to_factor.r", "/Users/rsaporta/git/misc/rscripts/utils/Orchard_Specific/get_dim_x.r", "/Users/rsaporta/git/orch/src/DeNormalizing/Scratch Work/mysql tables.r", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables/zArchive 2015-08-20/Accounting/01_AC create_aggregated_accounting.sql", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables/Accounting/03_AC update_aggregated_accounting_snowflake.sql", "/Users/rsaporta/git/orch/src/dbconcile/supportFns/compare_snowflake_to_redshift.r", "/Users/rsaporta/git/orch/src/Spotify_Accounting_ETL/20150810 Export to Looker.r", "/Users/rsaporta/git/orch/src/Spotify_Accounting_ETL/20150810 Export to Looker part 2, spotify schema.r", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables/Views/store_view.sql", "/Users/rsaporta/git/orch/src/Looker/supportFns/cleanLookerHeaders_after_download.r", "/Users/rsaporta/git/misc/rscripts/utils/DB_Utils/DB_Utils.r", "/Users/rsaporta/git/orch/src/Looker/create_lookml for bi accounting and analytics.r", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables/Create Analytics on Snowflake.r", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables/Create Accounting on Snowflake.r", "/Users/rsaporta/git/misc/rscripts/RickysRprofile.R", "/Users/rsaporta/git/RBoxScripts/RBOX.bashrc", "/Users/rsaporta/git/RBoxScripts/cti.sh", "/Users/rsaporta/git/misc/rscripts/utils/addQuarter.r", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables/Create All Views.r", "/Users/rsaporta/git/orch/src/Spotify_Accounting_ETL/supportFns/simpleClean_of_spotify_DT.r", "/Users/rsaporta/git/orch/src/Spotify_Accounting_ETL/02 Ingest Spotify Files.r", "/Users/rsaporta/git/misc/rscripts/utils/ggWrappers/ggHeatGrid.r", "/Users/rsaporta/git/orch/src/Spotify_Accounting_ETL/supportFns/readSpotifyFiles.r", "/Users/rsaporta/git/orch/src/Spotify_Accounting_ETL/02b DT.data.Total_usage - absolute - EU.r", "/Users/rsaporta/git/orch/src/Spotify_Accounting_ETL/02b DT.data.Total_usage - absolute.r", "/Users/rsaporta/git/orch/src/Spotify_Accounting_ETL/02b DT.data.Total_usage.r", "/Users/rsaporta/git/orch/src/Spotify_Accounting_ETL/03 Plot.r", "/Users/rsaporta/git/orch/src/Spotify_Accounting_ETL/_latestBackups.r", "/Users/rsaporta/git/orch/src/Spotify_Accounting_ETL/Vodafone - Tom.R", "/Users/rsaporta/git/orch/src/Spotify_Streams_Per_Top_Artist/11 Plotting.r", "/Users/rsaporta/git/misc/rscripts/utils/Orchard_Specific/country utils.r", "/Users/rsaporta/git/misc/rscripts/utils/Orchard_Specific/id Conversions.r", "/Users/rsaporta/git/orch/src/Acc_vs_Anal_2015/Plot DT.acc_v_anal.r", "/Users/rsaporta/git/orch/src/EU_PricingTest_2015/02 Analysis Two.r", "/Users/rsaporta/git/orch/src/Spotify Data/Country Groups.r", "/Users/rsaporta/git/orch/src/Spotify Data/Spotify Missing Data (OLD).r" ], "find": { "height": 35.0 }, "find_in_files": { "height": 93.0, "where_history": [ "" ] }, "find_state": { "case_sensitive": false, "find_history": [ "c.country_code", "carveouts", "LD_LIBRARY_PATH", "tbl_out.spot", "Q.spotify_streams_for_applemusic", "snowflake_spot", "Q.spotify_streams_for_applemusic", "staging_raw_spotify_", "get_all_playlists_downloaded_to_outDir", "fileInfo", "applemusicraw", "applemusic_raw", "split_part", "split_p", "R App is NULL", "various", "setSysVarIfBlank", "cron_jobs_small", "cron_job_small", "sublime-", "sublime", "wh <- ", "sfget", "sfGetCurrent", "sfGetCurrentd", "odbcDriverConnect_wrapper", "odbcDriverConnect_wrapper <- \ndbIsValid", "dbIsValid", "CLIENT_MANAGERS_BY_LABEL", "namedNullList", "showErrorCalls", "odbcConnect", "ClientManagers", "ClientManagers_LabelId", "wc -l", "propag", "propogate", "blacklist", "apple_id", "guides", "sfpopul", "ingestInto", "format_name", "rate_per_play", "DT.oanda", "rate_per_play", "videoservices_region_group", "applemusic", "applemusic.raw", "applemusic.aw", "Plot_UserCount_forCountryGroup", "\\\\x", "\\\\u", "\\u", "\\x", "\\x83", "\\u009", "~/development/looks", "(.Pfm == \"Darwin\")", "(.Pfm == \"Darwin\") ", "7", "cluster(.*?)\\s*=\\s*7", "cluster\\s*=\\s*7", "cluster(\\.|\\w)*\\s*(=)\\s*0?7", "cluster.in\\s*(=)\\s*0?7", "cluster.in\\s*(=|<\\-)\\s*0?7", "cluster.in\\s*=\\s*0?7", "cluster.in\\s*=\\s*7", "cluster.in=7", "cluster.in", "hashing_algorithms", "theorchard.looker.com/dashboards", "theorchard.looker.com/dashboards/46", "https://theorchard.looker.com/dashboards/46", "putney", "amanda", "marrissa", "grepl(pat, string, ignore.case", "dbConnect", "\n#", "RELEASE_PRODUCT_LABEL_VIEW", "release_product", "staging_raw_spotify_v2", "table", "staging_Raw_spotify_v2", "a_special_treatment", " \n", "ricks_writeDT_export", "set_snowflake_inuse", "\"alter", "alter", "alter warehouse", "alter warehouse\n.Internal", ".Internal", "usetz", "track", "Album", "-- \"", "zOTHER TRANSACTIONTYPESz", "\"in here\"", "swap_in_new_table", "user_id", "staging_raw_spotify_v2", ".sql", "user_id", "spotify_uk_", "guessIntCols", "intColsToCoerce", "wh.idcols", "add.ingestDate", "intColsToCoerce", "DT.out <- ", "setsnowflake", "releasename", "DT.upc_parent_table", "jesus", "DT.upc_parent_table", "not_group.releasename_cleaned", "function", "clean_release_name", "UPC_PARENT_TABLE", "PARENT_UPC", "bayes", "ManualCSVLoads", "cm", "CLIENT_MANAGERS_BY_LABEL", "ClientManagers", "ClientManagers_LabelId" ], "highlight": true, "in_selection": false, "preserve_case": false, "regex": false, "replace_history": [ "cluster=4", "cluster.in=4", "staging_raw_spotify_v2", "single_letter_special_treatment", "release_name", "releasename", "clean_text", "currency_to_id", "currency_from_id", "\\\\n\\\\s", "yes_units_spotify", "yes_units_spotifyf", "", "tbl_", "tbl_old", "$cti", "countries_in_spotify_data", "countries_in_spotify", "DT.country", "region_group", "product_description", "###", "view_label", "view_name", "DT.formatted", "wh", "Analytics", "Accounting", "BI_Accounting_Creation", "Accounting", "0", "is_store_itunesUSA = 1", "is_store_itunesUSA = true", "getSnowflakeWH(connex=connex, refresh=TRUE, verbose=FALSE)", "getSnowflakeWH(connex=connex, refresh=TRUE)", "setSnowflakeWH", "setSnowflake(showWarnings=FALSE)", ".sf_showDB", ".sf_useDB", "getSnowflakeDB()", "BeNeLux", "gzip=TRUE", "Searching", "setnames_addPreface", "getGNUScreenName", "aggFunc", "makeQry", "addCountry.byCode_", "addCountry.byCode", "s3_sync", "s3_download", "s3_upload", "s3_ls", "s3_p", "s3_bucketExists", "country_group", "ylims", "xlims", "yscale", "xscale", "aggregate_out_product_DT.users", "dots_", "alpha.allOthers", "alpha", "alphs", "DT", "eur", "weekly_absolute_byCountry", "dot_alpha", "line_alpha", "active", "x_scale", "xlab", "DT.RED_Split_Spotify.an", "", "\\'", "spotify_streams", "total_streams", "orchard_streams", "DT.toptracks", "DT.top", "", "activity_date", "accounting_month", "exportXLS.usingXLConnect", "store_name_short", "dict", "period_view", "dimCols", "dimensionCols", "fa.manual <- runQry(\"\nSELECT download_activity_date AS date, storeid, transactiontypeid AS transac_typeid, false AS from_errors_table\n , SUM(units) as units \nFROM production.fact_analytics \nWHERE storeid = 1 and download_activity_date >= '2014-10-01'\nGROUP By 1, 2, 3, 4\n \")\n", "schema", "period_view", "accounting_period_view", "skip.select.in_Denormalizing", "skip.select.indenormalizing", "out.right", "out.left", "gest_net_of_SC", "ancilla", "anal", "analytics", ".prod", "\\n ", "", " THEN", " THEN", "schema", "schema.tmp", "-------", "03_AC", "'", "DT.merged2", "calculated", "MgmtReport_", "MgmtReport", "----------", "Revenue", "file.in", "kCols.smry_supbuk", "thisRunIsAForecast", "notForecasting", "!notForecasting", "DT.GL_forecasted", "notForecasting", "DT.cleaned.aggd2", "DT.MgmtReport", "DT.cleaned.aggd" ], "reverse": false, "show_context": false, "use_buffer2": true, "whole_word": false, "wrap": true }, "groups": [ { "selected": 0, "sheets": [ { "buffer": 0, "file": "/Users/rsaporta/git/orch/src/DeNormalizing/Additional Tables/carve_outs label level.r", "semi_transient": false, "settings": { "buffer_size": 15985, "regions": { }, "selection": [ [ 166, 166 ] ], "settings": { "BracketHighlighterBusy": false, "bh_regions": [ "bh_default", "bh_default_center", "bh_default_open", "bh_default_close", "bh_default_content", "bh_round", "bh_round_center", "bh_round_open", "bh_round_close", "bh_round_content", "bh_double_quote", "bh_double_quote_center", "bh_double_quote_open", "bh_double_quote_close", "bh_double_quote_content", "bh_single_quote", "bh_single_quote_center", "bh_single_quote_open", "bh_single_quote_close", "bh_single_quote_content", "bh_c_define", "bh_c_define_center", "bh_c_define_open", "bh_c_define_close", "bh_c_define_content", "bh_regex", "bh_regex_center", "bh_regex_open", "bh_regex_close", "bh_regex_content", "bh_curly", "bh_curly_center", "bh_curly_open", "bh_curly_close", "bh_curly_content", "bh_square", "bh_square_center", "bh_square_open", "bh_square_close", "bh_square_content", "bh_angle", "bh_angle_center", "bh_angle_open", "bh_angle_close", "bh_angle_content", "bh_unmatched", "bh_unmatched_center", "bh_unmatched_open", "bh_unmatched_close", "bh_unmatched_content", "bh_tag", "bh_tag_center", "bh_tag_open", "bh_tag_close", "bh_tag_content" ], "incomplete_sync": null, "r_box_status": false, "remote_loading": false, "synced": false, "syntax": "Packages/R-Box/syntax/R Extended.tmLanguage", "syntax_mgr_loaded": true, "tab_size": 2, "translate_tabs_to_spaces": true }, "translation.x": 0.0, "translation.y": 0.0, "zoom_level": 1.0 }, "stack_index": 0, "type": "text" }, { "buffer": 1, "file": "/Users/rsaporta/git/orch/src/DeNormalizing/Additional Tables/carve_outs.r", "semi_transient": false, "settings": { "buffer_size": 9620, "regions": { }, "selection": [ [ 0, 0 ] ], "settings": { "BracketHighlighterBusy": false, "bh_regions": [ "bh_default", "bh_default_center", "bh_default_open", "bh_default_close", "bh_default_content", "bh_round", "bh_round_center", "bh_round_open", "bh_round_close", "bh_round_content", "bh_double_quote", "bh_double_quote_center", "bh_double_quote_open", "bh_double_quote_close", "bh_double_quote_content", "bh_single_quote", "bh_single_quote_center", "bh_single_quote_open", "bh_single_quote_close", "bh_single_quote_content", "bh_c_define", "bh_c_define_center", "bh_c_define_open", "bh_c_define_close", "bh_c_define_content", "bh_regex", "bh_regex_center", "bh_regex_open", "bh_regex_close", "bh_regex_content", "bh_curly", "bh_curly_center", "bh_curly_open", "bh_curly_close", "bh_curly_content", "bh_square", "bh_square_center", "bh_square_open", "bh_square_close", "bh_square_content", "bh_angle", "bh_angle_center", "bh_angle_open", "bh_angle_close", "bh_angle_content", "bh_unmatched", "bh_unmatched_center", "bh_unmatched_open", "bh_unmatched_close", "bh_unmatched_content", "bh_tag", "bh_tag_center", "bh_tag_open", "bh_tag_close", "bh_tag_content" ], "incomplete_sync": null, "r_box_status": false, "remote_loading": false, "synced": false, "syntax": "Packages/R-Box/syntax/R Extended.tmLanguage", "syntax_mgr_loaded": true, "tab_size": 2, "translate_tabs_to_spaces": true }, "translation.x": 0.0, "translation.y": 0.0, "zoom_level": 1.0 }, "stack_index": 1, "type": "text" } ] } ], "incremental_find": { "height": 25.0 }, "input": { "height": 31.0 }, "layout": { "cells": [ [ 0, 0, 1, 1 ] ], "cols": [ 0.0, 1.0 ], "rows": [ 0.0, 1.0 ] }, "menu_visible": true, "output.exec": { "height": 166.0 }, "output.find_results": { "height": 256.0 }, "output.git-checkout": { "height": 100.0 }, "output.git-commit": { "height": 100.0 }, "output.git-pull": { "height": 82.0 }, "output.git-push": { "height": 94.0 }, "output.sftp": { "height": 0.0 }, "pinned_build_system": "", "project": "Carveouts.sublime-project", "replace": { "height": 46.0 }, "save_all_on_build": true, "select_file": { "height": 0.0, "last_filter": "", "selected_items": [ [ "mk", "supportFns/mkForecast.r" ], [ "push", "DeNormalizing/zCleanTheseUp/AggregatedTables 140902/iTunes RED USA check.r" ], [ "ush", "DeNormalizing/zCleanTheseUp/AggregatedTables 140902/iTunes RED USA check.r" ], [ "jesusfordata_forecasting", "supportFns/jesusForData_Forecasting.r" ], [ "permeat", "supportFns/permeate.r" ], [ "dict.", "supportFns/dict.rev_summary_colnames.r" ], [ "dict", "supportFns/dict.GL_colnames.r" ], [ "manl_cr", "GL_pt3_a Create DT.manl_crop.r" ], [ "mkforecast", "supportFns/mkForecast.r" ], [ "ull", "supportFns/calculateSplitPercentages.r" ], [ "us", "supportFns/calculateSplitPercentages.r" ], [ "r", "03b DB_raw.r" ] ], "width": 0.0 }, "select_project": { "height": 0.0, "last_filter": "", "selected_items": [ ], "width": 0.0 }, "select_symbol": { "height": 392.0, "last_filter": "", "selected_items": [ ], "width": 431.0 }, "selected_group": 0, "settings": { }, "show_minimap": false, "show_open_files": false, "show_tabs": true, "side_bar_visible": false, "side_bar_width": 258.0, "status_bar_visible": true, "template_settings": { } }