variable "env" { default = "prod" } variable "service_name" { default = "art-relations" } variable "application_family" { default = "devops" } variable "team_name" { default = "devops" } variable "aws_region" { default = "us-east-1" } variable "environment" { type = string description = "The environment" default = "prod" } variable "art_relations_tables_to_sync_to_snowflake" { type = list(string) description = "List of tables to sync to Snnowflake" default = [ "DATABASECHANGELOG", "DATABASECHANGELOGLOCK", "RED_Backup_vendor_territory_contract_4_9_2013", "TEMP_dig_sales_processed", "TEMP_dig_sales_statements", "acct_period", "additional_artist_info", "advance_release", "advance_release_links", "advance_track", "agreement", "agreement_advance", "agreement_dms", "agreement_dms_master_restrictions", "agreement_form_content_in", "agreement_form_dmsp", "agreement_form_miscellaneous", "agreement_form_mobile", "agreement_form_territorial", "agreement_min_target", "agreement_note", "agreement_publishing_liability", "agreement_recoup_promotion", "agreement_revenue_rate", "agreement_revenue_rate_territory", "agreement_rights_granted", "agreement_sliding_percentages", "agreement_territory", "alert", "alert_roles", "alert_type", "alert_type_roles", "analytics_event_types", "analytics_events", "api_artist_custom_fields", "api_discounted_product", "api_images", "api_invoice_details", "api_invoice_payment_logs", "api_invoices", "api_label_custom_fields", "api_permissions", "api_privilege", "api_product_categories", "api_product_comments", "api_product_label_installation_verifiers", "api_product_label_purchases", "api_product_req_cats", "api_product_required_roles", "api_product_version_revenue_model", "api_product_videos", "api_products_screenshots", "api_resources", "api_revenue_model", "api_role_permissions", "api_roles", "api_statistics", "api_throttling", "artist_bio_social_references", "artist_carveout_template", "artist_custom_event_categories", "artist_custom_events", "artist_info", "artist_info_consolidation", "artist_info_profile_completion", "artist_info_profile_sections", "artist_info_tmp", "artist_marketable_events", "artist_name", "artist_news_social_references", "artist_photo_social_references", "artist_photos", "artist_press", "artist_profilephoto_social_references", "artist_services_assigned_release", "artist_social_connection_preferences", "artist_social_connections", "artist_social_preferences", "artist_thumbnails", "artist_tourdate_social_references", "artist_url", "artist_video_social_references", "artist_videos", "artist_web_images", "artist_yt_delivery_settings", "asset", "audio_attributes", "audio_attributes_suggestion_keywords", "b2b_hisd", "b2b_hism", "b2b_inventory", "b2b_mutex", "b2b_trd", "b2b_trm", "bfm_16x9_large_tmp_20141010", "bfm_16x9_thumb_tmp_20141010", "bfm_image_upc_tmp_20141010", "bfm_track_assets", "blacklist_reasons", "blacklist_words", "blacklisted_songs", "booked_vendor_contract_snapshot", "calltype", "carveout_change_release", "carveout_change_subaccount", "carveout_change_vendor", "catalog", "cd_receive", "channel", "channel_sequence", "check_receivable", "check_receivable_detail", "checkspaid", "checkspaid_tmp", "classification_detail", "client_notification_detail", "client_notification_url", "closed_caption_reasons", "collection_society", "comming_soon_release", "concierge_product", "contact", "continent", "correction", "country", "country_currencies", "country_language", "country_rating_advisory_system", "cs_functional_area", "cs_issue", "cs_subfunctional_area", "currencies", "currency", "currency_exchange_rates", "customer_master", "customer_master_contact", "customer_master_distribution_type", "customer_master_master", "customer_master_master_contact", "customer_master_master_distribution_type", "customer_order", "customer_return", "customer_return_tmp", "customer_service", "deal_info", "deal_info_contact", "deal_info_notes", "deal_info_product_type", "deks", "delivery_history", "detailed_sales_import_error", "dig_sales", "dig_sales_errors", "digital_deletions", "distribution_features", "distribution_format", "distribution_format_hfa", "distribution_format_media", "distribution_format_media_format", "distribution_type", "dms_availability", "dms_genre_mapping", "dms_hd_delivery", "dms_hd_delivery_detail", "dms_hd_priority", "dms_ingestion_failed", "dms_invoice", "dms_invoice_detail", "dms_links_email", "dms_master_genre", "dms_master_pricing_scheme", "dms_master_pricing_scheme_territory", "dms_master_product_type", "dms_master_subgenre", "dms_placement", "dms_preferred_artist_country", "dms_preferred_genre", "dms_preferred_label", "dms_preferred_label_country", "dms_preferred_label_priority", "dms_preferred_marketing_priority", "dms_preferred_meta_language", "dms_preferred_sales_start_date", "dms_preferred_subaccount", "dms_preferred_subgenre", "dms_pricing", "dms_pricing_tier", "dms_subgenre_mapping", "dms_territory_currency", "dms_track_identifier", "dms_users_delete", "dra_optout_responses", "dra_optouts", "ds_licensee", "ds_lsdroyalty", "duped-artist-info-mapping", "email_notification", "emaillist", "emaillistmembers_delete", "emd_releases", "emusic_genre", "emusic_track_mapping", "encoder", "encoder_dms", "encoding_order", "encoding_order_detail", "encoding_order_detail_dms", "ex_a_artist_info_delete", "ex_a_artist_url", "faq", "faq_category", "faq_category_link", "fc_dig_sales_errors", "fc_owner_accounting", "fc_processed_dig_sales", "fc_processed_phy_sales", "fc_publisher_accounting", "fc_publisher_statement", "fc_publisher_statement_detail", "fc_publishing_escrow", "fc_release_accounting", "fc_vendor_accounting", "features", "film_genre", "film_genre_store_mapping", "flashlight_delivery", "flashlight_delivery_details", "focus_track", "full_deletions", "genre", "hfa_status_codes", "hfa_valid_licenses", "image_assets", "image_category", "import_asset", "import_asset_batch", "import_asset_detail", "industry_growth", "instock", "instrument", "int_mkt_priority", "inventory_return_delete", "ioda_cleanup_assets", "ioda_cleanup_import_assets", "ioda_client_manager_mapping", "ioda_contact_mapping", "ioda_delivery_history_mapping_fix", "ioda_itunes_release_mapping", "ioda_itunes_staging", "ioda_label_mapping", "ioda_primary_release_artist_bio_fix", "ioda_primary_release_artist_fix", "ioda_primary_release_artist_name_fix", "ioda_release_artist_mapping", "ioda_release_exclusive_carveouts", "ioda_release_mapping", "ioda_release_migration_stop_list", "ioda_release_primary_artist_mapping", "ioda_release_rightsholder", "ioda_releases", "ioda_rightsholder_mapping", "ioda_rightsholder_migration_stop_list", "ioda_rightsholder_service_carveouts", "ioda_rightsholder_subservice_carveouts", "ioda_rightsholder_territory_carveouts", "ioda_service_mapping", "ioda_service_release_mapping", "ioda_shared_release_remap", "ioda_starting_ending_balance_exchange_rate", "ioda_track_artist_mapping", "ioda_track_mapping", "ioda_track_publisher_mapping", "ioda_track_writer_mapping", "ioda_tv_mapping", "ioda_vend_contact_mapping", "ioda_vendor_contract_mapping", "ioda_video_mapping", "ip_lookup", "isrcs", "itunes_film_languages", "itunes_languages", "join_comments", "label_sales_adjustment", "language", "licensing_review_status", "licensing_review_status_change_history", "listening_notes_release", "listening_notes_track", "login_stat", "login_stat_2019", "manual_adjustment", "manual_adjustment_category", "marketplace_terms_and_conditions_history", "marketplace_terms_conditions", "mass_mailer_log", "master_blacklist", "master_grid", "master_pitch", "master_pitch_detail", "message", "message_tag", "meta_update_dms_master", "meta_update_queue", "mfit_studio", "mkt_priority", "mkt_priority_project", "mkt_program", "mkt_program_info", "mkt_release_credit", "mm_package", "mm_package_detail", "mood", "musician", "narm_availability", "new_music_delete", "newsletter", "note", "notifications", "oa_documents", "omp_request", "oms_client", "oms_client_contact", "oms_client_notes", "oms_contact", "oms_label_deal", "oms_label_deal_owner", "oms_project", "oms_project_owner", "oms_task", "oms_task_owner", "oms_track", "onesheet", "onesheet_credit", "onesheet_selling_point", "onesheet_selling_point_territory", "opt_in_preference", "orchadmin_permissions", "orchadmin_permissions_old", "orchadmin_privileges", "orchadmin_resources", "orchadmin_role_permissions", "orchadmin_roles", "orchadmin_user_permission", "orchadmin_user_roles", "orchadmin_user_saved_query", "orchadmin_user_saved_query_criteria", "orchadmin_users", "orchard_state", "order_items", "order_shipping", "owner", "owner_accounting", "owner_accounting_old", "owner_accounting_r2", "owner_checkspaid", "owner_contact", "owner_dms", "owner_payment_level", "owner_sync_revenue", "owner_target", "owner_territory", "p1_eo_priority_releases", "participant_external_link", "participant_external_link_ids_seed", "participant_identifier", "payment_calculator", "payment_calculator_job", "payment_calculator_status", "payment_calculator_vendor", "payment_level", "payment_log", "performance_rights_delivery_settings", "period", "phf_mechadmin_track", "phf_publishing_escrow", "phf_publishing_escrow_released", "physical_order_targets", "physical_release_country_dates", "pitch", "pitch_detail", "pitch_note", "placeholder_upc", "playlist", "playlist_detail", "playlist_playlist_tag", "playlist_tags", "pnl", "pnl_sales", "pnl_sales_detail", "pnl_sales_genre_detail", "ppb_trashlist", "predefined_task", "processed_phy_sales", "processed_royalty_collection", "product_distribution", "product_manager_mapping_product", "product_manager_mapping_vendor", "product_physical", "product_physical_change_history", "product_physical_packaging", "product_physical_supply_chain_info", "product_physical_supply_chain_metadata", "product_split", "product_subtype", "product_territory_split", "product_transfer_history", "product_type", "product_video", "product_video_approval", "project", "project_transfer_job", "promo_code", "proper_stock_essn", "proposal_proposal_tag", "proposal_response", "proposal_response_list", "proposal_tags_REMOVE", "proposal_target_list", "proposals", "prospective_label", "publisher_accounting", "publisher_license_types", "publisher_statement", "publisher_statement_detail", "publishers", "publishers_checkspaid", "publishers_checkspaid_tmp", "publishers_contact", "publishers_license", "publishing_admin_contract", "publishing_escrow", "publishing_escrow_errors", "publishing_escrow_released", "qq_yy_costs", "qq_yy_creditmemo", "qq_yy_sales", "rating_advisory_system", "reason_type", "receive_new_release", "red_essential_label_mapping", "region", "region_country", "rejection_notes", "release_16x9_thumbnail_images", "release_accounting_sums", "release_approval_comments", "release_approval_queue", "release_artist", "release_artist_localized_metadata", "release_asset_error_type", "release_asset_errors", "release_asset_updates", "release_asset_version", "release_bubbling", "release_captions", "release_correction", "release_correction_detail", "release_country_dates", "release_cover_correction_images", "release_cover_images", "release_custom_pricing", "release_default_dms_master_restriction", "release_dms_master_restriction", "release_dms_restriction", "release_exclusive", "release_film_genre", "release_grid", "release_instrument", "release_large_16x9_thumbnail_images", "release_large_cover_correction_images", "release_large_cover_images", "release_large_poster_images", "release_localized_metadata", "release_logging", "release_manual_adjustment", "release_mfit_info", "release_mood", "release_payment_log", "release_phonetic_translations", "release_poster_images", "release_pricing_tier", "release_pricing_tier_country", "release_rating_advisory_system", "release_schedule_dashboard_change_history", "release_status", "release_subaccount_change_history", "release_subgenre", "release_subgenre_OLD", "release_subtitles", "release_tag", "release_territory_restriction", "release_theme", "release_tmp", "release_type", "release_video_links", "releases", "release_spatial", "product_additional_upc", "reorder_detail", "reorder_new", "reorder_tmp", "report_preset", "report_record", "revenue_plan", "rf_publisher_mapping", "rights_attributes", "rights_attributes_suggestion_genre_subgenre_keywords", "rights_attributes_suggestion_keywords", "rights_attributes_suggestion_vendor_imprint_keywords", "rights_attributes_suggestion_vendor_subaccount_keywords", "ringtone_licensing_request", "ringtone_order", "ringtone_order_detail", "ringtone_solicitation", "royalty_collection", "royalty_collection_contract", "royalty_collection_detail", "royalty_collection_errors", "royalty_collection_exports", "royalty_collection_staging_releases", "royalty_collection_staging_releases_errors", "scpp_labels", "screenshot", "service_type", "sites", "social_profile", "social_publish_history", "social_publish_queue", "social_publish_queue_resources", "social_references", "social_site_preferences", "sony_status", "soundexchange_upcs", "soundscan_codes", "soundscan_genre_mappings", "soundscan_genres", "soundscan_product_format_mappings", "soundscan_product_formats", "soundscan_subaccount_exclusion", "soundscan_upc_exclusion", "soundscan_vendor_exclusion", "spotify_equity_checkspaid", "statutory_rates", "stopwords", "store_classification_detail", "subaccount", "subaccount_dms_master_restriction", "subaccount_dms_restriction", "subaccount_royalty_collection", "subaccount_royalty_collection_territories", "subaccount_territory_restriction", "subgenre", "subgenre_original", "supply_chain_defaults", "sync_admin_contract", "sync_checkspaid", "sync_invoice", "sync_invoice_detail", "sync_invoice_detail_breakdown", "tag", "task", "temp_pre_backfill_project_artist", "temp_project_pre_backfill", "temp_project_with_bad_subaccount", "temp_release_project_backfill", "temp_releases_pre_backfill", "temp_upc_project_code", "test_vendors", "theme", "ticket", "ticket_assignment", "ticket_task_notes", "ticket_type", "tier", "tier_dms", "tmp_BFM", "top_sellers_REMOVE", "top_ten", "tour_date_other_artists", "tour_dates", "tourdate_buylinks", "track", "track_artist", "track_artist_localized_metadata", "track_audio_attribute_suggestions", "track_audio_attributes", "track_audio_attributes_changelog", "track_audio_attributes_edits", "track_clips", "track_credit", "track_crop_info", "track_custom_pricing", "track_instant_grat", "track_localized_metadata", "track_master_rights", "track_name", "track_note", "track_physical", "track_producer_nationality", "track_publisher", "track_publishing", "track_restriction", "track_rights_attribute_suggestions", "track_rights_attributes", "track_rights_attributes_changelog", "track_rights_attributes_edits", "track_split", "track_tag", "track_tmp", "track_video", "track_video_clips", "track_video_marker", "track_writer", "trackdown_activity", "trackdown_advance_release_user", "trackdown_newsletter", "trackdown_permissions", "trackdown_proposal_access", "trackdown_release_user", "trackdown_tags", "trackdown_user_permission", "trackdown_user_playlist", "trackdown_user_tag", "trackdown_users", "track_spatial", "track_additional_isrc", "transfered_releases", "travelex", "tv_series", "tv_series_artist_mapping", "ugc_policy", "ui_accounttype", "ui_restrictions", "unique_artist", "upcs", "vectorapi_access_tokens", "vectorapi_clients", "vectorapi_refresh_tokens", "vectorapi_user", "vectorapi_user_auth", "vend_contact", "vend_contact_roles", "vendor", "vendor_accounting", "vendor_accounting_flat", "vendor_accounting_old", "vendor_agreement", "vendor_audio_attributes", "vendor_chargeback", "vendor_checkspaid", "vendor_checkspaid_tmp", "vendor_closers", "vendor_contact_preferences", "vendor_contract", "vendor_contract_advance", "vendor_contract_change_history", "vendor_contract_compilation", "vendor_contract_distribution_type", "vendor_contract_rights_granted", "vendor_dms_contract", "vendor_dms_master_contract", "vendor_dms_master_restriction", "vendor_email_notification", "vendor_icon", "vendor_logo", "vendor_message", "vendor_notes", "vendor_payment_interval_history", "vendor_payment_interval_history_old", "vendor_permissions", "vendor_physical_supplychain_default_selection", "vendor_privilege", "vendor_proposed_contract_advance", "vendor_proposed_dms_contract", "vendor_proposed_dms_master_contract", "vendor_proposed_dms_master_restriction", "vendor_proposed_recoup_contract", "vendor_proposed_term", "vendor_proposed_term_change_history", "vendor_proposed_term_compilation", "vendor_proposed_term_distribution_type", "vendor_proposed_territory_contract", "vendor_recoup_contract", "vendor_resource", "vendor_restricted_features", "vendor_rights_attributes", "vendor_role_permissions", "vendor_roles", "vendor_sync_revenue", "vendor_territory_contract", "vendor_territory_restriction", "vendor_tmp", "vendor_tmp_notes", "vendor_transaction_type_contract", "vendor_tt_territory_contract", "venue", "video_asset_type", "video_dashboard_item", "video_dashboard_item_status", "video_dashboard_notifications", "video_dashboard_status", "welcome_email", "youtube_audit", "youtube_audit_log", "youtube_audit_release", "youtube_channel", "youtube_channel_access_token", "youtube_channel_activities_q_script_log", "youtube_channel_asset_types", "youtube_channel_category", "youtube_channel_cms_account", "youtube_channel_cms_account_history", "youtube_channel_manually_submitted_video_ids", "youtube_channel_partner_status", "youtube_channel_partner_status_history", "youtube_channel_service_tier", "youtube_channel_service_tier_history", "youtube_channel_upc", "youtube_channel_verify", "youtube_channel_video_category", "youtube_channel_video_status", "youtube_report_generation_log", "zipcodes", ] } variable "art_relations_log_tables_to_sync_to_snowflake" { type = list(string) description = "List of tables to sync to Snnowflake" default = [ "DATABASECHANGELOG", "DATABASECHANGELOGLOCK", "artist_info_log", "concierge_product_log", "mkt_priority_log", "mkt_priority_project_log", "mkt_program_info_log", "product_physical_log", "product_physical_supply_chain_metadata_log", "product_video_log", "project_log", "release_artist_log", "release_subgenre_log", "releases_log", "subaccount_log", "track_instant_grat_log", "track_log", "upcs_log", "vendor_log", "vendor_restricted_features_log", ] } variable "maxwell_neo4j_kinesis_tables_to_sync_to_snowflake" { type = list(string) description = "List of tables to sync to Snnowflake" default = [ "bootstrap", "columns", "databases", "heartbeats", "positions", "schemas", "tables", ] } variable "maxwell_switchboard_tables_to_sync_to_snowflake" { type = list(string) description = "List of tables to sync to Snnowflake" default = [ "bootstrap", "columns", "databases", "heartbeats", "positions", "schemas", "tables", ] } variable "physical_delivery_tables_to_sync_to_snowflake" { type = list(string) description = "List of tables to sync to Snnowflake" default = [ "DATABASECHANGELOG", "DATABASECHANGELOGLOCK", "product_physical_feed_delivery_history", ] } variable "publishing_tables_to_sync_to_snowflake" { type = list(string) description = "List of tables to sync to Snnowflake" default = [ "hfa_invoices", "hfa_invoices_details", "hfa_license_responses", ] } variable "route53_zone" { type = string description = "The name of the Route 53 zone" default = "theorchard.io" } variable "rds_ingress_cidr_blocks" { type = list(string) description = "List of CIDR blocks to allow ingress to the RDS instance" default = [ "10.100.112.0/21", # Vector subnet "10.100.72.0/21", # Vector subnet "10.100.88.0/21", # Vector subnet "10.12.38.0/23", # SME AZURE Windows365 CIDR Block "10.12.242.0/25", # SME AWS Workspaces CIDR Block "162.49.75.0/24", # SME Ashburn Virginia CIDR Block "192.168.32.0/24", "192.168.33.0/24", "192.168.40.0/22", "10.30.0.0/22", "10.40.0.0/22", ] } variable "rds_instance_count" { type = number description = "The number of RDS instances to create" default = 2 } variable "secrets_manager_secret_names" { type = list(string) description = "List of secret names to create in AWS Secrets Manager" default = [ "MYSQL_PASSWORD", ] } # PII KMS key users variable "kms_key_admin_users" { type = set(string) default = [ "rdemoose", "mymac80", ] } variable "kms_key_service_users" { type = set(string) default = [ "prod-art-relations-tin-user", "prod-workstation-user", "prod-oa-user", "prod-cron-user" ] } variable "kms_key_cross_account_iam_user_arns" { type = list(string) default = [ ] } variable "cloudflare_domain_name" { description = "Name of domain" default = "theorchard.com" } variable "additional_tags" { type = map(string) description = "List of tags to apply to Datadog monitors" default = { "map-migrated": "commKNBMDMW06I" } }