{ "auto_complete": { "selected_items": [ [ "trui", "track_uris" ], [ "track_", "track_artists" ], [ "album", "album_artist" ], [ "bucket", "bucket_tracks" ], [ "file.e", "file.exists {base}" ], [ "play", "playlist_uri" ], [ "STREM", "streams_accel_score_scaled_3wk_high" ], [ "meta", "metascore_perc_increase" ], [ "mate", "metascore_accel_score_scaled" ], [ "ma", "main_isrc" ], [ "CTE_", "CTE_Main" ], [ "date", "dateadd" ], [ "dateCol", "dateCol.nm" ], [ "local", "local_extrema" ], [ "accel", "accel_col" ], [ "ctp", "ctp_group" ], [ "streams_score", "streams_accel_score_scaled" ], [ "updo", "updownCol" ], [ "dateco", "dateCol" ], [ "uid", "uid_columns" ], [ "qry.", "qry.counts" ], [ "DT.", "DT.isrc_metadata" ], [ "exist", "exists {base}" ], [ "verbose", "verboseMsg" ], [ "last_", "last_updated" ], [ "colsto", "colsToAgg" ], [ "get_dim_tra", "get_dim_track_with_tuid" ], [ "track_un", "track_unique_id_included" ], [ "isr", "ISRC" ], [ "sour", "SOURCE" ], [ "frm.n", "frmt.null_joiner.numeric" ], [ "colsTop", "colsToPull.cumsum" ], [ "playst", "playlist_uri" ], [ "acce_", "accel_cols" ], [ "main", "main_groups" ], [ "acce", "accel_col" ], [ "Verbo.", "verbose.qry" ], [ "colsTo", "colsToPull" ], [ "create", "create_spotify_user_counts_table" ], [ "playlist", "playlist_is_unknown" ], [ "colsw", "colsWithaggFunc.counts" ], [ "colsT", "colsToAgg.cumsum" ], [ "jion", "join_statement.cumsum" ], [ "palyst", "playlist_is_unknown" ], [ "cumnew", "cumulative_new_users" ], [ "first_", "date_first_streamed" ], [ "colsag", "colsWithaggFunc" ], [ "schema", "schema_from" ], [ "unkno", "unknown" ], [ "unkn", "unknown_uri" ], [ "playlis", "playlist_uri" ], [ "ukno", "unknown_uri" ], [ "release", "release_name" ], [ "artit", "artist_name" ], [ "accl", "accel_score_scaled" ], [ "label_", "label_name" ], [ "artist", "artist_name" ], [ "idetn", "identity {base}" ], [ "TRACK", "track_id" ], [ "schem", "schema_new" ], [ "unk", "unknown" ], [ "track", "track_id" ], [ "row", "row_no" ], [ "row_", "ROW_NUMBER" ], [ "dist", "distinct" ], [ "tbl", "tbl_new" ], [ "accelsc", "accel_score_sclaed" ], [ "unko", "unknown_uri" ], [ "label", "label_is_dthree" ], [ "tmp_DT", "tmp_DT.meta" ], [ "setkey", "setkeyIfNot" ], [ "setke", "setkeyIfNot" ], [ "week", "weekof" ], [ "Dropp", "drop_parent" ], [ "paren", "parent_release_name" ], [ "trans", "transactiontypeid" ], [ "source", "source2" ], [ "labelid", "L.labelid" ], [ "produ", "production.dim_release" ], [ "Vec", "vec" ], [ "boolea", "BOOLEAN" ], [ "boole", "boolean_type" ], [ "join", "joinCols.g" ], [ "co", "colors" ], [ "origin", "original_is_deleted" ], [ "DT.re", "DT.releases" ], [ "uko", "unknown_uri" ], [ "verbos", "verbose" ], [ "file_", "file_candidates" ], [ "locat", "location" ], [ "quote", "quote_string" ], [ "ind", "inds" ], [ "check_", "check_truncatedness" ], [ "colNme", "colnames" ], [ "intege", "integer64" ], [ "quiet", "quietly" ], [ "rows_", "rows_parsed" ], [ "sfCreate", "sfCreateFileFormat.CSV" ], [ "file.ex", "filename.ext" ], [ "comment_", "comments_included" ], [ "commentfot", "comment_tbl_footer" ], [ "comme", "comment_schema" ], [ "accoun", "accounting_next" ], [ "file.mo", "file.model" ], [ "glob", "globalenv" ], [ "envi", "envir" ], [ "filensa", "filename.sample" ], [ "snowl", "snowflake_inuse" ], [ "getSnowfla", "getSnowflakeDB" ], [ "check_s", "check_exists_then_zArchive" ], [ "za", "zArchive_existing" ], [ "zAr", "zArchive_existing" ], [ "model.f", "model.file" ], [ "file.nam", "filename.sample" ], [ "sche", "schmea_view" ], [ "basena", "basename.f.out" ], [ "roya", "royaltydollar" ], [ "downlo", "download_date" ], [ "down", "download_date" ], [ "country", "country_rank_spotifypremium" ], [ "countr", "country_rank_applemusic" ], [ "country_", "country_code" ], [ "dowl", "download_date" ], [ "snowflake", "snowflake_inuse" ], [ "unlo", "unloadQry" ], [ "view_", "views_existing_no_schema" ], [ "views_", "views_existing" ], [ "snowfl", "snowflake_inuse" ] ] }, "buffers": [ { "file": "/Users/rsaporta/git/orch/src/orch_metadata/01 orch_metadata.r", "settings": { "buffer_size": 64, "line_ending": "Unix", "name": "setScience(\"orch_metadata\", subProj=\"\", create=TRU" } }, { "file": "/Users/rsaporta/git/orch/notes/orch_metadata/Orchard Metadata Notes.md", "settings": { "buffer_size": 74, "line_ending": "Unix", "name": "Orchard Metadata Notes" } } ], "build_system": "", "build_system_choices": [ ], "build_varint": "", "command_palette": { "height": 392.0, "last_filter": "rena", "selected_items": [ [ "rena", "File: Rename" ], [ "markdow", "Set Syntax: Markdown" ], [ "sql", "Set Syntax: SQL" ], [ "ren", "File: Rename" ], [ "rext", "Set Syntax: R Extended" ], [ "push", "Git: Push" ], [ "qui", "Git: Quick Commit Current File" ], [ "dele", "File: Delete" ], [ "renam", "File: Rename" ], [ "yaml", "Set Syntax: YAML" ], [ "path", "File: Copy Path" ], [ "reve", "File: Reveal" ], [ "delete", "File: Delete" ], [ "name", "File: Copy Name" ], [ "revea", "File: Reveal" ], [ "qu", "Git: Quick Commit Current File" ], [ "rpro", "R-Box: Choose Program" ], [ "rprogr", "R-Box: Choose Program" ], [ "r program", "R-Box: Choose Program" ], [ "commcur", "Git: Quick Commit Current File" ], [ "pull", "Git: Pull" ], [ "PUSH", "Git: Push" ], [ "QUI", "Git: Quick Commit Current File" ], [ "REX", "Set Syntax: R Extended" ], [ "slq", "Set Syntax: SQL" ], [ "word", "Word Wrap: Toggle" ], [ "wor", "Word Wrap: Toggle" ], [ "minim", "View: Toggle Minimap" ], [ "pus", "Git: Push" ], [ "wo", "Word Wrap: Toggle" ], [ "re", "Set Syntax: R Extended" ], [ "mini", "View: Toggle Minimap" ], [ "Wro", "Word Wrap: Toggle" ], [ "git pu", "Git: Push" ], [ "quic", "Git: Quick Commit Current File" ], [ "rex", "Set Syntax: R Extended" ], [ "r", "R-Box: Choose Program" ], [ "ptah", "File: Copy Path" ], [ "rap", "R Application Switch" ], [ "enh", "Set Syntax: Enhanced-R" ], [ "wro", "Word Wrap: Toggle" ], [ "nam", "File: Copy Name" ], [ "rev", "File: Reveal" ], [ "move", "File: Move" ], [ "ra", "R Application Switch" ], [ "prett", "Pretty JSON: Format (Pretty Print) JSON" ], [ "js", "JSLint" ], [ "json", "Set Syntax: JSON" ], [ "qi", "Git: Quick Commit" ], [ "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" ], [ "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" ], [ "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" ], [ "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" ], [ "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" ] ], "width": 388.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 }, "expanded_folders": [ "/Users/rsaporta/git/orch/src/orch_metadata", "/Users/rsaporta/git/orch/notes/orch_metadata", "/Users/rsaporta/git/orch/plots/orch_metadata", "/Users/rsaporta/git/orch/out/orch_metadata" ], "file_history": [ "/Users/rsaporta/git/misc/rscripts/utils/Orchard_Specific/getISRCMeta.r", "/Users/rsaporta/git/orch/src/Discover_Weekly/count labelids per ISRC.sql", "/Users/rsaporta/git/orch/src/Discover_Weekly/debugging/streams query (country + ISRC meta + Rank).sql", "/Users/rsaporta/git/misc/rscripts/utils/Orchard_Specific/get_sample_isrcs.r", "/Users/rsaporta/git/orch/src/Discover_Weekly/debugging/streams query (ISRC meta + Rank).sql", "/Users/rsaporta/git/orch/src/Discover_Weekly/supportFns/getISRCMeta.r", "/Users/rsaporta/git/orch/src/Discover_Weekly/supportFns/get top performers.r", "/Users/rsaporta/git/orch/src/Discover_Weekly/score up down.r", "/Users/rsaporta/development/looks/auto_generated_lookmls/spot_stream_counts/spot_stream_counts.by_main_isrc.view.lookml", "/Users/rsaporta/git/orch/out/Looker/auto_generated_lookmls/spot_stream_counts/spot_stream_counts.by_main_isrc.view.lookml", "/Users/rsaporta/git/orch/src/Discover_Weekly/debugging/close_to_zero (for deving).sql", "/Users/rsaporta/git/orch/src/Looker/Snowflake Functions.sql", "/Users/rsaporta/git/misc/rscripts/utils/DB_Utils/DB_Utils.r", "/Users/rsaporta/git/orch/src/Discover_Weekly/debugging/ISRC Investigation.R", "/Users/rsaporta/git/orch/src/Discover_Weekly/sample ISRC table creation.sql", "/Users/rsaporta/git/orch/src/Discover_Weekly/streams query (ISRC meta - using UNIQUE).sql", "/Users/rsaporta/git/orch/src/Discover_Weekly/debugging/streams query (ISRC meta - RUB421201604).sql", "/Users/rsaporta/git/orch/src/Discover_Weekly/debugging/new querry.sql", "/Users/rsaporta/git/misc/rscripts/utils/weekdaysPer.r", "/Users/rsaporta/git/orch/src/Looker/supportFns/create_lookml_from_tbl.r", "/Users/rsaporta/git/orch/src/Discover_Weekly/! OS Group Test.r", "/Users/rsaporta/git/misc/rscripts/utils/ggWrappers/gg_Helper_Funcs.r", "/Users/rsaporta/git/orch/src/Discover_Weekly/supportFns/create_counts_table_name_from_colsToPull.r", "/Users/rsaporta/git/orch/src/Discover_Weekly/supportFns/create_spotify_user_counts_table supportFns.r", "/Users/rsaporta/git/orch/src/Discover_Weekly/Disover Weekly II (using view in place of tbl).r", "/Users/rsaporta/git/orch/src/Discover_Weekly/debugging/streams query (ISRC).sql", "/Users/rsaporta/git/orch/src/Discover_Weekly/MANUAL CHECK.R", "/Users/rsaporta/git/orch/src/Discover_Weekly/create user_counts tables programatically.r", "/Users/rsaporta/git/misc/rscripts/utils/Orchard_Specific/get_dim_x.r", "/Users/rsaporta/git/misc/rscripts/utils/DB_Utils/SF_Utils.R", "/Users/rsaporta/git/orch/src/Discover_Weekly/example query.r", "/Users/rsaporta/git/orch/src/Discover_Weekly/user counts.r", "/Users/rsaporta/git/orch/src/Discover_Weekly/user count counts.r", "/Users/rsaporta/git/orch/src/Discover_Weekly/scratch - testing windowing and grouping.R", "/Users/rsaporta/git/misc/rscripts/utils/DB_Utils/makeQry and runQry.r", "/Users/rsaporta/git/orch/src/Spotify Playlist Webscrape/_latestBackups.r", "/Users/rsaporta/git/misc/rscripts/utilsRS.r", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables/Views/spotify.sos_from_raw_view.sql", "/Users/rsaporta/git/orch/src/Discover_Weekly/Data Hygiene - Confirming multiple track artists metadata per track.r", "/Users/rsaporta/git/orch/src/Discover_Weekly/scratch - graphing all of the accel scores.r", "/Users/rsaporta/git/orch/src/Discover_Weekly/Disover Weekly II MEta.r", "/Users/rsaporta/git/orch/src/Discover_Weekly/create meta_from_raw_v2.r", "/Users/rsaporta/git/orch/src/Discover_Weekly/Looking at Fiesta Huasa blowing up.R", "/Users/rsaporta/git/misc/rscripts/utils/ggWrappers/ggLinegraph.r", "/Users/rsaporta/git/orch/sublws/Discover_Weekly/Discover_Weekly.sublime-project", "/Users/rsaporta/git/orch/src/MasterUPC/MasterUPC.r", "/Users/rsaporta/git/orch/src/Discover_Weekly/Disover Weekly.r", "/Users/rsaporta/git/misc/rscripts/utils/DB_Utils/SF_Utils - Table Creations.r", "/Users/rsaporta/git/misc/rscripts/utils/makeSQLtable.r", "/Users/rsaporta/git/orch/src/MasterUPC/ManuallyUpdate.r", "/Users/rsaporta/git/orch/src/MasterUPC/supportFns/get_dict_manual_parent_upcs.r", "/Users/rsaporta/git/misc/rscripts/utils/idcol.r", "/Users/rsaporta/development/looks/find files with count_distinct but no primary_key.r", "/Users/rsaporta/git/misc/rscripts/utils/console_utils.R", "/Users/rsaporta/git/orch/src/Looker/additional_lookml_pieces/filters.yaml", "/Users/rsaporta/git/orch/src/Looker/additional_lookml_pieces/bi.accounting.additional_lookml.ssv", "/Users/rsaporta/git/orch/src/Looker/additional_lookml_pieces/bi.analytics_track_level.additional_lookml.ssv", "/Users/rsaporta/git/orch/src/Looker/supportFns/cleanLookerHeaders_after_download.r", "/Users/rsaporta/git/misc/rscripts/utils/Orchard_Specific/region_group_to_factor.r", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables/Create -- MANUAL SOURCING.r", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables/Create Accounting on Snowflake.r", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables/Accounting/03_AC update_aggregated_accounting_snowflake.sql", "/Users/rsaporta/git/orch/src/DeNormalizing/create BI_Tables_Dump_From_Snowflake_noHeader file format.r", "/Users/rsaporta/git/misc/rscripts/utils/workspace.R", "/Users/rsaporta/git/orch/src/Looker/cleanLookerHeaders_after_download.r", "/Users/rsaporta/git/misc/rscripts/utils/xls/exportXLS.r", "/Users/rsaporta/git/misc/rscripts/utils/Orchard_Specific/market_group_to_factor.r", "/Users/rsaporta/git/orch/src/misc/AppleMusic vs SpotifyPremium - Lee - 2015-08-05.r", "/Users/rsaporta/Desktop/cleopatra - multiple labelids.r", "/Users/rsaporta/Desktop/Apple Music Issues.txt", "/Users/rsaporta/Downloads/GSA bak/GSA - Releases Q1 2014 and 2015.csv", "/Users/rsaporta/development/looks/client_team.model.lookml", "/Users/rsaporta/development/looks/country_view.view.lookml", "/Users/rsaporta/git/misc/rscripts/!!Setup New Install/SetupNewInstall.r", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables/Create All Views.r", "/Users/rsaporta/git/orch/src/Looker/Create LookML from DataTable.r", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables/Create Analytics on Snowflake.r", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables/Analytics/02_AN populate_aggregated_analytics_snowflake.sql", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables/Analytics/03_AN update_aggregated_analytics_snowflake.sql", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables/Accounting/02_AC populate_aggregated_accounting_snowflake.sql", "/Users/rsaporta/git/orch/src/MgmtReport_bak 20140722/GL_pt1_e Ingest RED and OSC percentages.r", "/Users/rsaporta/git/orch/src/DeNormalizing/zCleanTheseUp/zArchived/AggregatedTables 140715/03_AN-update_aggregated_analytics (140715).sql", "/Users/rsaporta/git/orch/src/MGMT_REPORT_FULL_AUTO - Snowflake 20150716.r", "/Users/rsaporta/git/orch/src/DeNormalizing/2015-07-29 - Manual execution of table updates.R", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables/Accounting/01_AC create_aggregated_accounting_snowflake.sql", "/Users/rsaporta/git/orch/src/Looker/Row Numbers for fact_analytics 20150721 -- straight serial.r", "/Users/rsaporta/git/orch/src/Looker/Row Numbers for fact_analytics 20150721.r", "/Users/rsaporta/git/orch/src/ConversionRate/CountConversions.sql", "/Users/rsaporta/git/orch/src/Snowflake_Scratch/spotify json conversion.sql", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables/Accounting_no_RED.sql", "/Users/rsaporta/git/orch/src/Snowflake_Scratch/SF - stages & file format for Apple Music and Spotify [2015-07-07].r", "/Users/rsaporta/git/orch/log/MgmtReport/Automation_ETL+MGMT_LogFile_20150720_2247.logr", "/Users/rsaporta/git/orch/src/misc/Lee Spotify Numbers Request.r", "/Users/rsaporta/git/orch/src/AppleMusic/2015-07-07 Apple Music Overview.r", "/Users/rsaporta/git/orch/src/dbconcile/supportFns/compare_snowflake_to_redshift.r", "/Users/rsaporta/git/misc/rscripts/utils/DB_Utils/SF_Utils_Setters_and_Getters.r", "/Users/rsaporta/git/misc/rscripts/utils/DB_Utils/DB_Utils_Setters_and_Getters.r", "/Users/rsaporta/git/orch/src/Spotify_Streams_Per_Top_Artist/11 Plotting.r", "/Users/rsaporta/git/misc/rscripts/utils/AWS_Utils/AWS_unload_load.r", "/Users/rsaporta/git/orch/src/MGMT_REPORT_FULL_AUTO.r", "/Users/rsaporta/git/orch/src/MgmtReport/DumpTables_to_S3.r", "/Users/rsaporta/git/orch/src/MgmtReport/supportFns/automate new.r", "/Users/rsaporta/git/orch/src/TableBasics/00 REFRESH_ALL TableBasics.r", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables/Views/release_view.sql", "/Users/rsaporta/git/orch/src/Snowflake_Scratch/snowflake_settings.r", "/Users/rsaporta/git/misc/rscripts/utils/setPrompt.r", "/Users/rsaporta/git/orch/src/misc/bane anaysis.r", "/Users/rsaporta/git/misc/rscripts/utils/Orchard_Specific/get_meta.r", "/Users/rsaporta/git/orch/src/Snowflake_Scratch/All Queries To Refresh Spotify Flat Tables.r", "/Users/rsaporta/git/orch/src/Spotify_Stream_Count/playlist_to_collection_conversion.r", "/Users/rsaporta/git/orch/notes/Spotify_Stream_Count/staging_raw_spotify_v2 example.r", "/Users/rsaporta/git/orch/src/Acc_vs_Anal_2015/Acc_vs_Anal_for_Spotify RAW 20150413.r", "/Users/rsaporta/git/orch/src/Spotify_API_V2/streams per source - part 2.r", "/Users/rsaporta/git/orch/src/Spotify_Stream_Count/Spotify_Stream_Count_by_label.r", "/Users/rsaporta/git/misc/rscripts/utils/AWS_Utils/AWS_and_S3_options.r", "/Users/rsaporta/git/!Projects/_find and replace_.sublime-project", "/Users/rsaporta/git/misc/rscripts/utils/aggregateDT and changeAndAggregate.r", "/Users/rsaporta/git/misc/rscripts/utils/exploreDispersion.r", "/Users/rsaporta/git/misc/rscripts/utils/ggWrappers/ggHeatGrid.r", "/Users/rsaporta/git/misc/rscripts/utils/Orchard_Specific/AcctBIandProd_are_synced.r", "/Users/rsaporta/git/misc/rscripts/utils/Orchard_Specific/confirmSameValue.r", "/Users/rsaporta/git/misc/rscripts/utils/Orchard_Specific/getReleaseInfo.r", "/Users/rsaporta/git/misc/rscripts/utils/Orchard_Specific/mbworkbook.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/Accounting - missing transaction types 2015.r", "/Users/rsaporta/git/orch/src/Acc_vs_Anal_2015/Accounting_vs_Analytics_2015 (GL using) - old as of 20150114.r", "/Users/rsaporta/git/orch/src/Acc_vs_Anal_2015/Accounting_vs_Analytics_2015 CTP - DT.iTunes_US_NR.r", "/Users/rsaporta/git/orch/src/Acc_vs_Anal_2015/Comparing OA_acc.acc vs OA_acc.activity.r" ], "find": { "height": 22.0 }, "find_in_files": { "height": 93.0, "where_history": [ "" ] }, "find_state": { "case_sensitive": false, "find_history": [ "!is.null(subproj", "DT.sample", "dense_rank", "BY_MAIN_ISRC", "CTE_Main", "CTE_Rank", "weeks_back", "GROUP BY", "group by", "TMSTAMP", "country_code", "\n , CASE WHEN 1 = streams_is_up_or_down \n AND 1 = LAG(streams_is_up_or_down) OVER (PARTITION BY M.main_isrc, country_code ORDER BY weekof ASC)\n THEN 1 ELSE 0 END \n AS streams_upup\n , CASE WHEN 1 = streams_is_up_or_down \n AND 1 = LAG(streams_is_up_or_down) OVER (PARTITION BY M.main_isrc, country_code ORDER BY weekof ASC)\n AND 1 = LAG(streams_is_up_or_down, 2) OVER (PARTITION BY M.main_isrc, country_code ORDER BY weekof ASC) \n THEN 1 ELSE 0 END \n AS streams_upupup\n , LEAD(streams_is_up_or_down) OVER (PARTITION BY M.main_isrc, country_code ORDER BY weekof ASC) AS streams_next_is_up_or_down\n\n , CASE WHEN 1 = metascore_is_up_or_down \n AND 1 = LAG(metascore_is_up_or_down) OVER (PARTITION BY M.main_isrc, country_code ORDER BY weekof ASC)\n THEN 1 ELSE 0 END \n AS metascore_upup\n , CASE WHEN 1 = metascore_is_up_or_down \n AND 1 = LAG(metascore_is_up_or_down) OVER (PARTITION BY M.main_isrc, country_code ORDER BY weekof ASC)\n AND 1 = LAG(metascore_is_up_or_down, 2) OVER (PARTITION BY M.main_isrc, country_code ORDER BY weekof ASC) \n THEN 1 ELSE 0 END \n AS metascore_upupup\n , LEAD(metascore_is_up_or_down) OVER (PARTITION BY M.main_isrc, country_code ORDER BY weekof ASC) AS metascore_next_is_up_or_down\n\n , R.metascore_accel_score_scaled_3wk_high\n , R.streams_accel_score_scaled_3wk_high\n , R.rank_of_metascore_3wk_high\n , R.rank_of_streams_3wk_high\nFROM CTE_Main M\nLEFT JOIN CTE_Rank R\nON M.main_isrc, country_code = R.main_isrc, country_code \nORDER BY M.main_isrc, country_code, M.weekof", "country_code", "main_isrc", "dense_rank", "rank", "Various", "+", "groups", "drop_parent", "getISRCMeta <- ", "getisrc", "get_isrc", "streams_increase", "ggline", "upup", "upupup", "ggline", ",", "up", "increase", "streamsscore_is_up_or_down", "main_isrc", "meta", " , CASE WHEN BITAND(metascore_is_up_or_down, LAG(metascore_is_up_or_down) OVER (PARTITION BY main_isrc ORDER BY weekof ASC)) THEN 1 ELSE 0 END as metascore_upup\n , CASE WHEN BITAND(BITAND(metascore_is_up_or_down, LAG(metascore_is_up_or_down) OVER (PARTITION BY main_isrc ORDER BY weekof ASC)), LEAD(metascore_is_up_or_down) OVER (PARTITION BY main_isrc ORDER BY weekof ASC)) THEN 1 ELSE 0 END as metascore_upupup\n", "metascore_accel_score_scaled", "spot_stream_counts_prod.BY_main_isrc_with_rank", "with_rank_with_rank", "BY_main_isrc", "prod.SPOT_STREAM_COUNTS.BY_main_isrc", "by_main_isrc", "2", "accel_score", "/Users/rsaporta/git", "title", "ggline", "linetype", "label=", "label = ", "label", "BRWR", ".9", "ggline", "DT.accel_accel", "score_accel_score", "metascore", "isrc", "by_isrc", "nvl", "insert into", "CTE_Counts", "spot_stream_counts.by_isrc", "table spot_stream_counts.by_isrc", "spot_stream_counts.by_isrc", "dateCol.nm", "getDateCol", "tbl_in", "having_clause", "imension", "date", "measures", "metascore", "nms", "gglinegraph", "ggline", "as ", "score_accel_score", "score_accel", "getISRC", "metascore", "metascore <-", "stream_count", "diffCol", "AS ", "getISRCMeta <- ", "cols <-", "cols", "ctp", "dateCol", "make_addl_col", "FIRST_TMSTAMP", "new_users", "colsToAgg", "date", "colsWithaggFunc.counts", "colsToPull.counts", "colsWithaggFunc", "schema", "create_spotify_user_counts_table", "ctp", "partition by", "groups <- ", "getISRCMeta <- ", "getISRCMeta", "getISRC", "colsThatWillBeCumSumd", "diff_in", "source", "isrc, source", "os_group", "weekof_first_streamed", "::weekof", "date", "new_users", "country", "catn", "addl_cols", "colsToPull.cumsum", "T1.", "colsToAgg", "with.cumsum", "with.self_join", "colsThatWillBeCumSumd", "colsThatWillBeCumSumd.self_join", "colsToAgg.self_join", "cumsum", "colsToAgg.self_join", "cumsum" ], "highlight": true, "in_selection": false, "preserve_case": false, "regex": false, "replace_history": [ "M.country_code", "country_code", "main_isrc, country_code", "main_isrc", "streams_is_up_or_down", "streams", "BY_main_isrc_with_rank", "spot_stream_counts_prod.BY_main_isrc_with_rank", "with_rank", "with_rank_with_rank", "prod.BY_main_isrc_with_rank", "prod.SPOT_STREAM_COUNTS.BY_main_isrc_with_rank", "~/git", "/Users/rsaporta/git", "main_isrc", "partitionby", "orderby", "make_accel_cols", "colsWithaggFunc", "colsWithaggFunc.counts", "colsToPull", "colsToPull.counts", "create_spotify_stream_counts_table", "create_spotify_user_counts_table", "isrc", "::date", "weekof", "colsToPull.cumsum", "colsToAgg", "with.cumsum", "with.self_join", "colsThatWillBeCumSumd", "colsThatWillBeCumSumd.self_join", "%b", "addl_cols", "make_addl_col", "make_accel_col", "SpotifyAggregates", "'", "first_tmstamp::date)", "first_tmstamp::)", "max(last_tmstamp::date) AS date_last_streamed", "max(last_tmstamp) AS last_tmstamp", "min(first_tmstamp::) AS date_first_streamed", "spot_user_counts.user_m", "spotify.user_m", "FROM spotify.user_minmax_timestamps_detailed", "FROM user_minmax_timestamps_detailed", "isrc", "~~~~~~~~~~~~", "\", \"", "\",\"", "setIDCols", "verbose", "parent_upc", "parent_UPC", "dict.manual_parent_upcs", "overwrite", "cols_actually_integers", "DT.actually_integers", "schema", "", "ugc", ".create_looker_table_view_name", "create_looker_table_view_name", "create_lookml_model_from_schema", "create_model_from_schema", "create_lookml_model", "create_model_from_files", "pattern", "zArchive_if_flagged", "rsync=TRUE", "rsync=FALSE", "=tbl.apple", "call.", "transaction_type_id", "foreign_key: releaseid", "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", "", "\\'" ], "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/orch_metadata/01 orch_metadata.r", "semi_transient": false, "settings": { "buffer_size": 64, "regions": { }, "selection": [ [ 64, 64 ] ], "settings": { "BracketHighlighterBusy": false, "auto_name": "setScience(\"orch_metadata\", subProj=\"\", create=TRU", "bh_regions": [ "bh_double_quote", "bh_double_quote_center", "bh_double_quote_open", "bh_double_quote_close", "bh_double_quote_content", "bh_square", "bh_square_center", "bh_square_open", "bh_square_close", "bh_square_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_c_define", "bh_c_define_center", "bh_c_define_open", "bh_c_define_close", "bh_c_define_content", "bh_angle", "bh_angle_center", "bh_angle_open", "bh_angle_close", "bh_angle_content", "bh_tag", "bh_tag_center", "bh_tag_open", "bh_tag_close", "bh_tag_content", "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_unmatched", "bh_unmatched_center", "bh_unmatched_open", "bh_unmatched_close", "bh_unmatched_content", "bh_single_quote", "bh_single_quote_center", "bh_single_quote_open", "bh_single_quote_close", "bh_single_quote_content" ], "incomplete_sync": null, "r_box_status": false, "syntax": "Packages/R-Box/syntax/R Extended.tmLanguage", "syntax_mgr_loaded": 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/notes/orch_metadata/Orchard Metadata Notes.md", "semi_transient": false, "settings": { "buffer_size": 74, "regions": { }, "selection": [ [ 0, 0 ] ], "settings": { "BracketHighlighterBusy": false, "auto_name": "Orchard Metadata Notes", "bh_regions": [ "bh_double_quote", "bh_double_quote_center", "bh_double_quote_open", "bh_double_quote_close", "bh_double_quote_content", "bh_square", "bh_square_center", "bh_square_open", "bh_square_close", "bh_square_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_c_define", "bh_c_define_center", "bh_c_define_open", "bh_c_define_close", "bh_c_define_content", "bh_angle", "bh_angle_center", "bh_angle_open", "bh_angle_close", "bh_angle_content", "bh_tag", "bh_tag_center", "bh_tag_open", "bh_tag_close", "bh_tag_content", "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_unmatched", "bh_unmatched_center", "bh_unmatched_open", "bh_unmatched_close", "bh_unmatched_content", "bh_single_quote", "bh_single_quote_center", "bh_single_quote_open", "bh_single_quote_close", "bh_single_quote_content" ], "incomplete_sync": null, "syntax": "Packages/Markdown/Markdown.tmLanguage", "syntax_mgr_loaded": true }, "translation.x": 0.0, "translation.y": 0.0, "zoom_level": 1.0 }, "stack_index": 1, "type": "text" } ] } ], "incremental_find": { "height": 21.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.find_results": { "height": 256.0 }, "output.sftp": { "height": 0.0 }, "pinned_build_system": "", "project": "orch_metadata.sublime-project", "replace": { "height": 40.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": true, "show_open_files": true, "show_tabs": true, "side_bar_visible": true, "side_bar_width": 225.0, "status_bar_visible": true, "template_settings": { } }