version: 2 sources: - name: art_relations_prod_art_relations database: orchard_app_reporting_v2 tables: - name: acct_period - name: additional_artist_info - name: advance_release - name: advance_release_links - name: advance_track - name: agreement - name: agreement_advance - name: agreement_dms - name: agreement_dms_master_restrictions - name: agreement_form_content_in - name: agreement_form_dmsp - name: agreement_form_miscellaneous - name: agreement_form_mobile - name: agreement_form_territorial - name: agreement_min_target - name: agreement_note - name: agreement_publishing_liability - name: agreement_recoup_promotion - name: agreement_revenue_rate - name: agreement_revenue_rate_territory - name: agreement_rights_granted - name: agreement_sliding_percentages - name: agreement_territory - name: alert - name: alert_roles - name: alert_type - name: alert_type_roles - name: analytics_event_types - name: analytics_events - name: api_artist_custom_fields - name: api_discounted_product - name: api_images - name: api_invoice_details - name: api_invoice_payment_logs - name: api_invoices - name: api_label_custom_fields - name: api_permissions - name: api_privilege - name: api_product_categories - name: api_product_comments - name: api_product_label_installation_verifiers - name: api_product_label_installations - name: api_product_label_purchases - name: api_product_req_cats - name: api_product_required_roles - name: api_product_version_revenue_model - name: api_product_versions - name: api_product_videos - name: api_products - name: api_products_screenshots - name: api_resources - name: api_revenue_model - name: api_role_permissions - name: api_roles - name: api_statistics - name: api_throttling - name: api_vendors - name: artarch_278_artist_identifier_to_participant_identifier - name: artist_bio_social_references - name: artist_carveout_template - name: artist_custom_event_categories - name: artist_custom_events - name: artist_identifier - name: artist_info - name: artist_info_consolidation - name: artist_info_consolidation_202101 - name: artist_info_profile_completion - name: artist_info_profile_sections - name: artist_info_tmp - name: artist_marketable_events - name: artist_name - name: artist_news_social_references - name: artist_photo_social_references - name: artist_photos - name: artist_press - name: artist_profilephoto_social_references - name: artist_services_assigned_release - name: artist_social_connection_preferences - name: artist_social_connections - name: artist_social_preferences - name: artist_thumbnails - name: artist_tourdate_social_references - name: artist_url - name: artist_video_social_references - name: artist_videos - name: artist_web_images - name: artist_yt_delivery_settings - name: asset - name: audio_attributes - name: b2b_hisd - name: b2b_hism - name: b2b_inventory - name: b2b_mutex - name: b2b_trd - name: b2b_trm - name: bfm_16x9_large_tmp_20141010 - name: bfm_16x9_thumb_tmp_20141010 - name: bfm_image_upc_tmp_20141010 - name: bfm_track_assets - name: blacklist_reasons - name: blacklist_words - name: blacklisted_songs - name: booked_vendor_contract_snapshot - name: calltype - name: carveout_change_release - name: carveout_change_subaccount - name: carveout_change_vendor - name: catalog - name: cd_receive - name: channel - name: channel_sequence - name: check_receivable - name: check_receivable_detail - name: checkspaid - name: checkspaid_tmp - name: classification_detail - name: client_notification_detail - name: client_notification_url - name: closed_caption_reasons - name: collection_society - name: comming_soon_release - name: contact - name: continent - name: correction - name: country - name: country_currencies - name: country_language - name: country_rating_advisory_system - name: credit_card_history - name: credit_card_info - name: credit_card_log - name: cs_functional_area - name: cs_issue - name: cs_subfunctional_area - name: currencies - name: currency - name: currency_exchange_rates - name: customer_master - name: customer_master_contact - name: customer_master_distribution_type - name: customer_master_master - name: customer_master_master_contact - name: customer_master_master_distribution_type - name: customer_order - name: customer_return - name: customer_return_tmp - name: customer_service - name: databasechangelog - name: databasechangeloglock - name: deal_info - name: deal_info_contact - name: deal_info_notes - name: deal_info_product_type - name: deks - name: delivery_history - name: detailed_sales_import_error - name: dig_sales - name: dig_sales_errors - name: digital_deletions - name: distribution_features - name: distribution_format - name: distribution_format_hfa - name: distribution_format_media - name: distribution_format_media_format - name: distribution_type - name: distro_778_release_approval_queue - name: dms_availability - name: dms_genre_mapping - name: dms_hd_delivery - name: dms_hd_delivery_detail - name: dms_hd_priority - name: dms_ingestion_failed - name: dms_invoice - name: dms_invoice_detail - name: dms_links_email - name: dms_master_genre - name: dms_master_pricing_scheme - name: dms_master_pricing_scheme_territory - name: dms_master_product_type - name: dms_master_subgenre - name: dms_placement - name: dms_preferred_artist_country - name: dms_preferred_genre - name: dms_preferred_label - name: dms_preferred_label_country - name: dms_preferred_label_priority - name: dms_preferred_marketing_priority - name: dms_preferred_meta_language - name: dms_preferred_sales_start_date - name: dms_preferred_subaccount - name: dms_preferred_subgenre - name: dms_pricing - name: dms_pricing_tier - name: dms_subgenre_mapping - name: dms_territory_currency - name: dms_track_identifier - name: dms_users_delete - name: dra_optout_responses - name: dra_optouts - name: ds_licensee - name: ds_lsdroyalty - name: duped_artist_info_mapping - name: email_notification - name: emaillist - name: emaillistmembers_delete - name: emd_releases - name: emusic_genre - name: emusic_track_mapping - name: encoder - name: encoder_dms - name: encoding_order - name: encoding_order_detail - name: encoding_order_detail_dms - name: ex_a_artist_info_delete - name: ex_a_artist_url - name: faq - name: faq_category - name: faq_category_link - name: fc_dig_sales_errors - name: fc_owner_accounting - name: fc_processed_dig_sales - name: fc_processed_phy_sales - name: fc_publisher_accounting - name: fc_publisher_statement - name: fc_publisher_statement_detail - name: fc_publishing_escrow - name: fc_release_accounting - name: fc_vendor_accounting - name: features - name: film_genre - name: film_genre_store_mapping - name: fivetran_audit - name: flashlight_delivery - name: flashlight_delivery_details - name: focus_track - name: full_deletions - name: genre - name: hfa_status_codes - name: hfa_valid_licenses - name: image_assets - name: image_category - name: import_asset - name: import_asset_batch - name: import_asset_detail - name: industry_growth - name: inserted_mr_703_prs_backfill - name: instock - name: instrument - name: int_174_master_contacts - name: int_mkt_priority - name: inventory_return_delete - name: ioda_cleanup_assets - name: ioda_cleanup_import_assets - name: ioda_client_manager_mapping - name: ioda_contact_mapping - name: ioda_delivery_history_mapping_fix - name: ioda_itunes_release_mapping - name: ioda_itunes_staging - name: ioda_label_mapping - name: ioda_primary_release_artist_bio_fix - name: ioda_primary_release_artist_fix - name: ioda_primary_release_artist_name_fix - name: ioda_release_artist_mapping - name: ioda_release_exclusive_carveouts - name: ioda_release_mapping - name: ioda_release_migration_stop_list - name: ioda_release_primary_artist_mapping - name: ioda_release_rightsholder - name: ioda_releases - name: ioda_rightsholder_mapping - name: ioda_rightsholder_migration_stop_list - name: ioda_rightsholder_service_carveouts - name: ioda_rightsholder_subservice_carveouts - name: ioda_rightsholder_territory_carveouts - name: ioda_service_mapping - name: ioda_service_release_mapping - name: ioda_shared_release_remap - name: ioda_starting_ending_balance_exchange_rate - name: ioda_track_artist_mapping - name: ioda_track_mapping - name: ioda_track_publisher_mapping - name: ioda_track_writer_mapping - name: ioda_tv_mapping - name: ioda_vend_contact_mapping - name: ioda_vendor_contract_mapping - name: ioda_video_mapping - name: ip_lookup - name: isrcs - name: itunes_film_languages - name: itunes_languages - name: join_comments - name: label_sales_adjustment - name: language - name: licensing_review_status - name: licensing_review_status_change_history - name: listening_notes_release - name: listening_notes_track - name: login_stat - name: login_stat_2019 - name: manual_adjustment - name: manual_adjustment_category - name: marketplace_terms_and_conditions_history - name: marketplace_terms_conditions - name: mass_mailer_log - name: master_blacklist - name: master_grid - name: master_pitch - name: master_pitch_detail - name: message - name: message_tag - name: meta_update_dms_master - name: meta_update_queue - name: mfit_studio - name: mkt_priority - name: mkt_priority_project - name: mkt_program - name: mkt_program_info - name: mkt_release_credit - name: mm_package - name: mm_package_detail - name: mood - name: musician - name: narm_availability - name: new_music_delete - name: newsletter - name: note - name: notifications - name: oa_documents - name: omp_request - name: oms_client - name: oms_client_contact - name: oms_client_notes - name: oms_contact - name: oms_label_deal - name: oms_label_deal_owner - name: oms_project - name: oms_project_owner - name: oms_task - name: oms_task_owner - name: oms_track - name: onesheet - name: onesheet_credit - name: onesheet_selling_point - name: onesheet_selling_point_territory - name: opt_in_preference - name: orchadmin_permissions - name: orchadmin_permissions_old - name: orchadmin_privileges - name: orchadmin_resources - name: orchadmin_role_permissions - name: orchadmin_roles - name: orchadmin_user_permission - name: orchadmin_user_roles - name: orchadmin_user_saved_query - name: orchadmin_user_saved_query_criteria - name: orchadmin_users - name: orchard_state - name: order_items - name: order_shipping - name: owner - name: owner_accounting - name: owner_accounting_old - name: owner_accounting_r2 - name: owner_checkspaid - name: owner_contact - name: owner_dms - name: owner_payment_level - name: owner_sync_revenue - name: owner_target - name: owner_territory - name: p1_eo_priority_releases - name: participant_external_link - name: participant_external_link_ids_seed - name: participant_identifier - name: payment_calculator - name: payment_calculator_job - name: payment_calculator_status - name: payment_calculator_vendor - name: payment_level - name: payment_log - name: performance_rights_delivery_settings - name: period - name: phf_mechadmin_track - name: phf_publishing_escrow - name: phf_publishing_escrow_released - name: physical_order_targets - name: physical_release_country_dates - name: pitch - name: pitch_detail - name: pitch_note - name: placeholder_upc - name: playlist - name: playlist_detail - name: playlist_playlist_tag - name: playlist_tags - name: pnl - name: pnl_sales - name: pnl_sales_detail - name: pnl_sales_genre_detail - name: ppb_trashlist - name: predefined_task - name: processed_phy_sales - name: processed_royalty_collection - name: product_distribution - name: product_manager_mapping_product - name: product_manager_mapping_vendor - name: product_physical - name: product_physical_change_history - name: product_physical_packaging - name: product_physical_supply_chain_info - name: product_physical_supply_chain_metadata - name: product_split - name: product_subtype - name: product_territory_split - name: product_type - name: product_video - name: product_video_approval - name: project - name: promo_code - name: proper_stock_essn - name: proposal_proposal_tag - name: proposal_response - name: proposal_response_list - name: proposal_tags_remove - name: proposal_target_list - name: proposals - name: prospective_label - name: publisher_accounting - name: publisher_license_types - name: publisher_statement - name: publisher_statement_detail - name: publishers - name: publishers_checkspaid - name: publishers_checkspaid_tmp - name: publishers_contact - name: publishers_license - name: publishing_admin_contract - name: publishing_escrow - name: publishing_escrow_errors - name: publishing_escrow_released - name: qq_yy_costs - name: qq_yy_creditmemo - name: qq_yy_sales - name: rating_advisory_system - name: reason_type - name: receive_new_release - name: red_backup_vendor_territory_contract_4_9_2013 - name: red_essential_label_mapping - name: region - name: region_country - name: rejection_notes - name: release_16x9_thumbnail_images - name: release_accounting_sums - name: release_approval_comments - name: release_approval_queue - name: release_artist - name: release_artist_localized_metadata - name: release_asset_error_type - name: release_asset_errors - name: release_asset_updates - name: release_asset_version - name: release_bubbling - name: release_captions - name: release_correction - name: release_correction_detail - name: release_country_dates - name: release_cover_correction_images - name: release_cover_images - name: release_custom_pricing - name: release_default_dms_master_restriction - name: release_dms_master_restriction - name: release_dms_restriction - name: release_exclusive - name: release_film_genre - name: release_grid - name: release_instrument - name: release_large_16x9_thumbnail_images - name: release_large_cover_correction_images - name: release_large_cover_images - name: release_large_poster_images - name: release_localized_metadata - name: release_logging - name: release_manual_adjustment - name: release_mfit_info - name: release_mood - name: release_payment_log - name: release_phonetic_translations - name: release_poster_images - name: release_pricing_tier - name: release_pricing_tier_country - name: release_rating_advisory_system - name: release_schedule_dashboard_change_history - name: release_status - name: release_subaccount_change_history - name: release_subgenre - name: release_subgenre_old - name: release_subtitles - name: release_tag - name: release_territory_restriction - name: release_theme - name: release_tmp - name: release_type - name: release_video_links - name: releases - name: releases_tmp - name: reorder_detail - name: reorder_new - name: reorder_tmp - name: replaced_mr_703_prs_backfill - name: report_preset - name: report_record - name: revenue_plan - name: rf_publisher_mapping - name: rights_attributes - name: rightsflow_publisher_final_catalog - name: rightsflow_track_publisher_final_catalog - name: ringtone_licensing_request - name: ringtone_order - name: ringtone_order_detail - name: ringtone_solicitation - name: rollback-data-acc-3754 - name: rollback_artarch_419_delete_artist_duplicates - name: rollback_data_acc2864_acc_2864_1 - name: rollback_data_acc2864_acc_2864_2 - name: rollback_data_acc2916_acc_2916_1 - name: rollback_data_acc2916_acc_2916_2 - name: rollback_data_acc_2769_1 - name: rollback_data_acc_2769_2 - name: rollback_data_acc_2875 - name: rollback_data_acc_2906 - name: rollback_data_acc_2917 - name: rollback_data_acc_2933 - name: rollback_data_acc_5930_1_ - name: rollback_distro_3252_release_dms_master_restriction - name: rollback_distro_3292_project - name: rollback_distro_3443_release_dms_restriction - name: rollback_distro_3458_youtube_channel_video_status - name: rollback_distro_3526_release_dms_master_restriction - name: rollback_distro_3529_release_dms_master_restriction - name: rollback_distro_3529_release_territory_restriction - name: rollback_distro_3573_artist_yt_delivery_settings - name: rollback_distro_3575_track - name: rollback_distro_3604_update_project_subaccount - name: rollback_distro_3607_track - name: rollback_distro_3649_product_video - name: rollback_distro_3649_releases - name: rollback_distro_3654_releases - name: rollback_distro_3710_youtube_channel_video_status - name: rollback_distro_3714_youtube_channel_video_status - name: rollback_distro_3734_youtube_channel_video_status - name: rollback_distro_3789_releases - name: rollback_distro_3813_product_physical - name: rollback_do_not_purge_vendor_contract_carveout_russia - name: rollback_int689 - name: rollback_int_623_batch_13_set_to_in_content - name: rollback_int_624_batch_14_set_to_in_content - name: rollback_int_626_batch_15_set_to_in_content - name: rollback_int_628_track_featuring_artist - name: rollback_int_680_batch_01_set_to_in_content - name: rollback_int_682_batch_02_set_to_in_content - name: rollback_int_684_batch_03_set_to_in_content - name: rollback_int_688_batch_04_set_to_in_content - name: rollback_switch_1993 - name: royalty_collection - name: royalty_collection_contract - name: royalty_collection_detail - name: royalty_collection_errors - name: royalty_collection_exports - name: royalty_collection_staging_releases - name: royalty_collection_staging_releases_errors - name: scpp_labels - name: screenshot - name: service_type - name: sites - name: social_profile - name: social_publish_history - name: social_publish_queue - name: social_publish_queue_resources - name: social_references - name: social_site_preferences - name: sony_status - name: soundexchange_upcs - name: soundscan_codes - name: soundscan_genre_mappings - name: soundscan_genres - name: soundscan_product_format_mappings - name: soundscan_product_formats - name: soundscan_subaccount_exclusion - name: soundscan_upc_exclusion - name: soundscan_vendor_exclusion - name: spotify_equity_checkspaid - name: statutory_rates - name: stopwords - name: store_classification_detail - name: subaccount - name: subaccount_dms_master_restriction - name: subaccount_dms_restriction - name: subaccount_royalty_collection - name: subaccount_royalty_collection_territories - name: subaccount_territory_restriction - name: subgenre - name: subgenre_original - name: supply_chain_defaults - name: sync_admin_contract - name: sync_checkspaid - name: sync_invoice - name: sync_invoice_detail - name: sync_invoice_detail_breakdown - name: tag - name: task - name: temp_dig_sales_processed - name: temp_dig_sales_statements - name: temp_pre_backfill_project_artist - name: temp_project_pre_backfill - name: temp_project_with_bad_subaccount - name: temp_release_project_backfill - name: temp_releases_pre_backfill - name: temp_upc_project_code - name: test_vendors - name: theme - name: ticket - name: ticket_assignment - name: ticket_task_notes - name: ticket_type - name: tier - name: tier_dms - name: tmp_bfm - name: top_sellers_remove - name: top_ten - name: tour_date_other_artists - name: tour_dates - name: tourdate_buylinks - name: track - name: track_artist - name: track_artist_localized_metadata - name: track_audio_attributes - name: track_clips - name: track_credit - name: track_crop_info - name: track_custom_pricing - name: track_instant_grat - name: track_localized_metadata - name: track_master_rights - name: track_name - name: track_note - name: track_physical - name: track_producer_nationality - name: track_publisher - name: track_publishing - name: track_restriction - name: track_rights_attributes - name: track_split - name: track_tag - name: track_tmp - name: track_video - name: track_video_clips - name: track_video_marker - name: track_writer - name: trackdown_activity - name: trackdown_advance_release_user - name: trackdown_newsletter - name: trackdown_permissions - name: trackdown_proposal_access - name: trackdown_release_user - name: trackdown_tags - name: trackdown_user_permission - name: trackdown_user_playlist - name: trackdown_user_tag - name: trackdown_users - name: transfered_releases - name: travelex - name: tv_series - name: tv_series_artist_mapping - name: ugc_policy - name: ui_accounttype - name: ui_restrictions - name: unique_artist - name: upcs - name: vectorapi_access_tokens - name: vectorapi_clients - name: vectorapi_refresh_tokens - name: vectorapi_user - name: vectorapi_user_auth - name: vend_contact - name: vend_contact_roles - name: vendor - name: vendor_accounting - name: vendor_accounting_flat - name: vendor_accounting_old - name: vendor_agreement - name: vendor_audio_attributes - name: vendor_chargeback - name: vendor_checkspaid - name: vendor_checkspaid_tmp - name: vendor_contact_preferences - name: vendor_contract - name: vendor_contract_advance - name: vendor_contract_change_history - name: vendor_contract_compilation - name: vendor_contract_distribution_type - name: vendor_contract_rights_granted - name: vendor_dms_contract - name: vendor_dms_master_contract - name: vendor_dms_master_restriction - name: vendor_email_notification - name: vendor_icon - name: vendor_logo - name: vendor_message - name: vendor_notes - name: vendor_payment_interval_history - name: vendor_payment_interval_history_old - name: vendor_permissions - name: vendor_physical_supplychain_default_selection - name: vendor_privilege - name: vendor_proposed_contract_advance - name: vendor_proposed_dms_contract - name: vendor_proposed_dms_master_contract - name: vendor_proposed_dms_master_restriction - name: vendor_proposed_recoup_contract - name: vendor_proposed_term - name: vendor_proposed_term_change_history - name: vendor_proposed_term_compilation - name: vendor_proposed_term_distribution_type - name: vendor_proposed_territory_contract - name: vendor_recoup_contract - name: vendor_resource - name: vendor_restricted_features - name: vendor_rights_attributes - name: vendor_role_permissions - name: vendor_roles - name: vendor_sync_revenue - name: vendor_territory_contract - name: vendor_territory_restriction - name: vendor_tmp - name: vendor_tmp_notes - name: vendor_transaction_type_contract - name: vendor_tt_territory_contract - name: venue - name: video_asset_type - name: video_dashboard_item - name: video_dashboard_item_status - name: video_dashboard_notifications - name: video_dashboard_status - name: welcome_email - name: youtube_audit - name: youtube_audit_log - name: youtube_audit_release - name: youtube_channel - name: youtube_channel_access_token - name: youtube_channel_activities_q_script_log - name: youtube_channel_asset_types - name: youtube_channel_category - name: youtube_channel_cms_account - name: youtube_channel_cms_account_history - name: youtube_channel_manually_submitted_video_ids - name: youtube_channel_partner_status - name: youtube_channel_partner_status_history - name: youtube_channel_service_tier - name: youtube_channel_service_tier_history - name: youtube_channel_upc - name: youtube_channel_verify - name: youtube_channel_video_category - name: youtube_channel_video_status - name: youtube_report_generation_log - name: zipcodes