Index of /database/dw/changelog/dml

Name ↑SizeModified
⬆..📄1-INSERT-dim_transactiontype.sql277 B2026-07-13 03:27📄1-INSERT-dim_transactiontype_NS.sql307 B2026-07-13 03:27📄2-UPDATE-dim_transactiontype_description_for_streams.sql329 B2026-07-13 03:27📄224_new_dim_store.sql278 B2026-07-13 03:27📄225_new_dim_store.sql285 B2026-07-13 03:27📄225_rm_dup_dim_store.sql304 B2026-07-13 03:27📄226_new_dim_store.sql1.5 KB2026-07-13 03:27📄227_new_dim_store.sql2.1 KB2026-07-13 03:27📄228_new_dim_store.sql1.7 KB2026-07-13 03:27📄229_new_dim_store.sql19.4 KB2026-07-13 03:27📄230_new_dim_store.sql2.7 KB2026-07-13 03:27📄231_new_dim_store.sql3.6 KB2026-07-13 03:27📄232_new_dim_store.sql3.1 KB2026-07-13 03:27📄3-DELETE_dim_transactiontype_subscription_streams.sql361 B2026-07-13 03:27📄3-INSERT-dim_transactiontype_unmonetized_streams.sql403 B2026-07-13 03:27📄4-INSERT-map_transactiontype_youtube_unmonetized_streams.sql353 B2026-07-13 03:27📄5-INSERT-and-UPDATE-for_unmonetized_video_audio_streams.sql1.0 KB2026-07-13 03:27📄5-UPDATE_fact_analytics_with_unmonetized_video_streams.sql413 B2026-07-13 03:27📄ACC-1055_ADD_Publishing_revenue_transaction_types.sql465 B2026-07-13 03:27📄DATA-1231_yt_reprocess.sql891 B2026-07-13 03:27📄DATA-1303-Update_artist_id_in_all_fact_tables.txt1.1 KB2026-07-13 03:27📄DATA-1308-Update_label_id_in_all_fact_table.sql675 B2026-07-13 03:27📄DATA-1340-Update-itunes-to-itunes-apple-music.sql363 B2026-07-13 03:27📄DATA-1344-Delete-duplicated_data.sql507 B2026-07-13 03:27📄DATA-1347-Delete-247-duplicated_data.sql259 B2026-07-13 03:27📄DATA-1355-UPDATE-fix_satellite_transaction_type_typo.sql285 B2026-07-13 03:27📄DATA-1450_change_release_name.sql263 B2026-07-13 03:27📄DATA-1515_DELETE_shadow_deezer_store.sql319 B2026-07-13 03:27📄DATA-1519_INSERT_new_stores.sql723 B2026-07-13 03:27📄DATA-1547-DELETE_COPY_deezer_backfill.sql1.1 KB2026-07-13 03:27📄DATA-1577_DELETE_deezer_2015-05-05.sql282 B2026-07-13 03:27📄DATA-1641-faroe_island-data-fix.sql196 B2026-07-13 03:27📄DATA-1666_UPDATE_fact_analytics_null_catalogid.sql344 B2026-07-13 03:27📄DATA-1668_DELETE_fact_analytics_dummy_track.sql177 B2026-07-13 03:27📄DATA-1668_UNLOAD-dim_catalog_data_for_project_backfill.sql486 B2026-07-13 03:27📄DATA-1719_UPDATE_fact_analytics_null_catalogid.sql303 B2026-07-13 03:27📄DATA-1963_UPDATE_dim_store_for_rhapsody_napster_rename.sql323 B2026-07-13 03:27📄DATA-1994_UPDATE_clean_booked_vendor_contract_snapshot.sql365 B2026-07-13 03:27📄DATA-2096-Update_catalogid_in_all_fact_tables.sql798 B2026-07-13 03:27📄DATA-2111-free_up_space_for_cluster_07_10.sql1.1 KB2026-07-13 03:27📄DATA-2238_DELETE_fact_sales_212.sql216 B2026-07-13 03:27📄DATA-2239_backfill_fact_sales_dummy_data.sql12.6 KB2026-07-13 03:27📄DATA-2239_Update_staging_fact_sales_to_fix_data_error.sql11.7 KB2026-07-13 03:27📄DATA-2386-delete_data_for_period_213.sql152 B2026-07-13 03:27📄DATA-2611_add_pandora_to_dim_store.sql197 B2026-07-13 03:27📄DATA-2891-INSERT-dim_source_of_stream.sql416 B2026-07-13 03:27📄DATA-3090_UPDATE_missing_sos_placements.sql1019 B2026-07-13 03:27📄DATA-3261-spotify_playlists_cache-backfill.sql1.2 KB2026-07-13 03:27📄DATA-3321-Update_spotify_playlists_cache.sql542 B2026-07-13 03:27📄DATA-3331_INSERT_apple_id_mapping.sql432 B2026-07-13 03:27📄DATA-3342-Update_qa_staging_sos_with_sorted_metadata.sql2.6 KB2026-07-13 03:27📄DATA-3372_INSERT_pandora_into_feeddetails.sql258 B2026-07-13 03:27📄DATA-3372_INSERT_pandora_test_data.sql104.9 KB2026-07-13 03:27📄DATA-3372_INSERT_pandora_test_data_2017-04-01.sql104.9 KB2026-07-13 03:27📄DATA-3372_INSERT_pandora_test_data_for_2017-06-25.sql35.0 KB2026-07-13 03:27📄DATA-3372_INSERT_pandora_test_data_label_16055.sql207.2 KB2026-07-13 03:27📄DATA-3372_UPDATE_dayid_for_pandora_test_data.sql351 B2026-07-13 03:27📄DATA-3405_GRANT_staging_raw_pandora.sql311 B2026-07-13 03:27📄DATA-3533-INSERT_fact_demographics.sql1.2 KB2026-07-13 03:27📄DATA-3599-DELETE_spotify_fact_analytics.sql269 B2026-07-13 03:27📄DATA-3599-DELETE_spotify_fact_analytics_error.sql271 B2026-07-13 03:27📄DATA-3602_UPDATE_units_google_music.sql1.5 KB2026-07-13 03:27📄DATA-3602_UPDATE_units_google_music_snowflake.sql3.2 KB2026-07-13 03:27📄DATA-3603_UPDATE_fact_analytics_paidunits_for_napster.sql298 B2026-07-13 03:27📄DATA-3603_UPDATE_fact_analytics_paidunits_for_napster_snowflake.sql828 B2026-07-13 03:27📄DATA-3863_ADD_artistid_column_staging_sos_qa.sql187 B2026-07-13 03:27📄DATA-3866_UPDATE_staging_sos_with_artistid.sql744 B2026-07-13 03:27📄DATA-3895_UPDATE_fact_social_profile_metrics.sql740 B2026-07-13 03:27📄DATA-3914_INSERT_amazon_unlimited_feeddetails.sql278 B2026-07-13 03:27📄DATA-3951-DELETE_247_from_fact_analytics_and_error.sql486 B2026-07-13 03:27📄DATA-3951-DELETE_from_fact_analytics_and_error.sql1.4 KB2026-07-13 03:27📄DATA-4128_cleanup_dup_yt_claims.sql1.2 KB2026-07-13 03:27📄DATA-4128_DELETE_reprocess_youtube_claim_physical.sql1.5 KB2026-07-13 03:27📄DATA-4128_UPDATE_physical_to_digital_in_fact_analytics_for_247_on_redshift.sql1.8 KB2026-07-13 03:27📄DATA-4128_UPDATE_physical_to_digital_in_fact_analytics_for_amazon_digital_services_on_redshift.sql2.1 KB2026-07-13 03:27📄DATA-4128_UPDATE_physical_to_digital_in_fact_analytics_for_google.sql2.0 KB2026-07-13 03:27📄DATA-4128_UPDATE_physical_to_digital_in_fact_analytics_for_napster_on_redshift.sql1.8 KB2026-07-13 03:27📄DATA-4128_UPDATE_physical_to_digital_in_fact_analytics_for_spotify_on_redshift.sql1.8 KB2026-07-13 03:27📄DATA-4128_UPDATE_physical_to_digital_in_fact_analytics_for_youtube_claim.sql3.0 KB2026-07-13 03:27📄DATA-4128_UPDATE_physical_to_digital_in_fact_analytics_for_youtube_ioda.sql2.9 KB2026-07-13 03:27📄DATA-4128_UPDATE_physical_to_digital_in_fact_analytics_for_youtube_orchard.sql2.8 KB2026-07-13 03:27📄DATA-4128_UPDATE_physical_to_digital_in_fact_analytics_for_youtube_orchard_isrc.sql2.8 KB2026-07-13 03:27📄DC-791_new_spotify_feed.sql791 B2026-07-13 03:27📄DELETE-youtube_vod_temp_tables.sql2.9 KB2026-07-13 03:27📄DELETE_fact_analytics_duplicate_data_2017-07-07.sql451 B2026-07-13 03:27📄delete_spotify_data_from_fact_analytics_2017-03-28.sql279 B2026-07-13 03:27📄delete_spotify_data_from_staging_raw_2017-03-28.sql164 B2026-07-13 03:27📄DIG-3039_DELETE_catalog_bad_catalog_entries.sql451 B2026-07-13 03:27📄DIG-3093_DELETE_bad_catalog_numbers.sql437 B2026-07-13 03:27📄DIG-3200-dim-transactiontype-MT.sql403 B2026-07-13 03:27📄DIG-7790_UPDATE_fact_analytics_artitstid_948460_to_969790.sql175 B2026-07-13 03:27📄dim_store_sync.sql2.1 KB2026-07-13 03:27📄FO-161-DELETE_facts_analytics_spotify_dups.sql468 B2026-07-13 03:27📄FO-28_UNLOAD_and_COPY_staging_raw_youtube_claim_reload.sql660 B2026-07-13 03:27📄FO-73_DELETE_from_fact_tables.sql1.9 KB2026-07-13 03:27📄FO-73_DELETE_spotify_data_from_fact_tables.sql1.4 KB2026-07-13 03:27📄FO-74_DELETE_itunes_fanclub_20171228_from_fact.sql675 B2026-07-13 03:27📄FRNT-1117_INSERT_map_transactiontype_rhapsody.sql339 B2026-07-13 03:27📄FRNT-1259-INSERT-Rhapsody-in-feeddetails.sql277 B2026-07-13 03:27📄FRNT-1259-UPDATE-store-names.sql1.1 KB2026-07-13 03:27📄FRNT-1269-UPDATE-Itunes-Apple-Music-feeddetails.sql271 B2026-07-13 03:27📄FRNT-1269-UPDATE-Itunes-Apple-Music-store-name.sql218 B2026-07-13 03:27📄FRNT-1686_INSERT_new_deezer_storeid.sql210 B2026-07-13 03:27📄FRNT-999-UPDATE-dim_transactiontype_description.sql3.9 KB2026-07-13 03:27📄INSERT-fix-223-fact_sales-projectid.sql1.7 KB2026-07-13 03:27📄insert_missing_fact_sales_transactions.sql2.3 KB2026-07-13 03:27📄MOV-1002_update_feeddetails_for_googleplay.sql319 B2026-07-13 03:27📄MOV-1041-Update-dim_store_change-sne-to-playstation-video.sql299 B2026-07-13 03:27📄MOV-1129_INSERT_theatrical_physical_transaction_types.sql631 B2026-07-13 03:27📄MOV-1205_remove_dupe_vudu.sql234 B2026-07-13 03:27📄MOV-1269-INSERT_map_transactiontype_for_itunes_MB.sql226 B2026-07-13 03:27📄MOV-1274_INSERT_fanclub_release_mapping.sql45.3 KB2026-07-13 03:27📄MOV-1298_UPDATE_fanclub_release_mapping.sql1.8 KB2026-07-13 03:27📄MOV-1300_INSERT_fanclub_release_mapping.sql505 B2026-07-13 03:27📄MOV-1327_REPLACE_staging_raw_itunes_with_staging_raw_itunes_new.sql331 B2026-07-13 03:27📄MOV-1368-INSERT-sony-playstation-transactiontype-mapping.sql650 B2026-07-13 03:27📄MOV-1398_INSERT_new_film_transactiontypes.sql1.4 KB2026-07-13 03:27📄MOV-1429-DROP-itunes_fanclub_temp_table.sql1.0 KB2026-07-13 03:27📄MOV-1438-add-sony-amazon-to-analytics-sources.sql1.0 KB2026-07-13 03:27📄MOV-1760_INSERT_new_stores.sql973 B2026-07-13 03:27📄MOV-2111_VUDU_royaltydollars.sql383 B2026-07-13 03:27📄MOV-2114_playstation_royaltydollars.sql785 B2026-07-13 03:27📄MOV-2115_xbox_royaltydollars.sql785 B2026-07-13 03:27📄MOV-2250_playstation_royalty_calcu.sql565 B2026-07-13 03:27📄MOV-2250_vudu_negative_royalty.sql562 B2026-07-13 03:27📄MOV-2250_xbox_royalty_calcu.sql1.2 KB2026-07-13 03:27📄MOV-3033-INSERT-fandango_feedetails.sql305 B2026-07-13 03:27📄MOV-923_change_googlemusic_to_googleplay.sql196 B2026-07-13 03:27📄MOV-923_change_googlemusic_to_googleplay_withspaces.sql195 B2026-07-13 03:27📄MOV-936-INSERT_map_transactiontype_googleplay.sql287 B2026-07-13 03:27📄MOV-945-INSERT_map_transactiontype_for_amz_video.sql320 B2026-07-13 03:27📄MR-1132_delete_yt_weekly_20160919_20161002.sql721 B2026-07-13 03:27📄MR-1311_UNLOAD_and_COPY_staging_raw_youtube_claim_reload.sql626 B2026-07-13 03:27📄MR-1754_delete_yt_weekly_20170403_20170409.sql669 B2026-07-13 03:27📄MR-3672_UNLOAD_and_COPY_staging_raw_youtube_claim_reload.sql614 B2026-07-13 03:27📄MR-488_delete_yt_weekly_20160208_20160214.sql647 B2026-07-13 03:27📄MR-702_update_dim_transaction_type_rc.sql269 B2026-07-13 03:27📄MR-722_insert_dim_store_prs.sql160 B2026-07-13 03:27📄MR-817_delete_yt_weekly_20160711_20160717.sql429 B2026-07-13 03:27📄MR-892_update_dim_store_prs.sql208 B2026-07-13 03:27📄PHYS-1149_INSERT_data_for_a_test_vendor.sql6.1 KB2026-07-13 03:27📄PHYS-1299-add_physical_transaction_types.sql420 B2026-07-13 03:27📄PHYS-2236-INSERT-dim_transactiontype.sql419 B2026-07-13 03:27📄PLAT-1639-INSERT_clean_fae.sql386 B2026-07-13 03:27📄PLAT-1684-DELETE_dup_fact_analytics_am_video.sql766 B2026-07-13 03:27📄PLAT-1706_COPY_missing_fae_youtube_vod.sql1.9 KB2026-07-13 03:27📄PLAT-1882_COPY_fact_sales_error.sql328 B2026-07-13 03:27📄PLAT-2143_dim_tables_data_unload_from_redshift.sql994 B2026-07-13 03:27📄PLAT-2543_UPDATE_staging_sos_trim_isrc.sql142 B2026-07-13 03:27📄PLAT-465_prune_catalogids.sql238.6 KB2026-07-13 03:27📄PLAT-466-clean_dim_project.sql217 B2026-07-13 03:27📄PLAT-466_DELETE_catalogids_wo_releases.sql21.8 KB2026-07-13 03:27📄redshift-DELETE-dup_playstation_2017-09-13.sql228 B2026-07-13 03:27📄redshift_DATA-3574_DELETE_amazon_after_7-12_for_reprocessing.sql1.2 KB2026-07-13 03:27📄redshift_DATA-3675-DELETE_from_fact_analytics_google_music.sql1.9 KB2026-07-13 03:27📄redshift_DATA-3742-DELETE_from_fact_analytics_amazon_digital_services.sql1.3 KB2026-07-13 03:27📄redshift_DS-1004-DELETE_from_fact_analytics_google_music.sql1.5 KB2026-07-13 03:27📄redshift_DS-1004-DELETE_from_fact_analytics_google_music_rerun.sql1.5 KB2026-07-13 03:27📄redshift_DS-1004-DELETE_from_raw_file_ingestion_history.sql570 B2026-07-13 03:27📄redshift_FO-137-DELETE_from_staging_raw_youtube.sql309 B2026-07-13 03:27📄redshift_FO-137-DELETE_from_staging_raw_youtube_2018-02-26.sql309 B2026-07-13 03:27📄redshift_FO-146-DELETE_from_fact_analytics.sql728 B2026-07-13 03:27📄redshift_FO-146-DELETE_from_fact_analytics_error.sql752 B2026-07-13 03:27📄redshift_FO-146-DELETE_from_staging_raw_youtube.sql362 B2026-07-13 03:27📄redshift_FO-161-DELETE_facts_analytics_spotify_dups.sql474 B2026-07-13 03:27📄redshift_FO-161-DELETE_from_fact_analytics_error_spotify.sql922 B2026-07-13 03:27📄redshift_FO-161-DELETE_from_fact_analytics_spotify.sql908 B2026-07-13 03:27📄redshift_FO-24-DELETE_from_fact_analytics_error_google_music.sql872 B2026-07-13 03:27📄redshift_FO-24-DELETE_from_fact_analytics_google_music.sql831 B2026-07-13 03:27📄redshift_FO-25-DELETE_from_raw_file_ingestion_history.sql373 B2026-07-13 03:27📄redshift_FO-33-DELETE_from_fact_analytics_error_google.sql943 B2026-07-13 03:27📄redshift_FO-33-DELETE_from_fact_analytics_google_play.sql922 B2026-07-13 03:27📄redshift_FO-43-DELETE_from_fact_analytics_error_google_music.sql872 B2026-07-13 03:27📄redshift_FO-43-DELETE_from_fact_analytics_google_music.sql831 B2026-07-13 03:27📄redshift_FO-52-DELETE_from_fact_analytics_error_google_music.sql880 B2026-07-13 03:27📄redshift_FO-52-DELETE_from_fact_analytics_google_play.sql830 B2026-07-13 03:27📄redshift_FO-86-DELETE_from_fact_analytics_error_spotify.sql744 B2026-07-13 03:27📄redshift_FO-86-DELETE_from_fact_analytics_spotify.sql709 B2026-07-13 03:27📄redshift_FO-94-DELETE_from_fact_analytics.sql1.1 KB2026-07-13 03:27📄redshift_FO-94-DELETE_from_fact_analytics_error.sql1.1 KB2026-07-13 03:27📄redshift_MOV-2720_UPDATE_HD_SD_Mapping_iTunes_FactAnalytics.sql560 B2026-07-13 03:27📄redshift_MOV-2964-UPDATE_dim_store.sql343 B2026-07-13 03:27📄redshift_MOV-2997-INSERT_map_transactiontype_for_fandango_now.sql322 B2026-07-13 03:27📄redshift_MOV-3112-INSERT_4K_in_dim_format_table.sql214 B2026-07-13 03:27📄redshift_MOV-3121-INSERT_iTunes_backfill_data_with_4K.sql7.7 KB2026-07-13 03:27📄redshift_MOV-3125-INSERT_Googleplay_4K_data.sql4.7 KB2026-07-13 03:27📄redshift_PHYS-2314-UPDATE-transaction-type-description-for-PH.sql427 B2026-07-13 03:27📄snowflake_DATA-3574_DELETE_amazon_after_7-12_for_reprocessing.sql847 B2026-07-13 03:27📄snowflake_DATA-3675-DELETE_from_fact_analytics_google_music.sql1.5 KB2026-07-13 03:27📄snowflake_DATA-3675-DELETE_from_staging_raw_google.sql552 B2026-07-13 03:27📄snowflake_DATA-3742-DELETE_from_fact_analytics_amazon_digital_services.sql1000 B2026-07-13 03:27📄snowflake_DS-1004-DELETE_from_fact_analytics_google_music.sql1.2 KB2026-07-13 03:27📄snowflake_DS-1004-DELETE_from_staging_raw_google.sql456 B2026-07-13 03:27📄snowflake_MOV-2720_UPDATE_HD_SD_Mapping_iTunes_FactAnalytics.sql1.3 KB2026-07-13 03:27📄snowflake_MOV-2964-UPDATE_dim_store.sql365 B2026-07-13 03:27📄snowflake_PHYS-2314-UPDATE-transaction-type-description-for-PH.sql778 B2026-07-13 03:27📄SYS-2885_add_playster_to_dim_store191 B2026-07-13 03:27📄UPDATE_non-interactive_radio_revenue.sql372 B2026-07-13 03:27📄VC-1006_store_name_update.sql663 B2026-07-13 03:27📄VC-2197_remove_storeid_800.sql170 B2026-07-13 03:27📄VC-3253_store_name_update.sql1.6 KB2026-07-13 03:27📄VC-3351-UPDATE_dim_store_name.sql324 B2026-07-13 03:27📄VC-617_update_catalog_number.sql60.9 KB2026-07-13 03:27📄VC-791_update_dim_store_name.sql6.4 KB2026-07-13 03:27📄VS-133_clearout_processed_youtube_claims_data.sql560 B2026-07-13 03:27📄VS-133_DELETE_unused_stores_from_dim_store.sql581 B2026-07-13 03:27📄VS-133_INSERT_claims_channel_transaction_type.sql2.2 KB2026-07-13 03:27📄VS-133_UPDATE_transaction_type_desc_for_claims.sql1.5 KB2026-07-13 03:27📄VS-133_UPDATE_transaction_type_desc_for_claims_with_UGC.sql918 B2026-07-13 03:27📄VS-133_UPDATE_transaction_type_desc_with_Matches.sql906 B2026-07-13 03:27📄VS-161_update_yt_fact_analytics_to_ad_enabled.sql6.7 KB2026-07-13 03:27📄VS-161_yt_analytics_streams.sql2.1 KB2026-07-13 03:27📄VS-296_backfill_ioda.sql6.2 KB2026-07-13 03:27📄VS-312_delete_youtube_analytics_missing_isrc.sql569 B2026-07-13 03:27