Index of /database/snowflake/FACTS/build/changelog/dml

Name ↑SizeModified
⬆..📄ACC-1055_Add_publishing_revenue_transaction_types.sql465 B2026-07-13 03:27📄ACC-1093_Update_null_imprints_value.sql526 B2026-07-13 03:27📄ACC-1093_UPDATE_null_subaccountid_value_in_fact_sales.sql808 B2026-07-13 03:27📄ACC-1226_add_missing_stores.sql447 B2026-07-13 03:27📄ACC-1483-Update_dim_period_table.sql953 B2026-07-13 03:27📄ACC-1521-move_RED_films_to_the_music_accounts.sql1.3 KB2026-07-13 03:27📄ACC-1641_fix_subaccountids.sql1016 B2026-07-13 03:27📄ACC-1641_revert_move_RED_releases_to_MRI.sql685 B2026-07-13 03:27📄ACC-1643_fix_fa.sql103.8 KB2026-07-13 03:27📄ACC-1672_dedupe_fact_sales_error.sql438 B2026-07-13 03:27📄ACC-1672_fix_phonofile_sales.sql2.0 KB2026-07-13 03:27📄ACC-1672_period_240_store_insert.sql966 B2026-07-13 03:27📄ACC-1691_adding_a_new_type.sql251 B2026-07-13 03:27📄ACC-1862_update_missing_subaccountids.sql281 B2026-07-13 03:27📄ACC-1903_delete_booked_vendor_contract_snapshot_duplicate_reccords.sql425 B2026-07-13 03:27📄ACC-2509_update_musically_dms_tiktok.sql326 B2026-07-13 03:27📄ACC-2627_adding_a_new_txntype_FS.sql259 B2026-07-13 03:27📄ACC-2696_adding_a_new_txntypes_PM-VA.sql402 B2026-07-13 03:27📄ACC-3234_adding_a_new_txntype_FS.sql536 B2026-07-13 03:27📄ACC-3353_clean_dim_release_dim_artist.sql503 B2026-07-13 03:27📄ACC-3353_clean_dim_release_dim_artist_v2.sql552 B2026-07-13 03:27📄ACC-3353_update_fact_analytics_artist_id_2013.sql425 B2026-07-13 03:27📄ACC-3353_update_fact_analytics_artist_id_2013_v2.sql431 B2026-07-13 03:27📄ACC-3353_update_fact_analytics_artist_id_2014.sql425 B2026-07-13 03:27📄ACC-3353_update_fact_analytics_artist_id_2014_v2.sql431 B2026-07-13 03:27📄ACC-3353_update_fact_analytics_artist_id_2015.sql425 B2026-07-13 03:27📄ACC-3353_update_fact_analytics_artist_id_2015_v2.sql431 B2026-07-13 03:27📄ACC-3353_update_fact_analytics_artist_id_2016.sql425 B2026-07-13 03:27📄ACC-3353_update_fact_analytics_artist_id_2016_v2.sql431 B2026-07-13 03:27📄ACC-3353_update_fact_analytics_artist_id_2017.sql425 B2026-07-13 03:27📄ACC-3353_update_fact_analytics_artist_id_2017_v2.sql431 B2026-07-13 03:27📄ACC-3353_update_fact_analytics_artist_id_2018.sql425 B2026-07-13 03:27📄ACC-3353_update_fact_analytics_artist_id_2018_v2.sql431 B2026-07-13 03:27📄ACC-3353_update_fact_analytics_artist_id_2019.sql425 B2026-07-13 03:27📄ACC-3353_update_fact_analytics_artist_id_2019_v2.sql431 B2026-07-13 03:27📄ACC-3353_update_fact_analytics_artist_id_2020.sql425 B2026-07-13 03:27📄ACC-3353_update_fact_analytics_artist_id_2020_v2.sql431 B2026-07-13 03:27📄ACC-3353_update_fact_analytics_artist_id_2021.sql403 B2026-07-13 03:27📄ACC-3353_update_fact_analytics_artist_id_2021_v2.sql410 B2026-07-13 03:27📄ACC-3353_update_fact_analytics_artist_id_pre_2013.sql403 B2026-07-13 03:27📄ACC-3353_update_fact_analytics_artist_id_pre_2013_v2.sql409 B2026-07-13 03:27📄ACC-3353_update_fact_sales_artist_id.sql300 B2026-07-13 03:27📄ACC-3444_update_fact_sales.sql357 B2026-07-13 03:27📄ACC-3482_add_sc_txn_type.sql252 B2026-07-13 03:27📄ACC-3485_add_ac_ao_txn_type.sql464 B2026-07-13 03:27📄ACC-3562_update_WPtoAS_p267.sql654 B2026-07-13 03:27📄ACC-3660_update_storenames.sql1.1 KB2026-07-13 03:27📄ACC-3754_delete_vendor_contract_entry_facts.sql666 B2026-07-13 03:27📄ACC-3779_adding_a_new_txntype_SF.sql299 B2026-07-13 03:27📄ACC-3779_update_trans_type_SF.sql245 B2026-07-13 03:27📄ACC-4017_delete_records_from_sonyjv_247.sql165 B2026-07-13 03:27📄ACC-4089_fix_mismatched_isrcs_in_staging.sql561 B2026-07-13 03:27📄ACC-4100_adding_new_txn_types_WA_WS.sql478 B2026-07-13 03:27📄ACC-4254_workstation_summary_view.sql11.9 KB2026-07-13 03:27📄ACC-4254_workstation_summary_view_2.sql10.3 KB2026-07-13 03:27📄ACC-4277_update_upc_for_subacct_2.sql818 B2026-07-13 03:27📄ACC-4657-fix_unmapped_isrc_in_staging.sql307 B2026-07-13 03:27📄ACC-4665_add_sax_types_to_dim_trans.sql4.3 KB2026-07-13 03:27📄ACC-4885-fix-satellite-radio-tt-abbr.sql445 B2026-07-13 03:27📄ACC-5199-update-dim-period-table.sql3.7 KB2026-07-13 03:27📄ACC-5613_update_workstation_summary_view.sql23.8 KB2026-07-13 03:27📄ACC-6632-1_add_SA_transacton_type.sql315 B2026-07-13 03:27📄ACC-6734_update_artistid_for_5017742006516.sql676 B2026-07-13 03:27📄ACC-6822-1_reallocate_TR_type_to_correct_txn.sql12.1 KB2026-07-13 03:27📄ACC-7152-1_null_out_dim_track.sql908 B2026-07-13 03:27📄ACC-7162-1_null_out_dim_track_konzilla.sql926 B2026-07-13 03:27📄ACC-7163_remap_konzilla_rev_trackid.sql952 B2026-07-13 03:27📄ACC-7178_remap_rimas_subaccounts_on_sales_periods_303_304.sql7.1 KB2026-07-13 03:27📄ACC-7180-1_add_UQ_NQ_transaction_types.sql360 B2026-07-13 03:27📄ACC-7479_fix_bad_isrcid_in_staging.sql502 B2026-07-13 03:27📄ACC-7479_fix_bad_isrcid_in_staging_2.sql504 B2026-07-13 03:27📄ACC-7508-4_add_FP_tt_dim.sql248 B2026-07-13 03:27📄ACC-7753-update-artist-id-for-release.sql603 B2026-07-13 03:27📄ACC-7772-update-subccount-for-upc.sql743 B2026-07-13 03:27📄ACC-8142_fix_unmapped_isrcs.sql4.4 KB2026-07-13 03:27📄ACC-8213-update-imprint-ids-for-label-75675.sql1.3 KB2026-07-13 03:27📄ACC-8294-1-add-KS-KA-transaction-types.sql417 B2026-07-13 03:27📄ACC-8458-add-youtube-transaction-types.sql1.3 KB2026-07-13 03:27📄ACC-8543-update-artist-id-for-release.sql639 B2026-07-13 03:27📄ACC-8564-update-artist-id-for-release.sql638 B2026-07-13 03:27📄ACC-8643-update-track-ids-for-label-82439-period-316.sql15.3 KB2026-07-13 03:27📄ACC-9068_backfill_labelid_on_releases.sql1.6 KB2026-07-13 03:27📄ACC-9900_update_smithsonian_releases.sql55.4 KB2026-07-13 03:27📄ACC_1749_update_artistid_fact_sales.sql159.1 KB2026-07-13 03:27📄ACCP-9_INSERT_spotify_entry_to_dim_transaction_type.sql248 B2026-07-13 03:27📄ACCP-9_INSERT_spotify_entry_to_dim_transaction_type_update.sql248 B2026-07-13 03:27📄ACCRUN-249-insert-new-stores.sql443 B2026-07-13 03:27📄ACCRUN-249-remove-error-rows.sql2.0 KB2026-07-13 03:27📄AS-369_add_existing_collaborator_split_data.sql1.4 KB2026-07-13 03:27📄CAT-803_UPDATE_fact_analytics_artitstid_986794_to_954165.sql204 B2026-07-13 03:27📄CCM-2482_delete_facts_dim_track.sql409 B2026-07-13 03:27📄CCM-2643-dont-ingest-Som-Livre-SMEAnalyticsDummy.sql210 B2026-07-13 03:27📄CCM-699_UPDATE_es_for_missing_in_elasticsearch.sql1.9 KB2026-07-13 03:27📄CDAM-1529_UPDATE_missing_from_elasticsearch.sql63.4 KB2026-07-13 03:27📄CDAM-1838_UPDATE_missing_from_elasticsearch.sql157.5 KB2026-07-13 03:27📄CDM-793_UPDATE_es_for_missing_in_elasticsearch.sql113.1 KB2026-07-13 03:27📄change_amazon_album_id_type.sql705 B2026-07-13 03:27📄DATA-3664_DELETE_from_fact_analytics_and_fact_analytics_error_for_amazon_unlimited.sql332 B2026-07-13 03:27📄DATA-3874_COPY_test_data_into_S3_with_keys.sql338 B2026-07-13 03:27📄DATA-3896_INSERT_amazon_unlimited_test_data_label_16055.sql145.2 KB2026-07-13 03:27📄DATA-3906-INSERT_qa_factanalytics_backfilling.sql1.0 KB2026-07-13 03:27📄DATA-3938_ALTER_fact_demographics_swap_with_artistid.sql206 B2026-07-13 03:27📄DATA-3938_DROP_fact_demographics_with_artistid.sql136 B2026-07-13 03:27📄DATA-3938_INSERT_into_fact_demographics_with_artistid.sql1.2 KB2026-07-13 03:27📄DATA-3938_INSERT_into_fact_demographics_with_artistid_from_prod.sql1.3 KB2026-07-13 03:27📄DATA-3938_INSERT_into_fact_demographics_with_artistid_no_row_id.sql1.2 KB2026-07-13 03:27📄DATA-4046_DELETE_staging_sos_20171022.sql299 B2026-07-13 03:27📄DATA-4048_INSERT_qa_canonical_track_metadata.sql2.1 KB2026-07-13 03:27📄DATA-4128_DELETE_cleanup_dup_yt_claims.sql453 B2026-07-13 03:27📄DATA-4128_DELETE_reprocess_youtube_claim_physical.sql1.1 KB2026-07-13 03:27📄DATA-4128_INSERT_remaining_physical_units_into_FAE_from_FA.sql1.7 KB2026-07-13 03:27📄DATA-4128_UPDATE_physical_to_digital_in_fact_analytics_for_247.sql1.8 KB2026-07-13 03:27📄DATA-4128_UPDATE_physical_to_digital_in_fact_analytics_for_amazon_digital_services.sql2.1 KB2026-07-13 03:27📄DATA-4128_UPDATE_physical_to_digital_in_fact_analytics_for_google.sql1.9 KB2026-07-13 03:27📄DATA-4128_UPDATE_physical_to_digital_in_fact_analytics_for_napster.sql1.8 KB2026-07-13 03:27📄DATA-4128_UPDATE_physical_to_digital_in_fact_analytics_for_spotify.sql1.8 KB2026-07-13 03:27📄DATA-4128_UPDATE_physical_to_digital_in_fact_analytics_for_youtube_claim.sql2.9 KB2026-07-13 03:27📄DATA-4128_UPDATE_physical_to_digital_in_fact_analytics_for_youtube_ioda.sql2.8 KB2026-07-13 03:27📄DATA-4128_UPDATE_physical_to_digital_in_fact_analytics_for_youtube_orchard.sql2.7 KB2026-07-13 03:27📄DATA-4128_UPDATE_physical_to_digital_in_fact_analytics_for_youtube_orchard_isrc.sql2.7 KB2026-07-13 03:27📄DATA-4181_DELETE_staging_sos_20171107.sql300 B2026-07-13 03:27📄DATA-4353_DELETE_from_fa_amazon_data_june_2017.sql215 B2026-07-13 03:27📄DATA-4362_DELETE_staging_sos_20171113.sql299 B2026-07-13 03:27📄DATA-4519_INSERT_demographics_region_mapping.sql55.7 KB2026-07-13 03:27📄DATA-4567_INSERT_into_demographics_region_mapping.sql19.5 KB2026-07-13 03:27📄DATA-4567_INSERT_into_demographics_region_mapping_2_additional_regions.sql417 B2026-07-13 03:27📄DATA-4574-insert_into_demographics_region_mapping_GB_London.sql21.0 KB2026-07-13 03:27📄DATA-4618_cluster_dim_canonical_track_metadata.sql269 B2026-07-13 03:27📄DATA-4641_ALTER_cluster_fact_demographics.sql292 B2026-07-13 03:27📄DATA-4669_DELETE_incorrect_data_for_apple_music.sql285 B2026-07-13 03:27📄DATA-5072_UPDATE_demographics_region_mapping.sql513 B2026-07-13 03:27📄DATA-5171_UPDATE_staging_sos.sql256 B2026-07-13 03:27📄DATA-5271_UPDATE_staging_raw_spotify_v2_copy_source_uri_to_source_uri_legacy.sql254 B2026-07-13 03:27📄DATA-5272_UPDATE_source_uri_column_in_staging_raw_spotify_v2.sql662 B2026-07-13 03:27📄DATA-5354_UPDATE_staging_sos_copy_playlist_url_to_playlist_url_legacy.sql242 B2026-07-13 03:27📄DATA-5911-insert-trending-tracks-country-group.sql3.4 KB2026-07-13 03:27📄DATA-5911_INSERT_into_trending_tracks_country_group.sql3.4 KB2026-07-13 03:27📄DATA-5911_INSERT_into_trending_tracks_country_group_country.sql11.6 KB2026-07-13 03:27📄DATA-6240_INSERT_trending_tracks_country_group.sql1.4 KB2026-07-13 03:27📄DATA-6240_INSERT_trending_tracks_country_group_country.sql9.9 KB2026-07-13 03:27📄DATA-6240_UPDATE_TRENDING_TRACKS_COUNTRY_GROUP_COUNTRY_TURKEY.sql323 B2026-07-13 03:27📄DATA-6563_INSERT_dim_playlist.sql9.7 KB2026-07-13 03:27📄DATA-6563_INSERT_dim_playlist_2.sql13.6 KB2026-07-13 03:27📄DATA-6563_INSERT_dim_user.sql3.7 KB2026-07-13 03:27📄DATA-6563_INSERT_dim_user_2.sql6.2 KB2026-07-13 03:27📄DATA-6563_INSERT_INTO_dim_licensor_itunes_sme.sql370 B2026-07-13 03:27📄DATA-6563_INSERT_INTO_dim_licensor_youtube_weekly.sql223 B2026-07-13 03:27📄DATA-6563_INSERT_spotify_users_in_dim_playlist.sql1.4 KB2026-07-13 03:27📄DATA-6563_UPDATE_dim_user_to_fix_licensorid.sql257 B2026-07-13 03:27📄DATA-6595-DELETE_from_fact_analytics.sql414 B2026-07-13 03:27📄DATA-7133_INSERT_dim_user.sql2.6 KB2026-07-13 03:27📄DATA-7133_INSERT_dim_user_amu.sql1.1 KB2026-07-13 03:27📄DATA-7133_UPDATE_dim_playlist_dailyMix.sql241 B2026-07-13 03:27📄DATA-7160_ALTER_fact_analytics_v2.sql2.0 KB2026-07-13 03:27📄DATA-7181_INSERT_dim_playlist_amu.sql1.9 KB2026-07-13 03:27📄DATA-7181_INSERT_dim_user_amu_data.sql821 B2026-07-13 03:27📄DATA-7207_UPDATE_dim_playlist_ams_urls.sql613 B2026-07-13 03:27📄DATA-7211_INSERT_deprecated_feeds_to_dim_feed.sql442 B2026-07-13 03:27📄DATA-7211_INSERT_dim_feed_emusic.sql153 B2026-07-13 03:27📄DATA-7212_ALTER_fact_analytics_v2_cluster_as_fa.sql161 B2026-07-13 03:27📄DATA-7233-UPDATE_dim_playlist_personalized_playlists.sql684 B2026-07-13 03:27⚙️DATA-8949_backfill_LABEL_PARTICIPANT_PARTICIPATED_IN_ORCHARD_PRODUCT.xml890 B2026-07-13 03:27📄DIG-7790_UPDATE_fact_analytics_artitstid_948460_to_969790.sql198 B2026-07-13 03:27📄DIS-1005_UPDATE_es_columns_for_missing_in_es.sql44.1 KB2026-07-13 03:27📄DIS-3376_UPDATE_missing_from_elasticsearch.sql32.3 KB2026-07-13 03:27📄DIS-897_UPDATE_es_indexed_to_false_for_unindexed.sql48.5 KB2026-07-13 03:27📄DISTRO-1068_UPDATE_fact_conflict_conflicting_owner_names.sql656 B2026-07-13 03:27📄DISTRO-1180-unresolve-conflicts.sql761 B2026-07-13 03:27📄DISTRO-1180_UPDATE_es_column_for_unresolved.sql538 B2026-07-13 03:27📄DISTRO-1180_UPDATE_es_columns_for_missing_in_es.sql1.5 KB2026-07-13 03:27📄DISTRO-1180_UPDATE_unresolve_conflicts_20190813.sql788 B2026-07-13 03:27📄DISTRO-1358_UPDATE_missing_from_elasticsearch_qa.sql13.9 KB2026-07-13 03:27📄DISTRO-1519_UPDATE-dim_store-storename.sql312 B2026-07-13 03:27📄DISTRO-1567_UPDATE_es_columns_for_missing_in_es.sql33.4 KB2026-07-13 03:27📄DISTRO-1730_UPDATE_es_columns_for_missing_in_es.sql66.6 KB2026-07-13 03:27📄DISTRO-1730_UPDATE_es_columns_for_missing_in_es_2.sql9.9 KB2026-07-13 03:27📄DISTRO-1730_UPDATE_es_columns_for_missing_in_es_3.sql2.0 KB2026-07-13 03:27📄DISTRO-1730_UPDATE_es_columns_for_missing_in_es_4.sql6.9 KB2026-07-13 03:27📄DISTRO-1921_reset_resolved_datetimes.sql997 B2026-07-13 03:27📄DISTRO-1921_UPDATE_elasticsearch_columns.sql199 B2026-07-13 03:27📄DISTRO-2202_reset_resolved_datetime_and_es_columns.sql947 B2026-07-13 03:27📄DISTRO-2636_UPDATE_es_column_for_all_unresolved.sql293 B2026-07-13 03:27📄DISTRO-2636_UPDATE_unresolve_conflicts_20200303.sql788 B2026-07-13 03:27📄DISTRO-2636_UPDATE_unresolve_conflicts_20200303_2.sql794 B2026-07-13 03:27📄DISTRO-2957_UPDATE_missing_from_elasticsearch.sql28.1 KB2026-07-13 03:27📄DISTRO-3138_UPDATE_missing_from_elasticsearch.sql29.7 KB2026-07-13 03:27📄DISTRO-3663_UPDATE_missing_from_elasticsearch.sql30.3 KB2026-07-13 03:27📄DISTRO-3983_UPDATE_fact_analytics.sql1.1 KB2026-07-13 03:27📄DISTRO-4085_UPDATE_missing_from_elasticsearch.sql50.9 KB2026-07-13 03:27📄DISTRO-408_UPDATE_fact_conflict_fix_es.sql498 B2026-07-13 03:27📄DISTRO-4396_UPDATE_resolved_datetime_and_es_indexed_for_20201203.sql983 B2026-07-13 03:27📄DISTRO-4707_fix_bad_data_1.sql344 B2026-07-13 03:27📄DISTRO-4707_fix_bad_data_2.sql344 B2026-07-13 03:27📄DISTRO-4707_fix_bad_data_3.sql342 B2026-07-13 03:27📄DISTRO-4707_fix_isrc_casing.sql225 B2026-07-13 03:27📄DISTRO-4707_fix_json_data_1.sql1.1 KB2026-07-13 03:27📄DISTRO-4707_fix_json_data_2.sql578 B2026-07-13 03:27📄DISTRO-4707_fix_json_data_3.sql583 B2026-07-13 03:27📄DISTRO-4707_fix_json_data_4.sql583 B2026-07-13 03:27📄DISTRO-4707_remove_deleted_track.sql432 B2026-07-13 03:27📄DISTRO-4707_remove_deleted_track_jsonified.sql689 B2026-07-13 03:27📄DISTRO-477_UPDATE_es_indexed_to_false_for_unindexed.sql53.4 KB2026-07-13 03:27📄DISTRO-477_UPDATE_remaining_missing_es_id.sql178 B2026-07-13 03:27📄DISTRO-746_DELETE_unactioned_duplicate_conflicts_with_new_conflicting_owner_names.sql875 B2026-07-13 03:27📄DISTRO-746_UPDATE_es_ids_for_unactioned_unresolved_conflicts.sql348 B2026-07-13 03:27📄DISTRO-746_UPDATE_es_indexed_to_false_for_unindexed.sql91.3 KB2026-07-13 03:27📄DISTRO-746_UPDATE_es_indexed_to_false_for_unindexed_2.sql178 B2026-07-13 03:27📄DISTRO-746_UPDATE_resolved_for_unactioned_duplicate_conflicts.sql983 B2026-07-13 03:27📄DISTRO-961_DELETE_actioned_duplicate_conflicts_with_new_conflicting_owner_names.sql656 B2026-07-13 03:27📄DISTRO-961_UPDATE_es_indexed_to_false_for_unindexed.sql757 B2026-07-13 03:27📄DISTRO-961_UPDATE_resolved_for_actioned_duplicate_conflicts.sql1015 B2026-07-13 03:27📄DROP_deprecated_comment_count_in_dim_youtube_channel_names.sql246 B2026-07-13 03:27📄DROP_deprecated_dbt_tables_2.sql8.2 KB2026-07-13 03:27📄DROP_temp_sme_tables_1.sql740.8 KB2026-07-13 03:27📄DROP_temp_sme_tables_2.sql701.5 KB2026-07-13 03:27📄DS-1004-DELETE_from_fact_analytics_google_music.sql626 B2026-07-13 03:27📄DS-1004-DELETE_from_staging_raw_google.sql325 B2026-07-13 03:27📄DS-10056_UPDATE_dim_youtube_channel_names.sql898 B2026-07-13 03:27📄DS-10111_tiktok_altafonte_duplicates_clean.sql1.8 KB2026-07-13 03:27📄DS-10126_INSERT_to_youtube_neo4j_log.sql821 B2026-07-13 03:27📄DS-10160_update_missing_track_duration.sql674 B2026-07-13 03:27📄DS-10192-DELETE_from_apple_id_mapping.sql483 B2026-07-13 03:27📄DS-10219_restore_altafonte_singlestore_tables.sql2.0 KB2026-07-13 03:27📄DS-10256-INSERT_into_apple_id_mapping_from_altafonte.sql1000 B2026-07-13 03:27📄DS-1033_DELETE_incorrect_data_for_pandora_from_fact_analytics.sql290 B2026-07-13 03:27📄DS-1033_DELETE_incorrect_data_for_pandora_from_fact_analytics_error.sql296 B2026-07-13 03:27📄DS-1033_DELETE_incorrect_data_for_pandora_from_staging_raw_pandora.sql177 B2026-07-13 03:27📄DS-10367_spotify_reports_new_cols.sql584 B2026-07-13 03:27📄DS-10746_backfill_original_track_release_date_for_SMEAnalyticsDummy.sql2.0 KB2026-07-13 03:27📄DS-11022_update_facts_analytics_trackid.sql1.1 KB2026-07-13 03:27📄DS-11124_fact_conflict_duplicates_clean.sql2.4 KB2026-07-13 03:27📄DS-11161_fix_missed_release.sql267 B2026-07-13 03:27📄DS-1119_DELETE_errors_from_dim_zip.sql384 B2026-07-13 03:27📄DS-11262_spotify_stream_country_backfill.sql1.2 KB2026-07-13 03:27📄DS-1129_ALTER_spotify_staging_raw_v2_add_licensor.sql184 B2026-07-13 03:27📄DS-11321-delete-dim-track-for-smeanalyticsdummy.sql185 B2026-07-13 03:27📄DS-1191_DELETE_staging_raw_amazon_unlimited.sql147 B2026-07-13 03:27📄DS-1193_DELETE_fact_analytics_amazon_unlimited_data.sql287 B2026-07-13 03:27📄DS-1194_DELETE_staging_sos_amazon_unlimited_data.sql150 B2026-07-13 03:27📄DS-1208_CREATE_amazon_unlimited.sql545 B2026-07-13 03:27📄DS-1208_CREATE_deezer_streams.sql488 B2026-07-13 03:27📄DS-1208_CREATE_googleplay_streams.sql542 B2026-07-13 03:27📄DS-1208_CREATE_pandora_streams.sql490 B2026-07-13 03:27📄DS-1208_CREATE_rhapsody_streams.sql495 B2026-07-13 03:27📄DS-1214_INSERT_additional_sme_products.sql542 B2026-07-13 03:27📄DS-1222_ALTER_google_music_downloads_rename.sql223 B2026-07-13 03:27📄DS-1222_CREATE_amazon_digital_services.sql582 B2026-07-13 03:27📄DS-1222_CREATE_google_music.sql529 B2026-07-13 03:27📄DS-1222_CREATE_google_music_fix.sql523 B2026-07-13 03:27📄DS-1222_CREATE_itunes.sql484 B2026-07-13 03:27📄DS-1222_DROP_googleplay_streams.sql134 B2026-07-13 03:27📄DS-1346_backfill_google_play_market_share.sql748 B2026-07-13 03:27📄DS-1346_backfill_itunes_market_share.sql2.6 KB2026-07-13 03:27📄DS-1346_backfill_youtube_red_market_share.sql2.3 KB2026-07-13 03:27📄DS-1370_INSERT_spotify_marketshare_data.sql2.4 KB2026-07-13 03:27📄DS-1371_INSERT_amazon_prime_marketshare_data.sql2.1 KB2026-07-13 03:27📄DS-1372_INSERT_deezer_marketshare_data.sql2.0 KB2026-07-13 03:27📄DS-1376_INSERT_amazon_unlimited_marketshare_data.sql2.9 KB2026-07-13 03:27📄DS-1392_INSERT_new_user_id_mappings.sql365 B2026-07-13 03:27📄DS-1392_INSERT_new_user_id_mappings_fix.sql330 B2026-07-13 03:27📄DS-1397_update_analytics_tables.sql1.3 KB2026-07-13 03:27📄DS-1397_UPDATE_analytics_tables_again.sql1.3 KB2026-07-13 03:27📄DS-1425_INSERT_itunes_hides_historical_data.sql202 B2026-07-13 03:27📄DS-1433_CREATE_spotify_streams_sme.sql527 B2026-07-13 03:27📄DS-1459-ALTER_youtube_asset_conflict_add_v1_1_fields.sql471 B2026-07-13 03:27📄DS-1459-ALTER_youtube_asset_report_add_v1_1_field.sql254 B2026-07-13 03:27📄DS-1462-UPDATE_staging_raw_pandora_hash_listener_to_varchar.sql466 B2026-07-13 03:27📄DS-1470_UPDATE_dim_licensor_for_apple_music.sql1005 B2026-07-13 03:27📄DS-1470_UPDATE_vendor_name_for_apple_music_nonroylty_streams.sql1.1 KB2026-07-13 03:27📄DS-1470_UPDATE_vendor_name_for_apple_music_streams.sql1.0 KB2026-07-13 03:27📄DS-1470_UPDATE_vendor_name_for_staging_raw_apple_music_demographics.sql1.1 KB2026-07-13 03:27📄DS-1473_DELETE_sme_data_from_staging_raw_ams_tables.sql776 B2026-07-13 03:27📄DS-1473_INSERT_sony_am_mapping_values.sql2.9 KB2026-07-13 03:27📄DS-1481_UPDATE_fact_market_share.sql344 B2026-07-13 03:27📄DS-1486_UPDATE_fact_analytics_v2_AMU.sql225 B2026-07-13 03:27📄DS-1499_INSERT_missing_itunes_marketshare_data.sql24.8 KB2026-07-13 03:27📄DS-1519_INSERT_amazon_music_licensors.sql535 B2026-07-13 03:27📄DS-1519_INSERT_amazon_music_playlist_feed.sql394 B2026-07-13 03:27📄DS-1519_INSERT_amazon_music_sourcetypes_feedid.sql400 B2026-07-13 03:27📄DS-1519_INSERT_amazon_music_subscriptionpaytier_feed.sql398 B2026-07-13 03:27📄DS-1519_INSERT_amazon_music_subscriptiontype_feed.sql389 B2026-07-13 03:27📄DS-1519_INSERT_amazon_music_users_feed.sql353 B2026-07-13 03:27📄DS-1519_INSERT_new_feedid_for_Amazon_Music.sql261 B2026-07-13 03:27📄DS-1520_copy_fact_analytics_amazon_unlimited_storeid.sql3.8 KB2026-07-13 03:27📄DS-1520_copy_fact_analytics_error_amazon_unlimited_storeid.sql3.8 KB2026-07-13 03:27📄DS-1520_INSERT_Amazon_Music_data_into_dim_playlist.sql654 B2026-07-13 03:27📄DS-1520_INSERT_Amazon_Music_data_into_dim_sourcetype.sql384 B2026-07-13 03:27📄DS-1520_INSERT_Amazon_Music_data_into_dim_subscriptionpaytier.sql388 B2026-07-13 03:27📄DS-1520_INSERT_Amazon_Music_data_into_dim_subscriptiontype.sql373 B2026-07-13 03:27📄DS-1520_INSERT_Amazon_Music_data_into_dim_user.sql595 B2026-07-13 03:27📄DS-1534_UPDATE_fact_analytics_fix_paidunits.sql215 B2026-07-13 03:27📄DS-1552-UPDATE_staging_raw_pandora_source_id_to_varchar_256.sql191 B2026-07-13 03:27📄DS-1570_INSERT_new_feedid_for_youtube_bulk_reports.sql219 B2026-07-13 03:27📄DS-1573_backfill_youtube_facts_tables.sql2.8 KB2026-07-13 03:27📄DS-1603_CREATE_feeds_sla_breaches.sql510 B2026-07-13 03:27📄DS-1612_UPDATE_Amazon_Prime_transaction_type_in_fa_tables.sql680 B2026-07-13 03:27📄DS-1612_UPDATE_Amazon_Unlimited_transactiontypeid_in_fa_tables.sql495 B2026-07-13 03:27📄DS-1618_UPDATE_null_isrcid_in_fact_analytics.sql226 B2026-07-13 03:27📄DS-1620_DELETE_amazon_prime_and_adsupported_playlistids.sql275 B2026-07-13 03:27📄DS-1620_MERGE_Amazon_Music_dim_playlist_data.sql2.5 KB2026-07-13 03:27📄DS-1620_UPDATE_amazon_adsupported_playlistid_in_fact_analytics.sql696 B2026-07-13 03:27📄DS-1620_UPDATE_Amazon_Music_playlists.sql769 B2026-07-13 03:27📄DS-1620_UPDATE_amazon_prime_playlistid_in_fact_analytics.sql696 B2026-07-13 03:27📄DS-1624-update-missing-countryids.sql616 B2026-07-13 03:27📄DS-1630_INSERT_dim_playlist.sql10.0 KB2026-07-13 03:27📄DS-1630_UPDATE_amazon_adsupported_playlistid_in_fact_analytics.sql874 B2026-07-13 03:27📄DS-1630_UPDATE_amazon_prime_playlistid_in_fact_analytics.sql896 B2026-07-13 03:27📄DS-1630_UPDATE_amazon_unlimited_playlistid_in_fact_analytics.sql902 B2026-07-13 03:27📄DS-1656_INSERT_INTO_dim_feed.sql153 B2026-07-13 03:27📄DS-1656_INSERT_INTO_dim_licensor.sql251 B2026-07-13 03:27📄DS-1659_INSERT_INTO_dim_sourcetype.sql1.2 KB2026-07-13 03:27📄DS-1659_INSERT_INTO_dim_subscriptionpaytier.sql294 B2026-07-13 03:27📄DS-1659_INSERT_INTO_dim_subscriptiontype.sql305 B2026-07-13 03:27📄DS-1679_UPDATE_dim_playlist.sql355 B2026-07-13 03:27📄DS-1686_INSERT_poland_trending_tracks.sql495 B2026-07-13 03:27📄DS-1701_INSERT_STAGING_RAW_SPOTIFY_AGGREGATED_STREAMS_V2.sql2.6 KB2026-07-13 03:27📄DS-1701_INSERT_STAGING_RAW_SPOTIFY_AGGREGATED_STREAMS_V2_2.sql2.6 KB2026-07-13 03:27📄DS-1701_INSERT_STAGING_RAW_SPOTIFY_AGGREGATED_STREAMS_V2_3.sql2.5 KB2026-07-13 03:27📄DS-1713_INSERT_fact_analytics.sql10.3 KB2026-07-13 03:27📄DS-1718-INSERT_staging_raw_amazon_aggregated_streams.sql2.5 KB2026-07-13 03:27📄DS-1719_DELETE_fact_analytics_error_deezer.sql343 B2026-07-13 03:27📄DS-1719_INSERT_Deezer_into_FA_from_fae.sql1.4 KB2026-07-13 03:27📄DS-1720_INSERT_Deezer_into_fact_analytics_from_fae.sql4.1 KB2026-07-13 03:27📄DS-1720_INSERT_into_map_transactiontype.sql303 B2026-07-13 03:27📄DS-1720_INSERT_napster_additional_activity_types.sql3.3 KB2026-07-13 03:27📄DS-1723_DELETE_fact_analytics_error_amazon_unlimited_data.sql358 B2026-07-13 03:27📄DS-1723_DELETE_fact_analytics_error_napster_data.sql346 B2026-07-13 03:27📄DS-1723_INSERT_amazon_unlimited_data_with_null_country.sql4.2 KB2026-07-13 03:27📄DS-1723_INSERT_Amazon_Unlinited_missing_data_into_FA.sql1.4 KB2026-07-13 03:27📄DS-1723_INSERT_NAPSTER_missing_data_into_FA.sql1.4 KB2026-07-13 03:27📄DS-1723_UPDATE_staging_raw_amazon_unlimited.sql233 B2026-07-13 03:27📄DS-1724_backfill_device_os_amazon.sql3.7 KB2026-07-13 03:27📄DS-1724_backfill_device_os_google.sql657 B2026-07-13 03:27📄DS-1724_backfill_device_os_pandora.sql635 B2026-07-13 03:27📄DS-1724_backfill_device_os_spotify.sql625 B2026-07-13 03:27📄DS-1724_backfill_device_os_types.sql532 B2026-07-13 03:27📄DS-1724_backfill_missing_device_os_for_apple.sql1.2 KB2026-07-13 03:27📄DS-1724_backfill_missing_fa_dates.sql3.0 KB2026-07-13 03:27📄DS-1724_fill_missing_dates_for_apple_from_qa.sql378 B2026-07-13 03:27📄DS-1725_INSERT_new_device_type.sql262 B2026-07-13 03:27📄DS-1725_UPDATE_dim_sourcetype.sql221 B2026-07-13 03:27📄DS-1729_ALTER_fact_youtube_video_demographics.sql716 B2026-07-13 03:27📄DS-1785-add_clustering_for_yt_asset_analytics.sql267 B2026-07-13 03:27📄DS-1785-add_clustering_for_yt_asset_demographics.sql273 B2026-07-13 03:27📄DS-1785-add_clustering_for_yt_video_analytics.sql267 B2026-07-13 03:27📄DS-1785-add_clustering_for_yt_video_demographics.sql273 B2026-07-13 03:27📄DS-1785-cluster_yt_daily_tables.sql842 B2026-07-13 03:27📄DS-1785-remove_clustering_for_yt_asset_analytics.sql168 B2026-07-13 03:27📄DS-1785-remove_clustering_for_yt_asset_demoraphics.sql171 B2026-07-13 03:27📄DS-1785-remove_clustering_for_yt_video_analytics.sql168 B2026-07-13 03:27📄DS-1785-remove_clustering_for_yt_video_demographics.sql171 B2026-07-13 03:27📄DS-1786_CREATE_tables_for_sme_ingestion_candidates_7.sql1.6 KB2026-07-13 03:27📄DS-1788-remove_duplications_for_spotify_marketshare.sql4.5 KB2026-07-13 03:27📄DS-1811_UPDATE_staging_raw_apple_music_songs.sql213 B2026-07-13 03:27📄DS-1830_INSERT_INTO_dim_feed_dim_store.sql1.0 KB2026-07-13 03:27📄DS-1831_INSERT_licensors_for_Tencent.sql1.0 KB2026-07-13 03:27📄DS-1883_INSERT_into_dim_feed.sql187 B2026-07-13 03:27📄DS-1883_INSERT_INTO_dim_licensor_wynk.sql364 B2026-07-13 03:27📄DS-1909_INSERT_INTO_aggregated_skips_and_saves_bkfl_coalesce.sql7.7 KB2026-07-13 03:27📄DS-1935_ALTER_table_sme_analytics_ingestion_candidates_add_ar_columns.sql384 B2026-07-13 03:27📄DS-1940_ALTER_FA_RESUME_RECLUSTER.sql151 B2026-07-13 03:27📄DS-1946_UPDATE_dim_feed_dim_store.sql419 B2026-07-13 03:27📄DS-2000_2_INSERT_INTO_dim_tables.sql2.1 KB2026-07-13 03:27📄DS-2000_INSERT_INTO_dim_tables.sql2.1 KB2026-07-13 03:27📄DS-2026_INSERT_INTO_dim_feed_dim_store.sql424 B2026-07-13 03:27📄DS-2032_insert_sme_condidates_sample.sql4.4 KB2026-07-13 03:27📄DS-2049_INSERT_INTO_demographics_region_mapping_v2.sql499 B2026-07-13 03:27📄DS-2076_prod_sme_analytics_backload_candidates.sql225.4 KB2026-07-13 03:27📄DS-2088_delete_test_product_and_related_data.sql538 B2026-07-13 03:27📄DS-2096_INSERT_licensors_for_amazon_downloads_sme.sql475 B2026-07-13 03:27📄DS-2096_INSERT_map_transactiontype.sql308 B2026-07-13 03:27📄DS-2098_INSERT_licensor_for_rhapsody.sql342 B2026-07-13 03:27📄DS-2098_INSERT_map_transactiontype.sql275 B2026-07-13 03:27📄DS-2112_UPDATE_dim_feed_dim_store.sql431 B2026-07-13 03:27📄DS-2118_prod_sme_analytics_backload_candidates_update_23_25_apr.sql2.1 KB2026-07-13 03:27📄DS-2120-insert-sme-candidates-to-test-label-ingestion.sql745 B2026-07-13 03:27📄DS-2127-INSERT-sme_analytics_backload_candidates_till_2018_08_01.sql113.8 KB2026-07-13 03:27📄DS-2142_update_project_id_sme_candidates.sql639 B2026-07-13 03:27📄DS-2143_UPDATE_staging_raw_amazon_adsupported_licensor_theorchard.sql229 B2026-07-13 03:27📄DS-2143_UPDATE_staging_raw_amazon_prime_licensor_theorchard.sql217 B2026-07-13 03:27📄DS-2143_UPDATE_staging_raw_amazon_unlimited_licensor_theorchard.sql225 B2026-07-13 03:27📄DS-2144_INSERT_into_dim_licensor_for_Amazon_Music.sql1.1 KB2026-07-13 03:27📄DS-2171_UPDATE_fact_analytics.sql794 B2026-07-13 03:27📄DS-2175_update_sony_apple_id_mapping.sql187 B2026-07-13 03:27📄DS-2201_DELETE_incorrect_data_for_itunes_from_fact_analytics_error.sql780 B2026-07-13 03:27📄DS-2222_DELETE_dup_apple_id_in_sony_apple_id_mapping.sql214 B2026-07-13 03:27📄DS-2222_DELETE_duplicate_rows_apple_music_sme.sql475 B2026-07-13 03:27📄DS-2279-INSERT_dim_licensor_legacy_feeds.sql795 B2026-07-13 03:27📄DS-2279_UPDATE_fact_analytics.sql1.4 KB2026-07-13 03:27📄DS-2319_INSERT_licensor_for_pandora.sql342 B2026-07-13 03:27📄DS-2337_DELETE_fact_analytics_fix_nulls_in_licensorid.sql205 B2026-07-13 03:27📄DS-2337_INSERT_amazon_music_additional_sme_licensor.sql271 B2026-07-13 03:27📄DS-2342_INSERT_INTO_demographics_region_mapping_v2.sql462 B2026-07-13 03:27📄DS-2346-DELETE_from_sony_apple_id_mapping.sql170 B2026-07-13 03:27📄DS-2349_DROP_temporary_amazon_music_prime_tables.sql909.5 KB2026-07-13 03:27📄DS-2483_CREATE_view_label_copy_shared_data.sql2.4 KB2026-07-13 03:27📄DS-2518_DS-2553_UPDATE_staging_raw_youtube_reports_set_default_licensor.sql406 B2026-07-13 03:27📄DS-2530_UPDATE_fact_analytics.sql355 B2026-07-13 03:27📄DS-2547_rename_spotify_playlist.sql230 B2026-07-13 03:27📄DS-2597_CREATE_fact_analytics_1091_view.sql7.7 KB2026-07-13 03:27📄DS-2597_CREATE_fact_analytics_error_1091_view.sql7.7 KB2026-07-13 03:27📄DS-2597_CREATE_fact_sales_1091_view.sql7.6 KB2026-07-13 03:27📄DS-2597_RECREATE_1091_views_reduce_labels.sql22.9 KB2026-07-13 03:27📄DS-2597_RECREATE_1091_views_update_label_ids.sql23.1 KB2026-07-13 03:27📄DS-2597_RECREATE_1091_views_update_labels.sql23.4 KB2026-07-13 03:27📄DS-2597_RECREATE_fact_analytics_1091_view.sql7.6 KB2026-07-13 03:27📄DS-2597_RECREATE_fact_analytics_error_1091_view.sql7.6 KB2026-07-13 03:27📄DS-2597_RECREATE_fact_sales_1091_view.sql7.5 KB2026-07-13 03:27📄DS-2605_remove_duplicate_label_rows.sql2.3 KB2026-07-13 03:27📄DS-2605_remove_duplicate_label_rows_som_livre.sql2.3 KB2026-07-13 03:27📄DS-2662_DELETE_sme_labelcopy_ingest.sql168 B2026-07-13 03:27📄DS-2668_ALTER_dim_label_participant.sql169 B2026-07-13 03:27📄DS-2676-DELETE_from_sme_labelcopy_ingest.sql160 B2026-07-13 03:27📄DS-2700_DELETE_sme_labelcopy_ingest.sql236 B2026-07-13 03:27📄DS-2712_INSERT_demographics_region_mapping_v2.sql1.2 MB2026-07-13 03:27📄DS-2726_DELETE_sme_labelcopy_track_participant.sql391 B2026-07-13 03:27📄DS-2727_DELETE_sme_to_orchard_to_label_mapping.sql147 B2026-07-13 03:27📄DS-2727_UPDATE_sme_to_orchard_to_label_mapping_again.sql1.2 KB2026-07-13 03:27📄DS-2728_INSERT_INTO_dim_licensor_youtube_sme.sql338 B2026-07-13 03:27📄DS-2764_DELETE_sme_labelcopy_ingest.sql136 B2026-07-13 03:27📄DS-2794_UPDATE_sme_to_orchard_to_label_mapping_missing_subaccounts.sql26.4 KB2026-07-13 03:27📄DS-2801_INSERT_into_dim_licensor_SME_for_deezer_re.sql367 B2026-07-13 03:27📄DS-2824_UPDATE_exported_sme_labelcopy_ingest.sql224 B2026-07-13 03:27📄DS-2824_update_sme_labelcopy_ingest.sql1.1 KB2026-07-13 03:27📄DS-2828_UPDATE_sme_to_orchard_label_mapping.sql327 B2026-07-13 03:27📄DS-2828_UPDATE_sme_to_orchard_label_mapping_remove_fairtrade.sql246 B2026-07-13 03:27📄DS-2848-UPDATE_deezer_marketshare_adjustments.sql5.6 KB2026-07-13 03:27📄DS-2848_UPDATE_deezer_marketshare.sql357 B2026-07-13 03:27📄DS-2864_DELETE_from_sme_labelcopy_ingest.sql165 B2026-07-13 03:27📄DS-2876_delete_from_sme_labelcopy_product_participant.sql168 B2026-07-13 03:27📄DS-2915_UPDATE_sme_labelcopy_ingest.sql829 B2026-07-13 03:27📄DS-2924_delete_from_sme_labelcopy_track_participant.sql186 B2026-07-13 03:27📄DS-2980_UPDATE_marketshare_tables_for_deezer.sql4.9 KB2026-07-13 03:27📄DS-3023_INSERT_line_values_to_dim_tables.sql1.3 KB2026-07-13 03:27📄DS-3038_DELETE_FACT_SOCIALS.sql118 B2026-07-13 03:27📄DS-3066_DELETE_STAGING_RAW_TIKTOK_TRENDS_TOPHASHTAG.sql182 B2026-07-13 03:27📄DS-3092_backfill_GLOBAL_PARTICIPANT_REPRESENTS_LABEL_PARTICIPANT.sql1.2 KB2026-07-13 03:27📄DS-3107-DELETE_sme_labelcopy_track_participant.sql306 B2026-07-13 03:27📄DS-3160_DROP_unused_chartmetric_charts_SF_tables.sql1.7 KB2026-07-13 03:27📄DS-3223-UPDATE_deezer_marketshare_adjustments_3.sql5.6 KB2026-07-13 03:27📄DS-3225_INSERT_aggregated_skips_and_saves_correct_uma_data.sql2.9 KB2026-07-13 03:27📄DS-3268_DELETE_duplicated_uma_playlists_from_dim_playlist_and_fact_anaytics.sql1.1 KB2026-07-13 03:27📄DS-3268_DELETE_duplicated_uma_playlists_from_dim_playlist_and_fact_anaytics_for_2021-03-17.sql702 B2026-07-13 03:27📄DS-3320_DELETE_FACT_SOCIALS.sql132 B2026-07-13 03:27📄DS-3331_TRUNCATE_tables_3.sql244 B2026-07-13 03:27📄DS-3357_UPDATE_LINE_data.sql325 B2026-07-13 03:27📄DS-3376_INSERT_into_staging_raw_apple_music_container.sql1.9 KB2026-07-13 03:27📄DS-3411_DELETE_from_sme_labelcopy_ingest.sql4.8 KB2026-07-13 03:27📄DS-3411_DELETE_from_sme_labelcopy_ingest_2.sql228 B2026-07-13 03:27📄DS-3438_INSERT_into_staging_raw_apple_music_container.sql1.5 KB2026-07-13 03:27📄DS-3512_DELETE_failed_projects_sme_labelcopy_ingest.sql358 B2026-07-13 03:27📄DS-3516_UPDATE_spotify_statistics.sql220 B2026-07-13 03:27📄DS-3518_UPDATE_SPOTIFY_STATISTICS.sql283 B2026-07-13 03:27📄DS-3533_DELETE_from_sme_labelcopy_ingest.sql309 B2026-07-13 03:27📄DS-3595_UPDATE_dim_chart_chartid_to_nee4j_Chart_id.sql128.5 KB2026-07-13 03:27📄DS-3604_INSERT_INTO_chartmetric_socials_log.sql557 B2026-07-13 03:27📄DS-3634_DELETE_incorrect_artists_isrc_DEZ650710322.sql471 B2026-07-13 03:27📄DS-3694_INSERT_INTO_dim_feed_dim_store.sql359 B2026-07-13 03:27📄DS-3770_DELETE_incorrect_amazon_dim_charts.sql2.3 KB2026-07-13 03:27📄DS-3772_DELETE_label_32551_releases.sql422 B2026-07-13 03:27📄DS-3812_INSERT_INTO_FACT_YOUTUBE_ASSET_ANALYTICS.sql1.7 KB2026-07-13 03:27📄DS-3831_UPDATE_dim_chart.sql241 B2026-07-13 03:27📄DS-3849_DELETE_FROM_FACT_SOCIALS.sql305 B2026-07-13 03:27📄DS-3862_DELETE_old_rows_from_public_sound_recording.sql280 B2026-07-13 03:27📄DS-3874_UPDATE_dim_chart_change_youtube_charts_types.sql532 B2026-07-13 03:27📄DS-3886_INSERT_soundcloud_values_to_dim_tables.sql1.0 KB2026-07-13 03:27📄DS-3893_UPDATE_fact_analytics_formatid_audio.sql660 B2026-07-13 03:27📄DS-3938_INSERT_amazon_music_sme_licensor.sql312 B2026-07-13 03:27📄DS-3939_DELETE_duplicates_for_PublicSoundRecording_created_by_youtube_charts.sql112.8 KB2026-07-13 03:27📄DS-4004_INSERT_INTO_dim_licensor_awa.sql367 B2026-07-13 03:27📄DS-4016_UPDATE_fact_youtube_asset_analytics.sql320 B2026-07-13 03:27📄DS-4016_UPDATE_fact_youtube_asset_analytics_error.sql326 B2026-07-13 03:27📄DS-4016_UPDATE_fact_youtube_asset_demographics.sql322 B2026-07-13 03:27📄DS-4038_INSERT_INTO_dim_store.sql197 B2026-07-13 03:27📄DS-4053_TRUNCATE_placement_tables.sql501 B2026-07-13 03:27📄DS-4115_INSERT_INTO_dim_format.sql268 B2026-07-13 03:27📄DS-4154_REPLACE_dim_claims_table.sql856 B2026-07-13 03:27📄DS-4197_UPDATE_fact_youtube_asset_analytics.sql320 B2026-07-13 03:27📄DS-4218_DELETE_rows_chartmetric_participants_log.sql423 B2026-07-13 03:27📄DS-4226_recreate_dim_claim_without_duplications.sql1.4 KB2026-07-13 03:27📄DS-4226_UPDATE_dim_claim.sql735 B2026-07-13 03:27📄DS-4229_INSERT_ISRC_TO_LABEL_PARTICIPANT_MAPPING_backfill.sql1.2 KB2026-07-13 03:27📄DS-4314_UPDATE_dim_claim.sql720 B2026-07-13 03:27📄DS-4440_DELETE_STAGING_RAW_GFK.sql158 B2026-07-13 03:27📄DS-4535_remove_track.sql201 B2026-07-13 03:27📄DS-4585-facts_track_writer_clean_up.sql1.2 KB2026-07-13 03:27📄DS-4669_INSERT_into_fact_analytics_product_886443117167.sql1.6 KB2026-07-13 03:27📄DS-4743_DELETE_rows_from_FACT_ANALYTICS_ERROR_for_changed_label_ids.sql2.2 KB2026-07-13 03:27📄DS-4751_DROP_temp_line_etl_tables.sql394.9 KB2026-07-13 03:27📄DS-4794_INSERT_INTO_dim_licensor_awal_apple.sql420 B2026-07-13 03:27📄DS-4795_INSERT_INTO_dim_licensor_awal.sql392 B2026-07-13 03:27📄DS-4933_Drop_incorrect_backload_schedule.sql419 B2026-07-13 03:27📄DS-4996_INSERT_INTO_dim_licensor_awal_amazon.sql454 B2026-07-13 03:27📄DS-5013_INSERT_into_dim_feed.sql215 B2026-07-13 03:27📄DS-5013_INSERT_INTO_dim_licensor_beatport.sql363 B2026-07-13 03:27📄DS-5020_INSERT_INTO_dim_licensor_awal_youtube.sql394 B2026-07-13 03:27📄DS-5068_raw_tables_are_clustered_by_date.sql502 B2026-07-13 03:27📄DS-5068_raw_tables_are_clustered_by_date_resume_recluster.sql157 B2026-07-13 03:27📄DS-5102_UPDATE_staging_raw_youtube_claim.sql313 B2026-07-13 03:27📄DS-5103_INSERT_INTO_dim_licensor_awal_youtube_claims.sql394 B2026-07-13 03:27📄DS-5111_Bacfill_aggregated_streams_awal_apple.sql5.8 KB2026-07-13 03:27📄DS-5120_Bacfill_aggregated_streams_awal_spotify.sql1.6 KB2026-07-13 03:27📄DS-5120_Bacfill_awal_spotify_step_2.sql636 B2026-07-13 03:27📄DS-5120_backfill_awal_spotify_data.sql4.8 KB2026-07-13 03:27📄DS-5120_backfill_awal_spotify_data_2.sql1.5 KB2026-07-13 03:27📄DS-5120_Create_tmp_awal_spotify_table.sql757 B2026-07-13 03:27📄DS-5121_Cleanup_after_awal_apple_backfill.sql610 B2026-07-13 03:27📄DS-5166_INSERT_INTO_dim_licensor_awal_itunes.sql393 B2026-07-13 03:27📄DS-5174_remove_stale_cdc_events_for_global_sound_recording.sql3.4 KB2026-07-13 03:27📄DS-5210_Bacfill_aggregated_streams_awal_spotify.sql1.7 KB2026-07-13 03:27📄DS-5210_Bacfill_awal_spotify_step_3.sql663 B2026-07-13 03:27📄DS-5210_backfill_awal_spotify_data.sql4.8 KB2026-07-13 03:27📄DS-5210_backfill_awal_spotify_data_3.sql1.5 KB2026-07-13 03:27📄DS-5210_Create_tmp_awal_spotify_table.sql757 B2026-07-13 03:27📄DS-5210_DELETE_awal_fact_analytics_error.sql599 B2026-07-13 03:27📄DS-5211_backfill_awal_apple_data.sql4.6 KB2026-07-13 03:27📄DS-5211_backfill_awal_apple_data_2.sql1.5 KB2026-07-13 03:27📄DS-5211_Create_tmp_awal_apple_table.sql2.3 KB2026-07-13 03:27📄DS-5211_update_apple_id_mapping.sql552 B2026-07-13 03:27📄DS-5220_DELETE_awal_fact_analytics_error.sql599 B2026-07-13 03:27📄DS-5228_INSERT_licensor_for_amazon_downloads_awal.sql331 B2026-07-13 03:27📄DS-5228_UPDATE_staging_raw_amazon_v2.sql194 B2026-07-13 03:27📄DS-5254_backfill_awal_apple_data.sql4.6 KB2026-07-13 03:27📄DS-5254_backfill_awal_apple_data_2.sql1.7 KB2026-07-13 03:27📄DS-5254_backfill_awal_spotify_data.sql4.8 KB2026-07-13 03:27📄DS-5254_backfill_awal_spotify_data_2.sql1.4 KB2026-07-13 03:27📄DS-5254_clean_up_fact_error.sql819 B2026-07-13 03:27📄DS-5254_DELETE_awal_incorrect_data.sql1.5 KB2026-07-13 03:27📄DS-5286_backfill_awal_amazon_data.sql1.6 KB2026-07-13 03:27📄DS-5286_backfill_awal_amazon_data_2.sql7.0 KB2026-07-13 03:27📄DS-5286_clean_up_amazon_awal.sql184 B2026-07-13 03:27📄DS-5286_Create_tmp_awal_staging_fact_amazon_table.sql7.5 KB2026-07-13 03:27📄DS-5287-DELETE_duplicates_from_awal_apple_id_mapping.sql1.2 KB2026-07-13 03:27📄DS-5287_Fix_sme_itunes_data.sql26.1 KB2026-07-13 03:27📄DS-5287_Fix_theorchard_itunes_data.sql24.3 KB2026-07-13 03:27📄DS-5296_Create_tmp_awal_spotify_table.sql772 B2026-07-13 03:27📄DS-5296_DELETE_awal_fact_analytics_error.sql613 B2026-07-13 03:27📄DS-5297_backfill_awal_apple_data.sql1.5 KB2026-07-13 03:27📄DS-5326_backfill_awal_fact_analytics_error_itunes_data.sql2.2 KB2026-07-13 03:27📄DS-5326_backfill_awal_fact_analytics_itunes_data.sql1.6 KB2026-07-13 03:27📄DS-5326_create_tmp_awal_staging_fact_itunes_table.sql20.7 KB2026-07-13 03:27📄DS-5327_UPDATE_fact_analytics.sql3.5 KB2026-07-13 03:27📄DS-5331_UPDATE_fact_analytics.sql4.2 KB2026-07-13 03:27📄DS-5376_DELETE_videos_from_youtube_neo4j_log.sql609 B2026-07-13 03:27📄DS-5432_CREATE_amazon_digital_services_for_sme.sql1.1 KB2026-07-13 03:27📄DS-5432_DELETE_awal_fact_analytics_amazon_downloads_data.sql274 B2026-07-13 03:27📄DS-5432_INSERT_amazon_digital_services.sql1.1 KB2026-07-13 03:27📄DS-5432_INSERT_licensor_for_staging_raw_amazon_v2.sql460 B2026-07-13 03:27📄DS-5473_delete_duplicated_rows_in_fact_analytics.sql1.8 KB2026-07-13 03:27📄DS-5473_delete_tracks_which_were_moved.sql304 B2026-07-13 03:27📄DS-5473_fact_analytics.sql569 B2026-07-13 03:27📄DS-5473_update_fact_analytics_2.sql569 B2026-07-13 03:27📄DS-5517_update_artist_socials_youtube_subs.sql2.2 KB2026-07-13 03:27📄DS-5518_Bacfill_aggregated_streams_theorchard_spotify.sql1.4 KB2026-07-13 03:27📄DS-5518_Bacfill_theorchard_spotify.sql1.5 KB2026-07-13 03:27📄DS-5518_DELETE_theorchard_fact_analytics_error.sql530 B2026-07-13 03:27📄DS-5523_delete_duplicate_dim_track.sql523 B2026-07-13 03:27📄DS-5523_INSERT_FACT_ANALYTICS_spotify_data.sql4.2 KB2026-07-13 03:27📄DS-5523_UPDATE_fact_analytics-fix-moved-tracks.sql1.4 KB2026-07-13 03:27📄DS-5595_Spotify_revival.sql10.5 KB2026-07-13 03:27📄DS-5596_INSERT_fact_analytics_apple_music.sql9.4 KB2026-07-13 03:27📄DS-5664_DELETE_assets_from_youtube_neo4j_log.sql1.6 KB2026-07-13 03:27📄DS-5804_DELETE_rows_chartmetric_participants_log.sql308 B2026-07-13 03:27📄DS-5883_UPDATE_dim_track-fix-deleted-track.sql454 B2026-07-13 03:27📄DS-5918-INSERT-to-staging_raw_youtube_monthly_rawdata_v1_0-fixed-data.sql490 B2026-07-13 03:27📄DS-5950_delete_duplicate_track.sql295 B2026-07-13 03:27📄DS-5952_delete_incorrect_track.sql305 B2026-07-13 03:27📄DS-6011_remove_deplicate_rows_for_tiktok_fraudulent_streams.sql210 B2026-07-13 03:27📄DS-6022_delete_removed_isrc_from_fact_analytics.sql197 B2026-07-13 03:27📄DS-6025_DELETE_DIM_TRACK_duplicate_track.sql148 B2026-07-13 03:27📄DS-6061_add_spotify_lisensors.sql430 B2026-07-13 03:27📄DS-6079_DELETE_dim_track_with_wrong_label.sql458 B2026-07-13 03:27📄DS-6155_DELETE_REMOVED_TRACKS_AND_PRODUCT.sql2.4 KB2026-07-13 03:27📄DS-6155_DELETE_REMOVED_TRACKS_PART2.sql1.9 KB2026-07-13 03:27📄DS-6169_add_Itunes_lisensors.sql575 B2026-07-13 03:27📄DS-6302-QA-delete-staging-raw-spotify.sql332 B2026-07-13 03:27📄DS-6375_migrate_tuid_38384795_to_38445034.sql6.4 KB2026-07-13 03:27📄DS-6444_DELETE_from_sme_labelcopy_ingest.sql1.0 KB2026-07-13 03:27📄DS-6454_cleanup_old_dbt_tables.sql1.9 KB2026-07-13 03:27📄DS-6497_fix_youtube_chansels_inconsistency.sql1.1 KB2026-07-13 03:27📄DS-6503_backfill_Beatport_Above_Board_data_1.sql2.3 KB2026-07-13 03:27📄DS-6503_backfill_Beatport_Above_Board_data_2.sql6.7 KB2026-07-13 03:27📄DS-6504_create_staging_aggregated_raw_table.sql4.3 KB2026-07-13 03:27📄DS-6504_create_staging_streaams_table.sql14.4 KB2026-07-13 03:27📄DS-6504_load_staging_fact_analytics_table_backfill.sql4.8 KB2026-07-13 03:27📄DS-6504_load_staging_fact_analytics_table_backfill_p2.sql5.0 KB2026-07-13 03:27📄DS-6504_load_staging_fact_analytics_table_backfill_p3.sql4.6 KB2026-07-13 03:27📄DS-6504_load_staging_fact_analytics_table_backfill_p4.sql4.6 KB2026-07-13 03:27📄DS-6504_load_staging_fact_analytics_table_backfill_p5.sql4.6 KB2026-07-13 03:27📄DS-6504_upd_dim_tables.sql6.4 KB2026-07-13 03:27📄DS-6504_upload_data_to_staging_raw_tables.sql2.6 KB2026-07-13 03:27📄DS-6504_upload_fact_tables_backfill_p1.sql3.5 KB2026-07-13 03:27📄DS-6504_upload_fact_tables_backfill_p2.sql3.4 KB2026-07-13 03:27📄DS-6504_upload_fact_tables_backfill_p3.sql3.4 KB2026-07-13 03:27📄DS-6504_upload_fact_tables_backfill_p4.sql3.4 KB2026-07-13 03:27📄DS-6504_upload_fact_tables_backfill_p5.sql3.4 KB2026-07-13 03:27📄DS-6504_upload_raw_data.sql1.3 KB2026-07-13 03:27📄DS-6505_add_Above_Board_am_lisensors.sql330 B2026-07-13 03:27📄DS-6819_add_new_region_codes_demographics_region_mapping_v2.sql1.1 KB2026-07-13 03:27📄DS-6862_DELETE_videos_from_youtube_neo4j_log.sql379 B2026-07-13 03:27📄DS-6862_DELETE_videos_from_youtube_neo4j_log_2.sql256 B2026-07-13 03:27📄DS-6875_UPDATE_dim_youtube_channel_names.sql331 B2026-07-13 03:27📄DS-6960-ALTER-dim_licensor_UPDATE_theorchrd.sql385 B2026-07-13 03:27📄DS-6960_INSERT_INTO_dim_licensor_LINE.sql371 B2026-07-13 03:27📄DS-6976_delete_dim_track_duplicate_track.sql152 B2026-07-13 03:27📄DS-6976_delete_dim_track_duplicate_track_1.sql635 B2026-07-13 03:27📄DS-7168-clean_up_has_label_participant.sql705 B2026-07-13 03:27📄DS-7387_Update_fact_socials.sql2.0 KB2026-07-13 03:27📄DS-7425_insert_into_dim_physical_warehouse.sql587 B2026-07-13 03:27📄DS-7431_update_fact_socials_table_account_url.sql231 B2026-07-13 03:27📄DS-7477_clean_qa_physical_products.sql661 B2026-07-13 03:27📄DS-7487_delete_prod_labelcopy_ingest_failed_to_ingest.sql414 B2026-07-13 03:27📄DS-7515_clean_spotify_uris_in_grps_data.sql2.9 KB2026-07-13 03:27📄DS-7608_DELETE_EXPORTED_rows_from_sme_labelcopy_ingest.sql232 B2026-07-13 03:27📄DS-7608_UPDATE_exported_sme_labelcopy_ingest.sql333 B2026-07-13 03:27📄DS-7609_DELETE_from_sme_to_orchard_label_mapping.sql207 B2026-07-13 03:27📄DS-7609_DELETE_from_sme_to_orchard_label_mapping_outdated_data.sql198 B2026-07-13 03:27📄DS-7609_UPDATE_sme_to_orchard_label_mapping_2.sql187 B2026-07-13 03:27📄DS-7609_UPDATE_update_sme_to_orchard_label_mapping.sql601 B2026-07-13 03:27📄DS-7609_UPDATE_update_sme_to_orchard_label_mapping_vendor_id.sql222 B2026-07-13 03:27📄DS-7614_DELETE_DIM_TRACK_duplicate_track.sql256 B2026-07-13 03:27📄DS-7658_DELETE_video_from_youtube_neo4j_log.sql252 B2026-07-13 03:27📄DS-7729_update_dim_store_loen.sql236 B2026-07-13 03:27📄DS-7753_DELETE_from_sme_labelcopy_ingest.sql444 B2026-07-13 03:27📄DS-7829_DELETE_from_sme_labelcopy_ingest_various_artist.sql549 B2026-07-13 03:27📄DS-7829_DELETE_from_sme_labelcopy_ingest_various_artist_v2.sql420 B2026-07-13 03:27📄DS-7829_UPDATE_sme_labelcopy_ingest.sql280 B2026-07-13 03:27📄DS-7830_remove_qa_failed_to_ingest_rows_composer.sql1.3 KB2026-07-13 03:27📄DS-7890_remove_stuck_products_from_status_table.sql396 B2026-07-13 03:27📄DS-7970_delete_labelcopy_ingest_track_name_too_long.sql950 B2026-07-13 03:27📄DS-7973_DELETE_from_sme_labelcopy_ingest.sql2.3 KB2026-07-13 03:27📄DS-8069_add_new_traffic_sources.sql271 B2026-07-13 03:27📄DS-8141_backfill_altafonte_dim_tables.sql6.4 KB2026-07-13 03:27📄DS-8142_INSERT_INTO_dim_licensor_spotify_altafonte.sql416 B2026-07-13 03:27📄DS-8144_INSERT_INTO_dim_licensor_appleitunes_altafonte.sql428 B2026-07-13 03:27📄DS-8202_backfill_aggregated_skips_and_saves.sql1.6 KB2026-07-13 03:27📄DS-8202_step_1_upd_dim_tables.sql6.2 KB2026-07-13 03:27📄DS-8202_step_2_load_staging_fact_analytics_table_backfill.sql8.8 KB2026-07-13 03:27📄DS-8202_step_3_upload_fact_tables_backfill.sql3.1 KB2026-07-13 03:27📄DS-8202_step_4_upload_fact_error_tables_backfil.sql3.7 KB2026-07-13 03:27📄DS-8203_clean_up_sony_apple_id_mapping_derived.sql335 B2026-07-13 03:27📄DS-8250_DELETE_incorrect_data_for_deezer_market_share.sql4.3 KB2026-07-13 03:27📄DS-8265_insert_into_chartmetric_socials_log.sql271 B2026-07-13 03:27📄DS-8265_Update_fact_socials_deezer.sql3.9 KB2026-07-13 03:27📄DS-8308_backfill_amazon_music_sme.sql21.0 KB2026-07-13 03:27📄DS-8310_Update_fact_socials.sql1.5 KB2026-07-13 03:27📄DS-8377_UPDATE-sme_to_orchard_label_mapping-for-JV-rep-owners.sql790 B2026-07-13 03:27📄DS-8377_UPDATE-sme_to_orchard_label_mapping-for-som-livre-and-another-century.sql492 B2026-07-13 03:27📄DS-8442-insert-new-dates-to-dim_day-and-dim_week.sql2.1 KB2026-07-13 03:27📄DS-8442-insert-new-dates-to-dim_month.sql605 B2026-07-13 03:27📄DS-8465_itunes_altafonte_backfill.sql27.8 KB2026-07-13 03:27📄DS-8465_step_1_backfill_apple_music_altafonte_dim.sql5.0 KB2026-07-13 03:27📄DS-8465_step_2_backfill_apple_music_altafonte_update_apple_id_mapping.sql2.2 KB2026-07-13 03:27📄DS-8465_step_3_backfill_apple_music_altafonte_load_fact_analytics.sql11.0 KB2026-07-13 03:27📄DS-8466_backfill_soundcloud_altafonte.sql10.9 KB2026-07-13 03:27📄DS-8468_amazon_music_altafonte_backfill.sql60.9 KB2026-07-13 03:27📄DS-8469_insert_dim_licensor_altafonte.sql463 B2026-07-13 03:27📄DS-8469_insert_dim_licensor_awa_altafonte.sql376 B2026-07-13 03:27📄DS-8480_backfill_fact_analytics.sql7.1 KB2026-07-13 03:27📄DS-8486_insert_soundcloud_dim_licensor_altafonte.sql419 B2026-07-13 03:27📄DS-8495_backfill_awa_altafonte.sql5.1 KB2026-07-13 03:27📄DS-8501_fix_altafonte_itunes_duplicates.sql784 B2026-07-13 03:27📄DS-8516_exclude_som_livre_products_from_processing.sql1.1 KB2026-07-13 03:27📄DS-8517_delete_from_dim_linked_to_incomplete_products.sql1.6 KB2026-07-13 03:27📄DS-8517_delete_incomplete_grps_products.sql6.3 KB2026-07-13 03:27📄DS-8517_delete_re_created_dim_release_except_new.sql623 B2026-07-13 03:27📄DS-8905_UPDATE_dim_track.sql2.2 KB2026-07-13 03:27📄DS-9126-delete-duplicate-track-from-dim_track.sql446 B2026-07-13 03:27📄DS-9239_backfill_dim_store.sql452 B2026-07-13 03:27📄DS-9267-update_priority_playlists.sql12.8 KB2026-07-13 03:27📄DS-9293_restore_chartmetric_socials_log.sql577 B2026-07-13 03:27📄DS-9296_sme_spotify_apple_backfill.sql35.7 KB2026-07-13 03:27📄DS-9296_Spotify_Apple_backfill_cleanup.sql415 B2026-07-13 03:27📄DS-9387-update-COMPANY_BRAND_HAS_LABEL_VENDOR-and-COMPANY_BRAND-views.sql878 B2026-07-13 03:27📄DS-9427_DELETE_video_from_youtube_neo4j_log.sql310 B2026-07-13 03:27📄DS-9514-DELETE-from-tadas_v2025sep_output_countries.sql226 B2026-07-13 03:27📄DS-9637_Insights_backfill_following_product_refresh_spotify_v3.sql17.7 KB2026-07-13 03:27📄DS-9688-Amazon-Insights-backfill-following-product-refresh-Jan-May.sql15.4 KB2026-07-13 03:27📄DS-9689_spotify_backfill_qa_test.sql14.7 KB2026-07-13 03:27📄DS-9690_apple_backfill_sme_orchard_jan_may_2025.sql25.2 KB2026-07-13 03:27📄DS-9740-DELETE-from-tadas_daily_predictions.sql220 B2026-07-13 03:27📄DS-9890_yt_fact_video_analytics_backfill.sql7.3 KB2026-07-13 03:27📄DS-9890_yt_fact_video_demographics_backfill.sql3.1 KB2026-07-13 03:27📄DS2448-UPDATE_deezer_marketshare_adjustments.sql5.6 KB2026-07-13 03:27📄DS2448-UPDATE_deezer_marketshare_store_stream_scale.sql247 B2026-07-13 03:27📄DS2531-UPDATE_deezer_marketshare_adjustments.sql4.1 KB2026-07-13 03:27📄DS_6869_drop_old_clones.sql382 B2026-07-13 03:27📄DS_7333_add_artist_missing_social_link.sql817 B2026-07-13 03:27📄DS_7413_insert_membran_from_dev_qa.sql3.3 KB2026-07-13 03:27📄DS_8202_fix_spotify_altafonte_processed_date.sql426 B2026-07-13 03:27📄FO-120-DELETE_from_staging_raw_xbox.sql299 B2026-07-13 03:27📄FO-120_DELETE_incorrect_data_for_xbox_from_fact_analytics.sql220 B2026-07-13 03:27📄FO-120_DELETE_incorrect_data_for_xbox_from_fact_analytics_error.sql216 B2026-07-13 03:27📄FO-13_DELETE_incorrect_data_for_pandora_from_fact_analytics.sql254 B2026-07-13 03:27📄FO-13_DELETE_incorrect_data_for_pandora_from_fact_analytics_error.sql260 B2026-07-13 03:27📄FO-13_DELETE_incorrect_data_for_pandora_from_staging_raw_pandora.sql177 B2026-07-13 03:27📄FO-158_DELETE_spotify_data.sql255 B2026-07-13 03:27📄FO-161-DELETE_facts_analytics_spotify.sql527 B2026-07-13 03:27📄FO-24_DELETE_from_fact_analytics_errors_google_music.sql436 B2026-07-13 03:27📄FO-24_DELETE_from_fact_analytics_google_music.sql417 B2026-07-13 03:27📄FO-24_DELETE_from_staging_raw_google.sql310 B2026-07-13 03:27📄FO-25_DELETE_incorrect_data_for_pandora_from_fact_analytics.sql305 B2026-07-13 03:27📄FO-25_DELETE_incorrect_data_for_pandora_from_fact_analytics_error.sql311 B2026-07-13 03:27📄FO-25_DELETE_incorrect_data_for_pandora_from_staging_raw_pandora.sql181 B2026-07-13 03:27📄FO-268_UPDATE_fact_demographics_user_id_w_sony.sql485 B2026-07-13 03:27📄FO-268_UPDATE_raw_spotify_user_id.sql489 B2026-07-13 03:27📄FO-268_UPDATE_spotify_users_sony.sql444 B2026-07-13 03:27📄FO-268_UPDATE_staging_sos_user_id_sony.sql459 B2026-07-13 03:27📄FO-268_UPDATE_sub30_users.sql504 B2026-07-13 03:27📄FO-33-DELETE_from_fact_analytics_error_google_music.sql464 B2026-07-13 03:27📄FO-33-DELETE_from_fact_analytics_google_play.sql456 B2026-07-13 03:27📄FO-33-DELETE_from_staging_raw_google.sql307 B2026-07-13 03:27📄FO-43-DELETE_from_fact_analytics_errors_google_music.sql436 B2026-07-13 03:27📄FO-43-DELETE_from_fact_analytics_google_music.sql417 B2026-07-13 03:27📄FO-43-DELETE_from_staging_raw_google.sql310 B2026-07-13 03:27📄FO-44_DELETE_incorrect_data_for_pandora_from_fact_analytics.sql236 B2026-07-13 03:27📄FO-44_DELETE_incorrect_data_for_pandora_from_staging_raw_pandora.sql176 B2026-07-13 03:27📄FO-49_DELETE_incorrect_data_for_pandora_from_fact_analytics.sql275 B2026-07-13 03:27📄FO-49_DELETE_incorrect_data_for_pandora_from_fact_analytics_error.sql281 B2026-07-13 03:27📄FO-49_DELETE_incorrect_data_for_pandora_from_staging_raw_pandora.sql176 B2026-07-13 03:27📄FO-52-DELETE_from_fact_analytics_errors_google_music.sql438 B2026-07-13 03:27📄FO-52-DELETE_from_fact_analytics_google_music.sql416 B2026-07-13 03:27📄FO-52-DELETE_from_staging_raw_google.sql307 B2026-07-13 03:27📄FO-54_DELETE_incorrect_data_for_apple_from_fact_analytics_error.sql329 B2026-07-13 03:27📄FO-64_DELETE_incorrect_data_from_staging_sos.sql184 B2026-07-13 03:27📄FO-71-DELETE_from_fact_analytics.sql278 B2026-07-13 03:27📄FO-71_DELETE_from_fact_analytics.sql284 B2026-07-13 03:27📄FO-73_DELETE_from_fact_tables.sql753 B2026-07-13 03:27📄FO-73_DELETE_spotify_data_for_2017_12_21.sql603 B2026-07-13 03:27📄FO-87-DELETE_from_staging_sos.sql282 B2026-07-13 03:27📄FO-87_DELETE_from_staging_sos.sql271 B2026-07-13 03:27📄FO-90-DELETE_from_staging_raw_rhapsody.sql313 B2026-07-13 03:27📄GO-72_UPDATE_yt_fact_analytics.sql724 B2026-07-13 03:27📄IN-10538_UPDATE_dim_track-fix-moved-tracks.sql1.9 KB2026-07-13 03:27📄IN-11001_DELETE_FROM_sme_labelcopy_ingest.sql330 B2026-07-13 03:27📄IN-11116_UPDATE_sme_to_orchard_label_mapping.sql35.5 KB2026-07-13 03:27📄IN-11129_UPDATE_sme_to_orchard_label_mapping_with_new_vendors-batch-2.sql43.2 KB2026-07-13 03:27📄IN-11129_UPDATE_sme_to_orchard_label_mapping_with_new_vendors.sql1.3 KB2026-07-13 03:27📄IN-11134_DELETE_from_sme_labelcopy_ingest_EXPORTED.sql169 B2026-07-13 03:27📄IN-11165_DELETE_from_sme_labelcopy_ingest.sql306 B2026-07-13 03:27📄IN-11165_DELETE_from_sme_labelcopy_ingest_FAILED_TO_INGEST.sql848 B2026-07-13 03:27📄IN-11173_UPDATE_sme_to_orchard_label_mapping_with_new_vendors.sql4.0 KB2026-07-13 03:27📄IN-11182_Backfill_spotify_sme_data_2021_year.sql2.0 KB2026-07-13 03:27📄IN-11182_Backfill_spotify_sme_data_2022_year.sql2.0 KB2026-07-13 03:27📄IN-11182_Backfill_spotify_sme_data_2023_year.sql2.0 KB2026-07-13 03:27📄IN-11182_DELETE_sme_data_for_spotify_from_fact_analytics.sql461 B2026-07-13 03:27📄IN-11182_INSERT_fact_analytics_sme_spotify.sql3.3 KB2026-07-13 03:27📄IN-11183_backfill_sme_data_for_apple_from_fact_analytics.sql2.0 KB2026-07-13 03:27📄IN-11184_backfill_sme_data_for_amazon_music_to_aggregated_skips_and_saves.sql3.8 KB2026-07-13 03:27📄IN-11184_backfill_sme_data_for_amazon_music_to_fact_analytics.sql2.6 KB2026-07-13 03:27📄IN-11184_backfill_sme_data_for_amazon_music_to_fact_analytics_delete_old_data_part1.sql620 B2026-07-13 03:27📄IN-11184_backfill_sme_data_for_amazon_music_to_fact_analytics_delete_old_data_part2.sql620 B2026-07-13 03:27📄IN-11184_backfill_sme_data_for_amazon_music_to_fact_analytics_only_inserts.sql1.6 KB2026-07-13 03:27📄IN-11184_cleanup_backup_tables.sql216 B2026-07-13 03:27📄IN-11185-insert-into-fact-analytics-for-amazon_downloads.sql1.4 KB2026-07-13 03:27📄IN-11185_11189_delete_from_fact_analytics_for_amazon_downloads_and_itunes.sql606 B2026-07-13 03:27📄IN-11187_DELETE_sme_data_for_qq_from_fact_analytics.sql451 B2026-07-13 03:27📄IN-11189_INSERT_fact_analytics_sme_itunes.sql1.5 KB2026-07-13 03:27📄IN-11189_INSERT_INTO_sony_apple_id_mapping.sql1.3 KB2026-07-13 03:27📄IN-11203_DELETE_sme_data_for_spotify_from_fact_analytics.sql856 B2026-07-13 03:27📄IN-11203_INSERT_fact_analytics_sme_spotify.sql1.5 KB2026-07-13 03:27📄IN-11204_DELETE_sme_data_for_apple_from_fact_analytics.sql656 B2026-07-13 03:27📄IN-11204_INSERT_fact_analytics_sme_apple.sql1.5 KB2026-07-13 03:27📄IN-11210_Bacfill_aggregated_streams_sme_spotify.sql1.4 KB2026-07-13 03:27📄IN-11211_Bacfill_aggregated_streams_sme_apple.sql9.5 KB2026-07-13 03:27📄IN-11213_Bacfill_aggregated_streams_sme_spotify.sql1.4 KB2026-07-13 03:27📄IN-11214_Bacfill_aggregated_streams_sme_apple.sql6.2 KB2026-07-13 03:27📄IN-11215_DELETE_FROM_dbt_downloads.sql394 B2026-07-13 03:27📄IN-11225_backfill_facts_analytics_error_spotify.sql1.4 KB2026-07-13 03:27📄IN-11226_backfill_fact_analytics_error_apple_data.sql1.5 KB2026-07-13 03:27📄IN-11227-deezer-fae.sql2.8 KB2026-07-13 03:27📄IN-11228-amazon-downloads-fae.sql3.3 KB2026-07-13 03:27📄IN-11234_UPDATE_sme_staging_raw_apple_music_libraryevents.sql602 B2026-07-13 03:27📄IN-1136_backfill_fact_analytics_error_itunes_data.sql2.3 KB2026-07-13 03:27📄IN-11377_delete_facts_analytics_error_for_amazon_music.sql357 B2026-07-13 03:27📄IN-11377_insert-facts_analytics_error-for-amazon_music-adsupported.sql3.8 KB2026-07-13 03:27📄IN-11377_insert-facts_analytics_error-for-amazon_music-prime.sql3.8 KB2026-07-13 03:27📄IN-11377_insert-facts_analytics_error-for-amazon_music-unlimited.sql3.8 KB2026-07-13 03:27📄IN-11380-rhapsody-fae.sql3.3 KB2026-07-13 03:27📄IN-11451_add_youtube_streams_to_dbt_models.sql22.9 KB2026-07-13 03:27📄IN-11523_backfill_dbt_tables_with_sos_columns_2022.sql11.5 KB2026-07-13 03:27📄IN-11589_re-backfill_sos_2022.sql23.0 KB2026-07-13 03:27📄IN-11719_rebuild_dbt_tables.sql10.2 KB2026-07-13 03:27📄IN-11931_remove_vk_ok.sql728 B2026-07-13 03:27📄IN-12115_remove_bad_product.sql3.7 KB2026-07-13 03:27📄IN-12115_remove_bad_product_from_downloads.sql394 B2026-07-13 03:27📄IN-12278_cluster_dim_release.sql224 B2026-07-13 03:27📄IN-13579_update_meghan_trainor_global_participant_ids.sql16.0 KB2026-07-13 03:27📄IN-14062_drop_unused_tables_round_1.sql2.0 KB2026-07-13 03:27📄IN-14062_set_timetravel_to_0.sql1.1 KB2026-07-13 03:27📄IN-14229_drop_unused_tables_round_2.sql816 B2026-07-13 03:27📄IN-15343-backfill_offer_type_to_dim_track.sql922 B2026-07-13 03:27📄IN-15389-backfill-dim-chart-slug.sql217.5 KB2026-07-13 03:27📄IN-15581_create_fact_new_music_friday_availability.sql382 B2026-07-13 03:27📄IN-15683_backfill_dim_chart_store_specific_id_nmf.sql446 B2026-07-13 03:27📄IN-15683_create_dim_new_music_friday_chart.sql3.6 KB2026-07-13 03:27📄IN-15885_update_store_high_watermark.sql360 B2026-07-13 03:27📄IN-16510_backfill_historical_playlist_tracklists_initial.sql16.6 KB2026-07-13 03:27📄IN-16520-backfill-BE-Playlist-Page-Local-Local-can-be-more-than-100-for-some-countries-3.sql10.2 KB2026-07-13 03:27📄IN-16536_update_missing_track_duration.sql733 B2026-07-13 03:27📄IN-16538_backfill_null_position_data_in_priority_playlists.sql2.6 KB2026-07-13 03:27📄IN-16538_backfill_priority_playlist_type_from_canonical.sql2.8 KB2026-07-13 03:27📄IN-16596-Playlist-Page-Header-SME-is-not-consistent-with-qty-of-tracks-in-the-tracklist.sql9.7 KB2026-07-13 03:27📄IN-16654_repair_nmf_2026_01_09.sql5.1 KB2026-07-13 03:27📄IN-16654_repair_nmf_2026_01_09_2.sql4.3 KB2026-07-13 03:27📄IN-16669_backfill_PRIORITY_PLAYLIST_METADATA.sql15.9 KB2026-07-13 03:27📄IN-16669_backfill_PRIORITY_PLAYLIST_METADATA_2.sql3.9 KB2026-07-13 03:27📄IN-16671_backfill_removed_on_for_personalized_priority_playlists.sql13.2 KB2026-07-13 03:27📄IN-16679-Playlist-list-BE-Not-all-playlists-are-in-dim-playlist.sql5.2 KB2026-07-13 03:27📄IN-16679-Playlist-list-BE-Not-all-playlists-from-the-tier-1-priority-list-are-available.sql4.9 KB2026-07-13 03:27📄IN-16679-Playlist-list-BE-Not-all-playlists-from-the-tier-1-priority-list-are-available_2.sql13.0 KB2026-07-13 03:27📄IN-16679_backfill_new_priority_playlist_current_state.sql14.4 KB2026-07-13 03:27📄IN-16679_backfill_new_priority_playlist_private.sql13.2 KB2026-07-13 03:27📄IN-16679_backfill_priority_playlist_header_metrics.sql18.1 KB2026-07-13 03:27📄IN-16681_delete_overlapping_hourly_playlists.sql1.1 KB2026-07-13 03:27📄IN-16719_backfill_removed_on_last_added_on_date.sql12.3 KB2026-07-13 03:27📄IN-16728-remove-duplicate-hourly-playlists.sql1.3 KB2026-07-13 03:27📄IN-16779_backfill_owner_field_on_PRIORITY_PLAYLIST_METADATA.sql1.2 KB2026-07-13 03:27📄IN-16802_INSERT_missing_playlists_into_dim_playlist.sql1.9 KB2026-07-13 03:27📄IN-16802_INSERT_missing_playlists_into_hourly_playlists.sql995 B2026-07-13 03:27📄IN-16853_repair_last_added_on_date_from_events.sql5.1 KB2026-07-13 03:27📄IN-16889_backfill_playlist_placement.sql2.2 KB2026-07-13 03:27📄IN-17306_insert_filtr_curator_playlists_into_dim_playlist.sql14.1 KB2026-07-13 03:27📄IN-17335_backfill_apple_fact_analytics.sql6.2 KB2026-07-13 03:27📄IN-17335_backfill_spotify_fact_analytics.sql17.5 KB2026-07-13 03:27📄IN-17356_add_sony_playlist_owner.sql1.3 KB2026-07-13 03:27📄IN-17469_add_sony_playlist_owner_curator_country.sql728 B2026-07-13 03:27📄IN-17474_delete_priority_playlist_metadata_stub_rows.sql1.3 KB2026-07-13 03:27📄IN-17505_delete_chartmetric_backfill_from_playlist_event_stage.sql1.5 KB2026-07-13 03:27📄IN-9666-insert-new-algorithmic-playlists.sql1.2 KB2026-07-13 03:27📄IN-9682-insert-playlist-curator-mappings.sql3.6 KB2026-07-13 03:27📄IN-9877_CTAS_dbt_table.sql1.9 KB2026-07-13 03:27📄IN-9891_insert_into_dim_feed.sql196 B2026-07-13 03:27📄IN-9908-update-thesoundsofspotify-as-playlist_type-curated.sql376 B2026-07-13 03:27📄IN-9953_CREATE_vendor_company_brand_parent_company_service_tier_view.sql1.6 KB2026-07-13 03:27📄IN-9961_CTAS_for_summary_geographics_v2.sql4.8 KB2026-07-13 03:27📄IN-9966_CTAS_for_demographics_models.sql4.9 KB2026-07-13 03:27📄IN_15276_DELETE_orphaned_psr.sql1.0 KB2026-07-13 03:27📄IN_16052_fix_null_social_ids.sql17.2 KB2026-07-13 03:27📄INT-1701-Delete-P301-early-iTunes-transaction-from-facts.prod.sme_jv_itunes_sales.sql870 B2026-07-13 03:27📄INT-1831-Delete-the-rows-with-DATE=2023-06-30-for-P305-early-iTunes-from-facts.prod.sme_jv_itunes_sales.sql945 B2026-07-13 03:27📄INT-2600-delete-bad-itunes-transactions-p325-from-sme_jv_itunes_sales.sql1010 B2026-07-13 03:27📄INT-2844-Change-TRACK_ID-for-UPC=7891430371227-and-ISRC=FR47Q0200550-in-the-STARS-Early-iTunes-P330-feed-V2.sql1.4 KB2026-07-13 03:27📄KDH-103_delete_non_existing_records.sql19.0 KB2026-07-13 03:27📄KDH-103_delete_non_existing_records_p2.sql223 B2026-07-13 03:27📄KDH-152_dedupe_publishing_has_signed_writer.sql19.8 KB2026-07-13 03:27📄KDH-152_dedupe_publishing_song_writer.sql446 B2026-07-13 03:27📄KDH-152_dupe_publishing_has_signed_writer2.sql2.1 KB2026-07-13 03:27📄KDH-157_delete_publishing_agreement.sql1.4 KB2026-07-13 03:27📄KDH-157_delete_publishing_song_writer.sql1.8 KB2026-07-13 03:27📄KDH-163_delete_vendor.sql367 B2026-07-13 03:27📄KDH-169_remove_duplicate_companybrands.sql1.0 KB2026-07-13 03:27📄KDH-180_remove_duplicate_vendors_from_cdc_snowflake.sql458 B2026-07-13 03:27📄KDH-182_DELETE_PROFILE_HAS_ACCESS_TO_VENDOR.sql18.9 KB2026-07-13 03:27📄KDH-182_DELETE_profiles.sql234.2 KB2026-07-13 03:27📄KDH-244-delete_PUBLISHING_COMPOSITION_AGREEMENT.sql34.9 KB2026-07-13 03:27📄KDH-29_delete_Label_participant_participated_in_orchard_product.sql308 B2026-07-13 03:27📄KDH-29_delete_Label_participant_participated_in_orchard_product2.sql285 B2026-07-13 03:27📄KDH-29_delete_Label_participant_participated_in_orchard_track.sql30.0 KB2026-07-13 03:27📄KDH-29_delete_Label_participant_participated_in_orchard_track2.sql328 B2026-07-13 03:27📄KDH-29_delete_PROFILE_DELETED_HAS_ACCESS_TO_LABEL_PARTICIPANT.sql1.6 KB2026-07-13 03:27📄KDH-29_delete_qa_Profile_has_access_to_label_participant.sql562 B2026-07-13 03:27📄KDH-29_Global_participant_represents_label_participant.sql577 B2026-07-13 03:27📄KDH-311_delete_non_existing_INCLUDES.sql260 B2026-07-13 03:27📄KDH-311_delete_non_existing_nr_contribution.sql3.6 KB2026-07-13 03:27📄KDH-311_delete_non_existing_records_p1.sql193 B2026-07-13 03:27📄KDH-311_delete_non_existing_records_p2.sql192 B2026-07-13 03:27📄KDH-311_delete_non_existing_records_p3.sql155 B2026-07-13 03:27📄KDH-311_delete_non_existing_records_p4.sql159 B2026-07-13 03:27📄KDH-311_delete_non_existing_records_p5.sql147 B2026-07-13 03:27📄KDH-311_delete_non_existing_records_p6.sql192 B2026-07-13 03:27📄KDH-311_delete_non_existing_records_p7.sql1.3 KB2026-07-13 03:27📄KDH-311_delete_non_existing_records_p8.sql907 B2026-07-13 03:27📄KDH-311_delete_non_existing_records_p9.sql1.6 KB2026-07-13 03:27📄KDH-311_delete_non_existing_SUBACCOUNT.sql814 B2026-07-13 03:27📄KDH-311_delete_NR_SOUND_RECORDING_HAS_PRIMARY_ARTIST_NR_PARTICIPANT.sql320 B2026-07-13 03:27📄KDH-322_cleanup_duplicate_vendors_uuid.sql1.2 KB2026-07-13 03:27📄KDH-340_BACKFILL_ISRC_TO_LABEL_PARTICIPANT_MAPPING.sql661 B2026-07-13 03:27📄KDH-347_Delete_extra_artists.sql2.2 KB2026-07-13 03:27📄KDH-347_Delete_extra_products.sql320 B2026-07-13 03:27📄KDH-363_LABEL_PARTICIPANT_PARTICIPATED_IN_ORCHARD_PRODUCT_backfilling.sql5.7 KB2026-07-13 03:27📄KDH-363_LABEL_PARTICIPANT_PARTICIPATED_IN_ORCHARD_TRACK_backfilling.sql6.1 KB2026-07-13 03:27📄KDH-363_truncate_qa_cdc_tables.sql6.3 KB2026-07-13 03:27📄KDH-381_DELETE_PUBLISHING_COMPOSITION_AGREEMENT.sql34.3 KB2026-07-13 03:27📄KDH-381_DELETE_PUBLISHING_PUBLISHER_AGREEMENT.sql4.7 KB2026-07-13 03:27📄KDH-381_DELETE_PUBLISHING_SONGWRITER_AGREEMENT.sql7.3 KB2026-07-13 03:27📄KDH-730_build_hfr_reconcile.sql3.8 KB2026-07-13 03:27📄KDH-730_delete_snowflake_only_stale.sql1.8 KB2026-07-13 03:27📄KDH-730_load_has_fingerprint_rule_s3_copy.sql1.4 KB2026-07-13 03:27📄MAINT_backfill_fact_new_music_friday_availability_from_orchard_rows.sql1.9 KB2026-07-13 03:27📄MAINT_backfill_fact_new_music_friday_availability_from_orchard_rows_20260525.sql1.9 KB2026-07-13 03:27📄MAINT_backfill_missing_nmf_placements_in_fact_charts_from_orchard_rows.sql2.4 KB2026-07-13 03:27📄MAINT_backfill_missing_nmf_placements_in_fact_charts_from_orchard_rows_20260525.sql2.4 KB2026-07-13 03:27📄MAINT_backfill_priority_playlist_tables_from_orchard_rows.sql70.9 KB2026-07-13 03:27📄MAINT_backfill_priority_playlist_tables_from_orchard_rows_20260525.sql70.9 KB2026-07-13 03:27📄MAINT_cleanup_dim_label.sql302 B2026-07-13 03:27📄MAINT_cleanup_dim_label_duplicates.sql641 B2026-07-13 03:27📄MAINT_dedup_priority_participant_placements.sql1.9 KB2026-07-13 03:27📄MAINT_delete_test_vendors.sql317 B2026-07-13 03:27📄MAINT_drop_FACT_YOUTUBE_ASSET_ANALYTICS_BAK.sql245 B2026-07-13 03:27📄MAINT_fix_priority_playlist_metadata_metrics_update_20260525.sql11.9 KB2026-07-13 03:27📄MAINT_resume_recluster_dbt.sql919 B2026-07-13 03:27📄MOV-3000_UPDATE_fact_analytics_vudu_video_season.sql1.6 KB2026-07-13 03:27📄MOV-3120_UPDATE_fact_analytics_FandangoNow_4K_format.sql1.2 KB2026-07-13 03:27📄MOV-3121_DELETE_fact_analytics_error_itunes_4K_format.sql4.1 KB2026-07-13 03:27📄MOV-3123_UPDATE_fact_analytics_VUDU_4K_format.sql1.2 KB2026-07-13 03:27📄MOV-3125_DELETE_fact_analytics_error_Googleplay_4K_format.sql2.5 KB2026-07-13 03:27📄MR-3388_UPDATE_fact_conflict_fix_yt_recent_daily_avg_for_fully_resolved_conflicts.sql3.6 KB2026-07-13 03:27📄MR-3523_DELETE_from_fact_conflict.sql154.7 KB2026-07-13 03:27📄MR-4217_UPDATE_fact_conflict_resolved_datetime.sql577 B2026-07-13 03:27📄NOTICKET_remove_dodgy_fake_playlist_from_the_priority_list.sql1.4 KB2026-07-13 03:27📄NOTICKET_remove_last_unavailable_playlist_from_the_priority_list.sql514 B2026-07-13 03:27📄NOTICKET_remove_overlapping_playlists_from_hourly.sql1008 B2026-07-13 03:27📄NR-2273-Delete_rows_with_null_product_ids_cdc_has_featured_artist.sql598 B2026-07-13 03:27📄NR-2273_Delete_null_values_from_HAS_PRIMARY_HAS_FEATURED_ARTIST_cdc_tables.sql1.2 KB2026-07-13 03:27📄NR-2273_DELETE_rows_with_null_product_id_NR_OWNERSHIP_PRODUCT_HAS_PRIMARY_ARTIST_NR_PARTICIPANT.sql918 B2026-07-13 03:27📄NR-2346_drop_unused_tables.sql229 B2026-07-13 03:27📄NR-B2273-DELETE_rows_with_null_product_id_NR_OWNERSHIP_PRODUCT_HAS_FEATURED_ARTIST_NR_PARTICIPANT.sql920 B2026-07-13 03:27📄OSP-1454_create_table_for_reactivated_users_since_cleanup.sql811 B2026-07-13 03:27📄OSP-1454_create_table_for_validated_deactivated_users_csv.sql2.0 KB2026-07-13 03:27📄period_267_delete_fact_sales_error.sql159 B2026-07-13 03:27📄PLAT-2519_UPDATE_uuid_in_fact_analytics_for_google_music.sql2.2 KB2026-07-13 03:27📄PLAT-2541_UPDATE_uuid_in_fact_tables_for_google_play.sql1.6 KB2026-07-13 03:27📄PLAT-2543_UPDATE_staging_sos_trim_isrc.sql162 B2026-07-13 03:27📄PLAT-2545_UPDATE_uuid_in_fact_analytics_for_youtube_weekly.sql1.7 KB2026-07-13 03:27📄PLAT-2547_UPDATE_uuid_in_fact_analytics_for_youtube_claim.sql2.0 KB2026-07-13 03:27📄PLATFORM-3722_truncate_CDC__MUSIC_GRAPH_V5__VENDOR_IN_SERVICE_TIER.sql171 B2026-07-13 03:27📄PLATFORM-3722_truncate_VENDOR_IN_SERVICE_TIER_SERVICE_TIER.sql163 B2026-07-13 03:27📄PLATFORM-3908_remove_invalid_vendor_uuids_snowflake.sql225 B2026-07-13 03:27📄POD-1015-fix-ids-round2.sql840 B2026-07-13 03:27📄POD-1015-fix-ids.sql966 B2026-07-13 03:27📄POD-1113-1110-1111-fix-samsung-web-browser.sql372 B2026-07-13 03:27📄POD-1113-1110-1111-group-user-agents.sql1.1 KB2026-07-13 03:27📄POD-1377-fix-chartable-apple-data.sql806 B2026-07-13 03:27📄POD-1377-truncate-chartable-tables.sql247 B2026-07-13 03:27📄POD-1377_add_podcast_ids.sql756 B2026-07-13 03:27📄POD-1377_clear_chartable_ranking_peaks.sql180 B2026-07-13 03:27📄pod-1467-remove-bad-ids-from-megaphone.sql327 B2026-07-13 03:27📄POD-1507-uk-to-gb.sql142 B2026-07-13 03:27📄POD-1555-prod-normalize-chartable-genre.sql4.3 KB2026-07-13 03:27📄POD-1555_update_chartable_genres.sql4.3 KB2026-07-13 03:27📄POD-1579-prod-megaphone-backfill-2.sql1.4 KB2026-07-13 03:27📄POD-1579-qa-megaphone-backfil-2.sql1.4 KB2026-07-13 03:27📄POD-1614-remove-dead-podcast.sql254 B2026-07-13 03:27📄POD-1636-fix-qa-cloned-podcast.sql2.6 KB2026-07-13 03:27📄POD-1636-prod-cloned-podcast.sql2.6 KB2026-07-13 03:27📄POD-1650-delete_from_chartable_episode_ranking_peaks.sql143 B2026-07-13 03:27📄POD-1650-delete_from_chartable_episode_rankings.sql138 B2026-07-13 03:27📄POD-1650-update_genre_in_chartable_episode_ranking_peaks.sql705 B2026-07-13 03:27📄POD-1650-update_genre_in_chartable_episode_rankings.sql723 B2026-07-13 03:27📄POD-1711-remove-bad-chartable-episode-data.sql139 B2026-07-13 03:27📄POD-1764-update-prod-analytics.sql249 B2026-07-13 03:27📄POD-1823_prod_delete_duplicate_chartable.sql177 B2026-07-13 03:27📄POD-1831-fix-spotify-duplicate.sql203 B2026-07-13 03:27📄POD-2145-prod-backfill-is-episode-deleted-in-megaphone-table.sql465 B2026-07-13 03:27📄POD-2145-qa-backfill-is-episode-deleted-in-megaphone-table.sql461 B2026-07-13 03:27📄POD-2211_add_columns_to_subscription_events_table.sql835 B2026-07-13 03:27📄POD-2299_create_apple_podcasts_subscription_events_monthly.sql1.9 KB2026-07-13 03:27📄POD-2302_create_apple_podcasts_subscription_events_weekly.sql1.9 KB2026-07-13 03:27📄POD-2311_create_apple_podcasts_subscription_snapshot_weekly.sql1.9 KB2026-07-13 03:27📄POD-2315_delete_chartable_bad_metadata.sql131 B2026-07-13 03:27📄POD-2324_update_event_date_conv.sql294 B2026-07-13 03:27📄POD-2324_update_event_date_conv_in_weekly_monthly_table.sql784 B2026-07-13 03:27📄POD-2353_update_channel_names_in_sales_summary.sql676 B2026-07-13 03:27📄POD-2353_update_channel_names_in_subscription_events.sql694 B2026-07-13 03:27📄POD-2353_update_channel_names_in_subscription_snapshot.sql700 B2026-07-13 03:27📄POD-2359_update_quantity_in_subs_event_monthly_table.sql2.4 KB2026-07-13 03:27📄POD-2516-prod-delete-record-chartable-podcast-metadata.sql260 B2026-07-13 03:27📄POD-2531-qa-delete-record-chartable-podcast-metadata.sql256 B2026-07-13 03:27📄POD-2684_update_pod_sub_llc_rows_subscription_events_monthly_table.sql388 B2026-07-13 03:27📄POD-2684_update_sme_rows_subscription_events_monthly_table.sql380 B2026-07-13 03:27📄POD-2692_backfill_vendor_details_in_apple_subscription_events.sql204 B2026-07-13 03:27📄POD-2695_backfill_vendor_details_in_apple_sales_summary.sql198 B2026-07-13 03:27📄POD-2696_backfill_vendor_details_in_apple_sales_summary_weekly_table.sql199 B2026-07-13 03:27📄POD-2697_backfill_vendor_details_in_apple_sales_summary_monthly.sql206 B2026-07-13 03:27📄POD-2699_backfill_vendor_details.sql213 B2026-07-13 03:27📄POD-2700_backfill_vendor_details.sql214 B2026-07-13 03:27📄POD-2747_backfill_apple_subs_snapshot_table.sql286 B2026-07-13 03:27📄POD-2753_backfill_apple_subs_events_weekly_table.sql.sql296 B2026-07-13 03:27📄POD-2924_backfill_vendor_details.sql204 B2026-07-13 03:27📄POD-938-add-published-data-to-megaphone-qa.sql827 B2026-07-13 03:27📄PORT-111_backfill-more-dim_release_history.sql693 B2026-07-13 03:27📄PORT-111_one-more-backfill-dim_release_history-drifted.sql693 B2026-07-13 03:27📄PORT-111_one-more-backfill-dim_release_history.sql693 B2026-07-13 03:27📄PORT-165-fix-statement-period-ids.sql606 B2026-07-13 03:27📄PORT-167-remove-invalid-history.sql881 B2026-07-13 03:27📄PORT-203-revert-dim-release-history.sql599 B2026-07-13 03:27📄PORT-92_backfill_dim_release_history.sql596 B2026-07-13 03:27📄PUB-1272_remove_publisher_agreement_record.sql306 B2026-07-13 03:27📄PUB-1272_remove_publisher_record.sql329 B2026-07-13 03:27📄PUB-408_delete_ghost_agreements.sql931 B2026-07-13 03:27📄PUB-656_cleanup_composition_agreements.sql1.5 KB2026-07-13 03:27📄PUB-656_dupe_composition_agreement_cleanup.sql8.0 KB2026-07-13 03:27📄PUB-696_delete_duplicate_publisher.sql473 B2026-07-13 03:27📄PUB-696_delete_duplicate_publisher_agreement.sql198 B2026-07-13 03:27📄PUB-XX-cleanup-duplicate-compositions.sql699 B2026-07-13 03:27📄PUB-XX-comp-submitted-at.sql2.5 KB2026-07-13 03:27📄PUB-XX-prune-duplicate-comps.sql315 B2026-07-13 03:27📄SR-103_UPDATE_delivery_history_service.sql382 B2026-07-13 03:27📄SR-1041_Remove_duplication_logs.sql3.5 KB2026-07-13 03:27📄SR-1200_UPDATE_tiktok_delivery_ack_awaited_to_missing.sql304 B2026-07-13 03:27📄SR-14_fix_missing_deletes.sql469 B2026-07-13 03:27📄SR-179_backfill_orchard_track_is_placement_of_label_sound_recording.sql2.8 KB2026-07-13 03:27📄SR-579_delete_bad_delivery_history_records.sql331 B2026-07-13 03:27📄SR-796_insert_QA_sample_data.sql732 B2026-07-13 03:27📄SR-869_delete_null_version_id_delivery_history.sql199 B2026-07-13 03:27📄SRE-1121_UPDATE_missing_from_elasticsearch.sql8.8 KB2026-07-13 03:27📄SRE-319_UPDATE_es_columns_for_missing_in_es.sql54.5 KB2026-07-13 03:27📄SRE-465_UPDATE_es_columns_for_missing_elasticsearch.sql3.4 KB2026-07-13 03:27📄SRE-883_UPDATE_es_columns_for_missing_in_elasticsearch.sql180.3 KB2026-07-13 03:27📄SRE-957_UPDATE_es_columns_for_missing_in_elasticsearch.sql61.1 KB2026-07-13 03:27📄SWITCH-3223-exclude-one-seven-subaccount-for-sme-analytics.sql362 B2026-07-13 03:27📄TECHWEEK_CREATE_DATA_EXPORT_STATUS.sql531 B2026-07-13 03:27📄UPDATE_dim_trafficsource_typo.sql211 B2026-07-13 03:27📄VC-3253_store_name_update.sql1.7 KB2026-07-13 03:27📄VC-4478_conflict_manager_complete_es_backfill.sql127 B2026-07-13 03:27📄VC-4478_es_backfill_conflict_manager_try_2.sql127 B2026-07-13 03:27📄VS-355_UPDATE_es_indexed_for_missing_conflicts.sql510 B2026-07-13 03:27📄VS-355_UPDATE_es_indexed_for_missing_conflicts_again.sql510 B2026-07-13 03:27📄VS-355_UPDATE_es_indexed_for_unresolved_unactioned_conflicts.sql287 B2026-07-13 03:27📄VS-440_DELETE_registry.sql248 B2026-07-13 03:27📄VS-445_DELETE_registry.sql248 B2026-07-13 03:27📄WIZ-2802-check-connection.sql383 B2026-07-13 03:27📄YT-112_backfill_fact_youtube_video_analytics_for_2016.sql6.5 KB2026-07-13 03:27📄YT-112_backfill_fact_youtube_video_analytics_for_2017.sql6.5 KB2026-07-13 03:27📄YT-112_backfill_fact_youtube_video_analytics_for_2018.sql6.5 KB2026-07-13 03:27📄YT-112_backfill_fact_youtube_video_analytics_for_2019.sql6.5 KB2026-07-13 03:27📄YT-112_backfill_fact_youtube_video_analytics_for_2020.sql6.5 KB2026-07-13 03:27📄YT-13-ALTER_dim_youtube_channel_names_add_columns.sql1.5 KB2026-07-13 03:27📄YT-227_backfile_fact_youtube_video_analytics_for_2019.sql6.0 KB2026-07-13 03:27📄YT-227_backfill_fact_youtube_video_analytics_for_2016.sql6.0 KB2026-07-13 03:27📄YT-227_backfill_fact_youtube_video_analytics_for_2017.sql6.0 KB2026-07-13 03:27📄YT-227_backfill_fact_youtube_video_analytics_for_2018.sql6.0 KB2026-07-13 03:27📄YT-277_BACKFILL_fact_youtube_asset_analytics_for_2018.sql6.0 KB2026-07-13 03:27📄YT-383_alter_dim_youtube_channel_names_add_is_in_mcn.sql247 B2026-07-13 03:27📄YT-395-ALTER_dim_claim.sql776 B2026-07-13 03:27📄YT-395-backfill_dim_claim.sql1.6 KB2026-07-13 03:27📄YT-410-ALTER_dim_claim.sql559 B2026-07-13 03:27📄YT-410_rebuild_dim_claim.sql2.0 KB2026-07-13 03:27📄YT-525_REBUILD_dim_claim_ignore_no_isrcs.sql1.9 KB2026-07-13 03:27📄YT-550-ALTER_dim_claim_add_columns.sql697 B2026-07-13 03:27📄YT-550-UPDATE_dim_claim_backfill_new_columns.sql703 B2026-07-13 03:27📄YT-59-ALTER_fact_youtube_add_licensor.sql1.1 KB2026-07-13 03:27📄YT-59-UPDATE_dim_licensor.sql423 B2026-07-13 03:27📄YT-59_UPDATE_licensorid_in_fact_youtube_asset_analytics.sql312 B2026-07-13 03:27📄YT-59_UPDATE_licensorid_in_fact_youtube_asset_analytics_error.sql318 B2026-07-13 03:27📄YT-59_UPDATE_licensorid_in_fact_youtube_asset_demographics.sql315 B2026-07-13 03:27📄YT-59_UPDATE_licensorid_in_fact_youtube_video_analytics.sql312 B2026-07-13 03:27📄YT-59_UPDATE_licensorid_in_fact_youtube_video_demographics.sql315 B2026-07-13 03:27📄YT-707_DROP_deprecated_dbt_tables.sql2.0 KB2026-07-13 03:27📄YT-713_add_new_traffic_sources.sql291 B2026-07-13 03:27📄YT-733_update_playlist_curator_mappings.sql212 B2026-07-13 03:27