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

Name ↑SizeModified
⬆..📁fact_analytics_backfill-2026-09-14 06:27📁snowflake_tasks-2026-09-14 06:27📁view-2026-09-14 06:27📄AAA-244_create_gda_score_calculation_metrics.sql2.6 KB2026-07-13 03:27📄AAA-244_create_gda_score_calculation_metrics_by_v2.sql2.7 KB2026-07-13 03:27📄AAA-258_Add_field_to_indicate_if_a_voucher_code_is_a_consultant.sql2.9 KB2026-07-13 03:27📄AAA-289_create_gda_leads.sql2.0 KB2026-07-13 03:27📄ACC-2276_create_prod_SME_JV_SPOTIFY_SALES.sql1.1 KB2026-07-13 03:27📄ACC-2276_create_qa_SME_JV_SPOTIFY_SALES.sql1.4 KB2026-07-13 03:27📄ACC-2410-CREATE_transaction_detail_stage.sql412 B2026-07-13 03:27📄ACC-242-run-txn-import.sql410 B2026-07-13 03:27📄ACC-2628-create_prod_sme_jv_itunes_sales.sql1.1 KB2026-07-13 03:27📄ACC-2628-create_qa_sme_jv_itunes_sales.sql1.4 KB2026-07-13 03:27📄ACC-3358-create-unique-isrc-view.sql526 B2026-07-13 03:27📄ACC-3734-alter-unique-isrc-view.sql1.1 KB2026-07-13 03:27📄ACC-7417-add-txn_id-to-fact_sales.sql2.9 KB2026-07-13 03:27📄ARTARCH-614-reschedule-QA-product-project-trackartist-releaseartist-to-neo4j-tasks.sql1.1 KB2026-07-13 03:27📄ARTARCH-614-reschedule-QA-project-trackartist-releaseartist-to-neo4j-tasks.sql698 B2026-07-13 03:27📄ARTARCH-614_ALTER_product_qa_sf_task_schedule.sql283 B2026-07-13 03:27📄ARTARCH-614_ALTER_track_writer_qa_sf_task_schedule.sql293 B2026-07-13 03:27📄ARTARCH-614_create_neo4j_track_writer.sql4.8 KB2026-07-13 03:27📄ARTARCH-614_neo4j_product_query_to_SF_table.sql3.0 KB2026-07-13 03:27📄ARTARCH-614_neo4j_product_query_to_SF_table_update.sql3.3 KB2026-07-13 03:27📄ARTARCH-614_neo4j_project_query_to_SF_table.sql3.2 KB2026-07-13 03:27📄ARTARCH-614_neo4j_project_query_to_SF_table_update_task.sql2.4 KB2026-07-13 03:27📄ARTARCH-614_neo4j_releaseartist_query_to_SF_table.sql3.3 KB2026-07-13 03:27📄ARTARCH-614_neo4j_releaseartist_query_to_SF_table_update_task.sql2.4 KB2026-07-13 03:27📄ARTARCH-614_neo4j_track_writer_query_fix.sql4.3 KB2026-07-13 03:27📄ARTARCH-614_neo4j_trackartist_query_to_SF_table.sql3.2 KB2026-07-13 03:27📄ARTARCH-614_neo4j_trackartist_query_to_SF_table_update_task.sql2.4 KB2026-07-13 03:27📄ARTARCH-614_QA_neo4j_product_project_trackArtist_releaseArtist_replace_stale_streams.sql1.5 KB2026-07-13 03:27📄ARTARCH-647_neo4j_to_snowflake_track_writer_syncronization.sql1.4 KB2026-07-13 03:27📄AS-1040_ALTER_split_data_with_rate_type.sql214 B2026-07-13 03:27📄AS-2334-CREATE_splits_mirror.sql4.3 KB2026-07-13 03:27📄AS-2334-CREATE_splits_mirror_overwrite.sql2.5 KB2026-07-13 03:27📄AS-2334b-CREATE_splits_mirror.sql2.8 KB2026-07-13 03:27📄AS-2467-UPDATE_profile_has_access_to_collaborator.sql1.5 KB2026-07-13 03:27📄AS-2589-UPDATE_profile_has_access_to_data.sql11.4 KB2026-07-13 03:27📄AS-271-CREAT-fact_collaborator_split_data.sql827 B2026-07-13 03:27📄AS-2710-CREATE_splits_mirror_clustering.sql222 B2026-07-13 03:27📄AS-NOTICKET-UPDATE_profile_has_access_to_data.sql8.4 KB2026-07-13 03:27📄AUT-502-CREATE_isrc_availability_test_results.sql764 B2026-07-13 03:27📄CCM-1486_CREATE_mkt_priority_all.sql979 B2026-07-13 03:27📄CCM-1486_CREATE_mkt_priority_all_log.sql982 B2026-07-13 03:27📄CCM-4252_create_label_sound_recording_participation_tables.sql2.1 KB2026-07-13 03:27📄CON-1086_CREATE_ad_campaign_reporting.sql1.3 KB2026-07-13 03:27📄CON-124_CREATE_feature_fm_ad_campaign_budget_ingest.sql1.6 KB2026-07-13 03:27📄CON-143_CREATE_orchtblspotifyplaylisttracklisthistory.sql750 B2026-07-13 03:27📄CREATE_test_table.sql175 B2026-07-13 03:27📄DATA-1808_CREATE_staging_raw_apple_music_libraryevents.sql1.1 KB2026-07-13 03:27📄DATA-2098_ALTER_drop_column_staging_raw_rhapsody.sql151 B2026-07-13 03:27📄DATA-3608_ALTER_fact_demographics.sql250 B2026-07-13 03:27📄DATA-3663_CREATE_staging_raw_amazon_unlimited.sql2.9 KB2026-07-13 03:27📄DATA-3663_CREATE_staging_raw_amazon_unlimited_with_location_varchar.sql2.9 KB2026-07-13 03:27📄DATA-3864_CREATE_staging_sos.sql2.3 KB2026-07-13 03:27📄DATA-3874_CREATE_test_table_with_grants.sql436 B2026-07-13 03:27📄DATA-3937_ALTER_fact_demographics_add_artistid.sql194 B2026-07-13 03:27📄DATA-3938_CLUSTER_fact_demographics_with_artistid.sql286 B2026-07-13 03:27📄DATA-3938_CREATE_fact_demographics_with_artistid.sql568 B2026-07-13 03:27📄DATA-3938_CREATE_fact_demographics_with_artistid_no_row_id.sql562 B2026-07-13 03:27📄DATA-4034_CREATE_and_populate_summary_sos.sql1.0 KB2026-07-13 03:27📄DATA-4039_CREATE_playlist_metadata.sql870 B2026-07-13 03:27📄DATA-4049_CREATE_track_placement_metadata.sql710 B2026-07-13 03:27📄DATA-4412_clone_dim_canonical_track_metadata.sql493 B2026-07-13 03:27📄DATA-4412_GRANT_dim_canonical_track_metadata.sql460 B2026-07-13 03:27📄DATA-4574_alter_demographics_region_mapping.sql230 B2026-07-13 03:27📄DATA-4898_ALTER_dim_release_add_format_column.sql286 B2026-07-13 03:27📄DATA-4898_GRANT_OWNERSHIP_STG_DIM_RELEASE.sql647 B2026-07-13 03:27📄DATA-5006_GRANT_ONWERSHIP_STG_TABLES.sql20.2 KB2026-07-13 03:27📄DATA-5006_GRANT_OWNERSHIP_DIM_TABLES.sql6.7 KB2026-07-13 03:27📄DATA-5269_ALTER_staging_raw_spotify_v2_ADD_column_source_uri_legacy.sql212 B2026-07-13 03:27📄DATA-5274_UPDATE_playlist_url_in_staging_sos_regex.sql528 B2026-07-13 03:27📄DATA-5302_ALTER_dim_canonical_track_metadata_add_column.sql207 B2026-07-13 03:27📄DATA-5350_CREATE_mobile_top_tracks.sql5.0 KB2026-07-13 03:27📄DATA-5353_ALTER_staging_add_sos_palylist_url_legacy.sql192 B2026-07-13 03:27📄DATA-5409_CREATE_staging_raw_apple_music_demographics.sql1.4 KB2026-07-13 03:27📄DATA-5418_CREATE_mobile_track_streams.sql1.6 KB2026-07-13 03:27📄DATA-5593_CREATE_table_dim_transactiongroup.sql1.2 KB2026-07-13 03:27📄DATA-5911_CREATE_country_group_country_table.sql712 B2026-07-13 03:27📄DATA-5911_CREATE_country_group_table.sql641 B2026-07-13 03:27📄DATA-6251_CREATE_placements_metadata_table.sql744 B2026-07-13 03:27📄DATA-6503_ALTER_placements_metadata.sql358 B2026-07-13 03:27📄DATA-6563_CREATE_dim_containertype.sql988 B2026-07-13 03:27📄DATA-6563_CREATE_dim_containertype_2.sql986 B2026-07-13 03:27📄DATA-6563_CREATE_dim_feed.sql1.4 KB2026-07-13 03:27📄DATA-6563_CREATE_dim_licensor.sql3.1 KB2026-07-13 03:27📄DATA-6563_CREATE_dim_playlist.sql1.3 KB2026-07-13 03:27📄DATA-6563_CREATE_dim_sourcetype.sql4.4 KB2026-07-13 03:27📄DATA-6563_CREATE_dim_subscriptionpaytier.sql1.6 KB2026-07-13 03:27📄DATA-6563_CREATE_dim_subscriptiontype.sql5.1 KB2026-07-13 03:27📄DATA-6563_CREATE_dim_user.sql1.4 KB2026-07-13 03:27📄DATA-6564_CREATE_fact_analytics_v2.sql1.9 KB2026-07-13 03:27📄DATA-6574_ALTER_staging_raw_spotify_v2.sql184 B2026-07-13 03:27📄DATA-6774_CREATE_dim_track_clean_v2.sql1.6 KB2026-07-13 03:27📄DATA-6830_CREATE_fact_analytics_error_v2.sql1.5 KB2026-07-13 03:27📄DATA-7079_ALTER_staging_raw_itunes.sql185 B2026-07-13 03:27📄DATA-7122_CREATE_summary_geographics_v3.sql917 B2026-07-13 03:27📄DATA-7212_ALTER_TABLE_SWAP_fact_with_fact_v2.sql325 B2026-07-13 03:27📄DATA-7212_CREATE_placements_metadata_fa2.sql742 B2026-07-13 03:27📄DATA-7227_DROP_summary_sos_by_region_fa2.sql186 B2026-07-13 03:27📄DATA-7237_CREATE_dim_track_clean_mv.sql1.6 KB2026-07-13 03:27📄DATA-7237_DROP_TABLE_dim_track_clean_v2.sql178 B2026-07-13 03:27📄DATA-7511_DROP_unused_snowflake_tables.sql10.9 KB2026-07-13 03:27📄DATA-8949_CREATE_LABEL_PARTICIPANT_PARTICIPATED_IN_ORCHARD_PRODUCT.sql4.9 KB2026-07-13 03:27📄DATA-9136_CREATE_LABEL_PARTICIPANT_PARTICIPATED_IN_ORCHARD_TRACK_8.sql4.6 KB2026-07-13 03:27📄DIG-6453_CREATE_dim_continent.sql1.3 KB2026-07-13 03:27📄DIS-15_ALTER_fact_conflict_add_views_in_conflict_column.sql222 B2026-07-13 03:27📄DISTRO-4647-osr-delivery-events.sql2.6 KB2026-07-13 03:27📄DISTRO-4707_create_prod_table_for_acr_dedupe_data.sql300 B2026-07-13 03:27📄DISTRO-4707_create_qa_table_for_acr_dedupe_data.sql287 B2026-07-13 03:27📄DISTRO-4707_create_stage_prod.sql447 B2026-07-13 03:27📄DISTRO-4707_create_stage_qa.sql447 B2026-07-13 03:27📄DISTRO-4707_fill_table_for_acr_dedupe_data.sql896 B2026-07-13 03:27📄DISTRO-4707_fill_table_for_acr_dedupe_data_reimport_20210721_1.sql988 B2026-07-13 03:27📄DISTRO-4707_fill_table_for_acr_dedupe_data_reimport_20210917_2.sql988 B2026-07-13 03:27📄DISTRO-4881_create_stage.sql861 B2026-07-13 03:27📄DISTRO-4881_create_stage_full_export.sql880 B2026-07-13 03:27📄DISTRO-4881_create_stage_full_export_2.sql892 B2026-07-13 03:27📄DISTRO-4881_create_stage_full_export_3.sql892 B2026-07-13 03:27📄DISTRO-4881_create_stage_full_export_4.sql892 B2026-07-13 03:27📄DISTRO-746_CREATE_fact_conflict_content_owner_mapping.sql524 B2026-07-13 03:27📄DISTRO-746_CREATE_fact_conflict_unactioned_duplicate_conflicts.sql4.7 KB2026-07-13 03:27📄DISTRO-961_CREATE_fact_conflict_actioned_duplicate_conflicts.sql4.8 KB2026-07-13 03:27📄DS-10068-itunes-tickets-change-ticketid-to-str.sql444 B2026-07-13 03:27📄DS-10068-itunes-tickets-drop-column-ticketid-numeric.sql266 B2026-07-13 03:27📄DS-10068-itunes-tickets-tables-change-ticketid-to-str.sql963 B2026-07-13 03:27📄DS-10122_add_product_format_to_apple_maping.sql365 B2026-07-13 03:27📄DS-10193_CREATE_qa_apple_id_mapping.sql161 B2026-07-13 03:27📄DS-10226_ALTER_staging_raw_tiktok.sql536 B2026-07-13 03:27📄DS-10240_add_staging_raw_tiktok_asset_id.sql670 B2026-07-13 03:27📄DS-1026_CREATE_shazam_daily_events.sql1.1 KB2026-07-13 03:27📄DS-1027_CREATE_staging_raw_shazam.sql1.1 KB2026-07-13 03:27📄DS-10596-tadas-historical-predictions.sql267 B2026-07-13 03:27📄DS-10629-add-track_release_date-column-to-dim_track.sql579 B2026-07-13 03:27📄DS-10714_ALTER_staging_raw_vevo_add_column_content_provider.sql263 B2026-07-13 03:27📄DS-1084_CREATE_staging_raw_spotify_aggregated_streams.sql2.6 KB2026-07-13 03:27📄DS-10989_DROP_STAGING_RAW_DEEZER_V3_FRAUD_REPORT.sql162 B2026-07-13 03:27📄DS-11120_add_streaming_country_for_spotify.sql487 B2026-07-13 03:27📄DS-11136_spotify_new_fields.sql318 B2026-07-13 03:27📄DS-11231-promote-tadas-model-to-prod.sql420 B2026-07-13 03:27📄DS-1132_create_finetunes_track_id_mapping_table.sql715 B2026-07-13 03:27📄DS-11428-create_facts_prod_staging_raw_tiktok_view_to_consumer_reporting.sql2.2 KB2026-07-13 03:27📄DS-11428-create_facts_qa_staging_raw_tiktok_view_to_consumer_reporting.sql1.1 KB2026-07-13 03:27📄DS-11428-drop_staging_raw_tiktok_backup.sql191 B2026-07-13 03:27📄DS-11429-create_facts_prod_staging_raw_spotify_v2_view_to_consumer_reporting.sql3.5 KB2026-07-13 03:27📄DS-11429-create_facts_qa_staging_raw_spotify_v2_view_to_consumer_reporting.sql2.3 KB2026-07-13 03:27📄DS-11430-create_facts_prod_staging_raw_apple_music_views_to_consumer_reporting.sql5.4 KB2026-07-13 03:27📄DS-11430-create_facts_qa_staging_raw_apple_music_views_to_consumer_reporting.sql4.3 KB2026-07-13 03:27📄DS-11430-drop_backup_tables.sql550 B2026-07-13 03:27📄DS-11750_add_isrc_remmaping_table.sql2.8 KB2026-07-13 03:27📄DS-1196_CREATE_fact_point_of_sale.sql866 B2026-07-13 03:27📄DS-1196_CREATE_fact_point_of_sale_error.sql890 B2026-07-13 03:27📄DS-1196_CREATE_staging_raw_gfk.sql1.1 KB2026-07-13 03:27📄DS-1199_ALTER_staging_sos_remove_user_id_length_limitation.sql166 B2026-07-13 03:27📄DS-1208_REPLACE_amazon_unlimited.sql1.6 KB2026-07-13 03:27📄DS-1219_CREATE_spotidy_users_table.sql829 B2026-07-13 03:27📄DS-1219_CREATE_spotify_tracks_table.sql808 B2026-07-13 03:27📄DS-1219_CREATE_staging_raw_spotify_sub30.sql1.2 KB2026-07-13 03:27📄DS-1220_SWAP_SPOTIFY_TRACKS.sql541 B2026-07-13 03:27📄DS-1220_SWAP_SPOTIFY_USERS.sql534 B2026-07-13 03:27📄DS-1220_SWAP_STAGING_RAW_SPOTIFY_AGGREGATED_STREAMS.sql709 B2026-07-13 03:27📄DS-1220_SWAP_STAGING_RAW_SPOTIFY_SUB30.sql618 B2026-07-13 03:27📄DS-1234_DROP_CANONICAL_TRACK_METADATA.sql133 B2026-07-13 03:27📄DS-1234_DROP_fact_conflict_tables.sql9.1 KB2026-07-13 03:27📄DS-1247_ALTER_dim_canonical_track_metadata.sql391 B2026-07-13 03:27📄DS-1247_CREATE_dim_sound_recording_artist.sql1.0 KB2026-07-13 03:27📄DS-1251_CREATE_staging_raw_youtube_v11.sql1.1 KB2026-07-13 03:27📄DS-1316_ALTER_staging_dim_track_add_last_updated_column.sql191 B2026-07-13 03:27📄DS-1318_ALTER_dim_canonical_track_metadata_add_last_updated.sql392 B2026-07-13 03:27📄DS-1343_CREATE_staging_raw_google_play_marketshare.sql1.0 KB2026-07-13 03:27📄DS-1344_CREATE_staging_raw_youtube_red_marketshare.sql1.8 KB2026-07-13 03:27📄DS-1345_CREATE_staging_raw_itunes_marketshare.sql1.8 KB2026-07-13 03:27📄DS-1347_CREATE_staging_raw_amazon_market_share.sql920 B2026-07-13 03:27📄DS-1348_CREATE_staging_raw_deezer_market_share.sql857 B2026-07-13 03:27📄DS-1349_CREATE_staging_raw_spotify_market_share.sql1.0 KB2026-07-13 03:27📄DS-1350_CREATE_staging_raw_amazon_unlimited_market_share.sql1.3 KB2026-07-13 03:27📄DS-1352_CREATE_fact_market_share.sql1.1 KB2026-07-13 03:27📄DS-1389_ALTER_shadow_spotify_tables_add_new_user_id.sql168 B2026-07-13 03:27📄DS-1411_CREATE_staging_raw_apple_music_nonroyalty_streams.sql1.4 KB2026-07-13 03:27📄DS-1426_CREATE_itunes_ticket_defect_codes.sql265 B2026-07-13 03:27📄DS-1426_CREATE_itunes_ticket_notes.sql285 B2026-07-13 03:27📄DS-1426_CREATE_itunes_tickets.sql644 B2026-07-13 03:27📄DS-1434_DROP_backup_spotify_user_id_related_tables.sql327 B2026-07-13 03:27📄DS-1434_DROP_backup_tables.sql492 B2026-07-13 03:27📄DS-1434_DROP_MR_ACTIVE.sql11.3 KB2026-07-13 03:27📄DS-1434_DROP_rollback_tables.sql593 B2026-07-13 03:27📄DS-1434_DROP_temp_tables.sql207 B2026-07-13 03:27📄DS-1434_DROP_youtube_asset_confict_orchard_tables.sql36.8 KB2026-07-13 03:27📄DS-1434_DROP_youtube_asset_conflict_by_territory.sql28.7 KB2026-07-13 03:27📄DS-1434_DROP_youtube_asset_conflict_ioda.sql33.6 KB2026-07-13 03:27📄DS-1452-CREATE_itunes_hidden.sql643 B2026-07-13 03:27📄DS-1470_CREATE_apple_music_streams_for_data_share.sql1.4 KB2026-07-13 03:27📄DS-1473_ALTER_dim_licensor_add_distributor_column.sql394 B2026-07-13 03:27📄DS-1473_ALTER_staging_raw_amazon_market_share_v2_add_new_columns.sql620 B2026-07-13 03:27📄DS-1473_CREATE_sony_apple_id_mapping.sql437 B2026-07-13 03:27📄DS-1518-CREATE_amazon_music_tables.sql6.1 KB2026-07-13 03:27📄DS-1518-CREATE_amazon_unlimited.sql259 B2026-07-13 03:27📄DS-1518-CREATE_amazon_unlimited_2.sql484 B2026-07-13 03:27📄DS-1520-CLONE_amazon_unlimited.sql524 B2026-07-13 03:27📄DS-1541_delete_amazon_unlimited_from_fa.sql163 B2026-07-13 03:27📄DS-1541_remove_store_716.sql311 B2026-07-13 03:27📄DS-1570_CREATE_dim_ad.sql867 B2026-07-13 03:27📄DS-1570_CREATE_dim_device.sql695 B2026-07-13 03:27📄DS-1570_CREATE_dim_os.sql1.0 KB2026-07-13 03:27📄DS-1570_CREATE_dim_playback.sql688 B2026-07-13 03:27📄DS-1570_CREATE_dim_sharingservice.sql2.3 KB2026-07-13 03:27📄DS-1570_CREATE_dim_trafficsource.sql1.1 KB2026-07-13 03:27📄DS-1570_CREATE_fact_youtube_asset_analytics.sql1.3 KB2026-07-13 03:27📄DS-1570_CREATE_fact_youtube_asset_analytics_error.sql1.3 KB2026-07-13 03:27📄DS-1570_CREATE_fact_youtube_asset_demographics.sql1021 B2026-07-13 03:27📄DS-1570_CREATE_fact_youtube_video_analytics.sql1.3 KB2026-07-13 03:27📄DS-1570_CREATE_fact_youtube_video_demographics.sql997 B2026-07-13 03:27📄DS-1594-2_ALTER_TABLE_facts_analytics.sql369 B2026-07-13 03:27📄DS-1594_ALTER_TABLE_facts_analytics_ADD_osid_deviceid.sql392 B2026-07-13 03:27📄DS-1594_INSERT_INTO_DIM_DEVICE.sql311 B2026-07-13 03:27📄DS-1594_INSERT_INTO_DIM_OS.sql392 B2026-07-13 03:27📄DS-1613_CREATE_dim_claims.sql544 B2026-07-13 03:27📄DS-1641_SWAP_placements_metadata_v2.sql2.3 KB2026-07-13 03:27📄DS-1656_CREATE_staging_raw_uma.sql3.3 KB2026-07-13 03:27📄DS-1657_create_uma_store.sql231 B2026-07-13 03:27📄DS-1661_ALTER_am_shazam_daily_events.sql506 B2026-07-13 03:27📄DS-1661_create_apple_music_shazams.sql954 B2026-07-13 03:27📄DS-1694_UPDATE_DIM_STORE.sql261 B2026-07-13 03:27📄DS-1701_CLONE_STAGING_RAW_SPOTIFY_AGGREGATED_STREAMS.sql592 B2026-07-13 03:27📄DS-1701_CREATE_STAGING_RAW_SPOTIFY_AGGREGATED_STREAMS_v2.sql1.2 KB2026-07-13 03:27📄DS-1701_SWAP_SPOTIFY_AGGREGATED_STREAMS.sql634 B2026-07-13 03:27📄DS-1711_CREATE_shared_tables_stability.sql614 B2026-07-13 03:27📄DS-1718_CREATE_staging_raw_amazon_aggregated_streams.sql855 B2026-07-13 03:27📄DS-1779_ALTER_TABLE_facts_analytics_error_ADD_osid_deviceid.sql410 B2026-07-13 03:27📄DS-1779_backfill_osid_deviceid_for_amazon.sql1.2 KB2026-07-13 03:27📄DS-1779_backfill_osid_deviceid_for_amazon_2.sql3.5 KB2026-07-13 03:27📄DS-1779_backfill_osid_deviceid_for_pandora.sql2.4 KB2026-07-13 03:27📄DS-1779_backfill_osid_deviceid_for_spotify.sql488 B2026-07-13 03:27📄DS-1779_backfill_osid_deviceid_for_spotify_2.sql1.3 KB2026-07-13 03:27📄DS-1801_CREATE_aggregated_skips_and_saves.sql725 B2026-07-13 03:27📄DS-1808_CREATE_staging_raw_apple_music_artists.sql1015 B2026-07-13 03:27📄DS-1808_CREATE_staging_raw_apple_music_playlists.sql1.0 KB2026-07-13 03:27📄DS-1808_CREATE_staging_raw_apple_music_songs.sql971 B2026-07-13 03:27📄DS-1808_CREATE_staging_raw_apple_music_totallibraryadds.sql1.0 KB2026-07-13 03:27📄DS-1813_ALTER_apple_music_shazam.sql260 B2026-07-13 03:27📄DS-1883_CREATE_staging_raw_wynk.sql735 B2026-07-13 03:27📄DS-2044_ALTER_spotify_tables_add_age_group.sql453 B2026-07-13 03:27📄DS-2057_CREATE_l_global_participant_label_participant.sql579 B2026-07-13 03:27📄DS-2057_CREATE_tables.sql2.7 KB2026-07-13 03:27📄DS-2084_ALTER_table_sme_analytics_ingestion_candidate_backload_add_ingest_requested_column.sql583 B2026-07-13 03:27📄DS-2096_CREATE_staging_raw_amazon_v2_sme.sql1.4 KB2026-07-13 03:27📄DS-2098_ALTER_staging_raw_rhapsody_add_licensor_column.sql310 B2026-07-13 03:27📄DS-2098_CREATE_staging_raw_rhapsody_sme.sql1.3 KB2026-07-13 03:27📄DS-2130_CREATE_STAGING_RAW_AMAZON_MARKET_SHARE_V2.sql1.4 KB2026-07-13 03:27📄DS-2139_ALTER_sme_analytics_ingest_candidates_add_projectid_column.sql290 B2026-07-13 03:27📄DS-2143_ALTER_staging_raw_amazon_add_licensor.sql599 B2026-07-13 03:27📄DS-2160_ALTER_aggregated_skips_and_saves.sql2.9 KB2026-07-13 03:27📄DS-2175_ALTER_sony_apple_id_mapping_add_album_or_track.sql244 B2026-07-13 03:27📄DS-2176_DROP_temp_apple_music_streams_tables.sql56.0 KB2026-07-13 03:27📄DS-2176_DROP_temp_apple_music_tables.sql43.6 KB2026-07-13 03:27📄DS-2182_ALTER_staging_raw_itunes_add_column_vendor_name.sql328 B2026-07-13 03:27📄DS-2211_DROP_temp_apple_music_tables.sql84.4 KB2026-07-13 03:27📄DS-2214_ALTER_TABLE_STAGING_RAW_SPOTIFY_V2_ADD_audio_format.sql226 B2026-07-13 03:27📄DS-2214_ALTER_TABLE_STAGING_RAW_SPOTIFY_V2_ADD_discovery_flag.sql237 B2026-07-13 03:27📄DS-2216_CREATE_staging_raw_youtube_video_report.sql1.8 KB2026-07-13 03:27📄DS-2217_DROP_temp_apple_music_nonroyalty_tables.sql84.7 KB2026-07-13 03:27📄DS-2217_DROP_temp_spotify.sql9.4 KB2026-07-13 03:27📄DS-2246-2_ALTER_TABLE_staging_raw_feature_fm_ad_spend_ADD_accountingday_last_updated.sql506 B2026-07-13 03:27📄DS-2246_ALTER_TABLE_fact_ad_spend_ADD_accountingday_last_updated.sql897 B2026-07-13 03:27📄DS-2257_CREATE_backload_tasks.sql746 B2026-07-13 03:27📄DS-2275_DROP_temp_amazon_tables.sql12.0 KB2026-07-13 03:27📄DS-2300_create_label_licensor_table.sql674 B2026-07-13 03:27📄DS-2319_ALTER_staging_raw_pandora_add_licensor_column.sql307 B2026-07-13 03:27📄DS-2346_CREATE_mappings_sme_tables.sql1.4 KB2026-07-13 03:27📄DS-2451_ALTER_chartmetric_charts_log.sql260 B2026-07-13 03:27📄DS-2451_CREATE_chartmetric_charts_log.sql605 B2026-07-13 03:27📄DS-2463_create_sme_dim_distribution_type.sql882 B2026-07-13 03:27📄DS-2463_CREATE_sme_dim_product_type.sql2.1 KB2026-07-13 03:27📄DS-2463_CREATE_sme_dim_sale_type.sql780 B2026-07-13 03:27📄DS-2463_CREATE_sme_dim_service_type.sql6.6 KB2026-07-13 03:27📄DS-2463_CREATE_sme_dim_transaction_type.sql1.1 KB2026-07-13 03:27📄DS-2487_create_view_orchard_labelcopy.sql1.2 KB2026-07-13 03:27📄DS-2487_replace_view_orchard_labelcopy.sql1.7 KB2026-07-13 03:27📄DS-2501_CREATE_staging_sme_labelcopy.sql1.8 KB2026-07-13 03:27📄DS-2502_CREATE_sme_labelcopy_ingest.sql701 B2026-07-13 03:27📄DS-2503_CREATE_sme_to_orchard_label_mapping.sql645 B2026-07-13 03:27📄DS-2513_ALTER_staging_raw_uma.sql248 B2026-07-13 03:27📄DS-2518_DS-2553_ALTER_staging_raw_youtube_reports_add_column_licensor.sql436 B2026-07-13 03:27📄DS-2521_CREATE_chartmetric_socials_log.sql652 B2026-07-13 03:27📄DS-2532_DROP_old_tables.sql1.0 KB2026-07-13 03:27📄DS-2543_CREATE_youtube_neo4j_log.sql538 B2026-07-13 03:27📄DS-2556_CREATE_l_label_participant_label_track_participated_as.sql337 B2026-07-13 03:27📄DS-2556_CREATE_l_label_participant_label_track_participated_as_properly.sql370 B2026-07-13 03:27📄DS-2556_GRANT_rights.sql384 B2026-07-13 03:27📄DS-2570_create_cm_url_log_table.sql956 B2026-07-13 03:27📄DS-2570_populate_cm_url_log_table.sql391 B2026-07-13 03:27📄DS-2573_CREATE_spotify_playlist_curators.sql48.3 KB2026-07-13 03:27📄DS-2576_CREATE_top_playlists_share.sql559 B2026-07-13 03:27📄DS-2578-SWAP_placements_tables.sql1.4 KB2026-07-13 03:27📄DS-2578-SWAP_recent_placements_tables.sql858 B2026-07-13 03:27📄DS-2637_CREATE_staging_raw_apple_music_subscription_reference.sql1.0 KB2026-07-13 03:27📄DS-2639_ALTER_sme_labelcopy_ingest_add_prod_no_column.sql221 B2026-07-13 03:27📄DS-2653_CREATE_sme_labelcopy_product_participant.sql1.1 KB2026-07-13 03:27📄DS-2653_CREATE_sme_labelcopy_track_participant.sql1.3 KB2026-07-13 03:27📄DS-2667_CREATE_view_orchard_labelcopy_product_artist.sql843 B2026-07-13 03:27📄DS-2667_CREATE_view_orchard_labelcopy_track_artist.sql1.2 KB2026-07-13 03:27📄DS-2667_replace_view_orchard_labelcopy.sql2.0 KB2026-07-13 03:27📄DS-2668_ALTER_artist_attribution_tables.sql603 B2026-07-13 03:27📄DS-2668_ALTER_CREATE_tables.sql573 B2026-07-13 03:27📄DS-2668_ALTER_tables.sql1.1 KB2026-07-13 03:27📄DS-2704_CREATE_sme_to_orchard_label_mapping.sql575 B2026-07-13 03:27📄DS-2712_UPDATE_staging_raw_apple_music_streams.sql323 B2026-07-13 03:27📄DS-2749_create_view_orchard_labelcopy_product.sql1.4 KB2026-07-13 03:27📄DS-2749_replace_view_orchard_labelcopy.sql1.9 KB2026-07-13 03:27📄DS-2798-create-deezer-staging-raw-sme.sql2.2 KB2026-07-13 03:27📄DS-2837_create_view_orchard_labelcopy_track.sql730 B2026-07-13 03:27📄DS-2838_CREATE_dim_subgenre.sql1.1 KB2026-07-13 03:27📄DS-2839_ALTER_dim_release_add_columns.sql591 B2026-07-13 03:27📄DS-2840_CREATE_replace_view_orchard_labelcopy_product_artist.sql1.7 KB2026-07-13 03:27📄DS-2849-ALTER-STAGING_RAW_DEEZER_V2-ADD-LICENSOR.sql227 B2026-07-13 03:27📄DS-2852-neo-gsr-backfill-gap.sql1.7 KB2026-07-13 03:27📄DS-2852-neo-gsr-to-sf.sql3.2 KB2026-07-13 03:27📄DS-2852_CREATE_GLOBAL_SOUND_RECORDING_2.sql3.4 KB2026-07-13 03:27📄DS-2855_UPDATE_playlist_placements_empty_user_display_name.sql219 B2026-07-13 03:27📄DS-2881_CREATE_sme_participant_data.sql935 B2026-07-13 03:27📄DS-2881_CREATE_staging_sme_product_metadata_v2.sql1.6 KB2026-07-13 03:27📄DS-2881_CREATE_staging_sme_track_participants.sql630 B2026-07-13 03:27📄DS-2886_CREATE_soundcloud_staging_tables.sql1.8 KB2026-07-13 03:27📄DS-2974_CREATE_staging_tiktok_trends_tables.sql1.6 KB2026-07-13 03:27📄DS-2985_create_dim_chart_and_fact_charts.sql1.3 KB2026-07-13 03:27📄DS-3013_CREATE_uma_marketshare_staging_raw_table.sql801 B2026-07-13 03:27📄DS-3023_CREATE_line_staging_raw_tables.sql6.7 KB2026-07-13 03:27📄DS-3023_CREATE_LINE_tables.sql438 B2026-07-13 03:27📄DS-3037_create_fact_socials.sql721 B2026-07-13 03:27📄DS-3039_DROP_fact_socials_artist_id_and_recluster.sql452 B2026-07-13 03:27📄DS-3064-neo-to-global-participant.sql3.1 KB2026-07-13 03:27📄DS-3071_CREATE_GLOBAL_PARTICIPANT_MERGED_TO_GLOBAL_PARTICIPANT.sql2.7 KB2026-07-13 03:27📄DS-3071_CREATE_GLOBAL_PARTICIPANT_MERGED_TO_GLOBAL_PARTICIPANT_2.sql4.3 KB2026-07-13 03:27📄DS-3072_Neo4J-to-SF-Identity.sql3.1 KB2026-07-13 03:27📄DS-3074_CREATE_LABEL_SOUND_RECORDING_2.sql3.1 KB2026-07-13 03:27📄DS-3075_CREATE_LABEL_PARTICIPANT_3.sql2.9 KB2026-07-13 03:27📄DS-3075_CREATE_LABEL_PARTICIPANT_4.sql4.6 KB2026-07-13 03:27📄DS-3075_CREATE_LABEL_PARTICIPANT_5.sql4.2 KB2026-07-13 03:27📄DS-3078-neo-sf-vendor.sql2.6 KB2026-07-13 03:27📄DS-3079-neo-sf-subaccount.sql2.0 KB2026-07-13 03:27📄DS-3081_CREATE_ORCHARD_TRACK_4.sql3.9 KB2026-07-13 03:27📄DS-3081_CREATE_ORCHARD_TRACK_5.sql6.4 KB2026-07-13 03:27📄DS-3081_CREATE_ORCHARD_TRACK_6.sql5.4 KB2026-07-13 03:27📄DS-3081_CREATE_PUBLIC_TRACK_3.sql6.6 KB2026-07-13 03:27📄DS-3085-stream_HAS_PROFILE_neo4j_sf.sql2.4 KB2026-07-13 03:27📄DS-3086_stream_DELETED_HAS_PROFILE_Neo4J_SF.sql2.8 KB2026-07-13 03:27📄DS-3087-ALTER_Vendor_related_tasks.sql8.1 KB2026-07-13 03:27📄DS-3087-STREAM-Profile-HAS_ACCESS_TO-Subaccount.sql2.9 KB2026-07-13 03:27📄DS-3087-STREAM-Profile-HAS_ACCESS_TO-Vendor.sql2.9 KB2026-07-13 03:27📄DS-3087-stream_HAS_ACCESS_TO_neo4j_sf.sql2.5 KB2026-07-13 03:27📄DS-3087_STREAM_Profile-HAS_ACCESS_TO-LabelParticipant.sql3.0 KB2026-07-13 03:27📄DS-3087_STREAM_Profile_HAS_ACCESS_TO_ArtistInfo.sql2.9 KB2026-07-13 03:27📄DS-3088_stream_DELETED_HAS_ACCESS_TO_neo4j_sf.sql2.6 KB2026-07-13 03:27📄DS-3088_STREAM_Profile-DELETED_HAS_ACCESS_TO-ArtistInfo.sql3.1 KB2026-07-13 03:27📄DS-3088_STREAM_Profile-DELETED_HAS_ACCESS_TO-LabelParticipant.sql3.2 KB2026-07-13 03:27📄DS-3088_STREAM_Profile-DELETED_HAS_ACCESS_TO-Subaccount.sql3.1 KB2026-07-13 03:27📄DS-3088_STREAM_Profile-DELETED_HAS_ACCESS_TO-Vendor.sql3.0 KB2026-07-13 03:27📄DS-3089_3089_CREATE_LABEL_PARTICIPANT_PARTICIPATED_IN_ORCHARD_TRACK_3.sql3.2 KB2026-07-13 03:27📄DS-3089_CREATE_LABEL_PARTICIPANT_PARTICIPATED_IN_ORCHARD_TRACK_2.sql3.2 KB2026-07-13 03:27📄DS-3089_CREATE_LABEL_PARTICIPANT_PARTICIPATED_IN_ORCHARD_TRACK_4.sql4.9 KB2026-07-13 03:27📄DS-3089_CREATE_LABEL_PARTICIPANT_PARTICIPATED_IN_ORCHARD_TRACK_6.sql6.2 KB2026-07-13 03:27📄DS-3089_CREATE_PUBLIC_PARTICIPANT_PARTICIPATED_IN_PUBLIC_SOUND_RECORDING_3.sql4.7 KB2026-07-13 03:27📄DS-3090_CREATE_ORCHARD_TRACK_IS_PLACEMENT_OF_LABEL_SOUND_RECORDING.sql3.0 KB2026-07-13 03:27📄DS-3090_CREATE_ORCHARD_TRACK_IS_PLACEMENT_OF_LABEL_SOUND_RECORDING_2.sql4.2 KB2026-07-13 03:27📄DS-3090_CREATE_PUBLIC_TRACK_IS_PLACEMENT_OF_PUBLIC_SOUND_RECORDING_2.sql4.1 KB2026-07-13 03:27📄DS-3092_CREATE_GLOBAL_PARTICIPANT_REPRESENTS_LABEL_PARTICIPANT_1.sql2.9 KB2026-07-13 03:27📄DS-3092_CREATE_GLOBAL_PARTICIPANT_REPRESENTS_LABEL_PARTICIPANT_6.sql2.9 KB2026-07-13 03:27📄DS-3092_CREATE_GLOBAL_PARTICIPANT_REPRESENTS_PUBLIC_PARTICIPANT_1.sql2.9 KB2026-07-13 03:27📄DS-3092_CREATE_GLOBAL_SOUND_RECORDING_REPRESENTS_LABEL_SOUND_RECORDING_1.sql3.1 KB2026-07-13 03:27📄DS-3092_CREATE_GLOBAL_SOUND_RECORDING_REPRESENTS_LABEL_SOUND_RECORDING_2.sql4.4 KB2026-07-13 03:27📄DS-3092_CREATE_GLOBAL_SOUND_RECORDING_REPRESENTS_PUBLIC_SOUND_RECORDING_1.sql3.1 KB2026-07-13 03:27📄DS-3093-neo-sf-owns.sql2.1 KB2026-07-13 03:27📄DS-3108_CREATE_STAGING_SME_SONG_PARTICIPANTS.sql700 B2026-07-13 03:27📄DS-3157_ALTER_chart_sound_recording_and_aggregated_charts.sql581 B2026-07-13 03:27📄DS-3172_ALTER_table_fact_charts_add_column_chartmetric_artist_id.sql187 B2026-07-13 03:27📄DS-3186_alter_table_fact_charts_add_column_position_change.sql175 B2026-07-13 03:27📄DS-3201_staging_raw_amazon_add_new_columns.sql1.2 KB2026-07-13 03:27📄DS-3215_CREATE_apple_music_container_subtype_mapping.sql1.7 KB2026-07-13 03:27📄DS-3235_CREATE_staging_raw_apple_music_summary_streams.sql1.3 KB2026-07-13 03:27📄DS-3235_CREATE_staging_raw_apple_music_summary_streams_2.sql1.3 KB2026-07-13 03:27📄DS-3290_CREATE_staging_raw_apple_music_royalty_container.sql1.1 KB2026-07-13 03:27📄DS-3332_ADD_fact_socials_artist_id_to_fact_socials.sql364 B2026-07-13 03:27📄DS-3332_ALTER_fact_socials_cluster_by_artist_id.sql212 B2026-07-13 03:27📄DS-3335_CREATE_staging_raw_mrc.sql1.1 KB2026-07-13 03:27📄DS-3378_CREATE_GLOBAL_PARTICIPANT.sql4.3 KB2026-07-13 03:27📄DS-3378_CREATE_GLOBAL_PARTICIPANT_2.sql5.2 KB2026-07-13 03:27📄DS-3378_CREATE_GLOBAL_PARTICIPANT_3.sql5.6 KB2026-07-13 03:27📄DS-3383_CREATE_PUBLIC_PARTICIPANT_1.sql6.1 KB2026-07-13 03:27📄DS-3383_CREATE_PUBLIC_SOUND_RECORDING.sql5.4 KB2026-07-13 03:27📄DS-3383_CREATE_PUBLIC_SOUND_RECORDING_2.sql4.9 KB2026-07-13 03:27📄DS-3386_CREATE_soundcloud_staging_tables.sql4.9 KB2026-07-13 03:27📄DS-3387_CREATE_soundcloud_staging_tables.sql5.2 KB2026-07-13 03:27📄DS-3394_ALTER_TABLE_FACT_CHARTS_ADD_NEW_COLUMNS.sql498 B2026-07-13 03:27📄DS-3437-gsheets-stream-from-kafka-to-SF-aandr-artisttracking.sql3.6 KB2026-07-13 03:27📄DS-3437_ALTER_tasks_in_facts_qa.sql388 B2026-07-13 03:27📄DS-3456_CREATE_replace_view_orchard_labelcopy_product_artist.sql2.5 KB2026-07-13 03:27📄DS-3456_CREATE_view_orchard_labelcopy_track_artist.sql1.6 KB2026-07-13 03:27📄DS-3457_ALTER_tasks_in_facts_qa.sql11.5 KB2026-07-13 03:27📄DS-3497_CREATE_staging_raw_spotify_charts.sql655 B2026-07-13 03:27📄DS-3497_CREATE_staging_raw_tiktok.sql996 B2026-07-13 03:27📄DS-3523_ALTER_FACT_CHARTS_ADD_COLUMN_PUBLIC_SOUND_RECORDING_ID_1.sql236 B2026-07-13 03:27📄DS-3536_TRUNCATE_cdc_tables.sql1.3 KB2026-07-13 03:27📄DS-3569_DROP_view_orchard_labelcopy.sql101 B2026-07-13 03:27📄DS-3579_CREATE_task_chartmetric_socials_log.sql633 B2026-07-13 03:27📄DS-3599_CREATE_chartmetric_participants_log.sql557 B2026-07-13 03:27📄DS-3612_CREATE_staging_douyin_trends_tables.sql1.6 KB2026-07-13 03:27📄DS-3641_ALTER_staging_raw_apple.sql524 B2026-07-13 03:27📄DS-3644-alter-QA-task-schedule.sql435 B2026-07-13 03:27📄DS-3694_CREATE_staging_raw_awa.sql3.2 KB2026-07-13 03:27📄DS-3714_staging_raw_amazon_support_new_columns.sql1.3 KB2026-07-13 03:27📄DS-3777_ALTER_amazon_music_staging_raw_tables_add_trackAsin_and_albumAsin.sql1.1 KB2026-07-13 03:27📄DS-3862_ALTER_tasks_in_facts_qa.sql326 B2026-07-13 03:27📄DS-3899_ALTER_facts_charts_add_artist_names_column.sql212 B2026-07-13 03:27📄DS-3901_ALTER_staging_raw_pandora_ADD_platform.sql221 B2026-07-13 03:27📄DS-3949_CREATE_ISRC_TO_LABEL_PARTICIPANT_MAPPING.sql634 B2026-07-13 03:27📄DS-3971_DROP_staging_raw_soundcloud.sql149 B2026-07-13 03:27📄DS-3973-neo4j_to_sf_profile.sql2.9 KB2026-07-13 03:27📄DS-4016_ALTER_fact_youtube_asset_add_column.sql634 B2026-07-13 03:27📄DS-4030-DROP_NEO4J_TO_PUBLISHING_HAS_AGREEMENT_HAS_AGREEMENT_TOPIC_STREAM.sql199 B2026-07-13 03:27📄DS-4061_ALTER_TABLE_fact_charts_add_column_views.sql193 B2026-07-13 03:27📄DS-4178_ALTER_TABLE_dim_claim_ADD_COLUMN_views.sql196 B2026-07-13 03:27📄DS-4225_staging_raw_amazon_add_new_columns.sql672 B2026-07-13 03:27📄DS-4226_ALTER_dim_claim_add_customid_column.sql200 B2026-07-13 03:27📄DS-4226_DROP_dim_claim_old.sql204 B2026-07-13 03:27📄DS-4226_SWAP_dim_claim_tables.sql411 B2026-07-13 03:27📄DS-4298-add-created_at-to-facts-prod-deleted_has_profile.sql246 B2026-07-13 03:27📄DS-4298-Update-MusicGraph-CDC-Tables-in-QA-to-be-same-as-PROD-ones.sql11.1 KB2026-07-13 03:27📄DS-4298-Update-MusicGraph-CDC-Tables-part2.sql11.1 KB2026-07-13 03:27📄DS-4298_Add-created_at-to-MusicGraph-CDC.sql22.0 KB2026-07-13 03:27📄DS-4298_set-correct-grants-on-GLOBAL_SOUND_RECORDING.sql354 B2026-07-13 03:27📄DS-4314_ALTER_TABLE_dim_claim_ADD_COLUMN_views.sql190 B2026-07-13 03:27📄DS-4333_CREATE_STAGING_RAW_VEVO.sql1002 B2026-07-13 03:27📄DS-4334_CREATE_video_asset_mapping.sql850 B2026-07-13 03:27📄DS-4383_Drop_Transient_Tables_From_Charmetric_Socials.sql13.6 KB2026-07-13 03:27📄DS-4453_ALTER_ADD_CHANNEL_OWNER_TO_DIM_YOUTUBE_CHANNEL_NAMES.sql241 B2026-07-13 03:27📄DS-4509_CREATE_metadata_tables_spotify_charts.sql2.7 KB2026-07-13 03:27📄DS-4549-Add-apple_music_id-column-to-facts_prod_label_participant.sql259 B2026-07-13 03:27📄DS-4607-recreate-product-streams-on-correct-cdc-table.sql1.2 KB2026-07-13 03:27📄DS-4607_product_label_remove_cdc_table.sql156 B2026-07-13 03:27📄DS-4620_create_ritmogestion_feed.sql1.5 KB2026-07-13 03:27📄DS-4625_CREATE_staging_raw_spotify_marketshare_week_ending.sql790 B2026-07-13 03:27📄DS-4627_ALTER_FACT_CHARTS_ADD_COLUMNS_PUBLIC_PRODUCT_ID_NUM_TRACKS.sql252 B2026-07-13 03:27📄DS-4665(6)-clean-up-TMP-tables.sql304 B2026-07-13 03:27📄DS-4666-change-streams-on-CDC_MUSICGRAPH_TRACK.sql812 B2026-07-13 03:27📄DS-4669_CREATE_temp_table_missing_apple_music.sql10.0 KB2026-07-13 03:27📄DS-4740-change-streams-cdc-table.sql1.7 KB2026-07-13 03:27📄DS-4740-remove-TMP-table.sql169 B2026-07-13 03:27📄DS-4752_DROP_temp_tables_remaining_line_etl.sql2.0 KB2026-07-13 03:27📄DS-4767-suspend-clean-up-tasks.sql815 B2026-07-13 03:27📄DS-4786_ALTER_dim_label.sql671 B2026-07-13 03:27📄DS-4786_CREATE_dim_brand.sql823 B2026-07-13 03:27📄DS-4786_CREATE_dim_parent_company.sql687 B2026-07-13 03:27📄DS-4786_CREATE_dim_service_tier.sql714 B2026-07-13 03:27📄DS-4794_create_awal_apple_id_mapping_table.sql563 B2026-07-13 03:27📄DS-4843_CREATE_AND_BACKFILL_UPC_TO_LABEL_PARTICIPANT_MAPPING_TABLE.sql1.6 KB2026-07-13 03:27📄DS-4860_ALTER_amazon_music_staging_raw_tables_add_four_new_columns.sql2.8 KB2026-07-13 03:27📄DS-4890_add_clustering_to_apple_music_staging_raw_tables.sql482 B2026-07-13 03:27📄DS-4928_fix_ritmogestion_column_names.sql1.0 KB2026-07-13 03:27📄DS-4974_UPDATE_clean_dim_track.sql228 B2026-07-13 03:27📄DS-4996_CREATE_staging_raw_amazon_music_awal.sql3.7 KB2026-07-13 03:27📄DS-5013_CREATE_staging_raw_beatport.sql922 B2026-07-13 03:27📄DS-5099_ALTER_staging_raw_youtube_claim_add_licensor.sql231 B2026-07-13 03:27📄DS-5198_ALTER_TABLE_apple_music_shazam_daily_events.sql274 B2026-07-13 03:27📄DS-5204_ALTER_staging_raw_itunes_add_column.sql379 B2026-07-13 03:27📄DS-5221_ALTER_staging_raw_amazon_ADD_sumoftotalplaycountforplaylistandtotalplaycountforstation.sql889 B2026-07-13 03:27📄DS-5225_CREATE_LABEL_DOUND_RECORFING_STREAM_ON_TMP_TABLE.sql511 B2026-07-13 03:27📄DS-5226_DROP_temp_cdc_tables.sql391 B2026-07-13 03:27📄DS-5249_create_staging_raw_deezer_awal.sql1.1 KB2026-07-13 03:27📄DS-5266_CREATE_STAGING_RAW_SME_LATAM_WEEKLY_UNIFIED_CHART.sql1.0 KB2026-07-13 03:27📄DS-5289_CREATE_MUSIC_ANALYTICS_IN_REVIEW_ERRORS.sql1.3 KB2026-07-13 03:27📄DS-5289_CREATE_STAGING_RAW_MUSIC_ANALYTICS_IN_REVIEW_TABLE.sql1.3 KB2026-07-13 03:27📄DS-5304-staging_raw_youtube_claim_cluster_by_download_date.sql171 B2026-07-13 03:27📄DS-5306_create_tables_for_youtube_monthly.sql21.7 KB2026-07-13 03:27📄DS-5343-create-topisc-migrate-partitions-TMP.sql5.5 KB2026-07-13 03:27📄DS-5398_CREATE_staging_raw_qq.sql820 B2026-07-13 03:27📄DS-5401_grant_access_to_spotify_audio_features.sql1.1 KB2026-07-13 03:27📄DS-5428_CREATE_staging_raw_kuwo.sql828 B2026-07-13 03:27📄DS-5429_CREATE_staging_raw_kugou.sql832 B2026-07-13 03:27📄DS-5473_CREATE_table_for_moved_products.sql2.3 KB2026-07-13 03:27📄DS-5473_create_temp_table_with_dduplicated_rows.sql1.6 KB2026-07-13 03:27📄DS-5473_DROP_releases_to_move_to_another_label_DS_5473.sql169 B2026-07-13 03:27📄DS-5507_ALTER_ACTIVITY_SPIKE_HISTORY_columns.sql426 B2026-07-13 03:27📄DS-5518_CREATE_temp_table_with_tracks_for_revive.sql5.2 KB2026-07-13 03:27📄DS-5551_create_tables_for_swf_insta_reels.sql657 B2026-07-13 03:27📄DS-5564_ALTER_TABLE_staging_raw_tiktok.sql1.2 KB2026-07-13 03:27📄DS-5729_DROP_temp_deezer_marketshare_tables.sql3.9 KB2026-07-13 03:27📄DS-5783_ALTER_staging_raw_amazon_ADD_columns.sql1.1 KB2026-07-13 03:27📄DS-5794_create_table_staging_raw_youtube_monthly_rawdata_v1_0_dmgi.sql1.5 KB2026-07-13 03:27📄DS-5795_create_tables_for_youtube_monthly.sql2.6 KB2026-07-13 03:27📄DS-5796_CREATE_TABLE_staging_raw_youtube_monthly_adj_claim_summary_v1_1_dmgi.sql434 B2026-07-13 03:27📄DS-5796_CREATE_TABLE_staging_raw_youtube_monthly_adj_claim_summary_v1_1_dmgi_GRANTS.sql907 B2026-07-13 03:27📄DS-5849_create_staging_raw_spotify_fraud.sql823 B2026-07-13 03:27📄DS-5849_create_straging_raw_spotify_artificial_streams.sql952 B2026-07-13 03:27📄DS-5856_CREATE_VIEW_V_STREAMS_BY_PARTICIPANT_TRACK_COUNTRY_FEED_DISTRIBUTOR_DAILY.sql1.2 KB2026-07-13 03:27📄DS-5856_CREATE_VIEW_V_STREAMS_BY_PARTICIPANT_TRACK_FEED_DISTRIBUTOR_DAILY.sql871 B2026-07-13 03:27📄DS-5906-CREATE_TABLE_STAGING_RAW_TIKTOK_FRAUDULENT_USAGE_REPORT.sql1.3 KB2026-07-13 03:27📄DS-6057_add_cluster_by_for_aggregated_skips_and_saves.sql395 B2026-07-13 03:27📄DS-6064_REPLACE_SME_VENDOR_VIEW.sql1.4 KB2026-07-13 03:27📄DS-6069_alter_STAGING_RAW_ITUNES_MARKET_SHARE.sql1.9 KB2026-07-13 03:27📄DS-6111-DROP_fact_analytics_clones.sql177 B2026-07-13 03:27📄DS-6125-ALTER-retention-to-1-on-staging-megaphone-raw.sql178 B2026-07-13 03:27📄DS-6128-ALTER-retention-to-1-on-FACT_YOUTUBE_VIDEO_DEMOGRAPHICS.sql188 B2026-07-13 03:27📄DS-6129-ALTER-retention-to-1-on-DIM_PLAYLIST.sql169 B2026-07-13 03:27📄DS-6133_DROP_tmp_staging_raw_spotify_v2_new_userid.sql142 B2026-07-13 03:27📄DS-6137-ALTER-retention-to-1-on-DIM_USER.sql165 B2026-07-13 03:27📄DS-6138-DROP_STAGING_RAW_SPOTIFY_V2_TMP.sql136 B2026-07-13 03:27📄DS-6139-Drop-FACT_ANALYTICS_V2.sql140 B2026-07-13 03:27📄DS-6150_create_luminate_daily_reports_staging_raw_tables.sql3.7 KB2026-07-13 03:27📄DS-6150_rename_record_date_to_download_date.sql785 B2026-07-13 03:27📄DS-6151_create_luminate_weekly_reports_staging_raw_tables.sql6.5 KB2026-07-13 03:27📄DS-6170_CREATE_sony_apple_id_mapping_without_duplicates.sql775 B2026-07-13 03:27📄DS-6170_CREATE_sony_apple_id_mapping_without_duplicates_2.sql791 B2026-07-13 03:27📄DS-6170_DROP_sony_apple_id_mapping_backup.sql128 B2026-07-13 03:27📄DS-6170_SWAP_sony_apple_id_mapping_without_duplicates.sql310 B2026-07-13 03:27📄DS-6179_CREATE_VIEW_SUMMARY_DEMOGRAPHICS_BY_ISRC_FEED_DISTRIBUTOR.sql3.2 KB2026-07-13 03:27📄DS-6180_CREATE_VIEW_SUMMARY_GEOGRAPHICS_BY_ISRC_FEED_DISTRIBUTOR.sql3.2 KB2026-07-13 03:27📄DS-6180_SUMMARY_GEOGRAPHICS.sql1.3 KB2026-07-13 03:27📄DS-6181_create_V_VIEWS_BY_VIDEO_SOURCE_COUNTRY_FEED_DISTRIBUTOR_DAILY.sql3.4 KB2026-07-13 03:27📄DS-6182_create_V_VIEWS_BY_VIDEO_COUNTRY_FEED_DISTRIBUTOR_DAILY.sql3.6 KB2026-07-13 03:27📄DS-6182_fix_V_VIEWS_BY_VIDEO_COUNTRY_FEED_DISTRIBUTOR_DAILY.sql1.7 KB2026-07-13 03:27📄DS-6204-ALTER-retention-to-15-on-FACT_ANALYTICS.sql172 B2026-07-13 03:27📄DS-6206-add_notification_comment_CAPTURE_RELEASES_STREAM.sql305 B2026-07-13 03:27📄DS-6211_crange_data_retention.sql1.1 KB2026-07-13 03:27📄DS-6211_drop_backfill_tables.sql1018 B2026-07-13 03:27📄DS-6211_drop_backup_tables.sql919 B2026-07-13 03:27📄DS-6211_DROP_facts_shadow.sql112 B2026-07-13 03:27📄DS-6211_DROP_temp_tables.sql41.6 KB2026-07-13 03:27📄DS-6211_drop_unused_tables.sql2.5 KB2026-07-13 03:27📄DS-6211_drop_unused_tables_2.sql1.8 KB2026-07-13 03:27📄DS-6211_drop_unused_tables_3.sql36.9 KB2026-07-13 03:27📄DS-6211_drop_unused_tables_neo4j_2_snowflake.sql1.5 KB2026-07-13 03:27📄DS-6215-Drop-FACTS.PROD.FACT_ANALYTICS_RESTORED-and-FACT_ANALYTICS_RECLUSTER_CLONE.sql218 B2026-07-13 03:27📄DS-6237-add_sme_licensor_to_dim_licensor.sql416 B2026-07-13 03:27📄DS-6237-ALTER_soundcloud_customeranalytics_add_licensor_col.sql2.1 KB2026-07-13 03:27📄DS-6237-ALTER_soundcloud_customerdata_add_licensor_col.sql387 B2026-07-13 03:27📄DS-6237-ALTER_soundcloud_playlistreporting_add_licensor_column.sql675 B2026-07-13 03:27📄DS-6237-ALTER_soundcloud_streamlevelreport_add_licensor_col.sql402 B2026-07-13 03:27📄DS-6237-ALTER_soundcloud_trackinformation_add_licensor_column.sql399 B2026-07-13 03:27📄DS-6237-qa-agg-skips-and-saves.sql187 B2026-07-13 03:27📄DS-6237-update-soundcloud-theorchard-dim-licensor.sql331 B2026-07-13 03:27📄DS-6259-DROP_staging_raw_spotify_sub30.sql153 B2026-07-13 03:27📄DS-6259_DROP_tmp_staging_raw_tables.sql13.5 KB2026-07-13 03:27📄DS-6340_youtube_analytics_tablse.sql2.5 KB2026-07-13 03:27📄DS-6399-Drop-PLAYLISTS_PLACEMENTS_BY_TRACK_PLAYLIST_DISTRIBUTOR_PRIVATE.sql303 B2026-07-13 03:27📄DS-6399-remove_access_to_PLAYLISTS_PLACEMENTS_BY_TRACK_PLAYLIST_DISTRIBUTOR_PRIVATE.sql339 B2026-07-13 03:27📄DS-6417_create_V_SUMMARY_METRICS_BY_ISRC_FEED_DISTRIBUTOR.sql3.1 KB2026-07-13 03:27📄DS-6430_create_V_SUMMARY_DEMOGRAPHICS_BY_ARTIST_FEED_DISTRIBUTOR.sql3.2 KB2026-07-13 03:27📄DS-6431_create_v_summary_geographics_by_artist_feed_distributor.sql3.2 KB2026-07-13 03:27📄DS-6432_create_V_SUMMARY_SOS_BY_FEED_DISTRIBUTOR.sql3.1 KB2026-07-13 03:27📄DS-6497_add_owner_was_changed_column.sql967 B2026-07-13 03:27📄DS-6535_CREATE_STAGING_RAW_YOUTUBE_CLAIM_SME.sql1.8 KB2026-07-13 03:27📄DS-6570_CREATE_QA_sme_analytics_tables.sql2.4 KB2026-07-13 03:27📄DS-6674_ALTER_staging_raw_vevo_add_column_licensor.sql298 B2026-07-13 03:27📄DS-6804-create-deezer-staging-raw-theorchard-v3.sql11.8 KB2026-07-13 03:27📄DS-6838_ALTER_staging_raw_youtube_claim_add_is_shorts_eligible.sql261 B2026-07-13 03:27📄DS-6873_clean_up_fuga_backfill_tables.sql1.3 KB2026-07-13 03:27📄DS-6959_CREATE_TABLES_AWA_SMEJ.sql2.3 KB2026-07-13 03:27📄DS-6960_ALTER_TABLES_staging_raw_line_ADD_licensor.sql1.4 KB2026-07-13 03:27📄DS-7060_CREATE_TABLE_staging_raw_youtube_weekly_rawdata_v1_0_altafonte.sql1.0 KB2026-07-13 03:27📄DS-7103-update-deezer-v3-combined-views.sql3.8 KB2026-07-13 03:27📄DS-7137-ALTER-TABLE-staging_raw_youtube_monthly_claim_raw_v1_1-ADD-COLUMN.sql188 B2026-07-13 03:27📄DS-7137-CREATE-TABLE-staging_raw_youtube_monthly_claim_raw_v1_1.sql1.3 KB2026-07-13 03:27📄DS-7163-spotify-artificial-streams-add-column.sql295 B2026-07-13 03:27📄DS-7167_uuid_columnto_fact_charts.sql271 B2026-07-13 03:27📄DS-7320-create-membran-staging-raw.sql1.8 KB2026-07-13 03:27📄DS-7325_ALTER_staging_raw_spotify_market_share.sql273 B2026-07-13 03:27📄DS-7387_DROP_fact_socials_backup.sql144 B2026-07-13 03:27📄DS-7387_swap_fact_socials_with_fact_socials_without_dups_for_spotify.sql313 B2026-07-13 03:27📄DS-7412-create_snapchat_raw_tables.sql943 B2026-07-13 03:27📄DS-7425-create_dim_physical_warehouse.sql540 B2026-07-13 03:27📄DS-7440_add_columns_to_spotify_streams.sql389 B2026-07-13 03:27📄DS-7442_CREATE_cdc_musicgraph_participant_identifier.sql858 B2026-07-13 03:27📄DS-7548_ALTER_staging_sme_product_metadata_v2_add_column.sql259 B2026-07-13 03:27📄DS-7586_CREATE_l_cm_track_cm_artist_snapshot.sql533 B2026-07-13 03:27📄DS-7586_DROP_l_cm_track_cm_artist_snapshot.sql149 B2026-07-13 03:27📄DS-7931_change_MERGE_INTO_DIM_ISRC_task.sql3.2 KB2026-07-13 03:27📄DS-7999-create-tables.sql1.0 KB2026-07-13 03:27📄DS-8026_CREATE_sony_apple_id_mapping_derived.sql599 B2026-07-13 03:27📄DS-8045-QA-create-tables-for-altafonte-singlestore.sql3.8 KB2026-07-13 03:27📄DS-8066_ALTER_staging_raw_youtube_claim.sql176 B2026-07-13 03:27📄DS-8141_suspend_tasks_before_backfill.sql397 B2026-07-13 03:27📄DS-8145_add_staging_raw_deezer_v4.sql1.1 KB2026-07-13 03:27📄DS-8148_add_staging_raw_awa_trends.sql1.8 KB2026-07-13 03:27📄DS-8203_CREATE_altafonte_apple_id_mapping_derived.sql621 B2026-07-13 03:27📄DS-8258-create-auditing-for-spotify.sql15.6 KB2026-07-13 03:27📄DS-8265_swap_fact_socials_with_fact_socials_without_dups_for_deezer.sql313 B2026-07-13 03:27📄DS-8292_clean_up_backfill_tables.sql1.8 KB2026-07-13 03:27📄DS-8310_swap_fact_socials_with_fact_socials_without_dups.sql313 B2026-07-13 03:27📄DS-8311_DROP_fact_socials_backup.sql144 B2026-07-13 03:27📄DS-8339_add_distributor_column_to_sme_latam.sql278 B2026-07-13 03:27📄DS-8361-CREATE_TABLE_ALTAFONTE_SINGLESTORE_INFORMES.sql761 B2026-07-13 03:27📄DS-8361-CREATE_TABLE_ALTAFONTE_SINGLESTORE_INFORMES_ADD_MISSING_FILEDS.sql882 B2026-07-13 03:27📄DS-8456-ALTER-staging_raw_deezer_v3_activity_metrics.sql294 B2026-07-13 03:27📄DS-8456-ALTER-staging_raw_deezer_v3_playist_source.sql535 B2026-07-13 03:27📄DS-8698_staging_raw_tables.sql2.3 KB2026-07-13 03:27📄DS-8746-ALTER_staging_raw_amazon_unlimited_market_share.sql630 B2026-07-13 03:27📄DS-8856-create_staging_raw_netease.sql792 B2026-07-13 03:27📄DS-8858_create_netease_feed.sql234 B2026-07-13 03:27📄DS-8909_CREATE_sme_mapping_view.sql1.0 KB2026-07-13 03:27📄DS-8935_ALTER_apple_music_tables_add_container_type_column.sql728 B2026-07-13 03:27📄DS-8990_delete_qa_spotify_marquee_tables.sql211 B2026-07-13 03:27📄DS-9109-create-tadas-tables.sql1.3 KB2026-07-13 03:27📄DS-9139_rebuild_dim_track_clean_mv_new_logic.sql2.5 KB2026-07-13 03:27📄DS-9200_ALTER_staging_raw_youtube_video_report_add_engaged_views_column.sql256 B2026-07-13 03:27📄DS-9201_ALTER_staging_raw_youtube_asset_report_add_engaged_views_column.sql715 B2026-07-13 03:27📄DS-9202_ALTER_staging_raw_youtube_claim_add_engaged_views_column.sql373 B2026-07-13 03:27📄DS-9202_ALTER_staging_raw_youtube_claim_sme_add_engaged_views_column.sql385 B2026-07-13 03:27📄DS-9203_ALTER_staging_raw_youtube_asset_conflict_add_engaged_views_column.sql720 B2026-07-13 03:27📄DS-9245_CREATE_staging_raw_spotify_market_share.sql2.4 KB2026-07-13 03:27📄DS-9403_drop_temp_tables_prod.sql37.2 KB2026-07-13 03:27📄DS-9403_drop_temp_tables_qa.sql9.2 KB2026-07-13 03:27📄DS-9514-add-new-tadas-model.sql375 B2026-07-13 03:27📄DS-9762_Spotify_Apple_Amazon_Jan_May_2025_backfill_cleanup.sql1.2 KB2026-07-13 03:27📄DS-9811_CREATE_TIKTOK_WEEKLY_VIEWS_FOR_COLLABJAM25.sql1.0 KB2026-07-13 03:27📄DS-9922-drop-new-music-friday-playlists.sql321 B2026-07-13 03:27📄DS_1548_CREATE_cache_stats_by_queryid.sql869 B2026-07-13 03:27📄DS_9139_CREATE_QA_STREAMS.sql345 B2026-07-13 03:27📄DS_9139_disable_qa_dim_refresh.sql175 B2026-07-13 03:27📄FO-159_ALTER_staging_raw_youtube_claim.sql305 B2026-07-13 03:27📄FO-166_ALTER_staging_raw_pandora.sql218 B2026-07-13 03:27📄FO-268_CREATE_spotify_orch_sony_user_mapping.sql554 B2026-07-13 03:27📄FO-287_ALTER_staging_raw_youtube_claim.sql287 B2026-07-13 03:27📄FR-112-ALTER_dim_country_add_iso3166a3_column.sql370 B2026-07-13 03:27📄FR-112-ALTER_staging_dim_country_add_iso3166a3_column.sql224 B2026-07-13 03:27📄FS-145_DROP_event_marketing_pipe_and_table.sql746 B2026-07-13 03:27📄FS-5464-promote_dev_tadas_model.sql367 B2026-07-13 03:27📄FS-7279_promote_aws_yt_tadas_shadow_model.sql606 B2026-07-13 03:27📄GO-1105-ALTER_dim_release_add_delivered_version_column.sql405 B2026-07-13 03:27📄GO-1105-ALTER_dim_release_add_delivered_version_column_to_staging_dim_release.sql239 B2026-07-13 03:27📄GO-1347-event-social-media-to-snowflake-fix.sql3.3 KB2026-07-13 03:27📄GO-1347-event-social-media-to-snowflake.sql2.7 KB2026-07-13 03:27📄GO-367_CREATE_activity_spike_history.sql756 B2026-07-13 03:27📄GO-367_CREATE_spike_detection_tables.sql756 B2026-07-13 03:27📄GO-467_ALTER_PLACEMENTS_METADATA.sql198 B2026-07-13 03:27📄GO-467_ALTER_PLACEMENTS_METADATA_V2.sql204 B2026-07-13 03:27📄GO-528-ALTER_PLACEMENTS_METADATA_V2.sql225 B2026-07-13 03:27📄GO-528_ALTER_PLACEMENTS_METADATA.sql219 B2026-07-13 03:27📄GO-529_ALTER_PLACEMENTS_METADATA.sql201 B2026-07-13 03:27📄GO-529_ALTER_PLACEMENTS_METADATA_V2.sql207 B2026-07-13 03:27📄IN-10060_disable_recluster.sql1009 B2026-07-13 03:27📄IN-10738_1_ALTER_TABLE_add_column.sql289 B2026-07-13 03:27📄IN-10833_drop_dim_label_cdc.sql410 B2026-07-13 03:27📄IN-10833_drop_old_tables_and_tasks.sql1.8 KB2026-07-13 03:27📄IN-10833_rebuild_view_dim_brand.sql859 B2026-07-13 03:27📄IN-10833_rebuild_view_dim_parent_company.sql673 B2026-07-13 03:27📄IN-10833_rebuild_view_dim_service_tier.sql714 B2026-07-13 03:27📄IN-109099_copy_views_to_qa.sql736 B2026-07-13 03:27📄IN-10958_create_view_V_STREAMS_BY_PARTICIPANT_TRACK_PLAYLIST_COUNTRY_FEED_DISTRIBUTOR_DAILY.sql3.3 KB2026-07-13 03:27📄IN-10958_create_view_v_streams_by_track_playlist_country_feed_distributor_daily.sql1.8 KB2026-07-13 03:27📄IN-10960_create_view_V_STREAMS_BY_TRACK_COUNTRY_FEED_DISTRIBUTOR_DAILY.sql3.0 KB2026-07-13 03:27📄IN-10961_create_view_V_STREAMS_BY_TRACK_FEED_DISTRIBUTOR_DAILY.sql2.8 KB2026-07-13 03:27📄IN-10980_create_view_V_STREAMS_BY_PRODUCT_TRACK_COUNTRY_FEED_DISTRIBUTOR_DAILY.sql3.1 KB2026-07-13 03:27📄IN-10980_fix_create_view_V_STREAMS_BY_PRODUCT_TRACK_COUNTRY_FEED_DISTRIBUTOR_DAILY.sql1.4 KB2026-07-13 03:27📄IN-10981_create_view_V_STREAMS_BY_PRODUCT_TRACK_FEED_DISTRIBUTOR_DAILY.sql3.0 KB2026-07-13 03:27📄IN-10995_CREATE_VIEW_V_STREAMS_BY_PARTICIPANT_TRACK_FEED_DISTRIBUTOR_DAILY.sql1.2 KB2026-07-13 03:27📄IN-11040_CREATE_PLAYLISTS_PLACEMENTS_BY_TRACK_PLAYLIST_TABLES.sql1.2 KB2026-07-13 03:27📄IN-11116_ALTER_sme_to_orchard_label_mapping.sql262 B2026-07-13 03:27📄IN-11186-11188-11190-delete-fact_analytics-sme-deezer-pandora-rapsody.sql495 B2026-07-13 03:27📄IN-11186-insert-into-fact-analytics-for-deezer.sql1.4 KB2026-07-13 03:27📄IN-11188-insert-into-fact-analytics-for-pandora.sql1.4 KB2026-07-13 03:27📄IN-11190-insert-into-fact-analytics-for-rhapsody.sql1.4 KB2026-07-13 03:27📄IN-11203_DROP_temp_fact_analytics.sql151 B2026-07-13 03:27📄IN-11297_create_view_V_STREAMS_COMPLETIONS_BY_TRACK_PLAYLIST_COUNTRY_FEED_DISTRIBUTOR_DAILY.sql3.3 KB2026-07-13 03:27📄IN-11297_create_view_V_STREAMS_DEMOGRAPHICS_BY_TRACK_COUNTRY_FEED_DISTRIBUTOR_DAILY.sql4.3 KB2026-07-13 03:27📄IN-11451_include_youtube_columns_to_v_views.sql7.8 KB2026-07-13 03:27📄IN-11451_QA_include_youtube_columns.sql2.0 KB2026-07-13 03:27📄IN-11566_add_sos_columns_to_V_views.sql9.1 KB2026-07-13 03:27📄IN-11602_rebuild_V_STREAMS_DEMOGRAPHICS.sql2.4 KB2026-07-13 03:27📄IN-11835_create_views_V_STREAMS_BY_ACCOUNT.sql2.8 KB2026-07-13 03:27📄IN-12748_create_tables_for_upper_profit_center.sql4.2 KB2026-07-13 03:27📄IN-12748_update_upper_profit_center_mapping.sql520 B2026-07-13 03:27📄IN-13100_create_v_views_by_account_country_distributor_daily.sql1.1 KB2026-07-13 03:27📄IN-13326_views_for_views_by_account_video.sql6.4 KB2026-07-13 03:27📄IN-13333_create_V_VIEWS_BY_VIDEO_SOURCE_FEED_DISTRIBUTOR_DAILY.sql3.2 KB2026-07-13 03:27📄IN-13786-primary-playlist-type-table.sql3.3 KB2026-07-13 03:27📄IN-14007_add_grants_to_tables_retaining_activity_feed_data.sql515 B2026-07-13 03:27📄IN-14007_create_tables_retaining_activity_feed_data.sql2.2 KB2026-07-13 03:27📄IN-14007_re-create_tables_retaining_activity_feed_data.sql981 B2026-07-13 03:27📄IN-14062_create_mappings_video_to_tracks_aggregated.sql3.7 KB2026-07-13 03:27📄IN-14062_create_view_V_STREAMS_DEMOGRAPHICS_BY_TRACK_COUNTRY_FEED_DISTRIBUTOR_ROLLUP.sql2.3 KB2026-07-13 03:27📄IN-14062_create_view_V_STREAMS_ENRICHED_WITH_TIKTOK_BY_TRACK_COUNTRY_FEED_DISTRIBUTOR_PRODFAM_DAILY.sql3.5 KB2026-07-13 03:27📄IN-14221_create_view_V_METRICS_BY_MULTI_PRODUCT_COUNTRY_FEED_DISTRIBUTOR_ROLLUP.sql1.6 KB2026-07-13 03:27📄IN-14221_create_view_V_METRICS_BY_TRACK_COUNTRY_FEED_DISTRIBUTOR_PRODFAM_ROLLUP.sql4.5 KB2026-07-13 03:27📄IN-14221_create_view_V_METRICS_BY_TRACK_COUNTRY_FEED_DISTRIBUTOR_ROLLUP.sql3.8 KB2026-07-13 03:27📄IN-14221_create_view_V_METRICS_BY_TRACK_PARTICIPANT_COUNTRY_FEED_DISTRIBUTOR_PRODFAM_ROLLUP.sql3.8 KB2026-07-13 03:27📄IN-14221_create_view_V_METRICS_BY_TRACK_PARTICIPANT_COUNTRY_FEED_DISTRIBUTOR_ROLLUP.sql3.7 KB2026-07-13 03:27📄IN-14221_create_view_V_METRICS_UGC_BY_VIDEO_ASSET_COUNTRY_FEED_DISTRIBUTOR_ROLLUP.sql1.6 KB2026-07-13 03:27📄IN-14221_create_view_V_METRICS_UGC_BY_VIDEO_ASSET_FEED_DISTRIBUTOR_ROLLUP.sql1.5 KB2026-07-13 03:27📄IN-14221_create_view_V_STREAMS_BY_TRACK_COUNTRY_FEED_DISTRIBUTOR_PRODFAM_ROLLUP.sql2.6 KB2026-07-13 03:27📄IN-14221_create_view_V_STREAMS_BY_TRACK_COUNTRY_FEED_DISTRIBUTOR_ROLLUP.sql2.5 KB2026-07-13 03:27📄IN-14221_create_view_V_STREAMS_COMPLETIONS_BY_TRACK_PLAYLIST_COUNTRY_FEED_DISTRIBUTOR_ROLLUP.sql1.7 KB2026-07-13 03:27📄IN-14221_create_view_V_STREAMS_ENRICHED_WITH_TIKTOK_BY_TRACK_COUNTRY_DISTRIBUTOR_ROLLUP.sql1.9 KB2026-07-13 03:27📄IN-14221_create_view_V_STREAMS_ENRICHED_WITH_TIKTOK_BY_TRACK_COUNTRY_FEED_DISTRIBUTOR_DAILY.sql1.5 KB2026-07-13 03:27📄IN-14670_create_qa_views.sql4.2 KB2026-07-13 03:27📄IN-14670_re-create_views.sql4.2 KB2026-07-13 03:27📄IN-14705_decouple_gsr_lsr_enrichment_from_dbt_and_use_a_task.sql1.2 KB2026-07-13 03:27📄IN-14705_enable_streams_on_gsr_represents_lsr.sql724 B2026-07-13 03:27📄IN-15203-promote_dev_tadas_model.sql290 B2026-07-13 03:27📄IN-15203-promote_prod_tadas3_model.sql297 B2026-07-13 03:27📄IN-15203-promote_tadas30_model.sql502 B2026-07-13 03:27📄IN-15245_charts_by_isrc_and_platforms.sql5.5 KB2026-07-13 03:27📄IN-15245_charts_ranking.sql2.4 KB2026-07-13 03:27📄IN-15343-add_offer_type_to_dim_tracks.sql402 B2026-07-13 03:27📄IN-15389-add_slug_to_dim_chart.sql189 B2026-07-13 03:27📄IN-15420_optimise_spotify_daily_charts.sql6.1 KB2026-07-13 03:27📄IN-15449_delete_spotify_charts_dynamic_tables.sql256 B2026-07-13 03:27📄IN-15683-add_store_specific_id_to_dim_chart.sql215 B2026-07-13 03:27📄IN-15683_DELETE_BAD_NMF_FACT_CHARTS.sql281 B2026-07-13 03:27📄IN-15701_create_dbt_feature_flags.sql832 B2026-07-13 03:27📄IN-15717_create_priority_playlists.sql21.7 KB2026-07-13 03:27📄IN-16023_add_nmf_columns.sql1.5 KB2026-07-13 03:27📄IN-16226_create_table_MEDIUM_PRIORITY_PLAYLISTS.sql63.3 KB2026-07-13 03:27📄IN-16227_source_of_truth_table_for_hourly_playlists.sql128.3 KB2026-07-13 03:27📄IN-16295_create_playlist_filter_override_table.sql1.3 KB2026-07-13 03:27📄IN-16428_promote_no_aws_tadas_model.sql386 B2026-07-13 03:27📄IN-16506_CREATE_TABLE_profile_playlist_visits.sql2.2 KB2026-07-13 03:27📄IN-16779_add_classify_playlist_owner_fn.sql63.5 KB2026-07-13 03:27📄IN-16779_add_owner_column_on_PRIORITY_PLAYLIST_METADATA.sql255 B2026-07-13 03:27📄IN-16817_recluster_priority_metadata_and_isrc_playlist_public.sql504 B2026-07-13 03:27📄IN-16817_recluster_priority_placements_by_playlist_public.sql482 B2026-07-13 03:27📄IN-16817_review_clustering_on_priority_and_hourly_tables.sql483 B2026-07-13 03:27📄IN-16936_create_playlist_curator_owner_overrides.sql21.9 KB2026-07-13 03:27📄IN-16951_create_table_sony_owned_playlists.sql1.6 KB2026-07-13 03:27📄IN-16964_CREATE_playlist_catalog_tracks_check.sql7.1 KB2026-07-13 03:27📄IN-16964_CREATE_playlist_metadata_check.sql4.9 KB2026-07-13 03:27📄IN-16964_CREATE_playlist_track_count_check.sql19.0 KB2026-07-13 03:27📄IN-17067_youtube_track_missing_isrc.sql645 B2026-07-13 03:27📄IN-17086-2-add_curator_to_curator_override.sql464 B2026-07-13 03:27📄IN-17086-3-add_curator_to_curator_override.sql4.5 KB2026-07-13 03:27📄IN-17086-add_curator_to_curator_override.sql408 B2026-07-13 03:27📄IN-17148_fix_fact_charts_upc_NLUM71200154.sql299 B2026-07-13 03:27📄IN-17222_promote_no_aws_no_yt_tadas_model.sql428 B2026-07-13 03:27📄IN-17238_curator_owner_overrides_audit_and_sis.sql7.4 KB2026-07-13 03:27📄IN-17239-add_curator_to_curator_override.sql480 B2026-07-13 03:27📄IN-17281_add_source_to_hourly_playlists.sql482 B2026-07-13 03:27📄IN-17357_add_playlist_curator_override.sql455 B2026-07-13 03:27📄IN-17358_recreate_profile_playlist_visits.sql2.3 KB2026-07-13 03:27📄IN-9667-alter-dim_algorithmic_playlists.sql1.2 KB2026-07-13 03:27📄IN-9944_create_vendor_company_brand_parent_company_view.sql1.2 KB2026-07-13 03:27📄KDH-145_Sync_Identity_localization_from_neo_to_sf.sql212 B2026-07-13 03:27📄KDH-159_ADD_vendor_ids_to_label_participant.sql1.7 KB2026-07-13 03:27📄KDH-169_alter_company_brand_add_company_brand_id.sql135 B2026-07-13 03:27📄KDH-257_DROP_nr_graph_tables.sql1.2 KB2026-07-13 03:27📄KDH-29_ALTER_Label_participant_with_not_null.sql1008 B2026-07-13 03:27📄KDH-29_alter_LP_PARTICIPATED_IN_PRODUCT_add_uuid.sql298 B2026-07-13 03:27📄KDH-307_add_columns_identity.sql402 B2026-07-13 03:27📄KDH-340_alter_ISRC_TO_LABEL_PARTICIPANT_MAPPING.sql554 B2026-07-13 03:27📄KDH-358_DROP_MUSICGRAPTH_NR_TASKS.sql7.8 KB2026-07-13 03:27📄KDH-363_create_cdc_tables.sql31.5 KB2026-07-13 03:27📄KDH-363_drop_temporary_tables.sql3.5 KB2026-07-13 03:27📄KDH-363_recreate_stale_streams.sql3.0 KB2026-07-13 03:27📄KDH-363_recreate_v5_streams.sql31.5 KB2026-07-13 03:27📄KDH-366-truncate-tables-v5tov4.sql795 B2026-07-13 03:27📄KDH-625-delete-non-existing-publishing.sql9.2 KB2026-07-13 03:27📄KDH-667-refresh-qa-COLLABORATOR_SPLIT_DATA.sql1.1 KB2026-07-13 03:27📄KDH-724_CLUSTER_has_fingerprint_rule_tables.sql1.4 KB2026-07-13 03:27📄KDH-730_create_has_fingerprint_rule_s3_copy.sql1.3 KB2026-07-13 03:27📄KDH-94_ADD_referential_uuids_label_participant.sql619 B2026-07-13 03:27📄KDH-CREATE_SPOTIFY_ARTIST_LABEL_PARTICIPANT_AI_MATCHING.sql706 B2026-07-13 03:27📄KDH-music_graph_v5_task_target_tables.sql200.6 KB2026-07-13 03:27📄KDH_drop_old_neo4j_sync_tasks.sql27.1 KB2026-07-13 03:27📄KDH_UNDROP_CDC_TABLES.sql363 B2026-07-13 03:27📄KHD-29_add_label_participant_uuid_to_global_participant_represents_label_participant_table.sql1.3 KB2026-07-13 03:27📄MAINT-apollo-playlist-authors_CREATE_sony_playlist_owners.sql3.8 KB2026-07-13 03:27📄MAINT-XXXX_CLONE_APOLLO_PLAYLISTS_BOOTSTRAP.sql495 B2026-07-13 03:27📄MAINT_remove_decomissioned_task.sql280 B2026-07-13 03:27📄MAR-100_CREATE_staging_raw_feature_fm_facebook_spend.sql1.9 KB2026-07-13 03:27📄MAR-123_CREATE_DIM_AD_PLATFORM.sql878 B2026-07-13 03:27📄MAR-128_CREATE_fact_ad_spend_error.sql2.0 KB2026-07-13 03:27📄MAR-185_ALTER_TABLE_fact_ad_spend_ADD_is_monthly.sql513 B2026-07-13 03:27📄MAR-185_create_fact_ad_spend_monthly.sql2.0 KB2026-07-13 03:27📄MAR-99_CREATE_fact_ad_campaign_spend.sql2.0 KB2026-07-13 03:27📄MOV-3020_ALTER-staging_raw_fandango_now.sql428 B2026-07-13 03:27📄MR-2625_CREATE_fact_conflict_revised.sql709 B2026-07-13 03:27📄MR-2625_CREATE_fact_conflict_youtube.sql525 B2026-07-13 03:27📄MR-2626_COPY_INTO_fact_conflict.sql640 B2026-07-13 03:27📄MR-2626_COPY_INTO_fact_conflict_youtube.sql672 B2026-07-13 03:27📄MR-2767_COPY_INTO_fact_conflict_youtube_reload.sql711 B2026-07-13 03:27📄MR-2811_ALTER_fact_conflict.sql224 B2026-07-13 03:27📄MR-2818_ALTER_fact_conflict_youtube.sql256 B2026-07-13 03:27📄MR-2846_DROP_fact_conflict_youtube.sql612 B2026-07-13 03:27📄MR-2847_ALTER_fact_conflict_with_yt_recent_daily_average_column.sql954 B2026-07-13 03:27📄MR-2984_CREATE_VIEW_MR_ACTIVE_FLATTENED.sql450 B2026-07-13 03:27📄MR-3367_CREATE_registry_locked.sql624 B2026-07-13 03:27📄MR-4101_CREATE_mr_audit.sql456 B2026-07-13 03:27📄MR-4101_CREATE_registry_audit.sql1.3 KB2026-07-13 03:27📄MR-4298_ALTER_fact_conflict_add_es_indexed.sql236 B2026-07-13 03:27📄MR-4387_create_soundexchange_overlap_table.sql1.2 KB2026-07-13 03:27📄MR-4388_CREATE_soundexchange_reconfirmation.sql1.2 KB2026-07-13 03:27📄NEO4j_V5_MIGRATION_SUSPEND_v4_TASKS.sql4.7 KB2026-07-13 03:27📄NO_TICKET-alter-fact_analytics_error-sync-structure-with-fact_analytics.sql395 B2026-07-13 03:27📄NOTICKET-grant_qa_split_mirror_execute_permissions.sql249 B2026-07-13 03:27📄NOTICKET_DROP_temp_mr_table.sql280 B2026-07-13 03:27📄NR-1034_drop_nr_table_stream_task.sql998 B2026-07-13 03:27📄NR-1042_create_view_all_contributor_types.sql991 B2026-07-13 03:27📄NR-1761_create_view_NR_OWNERSHIP_RULES.sql1.8 KB2026-07-13 03:27📄NR-1842_create_nr_sound_recording_type_view.sql1.2 KB2026-07-13 03:27📄NR-1886_create_nr_contributor_type_view.sql1.1 KB2026-07-13 03:27📄NR-1889_create_nr_participant_type_view.sql999 B2026-07-13 03:27📄NR-1925_drop_participants_sound_recordings.sql451 B2026-07-13 03:27📄NR-1925_drop_unused_tables.sql1.0 KB2026-07-13 03:27📄NR-933_create_view_NR_CONTRIBUTION_TYPE.sql828 B2026-07-13 03:27📄PHYS-4188_ALTER_DIM_SUBACCOUNT.sql394 B2026-07-13 03:27📄PLAFORM-2852_STREAM_Profile-DELETED_HAS_ACCESS_TO-ArtistInfo-fix.sql2.7 KB2026-07-13 03:27📄PLAT-2000_create_staging_raw_amazon_instant_video_temp.sql2.8 KB2026-07-13 03:27📄PLAT-2002_create_dim_zip_temp.sql1.2 KB2026-07-13 03:27📄PLAT-2002_create_staging_raw_itunes_temp.sql2.9 KB2026-07-13 03:27📄PLAT-2004_create_staging_raw_ams_temp.sql2.7 KB2026-07-13 03:27📄PLAT-2006_CREATE_staging_raw_youtube_monthly_v2.sql1.7 KB2026-07-13 03:27📄PLAT-2007_CREATE_dim_track_clean.sql1.1 KB2026-07-13 03:27📄PLAT-2007_SWAP_staging_raw_youtubevod.sql2.2 KB2026-07-13 03:27📄PLAT-2008_create_staging_raw_playstation_video_temp.sql2.1 KB2026-07-13 03:27📄PLAT-2134-CREATE_dim_tables_and_staging_dim_tables.sql16.2 KB2026-07-13 03:27📄PLAT-2143_CREATE_dim_catalog.sql793 B2026-07-13 03:27📄PLAT-2143_CREATE_staging_dim_tables.sql1.3 KB2026-07-13 03:27📄PLAT-2143_CREATE_tables.sql2.9 KB2026-07-13 03:27📄PLAT-2294_create_staging_raw_juke_temp.sql2.7 KB2026-07-13 03:27📄PLAT-2296_create_staging_raw_xbox_temp.sql3.2 KB2026-07-13 03:27📄PLAT-2450_CREATE_staging_raw_pandora.sql1.3 KB2026-07-13 03:27📄PLAT-2450_SWAP_staging_raw_pandora.sql2.7 KB2026-07-13 03:27📄PLAT-2476_SWAP_staging_raw_rhapsody.sql1.6 KB2026-07-13 03:27📄PLAT-2519_SWAP_staging_raw_google.sql3.4 KB2026-07-13 03:27📄PLAT-2520_ALTER_fact_demographics_add_territory_code_and_region_code.sql413 B2026-07-13 03:27📄PLAT-2521_CREATE_demographics_region_mapping_table.sql645 B2026-07-13 03:27📄PLAT-2541_SWAP_staging_raw_googleplay.sql5.0 KB2026-07-13 03:27📄PLAT-2542_SWAP_staging_raw_amazon_v2.sql2.7 KB2026-07-13 03:27📄PLAT-2543_SWAP_staging_raw_spotify.sql6.9 KB2026-07-13 03:27📄PLAT-2544_CREATE_fact_sales_error.sql1.9 KB2026-07-13 03:27📄PLAT-2545_SWAP_staging_raw_youtubeclaim.sql4.2 KB2026-07-13 03:27📄PLAT-2545_SWAP_staging_raw_youtubeweekly.sql2.4 KB2026-07-13 03:27📄PLAT-2546_SWAP_staging_raw_youtube_asset_report.sql3.3 KB2026-07-13 03:27📄PLAT-2565_ALTER_dim_country_fix_data_type.sql1.1 KB2026-07-13 03:27📄PLAT_2450_CREATE_shadow_staging_raw_pandora.sql1.1 KB2026-07-13 03:27📄PLATFORM-2000_CREATE_social_spike_stats.sql645 B2026-07-13 03:27📄PLATFORM-2692_STREAM_Profile-DELETED_HAS_ADMIN_ACCESS_TO-Subaccount.sql3.0 KB2026-07-13 03:27📄PLATFORM-2692_STREAM_Profile-DELETED_HAS_ADMIN_ACCESS_TO_Vendor.sql2.9 KB2026-07-13 03:27📄PLATFORM-2692_STREAM_Profile-HAS_ADMIN_ACCESS_TO-Vendor.sql2.8 KB2026-07-13 03:27📄PLATFORM-2692_STREAM_Profile-HAS_ADMIN_ACCESS_TO_Subaccount.sql2.9 KB2026-07-13 03:27📄PLATFORM-2842-Identity_stream_add_user_types.sql2.7 KB2026-07-13 03:27📄PLATFORM-2852-STREAM-Profile-HAS_ACCESS_TO.createdAt-Subaccount.sql2.9 KB2026-07-13 03:27📄PLATFORM-2852-STREAM-Profile-HAS_ACCESS_TO.createdAt-Vendor.sql2.8 KB2026-07-13 03:27📄PLATFORM-2852-stream_Identity_HAS_PROFILEcreateAt_Profile.sql1.9 KB2026-07-13 03:27📄PLATFORM-2852_Identity_createdAt_from_neo_to_sf.sql2.8 KB2026-07-13 03:27📄PLATFORM-2852_STREAM_Profile-DELETED_HAS_ACCESS_TO-LabelParticipant-fix.sql2.8 KB2026-07-13 03:27📄PLATFORM-2852_STREAM_Profile-DELETED_HAS_ACCESS_TO-Subaccount-fix.sql2.6 KB2026-07-13 03:27📄PLATFORM-2852_STREAM_Profile-DELETED_HAS_ACCESS_TO-Vendor-fix.sql2.6 KB2026-07-13 03:27📄PLATFORM-2852_STREAM_Profile-DELETED_HAS_ADMIN_ACCESS_TO-Subaccount-fix.sql2.6 KB2026-07-13 03:27📄PLATFORM-2852_STREAM_Profile-HAS_ACCESS_TO.createdAt-LabelParticipant.sql3.0 KB2026-07-13 03:27📄PLATFORM-2852_STREAM_Profile-HAS_ADMIN_ACCESS_TO.createdAt-Vendor.sql2.7 KB2026-07-13 03:27📄PLATFORM-2852_STREAM_Profile-HAS_ADMIN_ACCESS_TO.createdAt_Subaccount.sql2.8 KB2026-07-13 03:27📄PLATFORM-2852_stream_Profile_createAt_from_neo_to_sf.sql2.7 KB2026-07-13 03:27📄PLATFORM-2852_STREAM_Profile_HAS_ACCESS_TO.createdAt_ArtistInfo.sql2.9 KB2026-07-13 03:27📄PLATFORM-2852_stream_Subaccount_createdAt_from_neo_to_sf.sql1.8 KB2026-07-13 03:27📄PLATFORM-2852_stream_Vendor_createdAt_Neo4j_to_sf.sql2.6 KB2026-07-13 03:27📄PLATFORM-3032_create_gda_accounts.sql667 B2026-07-13 03:27📄PLATFORM-3503_dim_brand_hide_deleted_parents.sql1.6 KB2026-07-13 03:27📄PLATORM-2682-Stream_HAS_ADMIN_ACCESS_TO_neo4j_sf.sql2.4 KB2026-07-13 03:27📄PLATORM-2692_Stream_has_admin_access_to_neo4j_sf.sql2.5 KB2026-07-13 03:27📄POD-1047-add-orch-user-agent-to-megaphone.sql230 B2026-07-13 03:27📄POD-1047-megaphone-update-orch-user-agent.sql339 B2026-07-13 03:27📄POD-1221-update-user-agent-country-unknown.sql307 B2026-07-13 03:27📄POD-1377-add-image-url-to-staging.sql252 B2026-07-13 03:27📄POD-1377-add-podcast-id-col.sql233 B2026-07-13 03:27📄POD-1377-chartable-staging-raw.sql389 B2026-07-13 03:27📄POD-1377-create-chartable-rankings-table.sql636 B2026-07-13 03:27📄POD-1377-new-chartable-staging-table.sql646 B2026-07-13 03:27📄POD-1377-recreate-chartable.sql1.1 KB2026-07-13 03:27📄POD-1377_add_chartable_columns.sql1.1 KB2026-07-13 03:27📄POD-1377_add_podcast_id_chartable_column.sql233 B2026-07-13 03:27📄POD-1377_create_permanent_table.sql2.0 KB2026-07-13 03:27📄POD-1377_rename_chartable_table.sql318 B2026-07-13 03:27📄POD-1377_store_ids.sql1.2 KB2026-07-13 03:27📄POD-1378-create-other-chartable-tables.sql3.9 KB2026-07-13 03:27📄POD-1406-create-megaphone-temp-table.sql170 B2026-07-13 03:27📄POD-1427-new-tables.sql1.5 KB2026-07-13 03:27📄POD-1452-add-published-column-to-chartable.sql275 B2026-07-13 03:27📄POD-1518-staging-catalog-table.sql475 B2026-07-13 03:27📄POD-1663_add-blacklisted-ip-and-blacklisted-ua-to-megaphone-and-staging.sql799 B2026-07-13 03:27📄POD-1665-update-chartable-ratings-column.sql892 B2026-07-13 03:27📄POD-1703-add-additional-chartable-episode-columns.sql588 B2026-07-13 03:27📄POD-1725-add-date-col-to-podcast-ratings-and-staging-table.sql222 B2026-07-13 03:27📄POD-1725-create-chartable-podcast-ratings-table.sql693 B2026-07-13 03:27📄POD-1725-create-chartable-podcast-reviews-and-staging-tables.sql1.3 KB2026-07-13 03:27📄POD-1725-create-staging-chartable-podcast-ratings-table.sql479 B2026-07-13 03:27📄POD-1727-add-published-date-to-chartable-tables.sql494 B2026-07-13 03:27📄POD-1744-create-chartable-retention-etl-tables.sql1.5 KB2026-07-13 03:27📄POD-1855-add-title-to-reviews-table.sql452 B2026-07-13 03:27📄POD-2090_add_columns_to_sales_summary_table.sql773 B2026-07-13 03:27📄POD-2091_create_content_performance.sql1.4 KB2026-07-13 03:27📄POD-2091_create_sales_summary.sql982 B2026-07-13 03:27📄POD-2091_create_staging_raw_tables.sql2.2 KB2026-07-13 03:27📄POD-2091_create_subscription_events.sql1.2 KB2026-07-13 03:27📄POD-2091_create_subscription_snapshot.sql1.2 KB2026-07-13 03:27📄POD-2145-add-is-deleted-column-in-megaphone-tables.sql469 B2026-07-13 03:27📄POD-2210_add_columns_to_subscription_snapshot_table.sql837 B2026-07-13 03:27📄POD-2248_create_episode_view.sql861 B2026-07-13 03:27📄POD-2248_create_podcasts_view.sql674 B2026-07-13 03:27📄POD-2248_update_episode_view_name.sql271 B2026-07-13 03:27📄POD-2248_update_podcast_view_name.sql271 B2026-07-13 03:27📄POD-2303-create-ap-snapshot-monthly-tables.sql1.9 KB2026-07-13 03:27📄POD-2324_add_new_column_for_event_date.sql499 B2026-07-13 03:27📄POD-2324_add_new_column_for_event_date_in_weekly_monthly.sql1.2 KB2026-07-13 03:27📄POD-2324_rename_columns.sql1.2 KB2026-07-13 03:27📄POD-2324_rename_columns_in_weekly_monthly_tables.sql2.6 KB2026-07-13 03:27📄POD-2327_add_source_column_in_snapshot_monthly_tables.sql569 B2026-07-13 03:27📄POD-2328_create_sales_summary_weekly_tables.sql1.6 KB2026-07-13 03:27📄POD-2329_create_sales_summary_monthly_tables.sql1.6 KB2026-07-13 03:27📄POD-2330_add_source_column_in_events_monthly_tables.sql561 B2026-07-13 03:27📄POD-2537_update_episode_view.sql2.7 KB2026-07-13 03:27📄POD-2671_add_vendor_columns_in_apple_events_monthly_tables.sql1009 B2026-07-13 03:27📄POD-2692_add_vendor_columns_in_apple_subscription_events_tables.sql959 B2026-07-13 03:27📄POD-2693_add_vendor_columns_in_apple_subscription_events_weekly_tables.sql1001 B2026-07-13 03:27📄POD-2695_add_vendor_columns_in_apple_sales_summary_tables.sql911 B2026-07-13 03:27📄POD-2696_add_vendor_columns_in_apple_sales_summary_weekly_tables.sql953 B2026-07-13 03:27📄POD-2697_add_vendor_columns_in_apple_sales_summary_monthly_tables.sql975 B2026-07-13 03:27📄POD-2698_add_vendor_columns_in_apple_subscription_snapshot_tables.sql961 B2026-07-13 03:27📄POD-2699_add_vendor_columns_in_apple_snapshot_weekly_tables.sql1.0 KB2026-07-13 03:27📄POD-2700_add_vendor_columns_in_apple_snapshot_monthly_tables.sql1.0 KB2026-07-13 03:27📄POD-2924_add_vendor_columns_apple_podcasts_content_performance.sql959 B2026-07-13 03:27📄POD-643_create_megaphone_table.sql878 B2026-07-13 03:27📄POD-897_rename_megaphone_table.sql268 B2026-07-13 03:27📄POD-904-add-columns-to-megaphone-qa.sql874 B2026-07-13 03:27📄POD-904-add-columns-to-megaphone.sql894 B2026-07-13 03:27📄POD-935-add-network-to-podcast-staging-raw-qa.sql138 B2026-07-13 03:27📄POD-935-add-network-to-podcast-staging-raw.sql140 B2026-07-13 03:27📄POD-938-add-published-columns-to-megaphone-qa.sql355 B2026-07-13 03:27📄POD-938-add-published-columns-to-megaphone.sql361 B2026-07-13 03:27📄PORT-54-create-dim_release_history.sql746 B2026-07-13 03:27📄PUB-101-refactor-agreement-table.sql8.6 KB2026-07-13 03:27📄PUB-500-drop-label-type.sql281 B2026-07-13 03:27📄PUB-562-add-delivery-fields.sql372 B2026-07-13 03:27📄PUB-562-fix-delivery-date.sql255 B2026-07-13 03:27📄PUB-61-neo-sf-has-agreement.sql2.6 KB2026-07-13 03:27📄PUB-61-neo-sf-has-composition.sql2.5 KB2026-07-13 03:27📄PUB-61-neo-sf-has-pub-share.sql2.4 KB2026-07-13 03:27📄PUB-61-neo-sf-has-signed-writer.sql2.6 KB2026-07-13 03:27📄PUB-61-neo-sf-has-sound-recording.sql2.5 KB2026-07-13 03:27📄PUB-61-neo-sf-has-writer-share.sql3.0 KB2026-07-13 03:27📄PUB-61-neo-sf-publishing-agreement.sql2.9 KB2026-07-13 03:27📄PUB-61-neo-sf-publishing-composition.sql3.3 KB2026-07-13 03:27📄PUB-61-neo-sf-publishing-publisher.sql2.8 KB2026-07-13 03:27📄PUB-61-neo-sf-publishing-song-writer.sql2.8 KB2026-07-13 03:27📄PUB-653-add-publishing-fields.sql844 B2026-07-13 03:27📄PUB-98-99-songwriter-publisher-ids.sql8.6 KB2026-07-13 03:27📄PUB-XX-agreements-refactor.sql5.0 KB2026-07-13 03:27📄PUB-XX-alter-sched-for-qa.sql2.3 KB2026-07-13 03:27📄PUB-XX-breakout-agreement-table.sql1.4 KB2026-07-13 03:27📄PUB-XX-cleanup-old-relationships.sql369 B2026-07-13 03:27📄PUB-XX-fix-split-pub.sql3.1 KB2026-07-13 03:27📄PUB-XX-fix-split.sql4.2 KB2026-07-13 03:27📄REMOVE_duplicates_in_dim_youtube_channel_names.sql922 B2026-07-13 03:27📄REVIEW-2349_rename_table.sql286 B2026-07-13 03:27📄REVIEW-2350_CREATE_acrcloud_audio_infringement.sql873 B2026-07-13 03:27📄REVIEW-2351-drop_not_null_from_upc_and_isrc.sql279 B2026-07-13 03:27📄REVIEW-2351-truncate_event_ows_assets_arccloud_audio_infringements.sql191 B2026-07-13 03:27📄REVIEW-2378_ALTER_acrcloud_and_create_stream.sql761 B2026-07-13 03:27📄SR-1041_clean_bad_ddex_deduplicator_records_qa.sql245 B2026-07-13 03:27📄SR-1041_QA-ONLY_DELETE_bad_rows.sql389 B2026-07-13 03:27📄SR-1287_clone-has_fingerprint_rule_tables.sql321 B2026-07-13 03:27📄SR-411_CREATE_VIEW_track_audio_rights_attributes.sql2.8 KB2026-07-13 03:27📄SR-797_ALTER_TABLE_tiktok_delivery_ack_message_column.sql224 B2026-07-13 03:27📄SR-797_CREATE_TABLE_tiktok_delivery_ack.sql522 B2026-07-13 03:27📄SR-956_CREATE_TABLE_registry_territories.sql513 B2026-07-13 03:27📄SWITCH-2877_CREATE_view_orchard_labelcopy_track_artist.sql1.7 KB2026-07-13 03:27📄VC-4676_add_es_id_column.sql172 B2026-07-13 03:27📄VS-387_DROP_obsolete_REGISTRY_tables.sql4.0 KB2026-07-13 03:27📄YT-14_CREATE_dim_youtube_channel_names.sql502 B2026-07-13 03:27📄YT-346_ALTER_dim_claim_add_columns.sql539 B2026-07-13 03:27📄YT-452_CREATE_playlist_types_tables.sql1.9 KB2026-07-13 03:27📄YT-733_CREATE_TASK_load_placements_participant_incremental.sql68.1 KB2026-07-13 03:27📄YT-735_ALTER_LOAD_PLACEMENTS_INCREMENTAL_TIMEOUT.sql522 B2026-07-13 03:27📄YT-735_ALTER_TASK_playlist.sql66.2 KB2026-07-13 03:27