variable "roles" { description = "List of objects containing role details" type = list(object({ name = string granted_account_roles = optional(list(string)) granted_database_roles = optional(list(string)) account_level_grants = optional(set(string)) granted_application_roles = optional(set(string)) comment = optional(string, "Managed by Terraform") })) validation { condition = alltrue([ for role in var.roles : can(regex("[[:upper:]]", role.name)) ]) error_message = "Error: Role name must be uppercase." } default = [ { name = "AWAL_RIGHTS_SUPPORT" granted_account_roles = [ "AWAL_DEV_WAREHOUSE_WAREHOUSE_ACCESS", ] granted_database_roles = [ "AWAL.DB_AWAL_TRUST_AND_SAFETY_SCHEMA_READWRITE" ] }, { name = "DEV_ENGINEERING", granted_account_roles = [ "PERMISSIONS_PLATFORM_DB_PROD_SCHEMA_READ", "PERMISSIONS_PLATFORM_DB_QA_SCHEMA_READWRITE", "FANSIFTER_DB_QA_SCHEMA_READWRITE", "S3_INTEGRATIONS_DB_PROD_SCHEMA_READ", "S3_INTEGRATIONS_DB_QA_SCHEMA_READWRITE", "ROYALTY_ACCOUNTING_REPORTING_DB_DEV_SCHEMA_READWRITE", "ROYALTY_ACCOUNTING_REPORTING_DB_QA_SCHEMA_READWRITE", "ROYALTY_ACCOUNTING_REPORTING_DB_UAT_SCHEMA_READWRITE", "ROYALTY_ACCOUNTING_REPORTING_DB_PROD_SCHEMA_READ", "FANSIFTER_DB_PROD_SCHEMA_READ", "PROD_FANSIFTER_FAN_ENGAGEMENT_WAREHOUSE_WAREHOUSE_ACCESS", "ROYALTYACCOUNTING_DB_UAT_SCHEMA_READWRITE", "STREAMLIT_DATA_APPS_WH_WAREHOUSE_ACCESS", "PROD_ACCOUNTING_DBT_WAREHOUSE_WAREHOUSE_ACCESS", "QA_ACCOUNTING_DBT_WAREHOUSE_WAREHOUSE_ACCESS", "BUSINESS_SYSTEMS_SALESFORCE_DATA_DB_READ", "QA_AUTH0_ACCESS_INTEGRATION_USAGE", "PROD_AUTH0_ACCESS_INTEGRATION_USAGE", "DATA_APPS_DELETE_SME_PRODUCT_RL", "PDE_SIGMA_WAREHOUSE_WAREHOUSE_ACCESS", "PROD_SIGMA_DB_READ_WRITE", "INTEGRATION_DB_READ_WRITE", ] granted_database_roles = [ "ORCHARD_APP_REPORTING_V2.DB_QA_DIRECT_DELIVERY_MAXWELL_LOGGING_SCHEMA_READWRITE", "ORCHARD_APP_REPORTING_V2.DB_PROD_DIRECT_DELIVERY_MAXWELL_LOGGING_SCHEMA_READ", "ROYALTY_ACCOUNTING.ROYALTYACCOUNTING_DB_UAT_SCHEMA_READWRITE", "FACTS.DB_PROD_SCHEMA_READ", "FACTS.DB_QA_SCHEMA_READ", "AWAL.DB_AWAL_TRUST_AND_SAFETY_SCHEMA_READWRITE", "DATA_APPS.DB_QA_SCHEMA_DELETE_SME_PRODUCT_STREAMLIT", "DATA_APPS.DB_PROD_SCHEMA_DELETE_SME_PRODUCT_STREAMLIT", "DATA_APPS.DB_READ", "INTEGRATION.DB_DEV_SCHEMA_STREAMLITS_READWRITE", "INTEGRATION.DB_QA_SCHEMA_STREAMLITS_READWRITE", "INTEGRATION.DB_PROD_SCHEMA_STREAMLITS_READWRITE", "SONY_INTERNAL.DB_DEV_SCHEMA_STREAMLITS_READWRITE", "SONY_INTERNAL.DB_QA_SCHEMA_STREAMLITS_READWRITE", "SONY_INTERNAL.DB_PROD_SCHEMA_STREAMLITS_READWRITE", ] }, { name = "PROD_DATADOG_INTEGRATION", granted_account_roles = [ "FACTS_DB_PROD_SCHEMA_READ", "ORCHARDAPPREPORTING_DB_ARTRELATIONS_SCHEMA_READ", "SNOWFLAKE_USAGE", "PROD_DATADOG_WAREHOUSE_WAREHOUSE_ACCESS", ], granted_application_roles = [ "SNOWFLAKE.EVENTS_VIEWER", "SNOWFLAKE.EVENTS_ADMIN", ] }, { name = "PROD_PODCAST_ROLE", granted_database_roles = [ "FACTS.DB_PROD_SCHEMA_APPLE_PODCASTS_CONTENT_PERFORMANCE_TABLE_READ", "FACTS.DB_PROD_SCHEMA_APPLE_PODCASTS_SALES_SUMMARY_TABLE_READ", "FACTS.DB_PROD_SCHEMA_APPLE_PODCASTS_SALES_SUMMARY_MONTHLY_TABLE_READ", "FACTS.DB_PROD_SCHEMA_APPLE_PODCASTS_SALES_SUMMARY_WEEKLY_TABLE_READ", "FACTS.DB_PROD_SCHEMA_APPLE_PODCASTS_SUBSCRIPTION_EVENTS_TABLE_READ", "FACTS.DB_PROD_SCHEMA_APPLE_PODCASTS_SUBSCRIPTION_EVENTS_MONTHLY_TABLE_READ", "FACTS.DB_PROD_SCHEMA_APPLE_PODCASTS_SUBSCRIPTION_EVENTS_WEEKLY_TABLE_READ", "FACTS.DB_PROD_SCHEMA_APPLE_PODCASTS_SUBSCRIPTION_SNAPSHOT_TABLE_READ", "FACTS.DB_PROD_SCHEMA_APPLE_PODCASTS_SUBSCRIPTION_SNAPSHOT_MONTHLY_TABLE_READ", "FACTS.DB_PROD_SCHEMA_APPLE_PODCASTS_SUBSCRIPTION_SNAPSHOT_WEEKLY_TABLE_READ", "FACTS.DB_PROD_SCHEMA_CHARTABLE_PODCAST_METADATA_TABLE_READ", "FACTS.DB_PROD_SCHEMA_CHARTABLE_PODCAST_RANKING_PEAKS_TABLE_READ", "FACTS.DB_PROD_SCHEMA_CHARTABLE_PODCAST_RANKINGS_TABLE_READ", "FACTS.DB_PROD_SCHEMA_CHARTABLE_PODCAST_REVIEWS_TABLE_READ", "FACTS.DB_PROD_SCHEMA_PODCAST_EPISODE_METADATA_VIEW_VIEW_READ", "FACTS.DB_PROD_SCHEMA_PODCAST_PODCAST_METADATA_VIEW_VIEW_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_MEGAPHONE_TABLE_READ", "ORCHARD_APP_REPORTING_V2.DB_PROD_OWS_PODCAST_OWS_PODCAST_SCHEMA_EPISODE_TABLE_READ", "ORCHARD_APP_REPORTING_V2.DB_PROD_OWS_PODCAST_OWS_PODCAST_SCHEMA_NETWORK_TABLE_READ", "ORCHARD_APP_REPORTING_V2.DB_PROD_OWS_PODCAST_OWS_PODCAST_SCHEMA_PODCAST_TABLE_READ", "ORCHARD_APP_REPORTING_V2.DB_PROD_OWS_PODCAST_OWS_PODCAST_SCHEMA_SHOW_FAMILY_TABLE_READ", ] granted_account_roles = [ "DEV_OWS_WAREHOUSE_WAREHOUSE_ACCESS", ] }, { name = "LOOKERADMIN", granted_account_roles = [ "INTELLIGENCE_DB_DBT_PROD_SCHEMA_READ", ] granted_database_roles = [ "AWAL.DB_AWAL_TRUST_AND_SAFETY_SCHEMA_READ", ] }, { name = "OPERATIONS_LOOKER_ROLE" granted_account_roles = [ "OPS_LOOKER_WH_WAREHOUSE_ACCESS", ] granted_database_roles = [ "ORCHARD_APP_REPORTING_V2.DB_READ", "FACTS.DB_READ", ] }, { name = "LOOKER_ADMIN_EXTERNAL", granted_account_roles = [ "ART_RELATIONS_DB_READ", "CHARTMETRIC_DB_RAW_DATA_SCHEMA_READ", "FACTS_DB_PROD_SCHEMA_READ", "FACTS_DB_READ_ONLY", "INTELLIGENCE_DB_PROD_SCHEMA_READ", "INTELLIGENCE_DB_READ_ONLY", "ORCHARDAPPREPORTING_DB_ARTRELATIONS_SCHEMA_READ", "ORCHARDAPPREPORTING_DB_READ_ONLY", "PROD_DB_LOOKERSCRATCH_SCHEMA_READWRITE", "PROD_DB_READ_ONLY", "ROYALTYACCOUNTING_DB_PROD_SCHEMA_READ", "ROYALTY_ACCOUNTING_REPORTING_DB_PROD_SCHEMA_READ", ] }, { name = "MARKETING_INTEGRATIONS_FIVETRAN" granted_account_roles = [ "MARKETING_INTEGRATIONS_DB_READWRITE", "MARKETING_INTEGRATIONS_WAREHOUSE_ACCESS", ] }, { name = "MOMENTS_PIPELINE_ROLE", granted_account_roles = [ "INTELLIGENCE_DB_DBT_PROD_PROJECT_MOMENTS_SCHEMA_READWRITE", "PROD_MOMENTS_WAREHOUSE_ACCESS", ] }, { name = "MONITOR_USAGE_ROLE" account_level_grants = ["MONITOR USAGE"] granted_account_roles = [ "DEV_OWS_WAREHOUSE_WAREHOUSE_ACCESS", "DEV_PERFORMANCE_WAREHOUSE_WAREHOUSE_ACCESS", ] }, { name = "ORCHARD_BIZ_BROWSE", granted_account_roles = [] }, { name = "ORCHARD_YOUTUBE_BROWSE", granted_account_roles = [ "FACTS_DB_PROD_SCHEMA_READ", "INTELLIGENCE_DB_MRI_SCHEMA_READ", "INTELLIGENCE_DB_PROD_SCHEMA_READ", "ORCHARDAPPREPORTING_DB_ARTRELATIONS_SCHEMA_READ", "ORCHARD_YOUTUBE_BROWSE_WAREHOUSE_ACCESS", ] }, { name = "PERMISSIONS_PLATFORM_DB_PROD_SCHEMA_DB_DEPLOY", granted_account_roles = [ "PERMISSIONS_PLATFORM_DB_PROD_SCHEMA_READWRITE", "PROD_OWS_WAREHOUSE_WAREHOUSE_ACCESS", "PROD_ETL_WAREHOUSE_WAREHOUSE_ACCESS", ], account_level_grants = ["EXECUTE TASK"] }, { name = "PERMISSIONS_PLATFORM_DB_QA_SCHEMA_DB_DEPLOY", granted_account_roles = [ "PERMISSIONS_PLATFORM_DB_QA_SCHEMA_READWRITE", "QA_OWS_WAREHOUSE_WAREHOUSE_ACCESS", "QA_ETL_WAREHOUSE_WAREHOUSE_ACCESS", ], account_level_grants = ["EXECUTE TASK"] }, { name = "PROD_DATABRICKS_ROLE" granted_account_roles = [ "DEV_ENGINEERING", "SWF_SME_ANALYTICS_INGEST_DATA_BACKLOAD_WAREHOUSE_ACCESS", ] }, { name = "PROD_DATALYTICS_ROLE" granted_account_roles = [ "APOLLO_DB_DEV_SCHEMA_READ", "ARTRELATIONS_DB_DEV_SCHEMA_READ", "ARTRELATIONS_DB_PROD_SCHEMA_READ", "ART_RELATIONS_DB_READ", "BUSINESS_SYSTEMS_SALESFORCE_DATA_DB_READ", "CAPSTONE_DB_PROD_SCHEMA_READWRITE", "CAPSTONE_DB_QA_SCHEMA_READWRITE", "CHARTMETRIC_DB_RAW_DATA_SCHEMA_READ", "DEV_ANALYTICS_ORCHARD_WAREHOUSE_ACCESS", "DEV_ENGINEERING", "FACTS_DB_PROD_SCHEMA_READ", "FACTS_DB_QA_SCHEMA_READWRITE", "FACTS_DB_READ_ONLY", "FILMTRANSPARENCY_DB_PROD_SCHEMA_READ", "INTELLIGENCE_DB_READ_WRITE", "LOOKER_WH_WAREHOUSE_ACCESS", "LOOKER_WH_EXPLORE_WAREHOUSE_ACCESS", "LOOKER_WH_SONY_WAREHOUSE_ACCESS", "ORCHARDAPPREPORTING_DB_ARTRELATIONS_SCHEMA_READ", "ORCHARDAPPREPORTING_DB_DIRECTDELIVERY_SCHEMA_READ", "ORCHARDAPPREPORTING_DB_MRC_SCHEMA_READ", "ORCHARDAPPREPORTING_DB_READ_ONLY", "OWSCONFLICTMANAGER_DB_PROD_SCHEMA_READWRITE", "OWSCONFLICTMANAGER_DB_QA_SCHEMA_READWRITE", "PPBCOLLECTIONS_DB_READ_ONLY", "PRICING_DB_PROD_SCHEMA_READ", "PROD_DBT", "PROD_DB_BI_SCHEMA_READWRITE", "PROD_DB_EFFECTIVEUNITS_SCHEMA_READWRITE", "PROD_DB_READ_ONLY", "PROD_DB_READ_WRITE", "PROMOPLAYER_DB_PROD_SCHEMA_READ", "QA_ABACUS_WH_ACCESS", "ROYALTYACCOUNTING_DB_QA_SCHEMA_READWRITE", "SALESGOAL_DB_PROD_SCHEMA_READ", "SALESSHEETS_DB_PROD_SCHEMA_READ", "SCHEDULER_JENKINS_WH_WAREHOUSE_ACCESS", "SONYINTERNAL_DB_PROD_SCHEMA_READ", "STMT_DB_READ_ONLY", "PROD_ANALYTICS_ORCHARD_LARGE_WAREHOUSE_ACCESS", "DEV_ANALYTICS_ORCHARD_LARGE_WAREHOUSE_ACCESS", "PIPEDREAM_WAREHOUSE_WAREHOUSE_ACCESS", "PROD_ANALYTICS_ORCHARD_EXTERNAL_WAREHOUSE_ACCESS", "PROD_ANALYTICS_ORCHARD_BACKFILL_WAREHOUSE_ACCESS", "PROD_ANALYTICS_ORCHARD_XL_WAREHOUSE_ACCESS", "PROD_ANALYTICS_ORCHARD_SMALL_WAREHOUSE_ACCESS", "PROD_ANALYTICS_ORCHARD_MEDIUM_WAREHOUSE_ACCESS", "PROD_STRATEGY_ORCHARD_MEDIUM_WAREHOUSE_ACCESS", "PROD_STRATEGY_ORCHARD_LARGE_WAREHOUSE_ACCESS", "PROD_RIGHTS_MGMT_ORCHARD_MEDIUM_WAREHOUSE_ACCESS", "PROD_RIGHTS_MGMT_ORCHARD_LARGE_WAREHOUSE_ACCESS", "PROD_KNR_ORCHARD_LARGE_WAREHOUSE_ACCESS", "PROD_KNR_ORCHARD_MEDIUM_WAREHOUSE_ACCESS", "LOOKER_WH_PUBLISHING_WAREHOUSE_ACCESS", "LOOKER_WH_ACCOUNTING_AGGREGATES_WAREHOUSE_ACCESS", "LOOKER_WH_INTEGRATION_WAREHOUSE_ACCESS", "LOOKER_WH_PDE_WAREHOUSE_ACCESS", "LOOKER_WH_ORCHARD_BIZ_REV_WAREHOUSE_ACCESS", "LOOKER_WH_YOUTUBE_WAREHOUSE_ACCESS", "LOOKER_WH_SONY_PODCASTING_WAREHOUSE_ACCESS", "LOOKER_WH_STRATEGY_WAREHOUSE_ACCESS" ] granted_database_roles = [ "ORCHARD_APP_REPORTING_V2.DB_ART_RELATIONS_PROD_ART_RELATIONS_SCHEMA_qa-business-solutions-automations-s3-stage_STAGE_USAGE", "ORCHARD_APP_REPORTING_V2.DB_ART_RELATIONS_PROD_ART_RELATIONS_SCHEMA_prod-business-solutions-automations-s3-stage_STAGE_USAGE", ] }, { name = "PROD_NEO4J" granted_account_roles = [ "ORCHARDAPPREPORTING_DB_PROD_DB_DEPLOY_ACCESS", "ROYALTYACCOUNTING_DB_PROD_SCHEMA_READ", "ROYALTYACCOUNTING_DB_PROD_SCHEMA_READWRITE", "ROYALTYACCOUNTING_DB_QA_SCHEMA_READ", "ROYALTYACCOUNTING_DB_QA_SCHEMA_READWRITE" ] }, { name = "PROD_LAMBDA_MCC" granted_account_roles = [ "QA_ETL_WAREHOUSE_WAREHOUSE_ACCESS", "PROD_DB_MCC_SCHEMA_READWRITE", ] }, { name = "PROD_OWS_COLLABORATOR", granted_account_roles = [ "FACTS_DB_PROD_SCHEMA_READWRITE", "ORCHARDAPPREPORTING_DB_ARTRELATIONS_SCHEMA_READ", ] granted_database_roles = [ "ORCHARD_APP_REPORTING_V2.DB_ALTAFONTE_ABO_ABO4_PRO_MAIN_SCHEMA_READ", "ORCHARD_APP_REPORTING_V2.DB_PROD_DDEX_INGESTER_DDEX_INGESTER_SCHEMA_READ", "ORCHARD_APP_REPORTING_V2.DB_ART_RELATIONS_PROD_ART_RELATIONS_SCHEMA_READ", "ORCHARD_APP_REPORTING_V2.DB_PROD_OWS_COLLABORATOR_OWS_COLLABORATOR_SCHEMA_READ" ] }, { name = "PROD_FANSIFTER_ANALYST", granted_account_roles = [ "FANSIFTER_DB_PROD_SCHEMA_READWRITE", "QA_PLAYLIST_WAREHOUSE_WAREHOUSE_ACCESS", "PROD_FANSIFTER_FAN_ENGAGEMENT_WAREHOUSE_WAREHOUSE_ACCESS", "FACTS_DB_PROD_SCHEMA_READ", ] granted_database_roles = ["EVENT_DB.DB_READ"] }, { name = "PROD_FIVETRAN" granted_database_roles = [ "ORCHARD_APP_REPORTING_V2.DB_READ", "ORCHARD_APP_REPORTING_V2.DB_CREATE_SCHEMA", "ORCHARD_APP_REPORTING_V2.DB_QA_DIRECT_DELIVERY_MAXWELL_LOGGING_SCHEMA_READWRITE", "ORCHARD_APP_REPORTING_V2.DB_PROD_DIRECT_DELIVERY_MAXWELL_LOGGING_SCHEMA_READWRITE", "SMART.DB_READ", "SMART.DB_CREATE_SCHEMA", ] }, { name = "PROD_OWS_DMP", granted_account_roles = [ "FANSIFTER_DB_PROD_SCHEMA_READWRITE", "MARKETING_INTEGRATIONS_DB_FACEBOOK_ADS_SCHEMA_READ", "PROD_OWS_WAREHOUSE_WAREHOUSE_ACCESS", ] }, { name = "PROD_PP", granted_account_roles = [ "PERMISSIONS_PLATFORM_DB_PROD_SCHEMA_READWRITE", "PROD_OWS_WAREHOUSE_WAREHOUSE_ACCESS", ] }, { name = "PROD_PP_ETL", granted_account_roles = [ "PERMISSIONS_PLATFORM_DB_PROD_SCHEMA_READWRITE", "PROD_ETL_WAREHOUSE_WAREHOUSE_ACCESS", ] }, { name = "QA_OWS_COLLABORATOR", granted_account_roles = [ "FACTS_DB_QA_SCHEMA_READWRITE", "ORCHARDAPPREPORTING_DB_ARTRELATIONS_SCHEMA_READ", ] granted_database_roles = [ "ORCHARD_APP_REPORTING_V2.DB_ALTAFONTE_ABO_ABO4_PRO_MAIN_SCHEMA_READ", "ORCHARD_APP_REPORTING_V2.DB_PROD_DDEX_INGESTER_DDEX_INGESTER_SCHEMA_READ", "ORCHARD_APP_REPORTING_V2.DB_ART_RELATIONS_PROD_ART_RELATIONS_SCHEMA_READ", "ORCHARD_APP_REPORTING_V2.DB_QA_OWS_COLLABORATOR_OWS_COLLABORATOR_SCHEMA_READ" ] }, { name = "QA_OWS_DMP", granted_account_roles = [ "FANSIFTER_DB_QA_SCHEMA_READWRITE", "MARKETING_INTEGRATIONS_DB_FACEBOOK_ADS_SCHEMA_READ", "QA_OWS_WAREHOUSE_WAREHOUSE_ACCESS", ] }, { name = "QA_PP", granted_account_roles = [ "PERMISSIONS_PLATFORM_DB_QA_SCHEMA_READWRITE", "QA_OWS_WAREHOUSE_WAREHOUSE_ACCESS", ] }, { name = "QA_PP_ETL", granted_account_roles = [ "PERMISSIONS_PLATFORM_DB_QA_SCHEMA_READWRITE", "QA_ETL_WAREHOUSE_WAREHOUSE_ACCESS", ] }, { name = "SAGEMAKER", granted_account_roles = [ "CHARTMETRIC_DB_RAW_DATA_SCHEMA_READ", "DEV_ENGINEERING", "DEV_ENGINEERING_DB_READ", "SAGEMAKER_WAREHOUSE_ACCESS", "FACTS_DB_PROD_SCHEMA_READ", "INTELLIGENCE_DB_READ_ONLY", ] }, { name = "BUDGET_ADMIN", granted_account_roles = [ "BUDGET_DB_DB_READWRITE", ], }, { name = "YOUTUBE_REPORTING" granted_account_roles = [ "ACCOUNT_REPORTING_READONLY", "PROD_DB_READ_ONLY", ], }, { name = "QA_ACCOUNTING_DBT_SCHEDULER" granted_account_roles = [ "ROYALTYACCOUNTING_DB_QA_SCHEMA_READ", "ROYALTYACCOUNTING_DB_QA_SCHEMA_READWRITE", "ROYALTY_ACCOUNTING_DB_CREATE_SCHEMA", "QA_DBT_WAREHOUSE_WAREHOUSE_ACCESS", "QA_ACCOUNTING_DBT_WAREHOUSE_WAREHOUSE_ACCESS", ] }, { name = "PROD_ACCOUNTING_DBT_SCHEDULER" granted_account_roles = [ "ROYALTYACCOUNTING_DB_PROD_SCHEMA_READ", "ROYALTYACCOUNTING_DB_PROD_SCHEMA_READWRITE", "PROD_DBT_WAREHOUSE_WAREHOUSE_ACCESS", "PROD_ACCOUNTING_DBT_WAREHOUSE_WAREHOUSE_ACCESS", ] }, { name = "QA_CONFLICT_MANAGER_ES_SYNC_DB_PASSWORD" granted_account_roles = [ "FACTS_DB_QA_SCHEMA_READWRITE", "OWSCONFLICTMANAGER_DB_QA_SCHEMA_READ" ] }, { name = "PROD_CONFLICT_MANAGER_ES_SYNC_DB_PASSWORD" granted_account_roles = [ "FACTS_DB_PROD_SCHEMA_READWRITE", "OWSCONFLICTMANAGER_DB_PROD_SCHEMA_READ" ] }, { name = "BUSINESS_SYSTEMS_SALESFORCE_DATA_QA_SCHEMA_READWRITE_DB_DEPLOY", granted_account_roles = [ "BUSINESS_SYSTEMS_SALESFORCE_DATA_DB_QA_SCHEMA_READWRITE", "QA_OWS_WAREHOUSE_WAREHOUSE_ACCESS" ], account_level_grants = ["EXECUTE TASK"] }, { name = "BUSINESS_SYSTEMS_SALESFORCE_DATA_PROD_SCHEMA_READWRITE_DB_DEPLOY", granted_account_roles = [ "BUSINESS_SYSTEMS_SALESFORCE_DATA_DB_PROD_SCHEMA_READWRITE", "PROD_OWS_WAREHOUSE_WAREHOUSE_ACCESS" ], account_level_grants = ["EXECUTE TASK"] }, { name = "SME_SNOWFLAKE_DEV" granted_account_roles = [ "FACTS_DB_READ_ONLY", "PROD_DB_READ_ONLY", "SME_DEV_WAREHOUSE_WAREHOUSE_ACCESS" ] }, { name = "QA_LAMBDA_CONTENT_REVIEW_QUEUE_CLEANUP" granted_account_roles = [ "ORCHARDAPPREPORTING_DB_ARTRELATIONS_SCHEMA_READWRITE", "ORCHARDAPPREPORTING_DB_PROD_CONTENT_REVIEW_SCHEMA_READWRITE" ] }, { name = "PROD_LAMBDA_CONTENT_REVIEW_QUEUE_CLEANUP" granted_account_roles = [ "ORCHARDAPPREPORTING_DB_ARTRELATIONS_SCHEMA_READWRITE", "ORCHARDAPPREPORTING_DB_PROD_CONTENT_REVIEW_SCHEMA_READWRITE", "PROD_OWS_WAREHOUSE_WAREHOUSE_ACCESS", "PROD_ETL_WAREHOUSE_WAREHOUSE_ACCESS" ] }, { name = "QA_SWF_COLLABORATOR_REPORT" granted_account_roles = [ "FACTS_DB_QA_SCHEMA_READ", "FACTS_DB_PROD_SCHEMA_READ", "FACTS_DB_QA_SCHEMA_READWRITE", "ROYALTYACCOUNTING_DB_QA_SCHEMA_READ", "ROYALTYACCOUNTING_DB_PROD_SCHEMA_READ", "S3_INTEGRATIONS_DB_QA_SCHEMA_READ", ] }, { name = "PROD_SWF_COLLABORATOR_REPORT" granted_account_roles = [ "FACTS_DB_QA_SCHEMA_READ", "FACTS_DB_QA_SCHEMA_READWRITE", "ROYALTYACCOUNTING_DB_QA_SCHEMA_READ", "S3_INTEGRATIONS_DB_PROD_SCHEMA_READ", ] }, { name = "PROD_SNOWFLAKE_ETL" granted_account_roles = [ "PROD_ETL_WAREHOUSE_WAREHOUSE_ACCESS", "STMTDB_DB_PROD_SCHEMA_READWRITE" ] }, { name = "ROYALTY_ACCOUNTING_DB_UAT_SCHEMA_DB_DEPLOY", granted_account_roles = [ "DEPLOY_WAREHOUSE_WAREHOUSE_ACCESS", "FACTS_DB_QA_SCHEMA_READ", "FACTS_DB_PROD_SCHEMA_READ", "PROD_FIVETRAN_WAREHOUSE_WAREHOUSE_ACCESS", # Required for creation of dynamic tables "INTELLIGENCE_DB_PROD_SCHEMA_READ", ], granted_database_roles = [ "ORCHARD_APP_REPORTING_V2.DB_READ", "ROYALTY_ACCOUNTING.ROYALTYACCOUNTING_DB_UAT_SCHEMA_READWRITE", ] }, { name = "ROYALTY_ACCOUNTING_REPORTING_DB_PROD_SCHEMA_DB_DEPLOY", granted_account_roles = [ "ROYALTY_ACCOUNTING_REPORTING_DB_PROD_SCHEMA_READWRITE", "ROYALTYACCOUNTING_DB_PROD_SCHEMA_READ", "DEPLOY_WAREHOUSE_WAREHOUSE_ACCESS" ] }, { name = "ROYALTY_ACCOUNTING_REPORTING_DB_UAT_SCHEMA_DB_DEPLOY", granted_account_roles = [ "ROYALTY_ACCOUNTING_REPORTING_DB_UAT_SCHEMA_READWRITE", "ROYALTYACCOUNTING_DB_UAT_SCHEMA_READ", "DEPLOY_WAREHOUSE_WAREHOUSE_ACCESS", "INTELLIGENCE_DB_PROD_SCHEMA_READ", ], granted_database_roles = [ "ORCHARD_APP_REPORTING_V2.DB_ART_RELATIONS_PROD_ART_RELATIONS_SCHEMA_READ" ] }, { name = "ROYALTY_ACCOUNTING_REPORTING_DB_QA_SCHEMA_DB_DEPLOY", granted_account_roles = [ "ROYALTY_ACCOUNTING_REPORTING_DB_QA_SCHEMA_READWRITE", "ROYALTYACCOUNTING_DB_QA_SCHEMA_READ", "DEPLOY_WAREHOUSE_WAREHOUSE_ACCESS", ] }, { name = "QA_BFF_MOBILE" granted_account_roles = [ "FACTS_DB_QA_SCHEMA_READ", "APOLLO_DB_DEV_SCHEMA_READ", "CHARTMETRIC_DB_RAW_DATA_SCHEMA_READ" ] }, { name = "PROD_BFF_MOBILE" granted_account_roles = [ "FACTS_DB_PROD_SCHEMA_READ", "APOLLO_DB_DEV_SCHEMA_READ", "CHARTMETRIC_DB_RAW_DATA_SCHEMA_READ" ] }, { name = "PROD_QA_AUTOMATION" granted_account_roles = [ "PROD_QA_AUTOMATION_WAREHOUSE_WAREHOUSE_ACCESS" ] granted_database_roles = [ # "ORCHARD_APP_REPORTING_V2.DB_GRPS_EXP_SCHEMA_GRAS_TRACK_TABLE_READ", # "ORCHARD_APP_REPORTING_V2.DB_GRPS_EXP_SCHEMA_GRAS_PRODUCT_TABLE_READ", # "ORCHARD_APP_REPORTING_V2.DB_GRPS_EXP_SCHEMA_GRAS_PRODUCT_TRACK_TABLE_READ", "ORCHARD_APP_REPORTING_V2.DB_PROD_INTEGRATIONS_BULK_UPLOAD_SCHEMA_INGESTION_TRACK_LOG_TABLE_READ", "FACTS.DB_PROD_SCHEMA_SME_LABELCOPY_INGEST_TABLE_READ", "FACTS.DB_PROD_SCHEMA_DIM_TRACK_TABLE_READ", "FACTS.DB_PROD_SCHEMA_ISRC_AVAILABILITY_TEST_RESULTS_TABLE_READWRITE" ] }, { name = "QA_QA_AUTOMATION" granted_database_roles = [ "FACTS.DB_QA_SCHEMA_ISRC_AVAILABILITY_TEST_RESULTS_TABLE_READWRITE" ] }, { name = "CYPRESS_TESTS" granted_database_roles = [ "ORCHARD_APP_REPORTING_V2.DB_PROD_OWS_TIMED_RELEASE_OWS_TIMED_RELEASE_SCHEDULE_SCHEMA_TIMED_RELEASE_TABLE_READ", "ORCHARD_APP_REPORTING_V2.DB_ART_RELATIONS_PROD_ART_RELATIONS_SCHEMA_RELEASES_TABLE_READ", "ORCHARD_APP_REPORTING_V2.DB_QA_SCHEMA_TIMED_RELEASES_STORE_LINKS_TABLE_READWRITE", "ORCHARD_APP_REPORTING_V2.DB_PROD_OWS_TIMED_RELEASE_OWS_TIMED_RELEASE_SCHEDULE_SCHEMA_TIMED_RELEASES_STORE_LINKS_TABLE_READWRITE", "ROYALTY_ACCOUNTING.DB_TEST_SCHEMA_E2E_ACC_RUN_STMT_DB_SALES_DISTRO_STAGING_TABLE_READ" ] }, { name = "FACTS_DB_QA_SCHEMA_AUDIT_RW", granted_account_roles = [ "DEV_OWS_WAREHOUSE_WAREHOUSE_ACCESS" ], granted_database_roles = [ "FACTS.DB_QA_SCHEMA_JOB_RUN_EVENTS_TABLE_READWRITE", "FACTS.DB_QA_SCHEMA_REPORT_RUN_EVENTS_TABLE_READWRITE", "FACTS.DB_QA_SCHEMA_JOB_DATA_EVENTS_TABLE_READWRITE", "FACTS.DB_QA_SCHEMA_REPORT_DATA_EVENTS_TABLE_READWRITE", "FACTS.DB_QA_SCHEMA_AUDIT_RUN_TABLE_READWRITE", ] }, { name = "CHARTMETRIC_RAW_DATA_ACCESS" granted_account_roles = [ "CHARTMETRIC_DB_RAW_DATA_SCHEMA_READ", "DEV_OWS_WAREHOUSE_WAREHOUSE_ACCESS", ] }, { name = "PROD_RDS_REFRESH" granted_database_roles = [ "ROYALTY_ACCOUNTING.ROYALTYACCOUNTING_DB_DEV_SCHEMA_READWRITE", "ROYALTY_ACCOUNTING.ROYALTYACCOUNTING_DB_QA_SCHEMA_READWRITE", "ROYALTY_ACCOUNTING.ROYALTYACCOUNTING_DB_UAT_SCHEMA_READWRITE", "ROYALTY_ACCOUNTING.ROYALTYACCOUNTING_DB_PROD_SCHEMA_READ", ] granted_account_roles = [ "ROYALTYACCOUNTING_DB_PROD_SCHEMA_READ", "ROYALTYACCOUNTING_DB_DEV_SCHEMA_READWRITE", "ROYALTYACCOUNTING_DB_QA_SCHEMA_READWRITE", ] }, { name = "DEV_ROYALTY_ACCOUNTING_REFRESH" granted_account_roles = [ "ROYALTYACCOUNTING_DB_PROD_SCHEMA_READ", "ROYALTYACCOUNTING_DB_DEV_SCHEMA_READWRITE", ] }, { name = "QA_ROYALTY_ACCOUNTING_REFRESH" granted_account_roles = [ "ROYALTYACCOUNTING_DB_PROD_SCHEMA_READ", "ROYALTYACCOUNTING_DB_QA_SCHEMA_READWRITE", ] }, { name = "UAT_ROYALTY_ACCOUNTING_REFRESH" granted_account_roles = [ "ROYALTYACCOUNTING_DB_PROD_SCHEMA_READ", "ROYALTYACCOUNTING_DB_UAT_SCHEMA_READWRITE", ] }, { name = "AWAL_AR_STREAMLIT_READ" granted_database_roles = [ "AWAL.DB_AWAL_AR_SCHEMA_READ", ], granted_account_roles = [ "AWAL_AR_WH_WAREHOUSE_ACCESS", ] }, { name = "AWAL_DB_PROD_SCHEMA_READWRITE", granted_database_roles = [ "AWAL.DB_AWAL_AR_SCHEMA_READWRITE", "AWAL.DB_AWAL_TRUST_AND_SAFETY_SCHEMA_READWRITE", ], granted_account_roles = [ "AWAL_AR_WH_WAREHOUSE_ACCESS", ] }, { name = "SALESFORCE_CA_READ", granted_database_roles = [], granted_account_roles = [ "FACTS_DB_PROD_SCHEMA_READ", "FACTS_DB_READ_ONLY", "INTELLIGENCE_DB_READ_WRITE", "BUSINESS_SYSTEMS_SALESFORCE_DATA_DB_READ", "PROD_DB_READ_ONLY", ] }, { name = "FACTS_DEV_ML_READWRITE", granted_database_roles = [ "FACTS.DB_DEV_SCHEMA_MODELS_READWRITE", "FACTS.DB_QA_SCHEMA_MODELS_READ", "FACTS.DB_PROD_SCHEMA_MODELS_READ", "FACTS.DB_DEV_SCHEMA_READWRITE", ], granted_account_roles = [ "DEV_ENGINEERING", "DEV_OWS_WAREHOUSE_WAREHOUSE_ACCESS", "SNOWFLAKE_NOTEBOOKS_WAREHOUSE_WAREHOUSE_ACCESS", "FACTS_DB_DEV_REPOSITORY_READWRITE", "FACTS_DB_FEATURE_STORE_ROLE_PRODUCER", "FACTS_DB_FEATURE_STORE_ROLE_CONSUMER", "INTELLIGENCE_DB_READ_WRITE", ] }, { name = "FACTS_DB_QA_SCHEMA_READWRITE", granted_account_roles = [ "PROD_DB_QA_YT_REPORTS_API_SCHEMA_READWRITE", ], granted_database_roles = [ "FACTS.DB_DEV_SCHEMA_MODELS_READWRITE", "FACTS.DB_QA_SCHEMA_MODELS_READWRITE", "FACTS.DB_QA_SCHEMA_READWRITE", ], }, { name = "FACTS_DB_PROD_SCHEMA_READWRITE", granted_database_roles = [ "FACTS.DB_DEV_SCHEMA_MODELS_READWRITE", "FACTS.DB_QA_SCHEMA_MODELS_READWRITE", "FACTS.DB_PROD_SCHEMA_MODELS_READWRITE", "FACTS.DB_PROD_SCHEMA_READWRITE", ], }, { name = "QA_OWS_ANALYTICS", granted_account_roles = [ "QA_INSIGHTS_WAREHOUSE_WAREHOUSE_ACCESS" ] }, { name = "PROD_OWS_ANALYTICS", granted_account_roles = [ "PROD_INSIGHTS_WAREHOUSE_WAREHOUSE_ACCESS", "PROD_INSIGHTS_PLAYLISTS_WAREHOUSE_WAREHOUSE_ACCESS" ] }, { name = "PROD_DATALYTICS_NON_TECH_READONLY_ROLE", granted_account_roles = [ "FACTS_DB_PROD_SCHEMA_READ", "INTELLIGENCE_DB_MRI_SCHEMA_READ", "INTELLIGENCE_DB_PROD_SCHEMA_READ", "INTELLIGENCE_DB_QA_SCHEMA_READ", "PERFORMANCE_RIGHTS_SALES_DB_PROD_SCHEMA_READ", "PERFORMANCE_RIGHTS_SALES_DB_QA_SCHEMA_READ", ] granted_database_roles = [ "AWAL.DB_AWAL_TRUST_AND_SAFETY_SCHEMA_READ", ], }, { name = "AWAL", comment = "Role used by AWAL users SYS-19699", granted_database_roles = [ "AWAL.DB_AWAL_TRUST_AND_SAFETY_SCHEMA_READ", ], }, { name = "BI_TEAM_ROLE", granted_account_roles = [ "FACTS_DB_PROD_SCHEMA_READ" ], granted_database_roles = [ "AWAL.DB_AWAL_TRUST_AND_SAFETY_SCHEMA_READ", ], }, { name = "UAT_LAMBDA_DOCUMENTS_READ", granted_account_roles = [ "ROYALTYACCOUNTING_DB_UAT_SCHEMA_READ", "UAT_OWS_WAREHOUSE_WAREHOUSE_ACCESS" ], granted_database_roles = [ "ORCHARD_APP_REPORTING_V2.DB_UAT_ROYALTY_ACCOUNTING_ROYALTY_ACCOUNTING_SCHEMA_READ" ] }, { name = "PROD_KAFKA_CONNECT_JDBC_SOURCE_TRACK_FINGERPRINT_RULES_SYNC", granted_account_roles = [ "FACTS_DB_PROD_SCHEMA_READ" ], granted_database_roles = [ "ORCHARD_APP_REPORTING_V2.DB_ART_RELATIONS_PROD_ART_RELATIONS_SCHEMA_READ" ] }, { name = "QA_KAFKA_CONNECT_JDBC_SOURCE_TRACK_FINGERPRINT_RULES_SYNC", granted_account_roles = [ "FACTS_DB_QA_SCHEMA_READ" ], granted_database_roles = [ "ORCHARD_APP_REPORTING_V2.DB_ART_RELATIONS_PROD_ART_RELATIONS_SCHEMA_READ" ] }, { name = "SONY_INTERNAL_PROD", granted_account_roles = [ "PRICING_DB_PROD_SCHEMA_READ", "SONYINTERNAL_DB_PROD_SCHEMA_READWRITE" ], granted_database_roles = [ "ORCHARD_APP_REPORTING_V2.DB_GRPS_EXP_SCHEMA_READ", "ORCHARD_APP_REPORTING_V2.DB_PROD_ROYALTY_ACCOUNTING_ROYALTY_ACCOUNTING_SCHEMA_READ", "ROYALTY_ACCOUNTING.ROYALTYACCOUNTING_DB_PROD_SCHEMA_READ", ] }, { name = "SONY_INTERNAL_QA", granted_account_roles = [ "SONYINTERNAL_DB_QA_SCHEMA_READWRITE" ], granted_database_roles = [ "ORCHARD_APP_REPORTING_V2.DB_GRPS_EXP_SCHEMA_READ", "ORCHARD_APP_REPORTING_V2.DB_QA_ROYALTY_ACCOUNTING_ROYALTY_ACCOUNTING_SCHEMA_READ", "ROYALTY_ACCOUNTING.ROYALTYACCOUNTING_DB_QA_SCHEMA_READ", ] }, { name = "UAT_LAMBDA_ROYALTY_ACCOUNTING" granted_account_roles = [ "ROYALTYACCOUNTING_DB_UAT_SCHEMA_READWRITE", "UAT_ABACUS_WH_WAREHOUSE_ACCESS" ] granted_database_roles = [ "FACTS.DB_PROD_SCHEMA_READ", "ORCHARD_APP_REPORTING_V2.DB_READ" ] }, { name = "UAT_OWS_ROYALTIES_WORKFLOW" granted_account_roles = [ "ROYALTYACCOUNTING_DB_UAT_SCHEMA_READWRITE", "UAT_ABACUS_WH_WAREHOUSE_ACCESS" ] granted_database_roles = [ "FACTS.DB_PROD_SCHEMA_READ", "ORCHARD_APP_REPORTING_V2.DB_READ" ] }, { name = "S3_INTEGRATIONS_ROYALTYSHARE_EXPORT_ROLE" granted_account_roles = [ "ROYALTYSHARE_DB_QA_SCHEMA_READWRITE", "ROYALTYSHARE_DB_PROD_SCHEMA_READ" ] granted_database_roles = [ "FACTS.DB_PROD_SCHEMA_royaltyshare_facts_export_STAGE_USAGE", "ROYALTY_ACCOUNTING.DB_PROD_SCHEMA_royaltyshare_royalty_accounting_export_STAGE_USAGE" ] }, { name = "TEMP_STATEMENTDB_SERVICE_ROLE" granted_account_roles = [ "TEMP_STATEMENTDB_WAREHOUSE_WAREHOUSE_ACCESS" ] granted_database_roles = [ "TEMP_STATEMENTDB.DB_READWRITE", ] }, { name = "PROD_SIGMA_SERVICE_ROLE" granted_account_roles = [ "PROD_SIGMA_WAREHOUSE_WAREHOUSE_ACCESS", "ORCHARDAPPREPORTING_DB_ARTRELATIONS_SCHEMA_READ", "ORCHARDAPPREPORTING_DB_READ_ONLY", "CHARTMETRIC_DB_RAW_DATA_SCHEMA_READ", "SONYINTERNAL_DB_PROD_SCHEMA_READ", "SONYINTERNAL_DB_QA_SCHEMA_READ", "SONYINTERNAL_DB_DEV_SCHEMA_READ", "INTEGRATION_DB_READ_ONLY", "ROYALTYACCOUNTING_DB_PROD_SCHEMA_READ", "STMT_DB_READ_ONLY", "INTELLIGENCE_DB_READ_ONLY", "INTELLIGENCE_DB_DBT_PROD_SCHEMA_READ", "FACTS_DB_PROD_SCHEMA_READ", "SONY_INTERNAL_DEV", "ROYALTYACCOUNTING_DB_QA_SCHEMA_READ", "SNOWFLAKE_USAGE", ] granted_database_roles = [ "FACTS.DB_PROD_SCHEMA_IDENTITY_TABLE_READ", "ORCHARD_APP_REPORTING_V2.DB_READ", "SEGMENT_EVENTS.DB_READ", "SIGMA.DB_PROD_SCHEMA_READWRITE", ] }, { name = "PROD_SIGMA_DB_READ_WRITE" granted_account_roles = [ "PROD_SIGMA_WAREHOUSE_WAREHOUSE_ACCESS", ] granted_database_roles = [ "SIGMA.DB_PROD_SCHEMA_READWRITE", ] }, { name = "DEV_FIVETRAN" granted_account_roles = [ "DEV_OWS_WAREHOUSE_WAREHOUSE_ACCESS", "SONYMETADATA_DB_DEV_SCHEMA_READWRITE", ] }, { name = "ORCHARD_ANALYTICS_TABLEAU_ROLE" granted_account_roles = [ "INTELLIGENCE_DB_READ_ONLY", "PROD_ANALYTICS_ORCHARD_TABLEAU_WAREHOUSE_ACCESS", ] }, { name = "SNOWFLAKE_INTELLIGENCE_ADMIN_RL" granted_account_roles = [ "SNOWFLAKE_INTELLIGENCE_MODELING_RL", "SNOWFLAKE_INTELLIGENCE_WH_WAREHOUSE_ACCESS", ] granted_database_roles = [ "FACTS.DB_PROD_SCHEMA_READ" ] }, { name = "SNOWFLAKE_INTELLIGENCE_MODELING_RL" granted_account_roles = [ "SNOWFLAKE_INTELLIGENCE_RO_RL", "SNOWFLAKE_INTELLIGENCE_WH_WAREHOUSE_ACCESS", ] }, { name = "SNOWFLAKE_INTELLIGENCE_RO_RL" granted_account_roles = [ "SNOWFLAKE_INTELLIGENCE_WH_WAREHOUSE_ACCESS", ] }, { name = "DATA_APPS_DELETE_SME_PRODUCT_RL" granted_account_roles = [ "STREAMLIT_DATA_APPS_WH_WAREHOUSE_ACCESS", "QA_AUTH0_ACCESS_INTEGRATION_USAGE", "PROD_AUTH0_ACCESS_INTEGRATION_USAGE", "QA_LAMBDA_CONTENT_DELETE_PRODUCT_INTEGRATION_USAGE", "PROD_LAMBDA_CONTENT_DELETE_PRODUCT_INTEGRATION_USAGE", ] granted_database_roles = [ "DATA_APPS.DB_READWRITE", "ORCHARD_APP_REPORTING_V2.DB_ART_RELATIONS_PROD_ART_RELATIONS_SCHEMA_READ" ] }, { name = "QA_SWF_YOUTUBE_ASSET_CONFLICT" granted_account_roles = [ "ARTRELATIONS_DB_PROD_SCHEMA_READ", "FACTS_DB_QA_SCHEMA_READWRITE", "ORCHARDAPPREPORTING_DB_ARTRELATIONS_SCHEMA_READ" ] }, { name = "PROD_DB_QA_YT_REPORTS_API_SCHEMA_READWRITE" granted_account_roles = [ "QA_ETL_WAREHOUSE_WAREHOUSE_ACCESS" ] }, { name = "CORTEX_USER_ROLE" granted_account_roles = [ "ORCHARDAPPREPORTING_DB_ARTRELATIONS_SCHEMA_READ" ] }, { name = "QA_LAMBDA_SR_ACK_PROCESSOR" granted_account_roles = [ "DEV_OWS_WAREHOUSE_WAREHOUSE_ACCESS", ] granted_database_roles = [ "FACTS.DB_QA_SCHEMA_READWRITE", ] }, { name = "SME_DATA_INSIGHTS", granted_database_roles = [ "FACTS.DB_PROD_SCHEMA_APPLE_ID_MAPPING_TABLE_READ", "FACTS.DB_PROD_SCHEMA_COMPANY_BRAND_TABLE_READ", "FACTS.DB_PROD_SCHEMA_COMPANY_BRAND_BELONGS_TO_PARENT_COMPANY_TABLE_READ", "FACTS.DB_PROD_SCHEMA_COMPANY_BRAND_HAS_LABEL_VENDOR_TABLE_READ", "FACTS.DB_PROD_SCHEMA_DIM_CHART_TABLE_READ", "FACTS.DB_PROD_SCHEMA_DIM_CONTAINERTYPE_TABLE_READ", "FACTS.DB_PROD_SCHEMA_DIM_CONTINENT_TABLE_READ", "FACTS.DB_PROD_SCHEMA_DIM_DEVICE_TABLE_READ", "FACTS.DB_PROD_SCHEMA_DIM_FEED_TABLE_READ", "FACTS.DB_PROD_SCHEMA_DIM_GLOBAL_PARTICIPANT_TABLE_READ", "FACTS.DB_PROD_SCHEMA_DIM_IMPRINT_TABLE_READ", "FACTS.DB_PROD_SCHEMA_DIM_ISRC_TABLE_READ", "FACTS.DB_PROD_SCHEMA_DIM_LABEL_PARTICIPANT_TABLE_READ", "FACTS.DB_PROD_SCHEMA_DIM_LICENSOR_TABLE_READ", "FACTS.DB_PROD_SCHEMA_DIM_NEW_MUSIC_FRIDAY_CHART_TABLE_READ", "FACTS.DB_PROD_SCHEMA_DIM_OS_TABLE_READ", "FACTS.DB_PROD_SCHEMA_DIM_OWNER_TABLE_READ", "FACTS.DB_PROD_SCHEMA_DIM_PHYSICAL_WAREHOUSE_TABLE_READ", "FACTS.DB_PROD_SCHEMA_DIM_PLATFORM_TABLE_READ", "FACTS.DB_PROD_SCHEMA_DIM_PLAYBACK_TABLE_READ", "FACTS.DB_PROD_SCHEMA_DIM_PLAYLIST_TABLE_READ", "FACTS.DB_PROD_SCHEMA_DIM_PROJECT_TABLE_READ", "FACTS.DB_PROD_SCHEMA_DIM_PUBLIC_TRACK_TABLE_READ", "FACTS.DB_PROD_SCHEMA_DIM_SHARINGSERVICE_TABLE_READ", "FACTS.DB_PROD_SCHEMA_DIM_SOURCETYPE_TABLE_READ", "FACTS.DB_PROD_SCHEMA_DIM_SUBGENRE_TABLE_READ", "FACTS.DB_PROD_SCHEMA_DIM_SUBSCRIPTIONPAYTIER_TABLE_READ", "FACTS.DB_PROD_SCHEMA_DIM_SUBSCRIPTIONTYPE_TABLE_READ", "FACTS.DB_PROD_SCHEMA_DIM_TRACK_TABLE_READ", "FACTS.DB_PROD_SCHEMA_DIM_TRACK_ARTIST_TABLE_READ", "FACTS.DB_PROD_SCHEMA_DIM_TRACK_CLEAN_MV_TABLE_READ", "FACTS.DB_PROD_SCHEMA_DIM_TRAFFICSOURCE_TABLE_READ", "FACTS.DB_PROD_SCHEMA_DIM_TRANSACTIONGROUP_TABLE_READ", "FACTS.DB_PROD_SCHEMA_DIM_UPPER_PROFIT_CENTER_TABLE_READ", "FACTS.DB_PROD_SCHEMA_DIM_USER_TABLE_READ", "FACTS.DB_PROD_SCHEMA_DIM_YOUTUBE_CHANNEL_NAMES_TABLE_READ", "FACTS.DB_PROD_SCHEMA_DIM_ZIP_TABLE_READ", "FACTS.DB_PROD_SCHEMA_FACT_ANALYTICS_TABLE_READ", "FACTS.DB_PROD_SCHEMA_FACT_ANALYTICS_ERROR_TABLE_READ", "FACTS.DB_PROD_SCHEMA_FACT_CHARTS_TABLE_READ", "FACTS.DB_PROD_SCHEMA_FACT_MARKET_SHARE_TABLE_READ", "FACTS.DB_PROD_SCHEMA_FACT_NEW_MUSIC_FRIDAY_AVAILABILITY_TABLE_READ", "FACTS.DB_PROD_SCHEMA_FACT_SOCIAL_TABLE_READ", "FACTS.DB_PROD_SCHEMA_FACT_SOCIALS_TABLE_READ", "FACTS.DB_PROD_SCHEMA_FACT_YOUTUBE_ASSET_ANALYTICS_TABLE_READ", "FACTS.DB_PROD_SCHEMA_FACT_YOUTUBE_ASSET_ANALYTICS_ERROR_TABLE_READ", "FACTS.DB_PROD_SCHEMA_FACT_YOUTUBE_ASSET_DEMOGRAPHICS_TABLE_READ", "FACTS.DB_PROD_SCHEMA_FACT_YOUTUBE_VIDEO_ANALYTICS_TABLE_READ", "FACTS.DB_PROD_SCHEMA_FACT_YOUTUBE_VIDEO_DEMOGRAPHICS_TABLE_READ", "FACTS.DB_PROD_SCHEMA_GLOBAL_PARTICIPANT_TABLE_READ", "FACTS.DB_PROD_SCHEMA_GLOBAL_PARTICIPANT_MERGED_TO_GLOBAL_PARTICIPANT_TABLE_READ", "FACTS.DB_PROD_SCHEMA_GLOBAL_PARTICIPANT_REPRESENTS_LABEL_PARTICIPANT_TABLE_READ", "FACTS.DB_PROD_SCHEMA_GLOBAL_PARTICIPANT_REPRESENTS_PUBLIC_PARTICIPANT_TABLE_READ", "FACTS.DB_PROD_SCHEMA_GLOBAL_SOUND_RECORDING_TABLE_READ", "FACTS.DB_PROD_SCHEMA_GLOBAL_SOUND_RECORDING_REPRESENTS_LABEL_SOUND_RECORDING_TABLE_READ", "FACTS.DB_PROD_SCHEMA_GLOBAL_SOUND_RECORDING_REPRESENTS_PUBLIC_SOUND_RECORDING_TABLE_READ", "FACTS.DB_PROD_SCHEMA_HAS_LABEL_PARTICIPANT_TABLE_READ", "FACTS.DB_PROD_SCHEMA_IODA_RELEASE_MAPPING_TABLE_READ", "FACTS.DB_PROD_SCHEMA_IODA_TRACK_MAPPING_TABLE_READ", "FACTS.DB_PROD_SCHEMA_IODA_TV_MAPPING_TABLE_READ", "FACTS.DB_PROD_SCHEMA_IODA_VIDEO_MAPPING_TABLE_READ", "FACTS.DB_PROD_SCHEMA_ISRC_TO_LABEL_PARTICIPANT_MAPPING_TABLE_READ", "FACTS.DB_PROD_SCHEMA_ITUNES_TICKET_DEFECT_CODES_TABLE_READ", "FACTS.DB_PROD_SCHEMA_ITUNES_TICKET_NOTES_TABLE_READ", "FACTS.DB_PROD_SCHEMA_ITUNES_TICKETS_TABLE_READ", "FACTS.DB_PROD_SCHEMA_LABEL_PARTICIPANT_TABLE_READ", "FACTS.DB_PROD_SCHEMA_LABEL_PARTICIPANT_PARTICIPATED_IN_ORCHARD_PRODUCT_TABLE_READ", "FACTS.DB_PROD_SCHEMA_LABEL_PARTICIPANT_PARTICIPATED_IN_ORCHARD_TRACK_TABLE_READ", "FACTS.DB_PROD_SCHEMA_LABEL_SOUND_RECORDING_TABLE_READ", "FACTS.DB_PROD_SCHEMA_PARENT_COMPANY_TABLE_READ", "FACTS.DB_PROD_SCHEMA_PLACEMENTS_BY_TRACK_PLAYLIST_COUNTRY_FEED_DISTRIBUTOR_ROLLUP_TABLE_READ", "FACTS.DB_PROD_SCHEMA_PLACEMENTS_METADATA_TABLE_READ", "FACTS.DB_PROD_SCHEMA_PLACEMENTS_METADATA_V2_TABLE_READ", "FACTS.DB_PROD_SCHEMA_PLAYLIST_CURATOR_MAPPINGS_TABLE_READ", "FACTS.DB_PROD_SCHEMA_PLAYLIST_MAPPINGS_TABLE_READ", "FACTS.DB_PROD_SCHEMA_PLAYLISTS_PLACEMENTS_BY_TRACK_PLAYLIST_DISTRIBUTOR_TABLE_READ", "FACTS.DB_PROD_SCHEMA_PRIORITY_PLAYLISTS_TABLE_READ", "FACTS.DB_PROD_SCHEMA_PUBLIC_LABEL_TABLE_READ", "FACTS.DB_PROD_SCHEMA_PUBLIC_LABEL_OWNS_PRODUCT_PUBLIC_PRODUCT_TABLE_READ", "FACTS.DB_PROD_SCHEMA_PUBLIC_PARTICIPANT_TABLE_READ", "FACTS.DB_PROD_SCHEMA_PUBLIC_PARTICIPANT_PARTICIPATED_IN_PUBLIC_SOUND_RECORDING_TABLE_READ", "FACTS.DB_PROD_SCHEMA_PUBLIC_PRODUCT_TABLE_READ", "FACTS.DB_PROD_SCHEMA_PUBLIC_PRODUCT_INCLUDES_PUBLIC_TRACK_TABLE_READ", "FACTS.DB_PROD_SCHEMA_PUBLIC_SOUND_RECORDING_TABLE_READ", "FACTS.DB_PROD_SCHEMA_PUBLIC_TRACK_TABLE_READ", "FACTS.DB_PROD_SCHEMA_PUBLIC_TRACK_IS_PLACEMENT_OF_PUBLIC_SOUND_RECORDING_TABLE_READ", "FACTS.DB_PROD_SCHEMA_SERVICE_TIER_TABLE_READ", "FACTS.DB_PROD_SCHEMA_SHAZAM_DAILY_EVENTS_TABLE_READ", "FACTS.DB_PROD_SCHEMA_SME_DIM_DISTRIBUTION_TYPE_TABLE_READ", "FACTS.DB_PROD_SCHEMA_SME_DIM_PRODUCT_TYPE_TABLE_READ", "FACTS.DB_PROD_SCHEMA_SME_DIM_SALE_TYPE_TABLE_READ", "FACTS.DB_PROD_SCHEMA_SME_DIM_SERVICE_TYPE_TABLE_READ", "FACTS.DB_PROD_SCHEMA_SME_DIM_TRANSACTION_TYPE_TABLE_READ", "FACTS.DB_PROD_SCHEMA_SME_JV_ITUNES_SALES_TABLE_READ", "FACTS.DB_PROD_SCHEMA_SME_JV_SPOTIFY_SALES_TABLE_READ", "FACTS.DB_PROD_SCHEMA_SONY_APPLE_ID_MAPPING_DERIVED_TABLE_READ", "FACTS.DB_PROD_SCHEMA_SOUND_RECORDING_TRACK_MAPPING_TABLE_READ", "FACTS.DB_PROD_SCHEMA_SPOTIFY_ORCHARD_SONY_USER_MAPPING_TABLE_READ", "FACTS.DB_PROD_SCHEMA_SPOTIFY_PLAYLIST_CURATORS_TABLE_READ", "FACTS.DB_PROD_SCHEMA_SPOTIFY_TRACKS_TABLE_READ", "FACTS.DB_PROD_SCHEMA_SPOTIFY_USERS_TABLE_READ", "FACTS.DB_PROD_SCHEMA_SPOTIFY_USERS_MAPPING_TABLE_READ", "FACTS.DB_PROD_SCHEMA_SPOTIFY_USERS_NEW_USER_ID_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_AMAZON_ADSUPPORTED_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_AMAZON_ADSUPPORTED_AWAL_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_AMAZON_AGGREGATED_STREAMS_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_AMAZON_INSTANT_VIDEO_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_AMAZON_MARKET_SHARE_V2_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_AMAZON_PRIME_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_AMAZON_PRIME_AWAL_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_AMAZON_UNLIMITED_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_AMAZON_UNLIMITED_AWAL_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_AMAZON_UNLIMITED_MARKET_SHARE_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_AMAZON_V2_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_AMAZON_V2_SME_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_APPLE_ALBUM_MAPPING_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_APPLE_MUSIC_ARTISTS_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_APPLE_MUSIC_CONTAINER_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_APPLE_MUSIC_DEMOGRAPHICS_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_APPLE_MUSIC_FOOTER_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_APPLE_MUSIC_LIBRARYEVENTS_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_APPLE_MUSIC_LINEAR_RADIO_SERVICE_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_APPLE_MUSIC_NONROYALTY_STREAMS_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_APPLE_MUSIC_NONROYALTY_SUMMARY_STREAMS_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_APPLE_MUSIC_ROYALTY_CALCULATION_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_APPLE_MUSIC_SONGS_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_APPLE_MUSIC_STREAMS_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_APPLE_MUSIC_SUB_REFERENCE_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_APPLE_MUSIC_SUMMARY_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_APPLE_MUSIC_SUMMARY_STREAMS_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_APPLE_MUSIC_TOTALLIBRARYADDS_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_APPLE_PODCASTS_CONTENT_PERFORMANCE_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_APPLE_PODCASTS_SALES_SUMMARY_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_APPLE_PODCASTS_SALES_SUMMARY_MONTHLY_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_APPLE_PODCASTS_SALES_SUMMARY_WEEKLY_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_APPLE_PODCASTS_SUBSCRIPTION_EVENTS_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_APPLE_PODCASTS_SUBSCRIPTION_EVENTS_MONTHLY_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_APPLE_PODCASTS_SUBSCRIPTION_EVENTS_WEEKLY_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_APPLE_PODCASTS_SUBSCRIPTION_SNAPSHOT_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_APPLE_PODCASTS_SUBSCRIPTION_SNAPSHOT_MONTHLY_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_APPLE_PODCASTS_SUBSCRIPTION_SNAPSHOT_WEEKLY_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_APPLE_TRACK_MAPPING_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_AWA_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_AWA_MARKETSHARE_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_AWA_STANDARD_SALES_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_AWA_TRENDS_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_BEATPORT_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_CHARTABLE_CATALOG_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_CHARTABLE_EPISODE_COUNTRY_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_CHARTABLE_EPISODE_METRICS_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_CHARTABLE_EPISODE_PLAYERS_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_CHARTABLE_EPISODE_RANKINGS_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_CHARTABLE_EPISODE_SMARTPROMOS_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_CHARTABLE_EPISODES_RETENTION_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_CHARTABLE_METADATA_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_CHARTABLE_PODCAST_RANKINGS_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_CHARTABLE_PODCAST_RATINGS_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_CHARTABLE_PODCAST_REVIEWS_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_CHARTABLE_RETENTION_CATALOG_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_CHARTABLE_SMARTLINKS_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_DEEZER_MARKET_SHARE_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_DEEZER_V4_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_DOUYIN_TRENDS_TOPHASHTAG_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_DOUYIN_TRENDS_TOPSONG_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_EMUSIC_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_FANDANGO_NOW_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_FEATURE_FM_AD_SPEND_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_GFK_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_GOOGLE_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_GOOGLE_PLAY_MARKET_SHARE_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_GOOGLEPLAY_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_INSTA_REELS_CREATIONS_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_INSTA_REELS_VIEWS_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_ITUNES_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_ITUNES_HIDDEN_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_ITUNES_MARKET_SHARE_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_JUKE_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_KUGOU_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_KUWO_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_LINE_PLACE_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_LINE_PREF_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_LINE_SEX_AGE_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_LINE_SEX_AGE_HOUR_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_LINE_SEX_AGE_REGION_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_LINE_SEX_AGE_TYPE_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_LINE_TYPE_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_LUMINATE_DAILY_ARTIST_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_LUMINATE_DAILY_ISRC_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_LUMINATE_DAILY_SONG_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_LUMINATE_WEEKLY_ARTIST_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_LUMINATE_WEEKLY_ARTIST_PRE_2022_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_LUMINATE_WEEKLY_ISRC_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_LUMINATE_WEEKLY_ISRC_PRE_2022_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_LUMINATE_WEEKLY_SONG_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_LUMINATE_WEEKLY_SONG_PRE_2022_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_MEGAPHONE_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_MEMBRAN_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_MRC_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_MRC_COLLECTION_METADATA_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_NETEASE_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_PANDORA_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_PLAYSTATION_VIDEO_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_QQ_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_RHAPSODY_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_RHAPSODY_SME_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_RITMOGESTION_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_SHAZAM_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_SME_LATAM_WEEKLY_UNIFIED_CHART_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_SNAPCHAT_CREATIONS_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_SNAPCHAT_VIEWS_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_SOUNDCLOUD_CUSTOMERANALYTICS_V2_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_SOUNDCLOUD_CUSTOMERDATA_V2_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_SOUNDCLOUD_PLAYLISTREPORTING_V2_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_SOUNDCLOUD_STREAMLEVELREPORT_V2_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_SOUNDCLOUD_TRACKINFORMATION_V2_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_SPOTIFY_AGGREGATED_STREAMS_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_SPOTIFY_ARTIFICIAL_STREAMS_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_SPOTIFY_CHARTS_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_SPOTIFY_MARKET_SHARE_V2_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_SPOTIFY_PLAYLIST_ATC_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_SPOTIFY_TRACK_CONVERSION_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_SPOTIFY_TRACK_PASSION_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_SPOTIFY_V2_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_TIKTOK_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_TIKTOK_FRAUDULENT_USAGE_REPORT_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_TIKTOK_TRENDS_TOPHASHTAG_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_TIKTOK_TRENDS_TOPSONG_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_UMA_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_UMA_MARKETSHARE_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_VEVO_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_VUDU_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_WYNK_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_XBOX_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_YOUTUBE_ASSET_REPORT_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_YOUTUBE_CLAIM_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_YOUTUBE_MONTHLY_ADJ_CLAIM_RAW_V1_1_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_YOUTUBE_MONTHLY_ADJ_CLAIM_RAW_V1_1_DMGI_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_YOUTUBE_MONTHLY_ADJ_CLAIM_SUMMARY_V1_1_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_YOUTUBE_MONTHLY_ADJ_CLAIM_SUMMARY_V1_1_DMGI_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_YOUTUBE_MONTHLY_ADJ_VIDEO_RAW_V1_1_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_YOUTUBE_MONTHLY_ADJUSTMENT_RED_LABEL_RAWDATA_VIDEO_V1_1__VIDEO_CLAIM_RAW_REPORT_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_YOUTUBE_MONTHLY_ADJUSTMENT_RED_MUSIC_RAWDATA_VIDEO_V1_1__VIDEO_CLAIM_RAW_REPORT_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_YOUTUBE_MONTHLY_ADJUSTMENT_RED_RAWDATA_VIDEO_V1_1__VIDEO_CLAIM_RAW_REPORT_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_YOUTUBE_MONTHLY_ADJUSTMENT_RED_RAWDATA_VIDEO_V1_1__VIDEO_CLAIM_RAW_REPORT_TMP_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_YOUTUBE_MONTHLY_CLAIM_RAW_V1_1_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_YOUTUBE_MONTHLY_LABEL_AP_REPORT_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_YOUTUBE_MONTHLY_RAWDATA_V1_0_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_YOUTUBE_MONTHLY_RAWDATA_V1_0_DMGI_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_YOUTUBE_MONTHLY_RED_LABEL_RAWDATA_VIDEO_V1_1__VIDEO_CLAIM_RAW_REPORT_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_YOUTUBE_MONTHLY_RED_LABEL_RAWDATA_VIDEO_V1_1__VIDEO_CLAIM_RAW_REPORT_TMP_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_YOUTUBE_MONTHLY_RED_LABEL_SUMMARY_V1_1__MUSIC_SUMMARY_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_YOUTUBE_MONTHLY_RED_LABEL_SUMMARY_V1_1__NON_MUSIC_SUMMARY_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_YOUTUBE_MONTHLY_RED_LABEL_SUMMARY_V1_1__SUBSCRIBER_SUMMARY_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_YOUTUBE_MONTHLY_RED_MUSIC_RAWDATA_VIDEO_V1_1__VIDEO_CLAIM_RAW_REPORT_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_YOUTUBE_MONTHLY_RED_RAWDATA_VIDEO_V1_1__VIDEO_CLAIM_RAW_REPORT_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_YOUTUBE_MONTHLY_RED_SUMMARY_V1_1__MUSIC_SUMMARY_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_YOUTUBE_MONTHLY_RED_SUMMARY_V1_1__NON_MUSIC_SUMMARY_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_YOUTUBE_MONTHLY_REPORT_V1_0__SUMMARY_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_YOUTUBE_MONTHLY_REPORT_V1_0__SUMMARY_BY_COUNTRY_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_YOUTUBE_MONTHLY_REPORT_V1_0__SUMMARY_BY_DAY_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_YOUTUBE_MONTHLY_V2_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_YOUTUBE_RED_MARKET_SHARE_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_YOUTUBE_VIDEO_REPORT_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_YOUTUBEVOD_TABLE_READ", "FACTS.DB_PROD_SCHEMA_DIM_DAY_TABLE_READ", "FACTS.DB_PROD_SCHEMA_DIM_WEEK_TABLE_READ", "FACTS.DB_PROD_SCHEMA_DIM_MONTH_TABLE_READ", "FACTS.DB_PROD_SCHEMA_DIM_RELEASE_TABLE_READ", "FACTS.DB_PROD_SCHEMA_DIM_COUNTRY_TABLE_READ", ], granted_account_roles = [ "CHARTMETRIC_DB_RAW_DATA_SCHEMA_READ", ] }, { name = "PROD_DELETE_SME_PRODUCT_STREAMLIT" granted_database_roles = [ "DATA_APPS.DB_PROD_SCHEMA_DELETE_SME_PRODUCT_STREAMLIT", ], granted_account_roles = [ "CHARTMETRIC_DB_RAW_DATA_SCHEMA_READ", ] }, { name = "INSIGHTS_TEAM_QA_FACTS_READWRITE", granted_database_roles = [ "FACTS.DB_QA_SCHEMA_READWRITE", ] granted_account_roles = [ "QA_ETL_WAREHOUSE_WAREHOUSE_ACCESS", ] }, { name = "SME_ANALYTICS_GERMANY", granted_account_roles = [ "SME_DATA_INSIGHTS", "SME_ANALYTICS_DE_SMALL_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_DE_MEDIUM_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_DE_LARGE_WAREHOUSE_WAREHOUSE_ACCESS", ], granted_database_roles = [ "SME_ANALYTICS.DB_SHARED_SCHEMA_READWRITE", "SME_ANALYTICS.DB_DE_SCHEMA_READWRITE", ] }, { name = "SME_ANALYTICS_FINLAND", granted_account_roles = [ "SME_DATA_INSIGHTS", "SME_ANALYTICS_FI_SMALL_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_FI_MEDIUM_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_FI_LARGE_WAREHOUSE_WAREHOUSE_ACCESS", ], granted_database_roles = [ "SME_ANALYTICS.DB_SHARED_SCHEMA_READWRITE", "SME_ANALYTICS.DB_FI_SCHEMA_READWRITE", ] }, { name = "SME_ANALYTICS_BENELUX", granted_account_roles = [ "SME_DATA_INSIGHTS", "SME_ANALYTICS_BX_SMALL_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_BX_MEDIUM_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_BX_LARGE_WAREHOUSE_WAREHOUSE_ACCESS", ], granted_database_roles = [ "SME_ANALYTICS.DB_SHARED_SCHEMA_READWRITE", "SME_ANALYTICS.DB_BX_SCHEMA_READWRITE", ] }, { name = "SME_ANALYTICS_FRANCE", granted_account_roles = [ "SME_DATA_INSIGHTS", "SME_ANALYTICS_FR_SMALL_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_FR_MEDIUM_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_FR_LARGE_WAREHOUSE_WAREHOUSE_ACCESS", ], granted_database_roles = [ "SME_ANALYTICS.DB_SHARED_SCHEMA_READWRITE", "SME_ANALYTICS.DB_FR_SCHEMA_READWRITE", ] }, { name = "SME_ANALYTICS_UK", granted_account_roles = [ "SME_DATA_INSIGHTS", "SME_ANALYTICS_UK_SMALL_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_UK_MEDIUM_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_UK_LARGE_WAREHOUSE_WAREHOUSE_ACCESS", ], granted_database_roles = [ "SME_ANALYTICS.DB_SHARED_SCHEMA_READWRITE", "SME_ANALYTICS.DB_UK_SCHEMA_READWRITE", ] }, { name = "SME_ANALYTICS_PHILIPPINES", granted_account_roles = [ "SME_DATA_INSIGHTS", "SME_ANALYTICS_PH_SMALL_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_PH_MEDIUM_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_PH_LARGE_WAREHOUSE_WAREHOUSE_ACCESS", ], granted_database_roles = [ "SME_ANALYTICS.DB_SHARED_SCHEMA_READWRITE", "SME_ANALYTICS.DB_PH_SCHEMA_READWRITE", ] }, { name = "SME_ANALYTICS_BRAZIL", granted_account_roles = [ "SME_DATA_INSIGHTS", "SME_ANALYTICS_BR_SMALL_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_BR_MEDIUM_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_BR_LARGE_WAREHOUSE_WAREHOUSE_ACCESS", ], granted_database_roles = [ "SME_ANALYTICS.DB_SHARED_SCHEMA_READWRITE", "SME_ANALYTICS.DB_BR_SCHEMA_READWRITE", ] }, { name = "QA_AUTH0_ACCESS_INTEGRATION_USAGE", }, { name = "PROD_AUTH0_ACCESS_INTEGRATION_USAGE", }, { name = "QA_LAMBDA_CONTENT_DELETE_PRODUCT_INTEGRATION_USAGE", }, { name = "PROD_LAMBDA_CONTENT_DELETE_PRODUCT_INTEGRATION_USAGE", }, { name = "SME_ANALYTICS_INSIGHTS_REPORTING", granted_account_roles = [ "SME_DATA_INSIGHTS", "SME_ANALYTICS_INSIGHTS_SMALL_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_INSIGHTS_MEDIUM_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_INSIGHTS_LARGE_WAREHOUSE_WAREHOUSE_ACCESS", ], granted_database_roles = [ "SME_ANALYTICS.DB_SHARED_SCHEMA_READWRITE", "SME_ANALYTICS.DB_INSIGHTS_SCHEMA_READWRITE", ] }, { name = "SME_DATA_SCIENCE_AND_ANALYTICS", granted_account_roles = [ "SME_DATA_INSIGHTS", "SME_ANALYTICS_DATA_SCIENCE_SMALL_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_DATA_SCIENCE_MEDIUM_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_DATA_SCIENCE_LARGE_WAREHOUSE_WAREHOUSE_ACCESS", ], granted_database_roles = [ "SME_ANALYTICS.DB_SHARED_SCHEMA_READWRITE", "SME_ANALYTICS.DB_DATA_SCIENCE_SCHEMA_READWRITE", ] }, { name = "SME_ANALYTICS_INT_MKTG", granted_account_roles = [ "SME_DATA_INSIGHTS", "SME_ANALYTICS_INT_MKTG_SMALL_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_INT_MKTG_MEDIUM_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_INT_MKTG_LARGE_WAREHOUSE_WAREHOUSE_ACCESS", ], granted_database_roles = [ "SME_ANALYTICS.DB_SHARED_SCHEMA_READWRITE", "SME_ANALYTICS.DB_INT_MKTG_SCHEMA_READWRITE", ] }, { name = "SNOWFLAKE_TEAM", granted_account_roles = [ "DEV_ENGINEERING", "PROD_INSIGHTS_PLAYLISTS_WAREHOUSE_WAREHOUSE_ACCESS", ], granted_database_roles = [ "SME_ANALYTICS.DB_READ", ] }, { name = "REPORTING_DB_TEAM", granted_account_roles = [ "DEV_ENGINEERING", "SME_DATA_INSIGHTS", "SME_ANALYTICS_REPORTING_DB_SMALL_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_REPORTING_DB_MEDIUM_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_REPORTING_DB_LARGE_WAREHOUSE_WAREHOUSE_ACCESS", ], granted_database_roles = [ "SME_ANALYTICS.DB_SHARED_SCHEMA_READWRITE", "SME_ANALYTICS.DB_REPORTING_DB_SCHEMA_READWRITE", ] }, { name = "BEATROOT_REPORT", granted_account_roles = [ "PROD_SIGMA_WAREHOUSE_WAREHOUSE_ACCESS", ], granted_database_roles = [ "ORCHARD_APP_REPORTING_V2.DB_ART_RELATIONS_PROD_ART_RELATIONS_SCHEMA_SUBACCOUNT_TABLE_READ", "FACTS.DB_PROD_SCHEMA_IDENTITY_TABLE_READ", "FACTS.DB_PROD_SCHEMA_HAS_PROFILE_TABLE_READ", "FACTS.DB_PROD_SCHEMA_PROFILE_HAS_ACCESS_TO_SUBACCOUNT_TABLE_READ", ] }, { name = "SME_ANALYTICS_ALAMO", granted_account_roles = [ "SME_DATA_INSIGHTS", "SME_ANALYTICS_ALAMO_SMALL_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_ALAMO_MEDIUM_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_ALAMO_LARGE_WAREHOUSE_WAREHOUSE_ACCESS", ], granted_database_roles = [ "SME_ANALYTICS.DB_SHARED_SCHEMA_READWRITE", "SME_ANALYTICS.DB_ALAMO_SCHEMA_READWRITE", ] }, { name = "SME_ANALYTICS_US_RCA", granted_account_roles = [ "SME_DATA_INSIGHTS", "SME_ANALYTICS_US_RCA_SMALL_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_US_RCA_MEDIUM_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_US_RCA_LARGE_WAREHOUSE_WAREHOUSE_ACCESS", ], granted_database_roles = [ "SME_ANALYTICS.DB_SHARED_SCHEMA_READWRITE", "SME_ANALYTICS.DB_US_RCA_SCHEMA_READWRITE", ] }, ] }