roles = [ { name = "ACCOUNT_SUPPORT" }, { name = "AE_CRM_USER" granted_account_roles = [ "DELPHI_AE_REPORTING_DB_EXP_SCHEMA_READ", "DELPHI_EXPLORATION_DB_EXP_SCHEMA_READ", "EXPLORATION_USER", ] }, { name = "AE_CRM_USER_BASE" comment = "Deprecated. This is a copy of AE_CRM_USER but without warehouses access. Created by manual script which copies permissions from AE_CRM_USER." granted_account_roles = [ "DELPHI_AE_REPORTING_DB_MAIN_SCHEMA_READ", "DELPHI_EXPLORATION_DB_MAIN_SCHEMA_READ", "EXPLORATION_BASE", ] }, { name = "AE_QUICKSIGHT" granted_account_roles = [ "DELPHI_AE_REPORTING_DB_MAIN_SCHEMA_READ", "DELPHI_EXPLORATION_DB_MAIN_SCHEMA_READ", "QUICKSIGHT_WH_WAREHOUSE_ACCESS", ] }, { name = "AIRTABLE_SERVICE_ROLE" granted_account_roles = [ "BUSINESS_SOLUTIONS_WH_WAREHOUSE_ACCESS" ] granted_database_roles = [ "BUSINESS_SOLUTIONS.DB_READ", "GRPS_APP_REPORTING_NOCONF.DB_GRPS_DRAS002_SCHEMA_READ" ] }, { name = "ANALYST_BASELINE_ROLE" granted_account_roles = [ "DS_CHARTMETRIC_DB_READ", "LUMINATE_SHARE_READ", ] granted_database_roles = [ "CONSUMER_REPORTING.DB_SPOTIFY_SCHEMA_READ", "CONSUMER_REPORTING.DB_TIKTOK_SCHEMA_READ", "CONSUMER_REPORTING.DB_APPLE_SCHEMA_READ", "CONSUMER_REPORTING.DB_META_SCHEMA_READ", ] }, { name = "APOLLO_TEAM_ROLE" }, { name = "APP_ENABLEMENT_READER" }, { name = "AWAL" comment = "Role used by AWAL users SYS-19699" granted_database_roles = [ "AWAL.DB_AWAL_TRUST_AND_SAFETY_SCHEMA_READ", ] }, { name = "AWAL_ANALYTICS" granted_account_roles = [ "ANALYST_BASELINE_ROLE", "AWAL_ANALYTICS_SMALL_WAREHOUSE_WAREHOUSE_ACCESS", "AWAL_ANALYTICS_MEDIUM_WAREHOUSE_WAREHOUSE_ACCESS", "AWAL_ANALYTICS_LARGE_WAREHOUSE_WAREHOUSE_ACCESS", "AWAL_ANALYTICS_COMPUTE_POOL_COMPUTE_POOL_ACCESS", "SME_DATA_INSIGHTS", "INTELLIGENCE_DB_READ_ONLY", ] granted_database_roles = [ "SME_ANALYTICS.DB_SHARED_SCHEMA_READWRITE", "SME_ANALYTICS.DB_AWAL_SCHEMA_READWRITE", "ORCHARD_APP_REPORTING_V2.DB_READ", "AWAL.DB_AWAL_AR_SCHEMA_READ", ] }, { name = "AWAL_EXECUTIVE" comment = "Role for AWAL executive leadership staff. Same access as AWAL_ANALYTICS, plus the AWAL_EXECUTIVE schema for Streamlit apps hidden from other AWAL staff" granted_account_roles = [ "AWAL_ANALYTICS", ] granted_database_roles = [ "SME_ANALYTICS.DB_AWAL_EXECUTIVE_SCHEMA_READWRITE", ] }, { name = "AWAL_AR_STREAMLIT_READ" granted_account_roles = [ "AWAL_AR_WH_WAREHOUSE_ACCESS", ] granted_database_roles = [ "AWAL.DB_AWAL_AR_SCHEMA_READ", ] }, { name = "AWAL_DB_PROD_SCHEMA_READWRITE" granted_account_roles = [ "AWAL_AR_WH_WAREHOUSE_ACCESS", ] granted_database_roles = [ "AWAL.DB_AWAL_AR_SCHEMA_READWRITE", "AWAL.DB_AWAL_TRUST_AND_SAFETY_SCHEMA_READWRITE", ] }, { name = "AWAL_RIGHTS_SUPPORT" granted_account_roles = [ "AWAL_DEV_WAREHOUSE_WAREHOUSE_ACCESS", ] granted_database_roles = [ "AWAL.DB_AWAL_TRUST_AND_SAFETY_SCHEMA_READWRITE", ] }, { name = "BEATDAPP_DB_DEPLOY" granted_account_roles = [ "DEPLOY_WAREHOUSE_WAREHOUSE_ACCESS", ] granted_database_roles = [ "BEATDAPP.DB_PROD_SCHEMA_READWRITE", "BEATDAPP.DB_QA_SCHEMA_READWRITE", "FACTS.DB_PROD_SCHEMA_READ", "CONSUMER_REPORTING.DB_SPOTIFY_SCHEMA_READ", "CONSUMER_REPORTING.DB_APPLE_SCHEMA_READ", ] }, { name = "BEATDAPP_READ" granted_account_roles = [ "DEV_OWS_WAREHOUSE_WAREHOUSE_ACCESS", ] granted_database_roles = [ "BEATDAPP.DB_PROD_SCHEMA_READ", "BEATDAPP.DB_QA_SCHEMA_READ", "FACTS.DB_PROD_SCHEMA_READ", ] }, { name = "BEATROOT_REPORT" granted_account_roles = [ "PDE_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 = "BILLING_ROLE" }, { name = "BI_TEAM_ROLE" granted_account_roles = [ "FACTS_DB_PROD_SCHEMA_READ", ] granted_database_roles = [ "AWAL.DB_AWAL_TRUST_AND_SAFETY_SCHEMA_READ", "CONSUMER_REPORTING.DB_READ", "CONFLICT_REPORTING.DB_READ", ] }, { name = "BUDGET_ADMIN" granted_account_roles = [ "BUDGET_DB_DB_READWRITE", ] }, { name = "BUSINESS_SYSTEMS_SALESFORCE_DATA_PROD_SCHEMA_READWRITE_DB_DEPLOY" account_level_grants = [ "EXECUTE TASK", ] granted_account_roles = [ "BUSINESS_SYSTEMS_SALESFORCE_DATA_DB_PROD_SCHEMA_READWRITE", "PROD_OWS_WAREHOUSE_WAREHOUSE_ACCESS", ] }, { name = "BUSINESS_SYSTEMS_SALESFORCE_DATA_QA_SCHEMA_READWRITE_DB_DEPLOY" account_level_grants = [ "EXECUTE TASK", ] granted_account_roles = [ "BUSINESS_SYSTEMS_SALESFORCE_DATA_DB_QA_SCHEMA_READWRITE", "QA_OWS_WAREHOUSE_WAREHOUSE_ACCESS", ] }, { name = "CHARTMETRIC_RAW_DATA_ACCESS" granted_account_roles = [ "CHARTMETRIC_DB_RAW_DATA_SCHEMA_READ", "DEV_OWS_WAREHOUSE_WAREHOUSE_ACCESS", ] }, { name = "CHARTMETRIC_TIKTOK_USER" }, { name = "CHARTMETRIC_USER" }, { name = "CHARTMETRIC_USER_ANALYTICS" granted_account_roles = [ "DELPHI_EXPLORATION_DB_CHARTMETRIC_SCHEMA_READ", "CHARTMETRIC_ANALYTICS_WH_WAREHOUSE_ACCESS", ] }, { name = "CONTACTS_MANAGER" comment = "Role to create and associate contacts" granted_account_roles = [ "DEV_ENGINEERING", ] }, { name = "CORTEX_AGENT_CHATBOT" comment = "Role for stakeholders to access Cortex POC called CHATBOT_AGENT" granted_account_roles = [ "DEV_PERFORMANCE_WAREHOUSE_WAREHOUSE_ACCESS", "SNOWFLAKE_INTELLIGENCE_RO_RL", ] granted_database_roles = [ "DEV_ENGINEERING.DB_DEV_RBOMBERG_SCHEMA_READ", "FACTS.DB_PROD_SCHEMA_DATA_AVAILABILITY_BY_STORE_DAILY_TABLE_READ", "FACTS.DB_PROD_SCHEMA_DIM_CHART_TABLE_READ", "FACTS.DB_PROD_SCHEMA_DIM_COUNTRY_TABLE_READ", "FACTS.DB_PROD_SCHEMA_DIM_RELEASE_TABLE_READ", "FACTS.DB_PROD_SCHEMA_DIM_STORE_TABLE_READ", "FACTS.DB_PROD_SCHEMA_DOWNLOADS_BY_PARTICIPANT_PRODUCT_COUNTRY_FEED_DISTRIBUTOR_DAILY_TABLE_READ", "FACTS.DB_PROD_SCHEMA_DOWNLOADS_BY_PARTICIPANT_TRACK_COUNTRY_FEED_DISTRIBUTOR_DAILY_TABLE_READ", "FACTS.DB_PROD_SCHEMA_FACT_CHARTS_TABLE_READ", "FACTS.DB_PROD_SCHEMA_FACT_SOCIALS_TABLE_READ", "FACTS.DB_PROD_SCHEMA_GLOBAL_PARTICIPANT_TABLE_READ", "FACTS.DB_PROD_SCHEMA_GLOBAL_SOUND_RECORDING_TABLE_READ", "FACTS.DB_PROD_SCHEMA_V_PLAYLISTS_PLACEMENTS_BY_PARTICIPANT_ISRC_PLAYLIST_PUBLIC_VIEW_READ", "FACTS.DB_PROD_SCHEMA_V_STREAMS_BY_PARTICIPANT_TRACK_COUNTRY_FEED_DISTRIBUTOR_DAILY_VIEW_READ", "FACTS.DB_PROD_SCHEMA_V_STREAMS_BY_TRACK_COUNTRY_FEED_DISTRIBUTOR_DAILY_VIEW_READ", "FACTS.DB_PROD_SCHEMA_V_TIKTOK_BY_ISRC_COUNTRY_DAILY_VIEW_READ", "DEV_ENGINEERING.DB_DEV_RBOMBERG_SCHEMA_CHATBOT_AGGREGATED_CHARTS_TABLE_READ", "DEV_ENGINEERING.DB_DEV_RBOMBERG_SCHEMA_CHATBOT_GLOBAL_PARTICIPANT_BRAND_MAPPING_DYNAMIC_TABLE_READ", "DEV_ENGINEERING.DB_DEV_RBOMBERG_SCHEMA_CHATBOT_ISRC_ACCOUNT_MAPPING_DYNAMIC_TABLE_READ", "DEV_ENGINEERING.DB_DEV_RBOMBERG_SCHEMA_CHATBOT_ISRC_BRAND_MAPPING_DYNAMIC_TABLE_READ", "DEV_ENGINEERING.DB_DEV_RBOMBERG_SCHEMA_CHATBOT_TADAS_INPUT_DYNAMIC_TABLE_READ", "DEV_ENGINEERING.DB_DEV_RBOMBERG_SCHEMA_ISRC_TO_GLOBAL_PARTICIPANT_MAPPING_DYNAMIC_TABLE_READ", "DEV_ENGINEERING.DB_DEV_RBOMBERG_SCHEMA_REGION_COUNTRY_MAPPING_TABLE_READ", "DEV_ENGINEERING.DB_DEV_RBOMBERG_SCHEMA_STREAM_SOURCE_MAPPINGS_TABLE_READ", "DEV_ENGINEERING.DB_DEV_RBOMBERG_SCHEMA_V_STREAMS_SOS_UNPIVOTED_VIEW_READ", "DEV_ENGINEERING.DB_DEV_RBOMBERG_SCHEMA_CORTEX_SEARCH_SERVICES_READ", "DEV_ENGINEERING.DB_DEV_RBOMBERG_SCHEMA_CHATBOT_AGENT_AGENT_USAGE", "DELPHI_EXPLORATION.DB_CHARTMETRIC_SCHEMA_CM_TRACK_TABLE_READ", ] }, { name = "CORTEX_USER_ROLE" granted_account_roles = [ "ORCHARDAPPREPORTING_DB_ARTRELATIONS_SCHEMA_READ", "FACTS_DB_PROD_SCHEMA_READ", "FACTS_DB_QA_SCHEMA_READ", ] granted_database_roles = [ "FACTS.DB_QA_SCHEMA_CORTEX_SEARCH_SERVICES_READ", "FACTS.DB_PROD_SCHEMA_CORTEX_SEARCH_SERVICES_READ", ] }, { name = "CRM_ADMIN_USER" granted_account_roles = [ "AE_CRM_USER", "CRM_ECOMMERCE_ROLE", "PROD_MARTECH_SNOWFLAKE_SALESFORCE_NODE_WH_WAREHOUSE_ACCESS", "QA_SHOPIFY_INTEGRATIONS_DB_READWRITE", "DELPHI_CRM_DATA_DB_READWRITE", "SONGWHIP_APP_REPORTING_DB_READ", "FANSIFTER_APP_REPORTING_DB_READ", "ORCHARD_APP_REPORTING_DB_READ", "FANSIFTER_APP_REPORTING_DB_QA_CRM_FANS_SCHEMA_READ", "FANSIFTER_SHOPIFY_ANALYST", "SONGWHIP_APP_REPORTING_DB_READWRITE", "SONGWHIP_APP_REPORTING_DB_CREATE_SCHEMA", ] granted_database_roles = [ "FANSIFTER_APP_REPORTING.DB_QA_CRM_FANS_SCHEMA_TRIGGERED_SENDS_STREAMLIT", "SME_ANALYTICS.DB_UK_SCHEMA_READWRITE", "SME_ANALYTICS.DB_US_COLUMBIA_SCHEMA_READWRITE", "SME_ANALYTICS.DB_INSIGHTS_SCHEMA_READWRITE", "SHOPIFY_STORES_GLOBAL.DB_READ", "FAN_LIVE_EVENTS.DB_QA_SCHEMA_READ", "FAN_LIVE_EVENTS.DB_PROD_SCHEMA_READ", "SME_ANALYTICS.DB_CRM_UK_SCHEMA_READWRITE", "SMF_APP_REPORTING.DB_READWRITE", "SMF_APP_REPORTING.DB_CREATE_SCHEMA", "FACTS.DB_PROD_SCHEMA_VENDOR_COMPANY_BRAND_PARENT_COMPANY_VIEW_READ", ] }, { name = "CRM_BUSINESS_REPORTING_USER" }, { name = "CRM_ECOMMERCE_ROLE" granted_account_roles = [ "DELPHI_EXPLORATION_DB_LINKFIRE_APPLE_MUSIC_SCHEMA_READ", "QA_SHOPIFY_INTEGRATIONS_DB_READWRITE", "CRM_ECOMMERCE_DATA_DB_READWRITE", "QA_CRM_ECOMMERCE_DATA_DB_READWRITE", "FANSIFTER_SHOPIFY_ANALYST", ] granted_database_roles = [ "SHOPIFY_STORES_GLOBAL.DB_READ", ] }, { name = "CRM_ECOMMERCE_USER" }, { name = "CRM_FAN_SEGMENTATION_MODEL" }, { name = "CRM_TEAM_ROLE" granted_account_roles = [ "DELPHI_CRM_DATA_DB_RAW_SALESFORCE_SALES_CLOUD_SCHEMA_READ", "DELPHI_CRM_DATA_DB_RAW_SALESFORCE_MARKETING_CLOUD_SCHEMA_READ", "DELPHI_AE_REPORTING_DB_EXP_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_CONSOLIDATION_DATA_SCHEMA_READ", "EXPLORATION_USER", "AE_QUICKSIGHT", "PDE_SIGMA_WAREHOUSE_WAREHOUSE_ACCESS", "FANSIFTER_ARTIST_ROSTER_VIEWS_ACCESS", ] granted_database_roles = [ "FANSIFTER_APP_REPORTING.DB_PROD_SCHEMA_FILEUPLOAD_STREAMLIT", "DELPHI_EXPLORATION.DB_EXP_SCHEMA_READ", "DELPHI_EXPLORATION.DB_MAIN_SCHEMA_READ", "FANSIFTER_APP_REPORTING.DB_PROD_SCHEMA_ARTIST_ROSTER_MAIN_REP_TABLE_READ", "FANSIFTER_APP_REPORTING.DB_PROD_SCHEMA_ARTIST_ROSTER_LOCAL_REP_TABLE_READ", "ORCHARD_APP_REPORTING.DB_DELPHI_PROD_SCHEMA_VENDOR_TABLE_READ", "ORCHARD_APP_REPORTING.DB_DELPHI_PROD_SCHEMA_GLOBAL_PARTICIPANT_TABLE_READ", "FANSIFTER_APP_REPORTING.DB_PROD_STREAMLIT_FANSIFTER_BACKOFFICE_SCHEMA_STREAMLITS_READ", ] }, { name = "CRM_TEAM_ROLE_BASE" comment = "Deprecated. This is a copy of CRM_TEAM_ROLE but without warehouses access." granted_account_roles = [ "DELPHI_CRM_DATA_DB_RAW_SALESFORCE_SALES_CLOUD_SCHEMA_READ", "DELPHI_CRM_DATA_DB_RAW_SALESFORCE_MARKETING_CLOUD_SCHEMA_READ", "DELPHI_AE_REPORTING_DB_EXP_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_CONSOLIDATION_DATA_SCHEMA_READ", "EXPLORATION_BASE", ] granted_database_roles = [ "FANSIFTER_APP_REPORTING.DB_PROD_SCHEMA_FILEUPLOAD_STREAMLIT", "DELPHI_EXPLORATION.DB_EXP_SCHEMA_READ", "DELPHI_EXPLORATION.DB_MAIN_SCHEMA_READ", ] }, { name = "CURATOR_OWNER_OVERRIDES_APP_STREAMLIT_ACCESS" granted_database_roles = [ "FACTS.DB_QA_SCHEMA_CURATOR_OWNER_OVERRIDES_APP_STREAMLIT", ] }, { 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 = "D2C" granted_account_roles = [ "SME_MERCH_STREAMLIT_ACCESS", "CRM_ECOMMERCE_DATA_DB_READ", "PROD_SHOPIFY_INTEGRATIONS_DB_READ", "QA_SHOPIFY_INTEGRATIONS_DB_READ", "FANSIFTER_APP_REPORTING_DB_PROD_SHOPIFY_SCHEMA_READ", "D2C_SMALL_WAREHOUSE_WAREHOUSE_ACCESS", "D2C_MEDIUM_WAREHOUSE_WAREHOUSE_ACCESS", "D2C_LARGE_WAREHOUSE_WAREHOUSE_ACCESS", ] granted_database_roles = [ "SHOPIFY_STORES_GLOBAL.DB_READ", "SME_ANALYTICS.DB_SHARED_SCHEMA_READ", ] }, { name = "D2C_OPERATIONS_PROD_READWRITE" granted_database_roles = [ "SHOPIFY_STORES_GLOBAL.DB_D2C_OPERATIONS_SCHEMA_READWRITE", ] }, { name = "D2C_OPERATIONS_QA_READWRITE" granted_database_roles = [ "SHOPIFY_STORES_GLOBAL.DB_QA_D2C_OPERATIONS_SCHEMA_READWRITE", ] }, { name = "DATADOG" }, { 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 = "DELPHI_DATA_DAILY_ALERT" granted_account_roles = [ "DELPHI_EXPLORATION_DB_READ", "DELPHI_PUBLIC_DATA_RAW_DB_READ", "DELPHI_PUBLIC_DATA_MAIN_DB_READ", "TEAM_L2_SUPPORT_WH_WAREHOUSE_ACCESS", ] }, { name = "DELPHI_EXPLORATION_DB_AE_READ" comment = "AE views with row level security" granted_database_roles = [ "DELPHI_EXPLORATION.DB_EXP_SCHEMA_V_AE_SEGMENT_VIEW_READ", "DELPHI_EXPLORATION.DB_EXP_SCHEMA_V_AE_MEMBERS_DOMAINS_VIEW_READ", "DELPHI_EXPLORATION.DB_EXP_SCHEMA_V_AE_MEMBERS_SERVICES_VIEW_READ", "DELPHI_EXPLORATION.DB_EXP_SCHEMA_V_AE_BRAND_VIEW_READ", "DELPHI_EXPLORATION.DB_EXP_SCHEMA_V_AE_ACTIVITY_VIEW_READ", "DELPHI_EXPLORATION.DB_EXP_SCHEMA_V_AE_MEMBER_COUNTRY_VIEW_READ", "DELPHI_EXPLORATION.DB_EXP_SCHEMA_V_AE_MEMBERS_OPT_INS_VIEW_READ", "DELPHI_EXPLORATION.DB_EXP_SCHEMA_V_AE_MEMBERS_LOGINS_VIEW_READ", "DELPHI_EXPLORATION.DB_EXP_SCHEMA_V_AE_MEMBERS_VISIT_TOTALS_VIEW_READ", "DELPHI_EXPLORATION.DB_EXP_SCHEMA_V_AE_ACTIVITIES_FEED_VIEW_READ", ] }, { name = "DELPHI_EXPLORATION_DB_BRANDWATCH_READ" comment = "EXP schema: brandwatch." granted_database_roles = [ "DELPHI_EXPLORATION.DB_EXP_SCHEMA_V_BRANDWATCH_EMOTION_VIEW_READ", "DELPHI_EXPLORATION.DB_EXP_SCHEMA_V_BRANDWATCH_LOCATION_VIEW_READ", "DELPHI_EXPLORATION.DB_EXP_SCHEMA_V_BRANDWATCH_PLATFORM_VIEW_READ", "DELPHI_EXPLORATION.DB_EXP_SCHEMA_V_BRANDWATCH_QUERY_LOG_VIEW_READ", "DELPHI_EXPLORATION.DB_EXP_SCHEMA_V_BRANDWATCH_QUERY_META_VIEW_READ", "DELPHI_EXPLORATION.DB_EXP_SCHEMA_V_BRANDWATCH_QUERY_RUN_VIEW_READ", "DELPHI_EXPLORATION.DB_EXP_SCHEMA_V_BRANDWATCH_SENTIMENT_VIEW_READ", ] }, { name = "DELPHI_EXPLORATION_DB_CRM_ECOMMERCE_READ" comment = "EXP schema: CRM Ecommerce." granted_database_roles = [ "DELPHI_EXPLORATION.DB_EXP_SCHEMA_V_CRM_ECOMMERCE_CUSTOMERS_VIEW_READ", "DELPHI_EXPLORATION.DB_EXP_SCHEMA_V_CRM_ECOMMERCE_ORDERS_VIEW_READ", "DELPHI_EXPLORATION.DB_EXP_SCHEMA_V_CRM_ECOMMERCE_PRODUCTS_VIEW_READ", "DELPHI_EXPLORATION.DB_EXP_SCHEMA_V_CRM_ECOMMERCE_STORES_VIEW_READ", ] }, { name = "DELPHI_EXPLORATION_DB_STREAMS_READ" comment = "EXP schema: streams. It includes Amazon, Apple, Spotify, Youtube, Tiktok and GRAS." granted_database_roles = [ "DELPHI_EXPLORATION.DB_EXP_SCHEMA_V_AMAZON_AD_SUPPORTED_ACTIVITY_VIEW_READ", "DELPHI_EXPLORATION.DB_EXP_SCHEMA_V_AMAZON_AD_SUPPORTED_PLAYLIST_VIEW_READ", "DELPHI_EXPLORATION.DB_EXP_SCHEMA_V_AMAZON_MUSIC_UNLIMITED_ACTIVITY_VIEW_READ", "DELPHI_EXPLORATION.DB_EXP_SCHEMA_V_AMAZON_MUSIC_UNLIMITED_PLAYLIST_VIEW_READ", "DELPHI_EXPLORATION.DB_EXP_SCHEMA_V_AMAZON_PRIME_ACTIVITY_VIEW_READ", "DELPHI_EXPLORATION.DB_EXP_SCHEMA_V_AMAZON_PRIME_PLAYLIST_VIEW_READ", "DELPHI_EXPLORATION.DB_EXP_SCHEMA_V_APPLE_ARTISTS_VIEW_READ", "DELPHI_EXPLORATION.DB_EXP_SCHEMA_V_APPLE_ARTIST_DEMOGRAPHICS_VIEW_READ", "DELPHI_EXPLORATION.DB_EXP_SCHEMA_V_APPLE_CONTAINER_VIEW_READ", "DELPHI_EXPLORATION.DB_EXP_SCHEMA_V_APPLE_CONTENT_VIEW_READ", "DELPHI_EXPLORATION.DB_EXP_SCHEMA_V_APPLE_CONTENT_DEMOGRAPHICS_VIEW_READ", "DELPHI_EXPLORATION.DB_EXP_SCHEMA_V_APPLE_ENGAGEMENT_VIEW_READ", "DELPHI_EXPLORATION.DB_EXP_SCHEMA_V_APPLE_PLAYLISTS_VIEW_READ", "DELPHI_EXPLORATION.DB_EXP_SCHEMA_V_APPLE_SHAZAM_VIEW_READ", "DELPHI_EXPLORATION.DB_EXP_SCHEMA_V_APPLE_SONGS_VIEW_READ", "DELPHI_EXPLORATION.DB_EXP_SCHEMA_V_APPLE_STREAMS_VIEW_READ", "DELPHI_EXPLORATION.DB_EXP_SCHEMA_V_APPLE_SUMMARY_STREAMS_VIEW_READ", "DELPHI_EXPLORATION.DB_EXP_SCHEMA_V_SME_MAX_ALBUM_MAPPING_VIEW_READ", "DELPHI_EXPLORATION.DB_EXP_SCHEMA_V_SME_MAX_TRACK_MAPPING_VIEW_READ", "DELPHI_EXPLORATION.DB_EXP_SCHEMA_V_SPOTIFY_AGGREGATED_STREAMS_VIEW_READ", "DELPHI_EXPLORATION.DB_EXP_SCHEMA_V_SPOTIFY_MARQUEE_CAMPAIGN_LEVEL_VIEW_READ", "DELPHI_EXPLORATION.DB_EXP_SCHEMA_V_SPOTIFY_MARQUEE_SEGMENT_LEVEL_VIEW_READ", "DELPHI_EXPLORATION.DB_EXP_SCHEMA_V_SPOTIFY_STREAMS_VIEW_READ", "DELPHI_EXPLORATION.DB_EXP_SCHEMA_V_SPOTIFY_TRACKS_VIEW_READ", "DELPHI_EXPLORATION.DB_EXP_SCHEMA_V_TIKTOK_TRENDS_DAILY_VIEW_READ", "DELPHI_EXPLORATION.DB_EXP_SCHEMA_V_TIKTOK_TRENDS_TOPHASHTAG_VIEW_READ", "DELPHI_EXPLORATION.DB_EXP_SCHEMA_V_TIKTOK_TRENDS_TOPSONG_VIEW_READ", "DELPHI_EXPLORATION.DB_EXP_SCHEMA_V_VEVO_ACTIVE_CLAIMS_VIEW_READ", "DELPHI_EXPLORATION.DB_EXP_SCHEMA_V_YT_ACTIVE_CLAIMS_VIEW_READ", "DELPHI_EXPLORATION.DB_EXP_SCHEMA_V_YT_CONTENT_OWNER_ASSET_VIEW_READ", "DELPHI_EXPLORATION.DB_EXP_SCHEMA_V_YT_PLAYLIST_COMBINED_VIEW_READ", "DELPHI_EXPLORATION.DB_EXP_SCHEMA_V_YT_VIDEO_ISRC_VIEW_READ", "DELPHI_EXPLORATION.DB_EXP_SCHEMA_V_GRAS_BUSINESS_UNIT_VIEW_READ", "DELPHI_EXPLORATION.DB_EXP_SCHEMA_V_GRAS_COMPANY_VIEW_READ", "DELPHI_EXPLORATION.DB_EXP_SCHEMA_V_GRAS_CONFIGURATION_VIEW_READ", "DELPHI_EXPLORATION.DB_EXP_SCHEMA_V_GRAS_CONFIGURATION_CATEGORY_VIEW_READ", "DELPHI_EXPLORATION.DB_EXP_SCHEMA_V_GRAS_COUNTRY_VIEW_READ", "DELPHI_EXPLORATION.DB_EXP_SCHEMA_V_GRAS_DIM_COMPONENT_VIEW_READ", "DELPHI_EXPLORATION.DB_EXP_SCHEMA_V_GRAS_DIM_SAP_COMPANY_VIEW_READ", "DELPHI_EXPLORATION.DB_EXP_SCHEMA_V_GRAS_DIM_SAP_PROFIT_CENTER_VIEW_READ", "DELPHI_EXPLORATION.DB_EXP_SCHEMA_V_GRAS_DIM_SONG_VIEW_READ", "DELPHI_EXPLORATION.DB_EXP_SCHEMA_V_GRAS_DIM_SONG_PARTICIPANT_VIEW_READ", "DELPHI_EXPLORATION.DB_EXP_SCHEMA_V_GRAS_DIM_TASK_TYPE_VIEW_READ", "DELPHI_EXPLORATION.DB_EXP_SCHEMA_V_GRAS_FIN_LABEL_VIEW_READ", "DELPHI_EXPLORATION.DB_EXP_SCHEMA_V_GRAS_FIN_LABEL_LABEL_VIEW_READ", "DELPHI_EXPLORATION.DB_EXP_SCHEMA_V_GRAS_FIN_LABEL_PROFIT_CENTER_VIEW_READ", "DELPHI_EXPLORATION.DB_EXP_SCHEMA_V_GRAS_GENRE_VIEW_READ", "DELPHI_EXPLORATION.DB_EXP_SCHEMA_V_GRAS_LABEL_VIEW_READ", "DELPHI_EXPLORATION.DB_EXP_SCHEMA_V_GRAS_LANGUAGE_VIEW_READ", "DELPHI_EXPLORATION.DB_EXP_SCHEMA_V_GRAS_MEDIA_TYPE_VIEW_READ", "DELPHI_EXPLORATION.DB_EXP_SCHEMA_V_GRAS_PARENT_FIN_LABEL_VIEW_READ", "DELPHI_EXPLORATION.DB_EXP_SCHEMA_V_GRAS_PARTICIPANT_VIEW_READ", "DELPHI_EXPLORATION.DB_EXP_SCHEMA_V_GRAS_PARTICIPANT_MEMBER_VIEW_READ", "DELPHI_EXPLORATION.DB_EXP_SCHEMA_V_GRAS_PARTICIPANT_PARTNER_INFO_VIEW_READ", "DELPHI_EXPLORATION.DB_EXP_SCHEMA_V_GRAS_PRODUCT_VIEW_READ", "DELPHI_EXPLORATION.DB_EXP_SCHEMA_V_GRAS_PRODUCT_CLASS_VIEW_READ", "DELPHI_EXPLORATION.DB_EXP_SCHEMA_V_GRAS_PRODUCT_COUNTRY_VIEW_READ", "DELPHI_EXPLORATION.DB_EXP_SCHEMA_V_GRAS_PRODUCT_COUNTRY_INFO_VIEW_READ", "DELPHI_EXPLORATION.DB_EXP_SCHEMA_V_GRAS_PRODUCT_TRACK_VIEW_READ", "DELPHI_EXPLORATION.DB_EXP_SCHEMA_V_GRAS_PRODUCT_VERSION_VIEW_READ", "DELPHI_EXPLORATION.DB_EXP_SCHEMA_V_GRAS_PROJECT_ARTIST_VIEW_READ", "DELPHI_EXPLORATION.DB_EXP_SCHEMA_V_GRAS_PROJECT_TYPE_VIEW_READ", "DELPHI_EXPLORATION.DB_EXP_SCHEMA_V_GRAS_RECORDING_PROJECT_VIEW_READ", "DELPHI_EXPLORATION.DB_EXP_SCHEMA_V_GRAS_REC_PROJECT_PRODUCT_VERSION_VIEW_READ", "DELPHI_EXPLORATION.DB_EXP_SCHEMA_V_GRAS_REPERTOIRE_OWNER_HIERARCHY_VIEW_READ", "DELPHI_EXPLORATION.DB_EXP_SCHEMA_V_GRAS_TRACK_VIEW_READ", "DELPHI_EXPLORATION.DB_EXP_SCHEMA_V_GRAS_TRACK_PARTICIPANT_VIEW_READ", ] }, { name = "DELPHI_PUBLIC_DATA_MAIN_PLAYLISTS_READ" comment = "PLAYLIST schema: Read of all tables" granted_database_roles = [ "DELPHI_PUBLIC_DATA_MAIN.DB_PLAYLISTS_SCHEMA_DIM_ALBUM_TABLE_READ", "DELPHI_PUBLIC_DATA_MAIN.DB_PLAYLISTS_SCHEMA_DIM_ALBUM_ARTIST_TABLE_READ", "DELPHI_PUBLIC_DATA_MAIN.DB_PLAYLISTS_SCHEMA_DIM_ARTIST_TABLE_READ", "DELPHI_PUBLIC_DATA_MAIN.DB_PLAYLISTS_SCHEMA_DIM_DSP_TABLE_READ", "DELPHI_PUBLIC_DATA_MAIN.DB_PLAYLISTS_SCHEMA_DIM_MARKET_TABLE_READ", "DELPHI_PUBLIC_DATA_MAIN.DB_PLAYLISTS_SCHEMA_DIM_PLAYLIST_TABLE_READ", "DELPHI_PUBLIC_DATA_MAIN.DB_PLAYLISTS_SCHEMA_DIM_PLAYLIST_EXTRA_TABLE_READ", "DELPHI_PUBLIC_DATA_MAIN.DB_PLAYLISTS_SCHEMA_DIM_PLAYLIST_OWNER_TABLE_READ", "DELPHI_PUBLIC_DATA_MAIN.DB_PLAYLISTS_SCHEMA_DIM_PLAYLIST_OWNER_CATEGORY_TABLE_READ", "DELPHI_PUBLIC_DATA_MAIN.DB_PLAYLISTS_SCHEMA_DIM_TRACK_TABLE_READ", "DELPHI_PUBLIC_DATA_MAIN.DB_PLAYLISTS_SCHEMA_DIM_TRACK_ALBUM_TABLE_READ", "DELPHI_PUBLIC_DATA_MAIN.DB_PLAYLISTS_SCHEMA_DIM_TRACK_ARTIST_TABLE_READ", "DELPHI_PUBLIC_DATA_MAIN.DB_PLAYLISTS_SCHEMA_FACT_PLAYLIST_TRACK_HISTORY_TABLE_READ", "DELPHI_PUBLIC_DATA_MAIN.DB_PLAYLISTS_SCHEMA_FACT_PLAYLIST_TRACK_SNAPSHOT_TABLE_READ", "DELPHI_PUBLIC_DATA_MAIN.DB_PLAYLISTS_SCHEMA_FACT_PLAYLIST_TRACKLIST_UPDATES_TABLE_READ", "DELPHI_PUBLIC_DATA_MAIN.DB_PLAYLISTS_SCHEMA_FACT_PUBLIC_APPLE_PLAYLIST_ISRC_LIFETIME_TABLE_READ", "DELPHI_PUBLIC_DATA_MAIN.DB_PLAYLISTS_SCHEMA_FACT_PUBLIC_SPOTIFY_PLAYLIST_ISRC_LIFETIME_TABLE_READ", "DELPHI_PUBLIC_DATA_MAIN.DB_PLAYLISTS_SCHEMA_FACT_SPOTIFY_PLAYLIST_FOLLOWERS_TABLE_READ", "DELPHI_PUBLIC_DATA_MAIN.DB_PLAYLISTS_SCHEMA_PLAYLIST_EVENT_HISTORY_TABLE_READ", "DELPHI_PUBLIC_DATA_MAIN.DB_PLAYLISTS_SCHEMA_PLAYLIST_TRACK_EVENT_HISTORY_TABLE_READ", "DELPHI_PUBLIC_DATA_MAIN.DB_PLAYLISTS_SCHEMA_STARRED_PLAYLIST_TABLE_READ", "DELPHI_PUBLIC_DATA_MAIN.DB_PLAYLISTS_SCHEMA_STARRED_TRACK_TABLE_READ", "DELPHI_PUBLIC_DATA_MAIN.DB_PLAYLISTS_SCHEMA_TOP_PLAYLIST_TABLE_READ", ] }, { name = "DEV_ENGINEERING" comment = "Generic developer role (managed by Terraform)." granted_account_roles = [ "ACCOUNTINGFLAT_DB_PROD_SCHEMA_READ", "APOLLO_DB_DEV_SCHEMA_READ", "APOLLO_DB_DEV_SCHEMA_READWRITE", "ARTRELATIONS_DB_DEV_SCHEMA_READ", "AWAL_DB_PROD_SCHEMA_READWRITE", "BUSINESS_SYSTEMS_SALESFORCE_DATA_DB_READ", "CAPSTONE_DB_PROD_SCHEMA_READWRITE", "CAPSTONE_DB_QA_SCHEMA_READWRITE", "CATALOGDATAANALYSIS_DB_DEV_SCHEMA_READWRITE", "CATALOGDATAANALYSIS_DB_PROD_SCHEMA_READ", "CATALOGDATAANALYSIS_DB_QA_SCHEMA_READ", "CHARTMETRIC_DB_RAW_DATA_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_READ", "DATA_APPS_DELETE_SME_PRODUCT_RL", "DELPHI_AE_REPORTING_DB_READ", "DELPHI_CRM_DATA_DB_READ", "DELPHI_EXPLORATION_DB_READ", "DELPHI_PUBLIC_DATA_MAIN_DB_READ", "DELPHI_PUBLIC_DATA_RAW_DB_READ", "DEV_DB_READONLY", "DEV_DB_READ_WRITE", "DEV_ENGINEERING_DB_READWRITE", "DEV_MYSQL_CONNECTOR", "DEV_PERFORMANCE", "DISTRIBUTION_DB_DEV_SCHEMA_READWRITE", "DISTRIBUTION_DB_PROD_SCHEMA_READ", "DISTRIBUTION_DB_QA_SCHEMA_READ", "DS_CHARTMETRIC_DB_READ", "FACTS_DB_QA_SCHEMA_READ", "FACTS_DB_READ_ONLY", "FACTS_DB_SME_SCHEMA_READ", "FANSIFTER_DB_DEV_SCHEMA_READWRITE", "FANSIFTER_DB_PROD_SCHEMA_READ", "FANSIFTER_DB_QA_SCHEMA_READWRITE", "FILMTRANSPARENCY_DB_PROD_SCHEMA_READ", "INTEGRATION_DB_DEV_SCHEMA_READWRITE", "INTEGRATION_DB_PROD_SCHEMA_READ", "INTEGRATION_DB_QA_SCHEMA_READ", "INTEGRATION_DB_READ_WRITE", "INTELLIGENCE_DB_READ_ONLY", "LUMINATE_SHARE_READ", "ORCHARDAPPREPORTING_DB_ARTRELATIONS_SCHEMA_READ", "ORCHARDAPPREPORTING_DB_DIRECTDELIVERY_SCHEMA_READ", "ORCHARDAPPREPORTING_DB_OWSASSETS_SCHEMA_READ", "ORCHARDAPPREPORTING_DB_OWSPRODUCTSTOREMAPPING_READ", "ORCHARDAPPREPORTING_DB_OWSTIMEDRELEASESCHEDULE_READ", "ORCHARDAPPREPORTING_DB_READ_ONLY", "ORCHARD_FACTS", "OWSCONFLICTMANAGER_DB_DEV_SCHEMA_READWRITE", "OWSCONFLICTMANAGER_DB_PROD_SCHEMA_READ", "OWSCONFLICTMANAGER_DB_QA_SCHEMA_READ", "OWS_CONTENT_REVIEW_DB_PROD_SCHEMA_READ", "OWS_CONTENT_REVIEW_DB_QA_SCHEMA_READ", "PERMISSIONS_PLATFORM_DB_PROD_SCHEMA_READ", "PERMISSIONS_PLATFORM_DB_QA_SCHEMA_READWRITE", "PPBCOLLECTIONS_DB_READ_ONLY", "PRICING_DB_PROD_SCHEMA_READ", "PROD_AUTH0_ACCESS_INTEGRATION_USAGE", "PROD_DB_READ_ONLY", "PROD_LAMBDA_SOUNDEXCHANGE_ROLE", "PROD_SIGMA_DB_READ_WRITE", "PROMOPLAYER_DB_PROD_SCHEMA_READ", "PRS_SALESSHEETS_DB_QA_SCHEMA_READWRITE", "QA_AUTH0_ACCESS_INTEGRATION_USAGE", "QA_LAMBDA_NEW_RELEASES_BLASTER", "QA_LAMBDA_SOUNDEXCHANGE_ROLE", "ROYALTYACCOUNTING_DB_DEV_SCHEMA_READWRITE", "ROYALTYACCOUNTING_DB_QA_SCHEMA_READ", "ROYALTYACCOUNTING_DB_QA_SCHEMA_READWRITE", "ROYALTYACCOUNTING_DB_READONLY", "ROYALTYACCOUNTING_DB_UAT_SCHEMA_READWRITE", "ROYALTY_ACCOUNTING_REPORTING_DB_DEV_SCHEMA_READWRITE", "ROYALTY_ACCOUNTING_REPORTING_DB_PROD_SCHEMA_READ", "ROYALTY_ACCOUNTING_REPORTING_DB_QA_SCHEMA_READWRITE", "ROYALTY_ACCOUNTING_REPORTING_DB_UAT_SCHEMA_READWRITE", "S3_INTEGRATIONS_DB_PROD_SCHEMA_READ", "S3_INTEGRATIONS_DB_QA_SCHEMA_READWRITE", "SALESGOAL_DB_PROD_SCHEMA_READ", "SALESSHEETS_DB_PROD_SCHEMA_READ", "SEGMENT", "SMEJ", "SMEJ_DB_PROD_SCHEMA_READ", "SNOWFLAKE_DOCUMENTATION_SHARE_READ", "SONYINTERNAL_DB_DEV_SCHEMA_READWRITE", "SONYINTERNAL_DB_PROD_SCHEMA_READ", "SONYINTERNAL_DB_READ_ONLY", "SONYMETADATA_DB_DEV_SCHEMA_READWRITE", "SONY_INTERNAL_DEV", "STMTDB_DB_QA_SCHEMA_READ", "STMT_DB_READ_ONLY", "TASKADMIN", # compute pools "ORCHARD_SOLUTIONS_COMPUTE_POOL_COMPUTE_POOL_ACCESS", # warehouses "ANALYTICS_AD_HOC_WAREHOUSE_ACCESS", "AWAL_DEV_WAREHOUSE_WAREHOUSE_ACCESS", "DATA_BETA_WAREHOUSE_WAREHOUSE_MONITOR", "DEPLOY_WAREHOUSE_WAREHOUSE_MONITOR", "DEV_OWS_WAREHOUSE_WAREHOUSE_ACCESS", "DEV_OWS_WH_WAREHOUSE_ACCESS", "DEV_PERFORMANCE_WAREHOUSE_WAREHOUSE_ACCESS", "EXPLORATION_WH_WAREHOUSE_ACCESS", "LOOKER_DYNAMIC_TABLE_REFRESH_WAREHOUSE_ACCESS", "LOOKER_HIGH_PERFORMANCE_WAREHOUSE_ACCESS", "PDE_SIGMA_WAREHOUSE_WAREHOUSE_ACCESS", "PROD_ACCOUNTING_DBT_WAREHOUSE_WAREHOUSE_ACCESS", "PROD_ASYNC_REPORTING_WAREHOUSE_WAREHOUSE_MONITOR", "PROD_DBT_WAREHOUSE_WAREHOUSE_ACCESS", "PROD_ETL_ACCOUNTING_WAREHOUSE_WAREHOUSE_MONITOR", "PROD_ETL_WAREHOUSE_WAREHOUSE_MONITOR", "PROD_FANSIFTER_FAN_ENGAGEMENT_WAREHOUSE_WAREHOUSE_ACCESS", "PROD_FIVETRAN_WAREHOUSE_WAREHOUSE_ACCESS", "PROD_OWS_REPORTING_WAREHOUSE_WAREHOUSE_MONITOR", "PROD_OWS_WAREHOUSE_WAREHOUSE_MONITOR", "PROD_PLAYLIST_WAREHOUSE_WAREHOUSE_MONITOR", "QA_ABACUS_WH_ACCESS", "QA_DBT_WAREHOUSE_WAREHOUSE_ACCESS", "QA_ETL_WAREHOUSE_WAREHOUSE_ACCESS", "QA_OWS_REPORTING_WAREHOUSE_WAREHOUSE_MONITOR", "QA_PLAYLIST_WAREHOUSE_WAREHOUSE_MONITOR", "QA_SWF_COLLABORATOR_REPORT_WAREHOUSE_ACCESS", "SONY_INTERNAL_WH_LARGE_WAREHOUSE_ACCESS", "SPOTIFY_BACKFILL_ETL_WAREHOUSE_WAREHOUSE_MONITOR", "STREAMLIT_DATA_APPS_WH_WAREHOUSE_ACCESS", "SWF_ACTIVITY_DETECTOR_WAREHOUSE_MONITOR", "SWF_SME_ANALYTICS_INGEST_DATA_BACKLOAD_WAREHOUSE_ACCESS", "TEAM_DEV_BA_WH_WAREHOUSE_ACCESS", "fact_analytics_backfill_ds_10291_wh_WAREHOUSE_ACCESS", ] granted_database_roles = [ "DEV_ENGINEERING.DB_READWRITE", "DEV_DBT.DB_READWRITE", "APP_ENABLEMENT.DB_READWRITE", "DELPHI_ADS_DATA.DB_READ", "DELPHI_CHARTMETRIC_ETL.DB_READ", "DELPHI_CHARTMETRIC_MAIN.DB_READ", "DELPHI_CHARTMETRIC_RAW.DB_READ", "DELPHI_CHARTS_ETL.DB_READ", "DELPHI_CHARTS_MAIN.DB_READ", "DELPHI_CHARTS_RAW.DB_READ", "DELPHI_LINKFIRE.DB_READ", "DELPHI_PUBLIC_DATA_ETL.DB_READ", "DELPHI_TIKTOK_CHARTMETRIC.DB_READ", "LUMINATE_MODELS.DB_READ", "LUMINATE_MODELS.DB_DEV_SCHEMA_READWRITE", "REVENUE_FILE_INGESTION.DB_READ", "REVENUE_FILE_INGESTION.DB_DEV_SCHEMA_READWRITE", "REVENUE_FILE_INGESTION.DB_QA_SCHEMA_qa-revenue-file-ingestion-s3-stage_STAGE_USAGE", "SALES_PROCESSING.DB_READ", "FRAUD_REPORTING.DB_READ", "QA_FRAUD_REPORTING.DB_READ", "QA_CONSUMER_REPORTING.DB_READ", "CONSUMER_REPORTING.DB_READ", "LORELAI_AGENT.DB_DEV_SCHEMA_LORELAI_AGENT_USAGE", "BEATDAPP.DB_PROD_SCHEMA_READ", "SHOPIFY_STORES_GLOBAL.DB_READ", "SHOPIFY_STORES_GLOBAL.DB_QA_D2C_OPERATIONS_SCHEMA_READWRITE", ] }, { name = "DEV_FIVETRAN" granted_account_roles = [ "DEV_OWS_WAREHOUSE_WAREHOUSE_ACCESS", "SONYMETADATA_DB_DEV_SCHEMA_READWRITE", ] }, { name = "DEV_ROYALTY_ACCOUNTING_REFRESH" granted_account_roles = [ "ROYALTYACCOUNTING_DB_PROD_SCHEMA_READ", "ROYALTYACCOUNTING_DB_DEV_SCHEMA_READWRITE", ] }, { name = "DEV_VSR_SERVICE" comment = "Functional role for the Virtual Sales Rep dev service account (INT-2720)" granted_database_roles = [ "VIRTUALSALESREP.DB_DEV_SCHEMA_READWRITE", "SONY_INTERNAL.DB_DEV_SCHEMA_READ", "SONY_INTERNAL.DB_PROD_SCHEMA_READ", ] }, { name = "DNA" }, { name = "DNA_CHARTMETRIC_RO" }, { name = "DNA_DEV" comment = "The role for “DNA”.“DNA_PUBLIC_QA” + “DNA”.“DNA_PUBLIC_DEV” + “DNA”.“DNA_PUBLIC_LOCAL” RW data access (manual interaction with DB)" granted_account_roles = [ "DNA_CHARTMETRIC_RO", ] }, { name = "DNA_NON_PROD" comment = "The role for “DNA”.“DNA_PUBLIC_QA” + “DNA”.“DNA_PUBLIC_DEV” + “DNA”.“DNA_PUBLIC_LOCAL” RW data access (automation purposes)" granted_account_roles = [ "DNA_CHARTMETRIC_RO", ] }, { name = "DNA_PROD" comment = "The role for “DNA”.“DNA_PUBLIC_PROD” + “DNA”.“DNA_PUBLIC_UAT” RW data access (automation purposes)" granted_account_roles = [ "DNA_CHARTMETRIC_RO", ] }, { name = "DNA_STAKEHOLDER" comment = "The role for R data access (manual interaction with DB)" granted_account_roles = [ "DNA_CHARTMETRIC_RO", ] }, { name = "EMAILPOC_STREAMLIT_ACCESS" granted_database_roles = [ "FANSIFTER_APP_REPORTING.DB_DEV_RBOMBERG_SCHEMA_EMAILPOC_STREAMLIT", ] }, { name = "ENGINEER" comment = "All Engineers of SME-Data analytics team" }, { name = "EXPLORATION_ADV_USER" }, { name = "EXPLORATION_AD_PLUS" granted_account_roles = [ "EXPLORATION_WH_WAREHOUSE_ACCESS", ] }, { name = "EXPLORATION_BASE" comment = "Deprecated. This is a copy of EXPLORATION_USER but without warehouses access. Created by manual script which copies permissions from EXPLORATION_USER." }, { name = "EXPLORATION_BASE_AD_PLUS" comment = "Deprecated. This is a copy of EXPLORATION_AD_PLUS but without warehouses access. Created by manual script which copies permissions from EXPLORATION_AD_PLUS." }, { name = "EXPLORATION_SANDBOX_RW_ROLE" granted_database_roles = [ "DELPHI_EXPLORATION.DB_EXPLORATION_SANDBOX_SCHEMA_READWRITE", ] }, { name = "EXPLORATION_SYS_USER" granted_account_roles = [ "EXPLORATION_WH_WAREHOUSE_ACCESS", ] }, { name = "EXPLORATION_USER" granted_account_roles = [ "EXPLORATION_WH_WAREHOUSE_ACCESS", ] }, { name = "FACTS_DB_PROD_SCHEMA_READWRITE" granted_account_roles = [ "CHARTMETRIC_DB_RAW_DATA_SCHEMA_READ", "INTELLIGENCE_DB_PROD_SCHEMA_READWRITE", "ORCHARDAPPREPORTING_DB_ARTRELATIONS_SCHEMA_READ", "ORCHARDAPPREPORTING_DB_PRODDDEXINGESTER_SCHEMA_READ", "ORCHARDAPPREPORTING_DB_READ_ONLY", "OWSCONFLICTMANAGER_DB_PROD_SCHEMA_READ", "PROD_DB_READ_ONLY", "PROD_DB_YTREPORTSAPI_SCHEMA_READWRITE", "PROD_TASK_WAREHOUSE_WAREHOUSE_ACCESS", "ROYALTYACCOUNTING_DB_PROD_SCHEMA_READ", "SONYINTERNAL_DB_DEV_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", "GRPS_APP_REPORTING_NOCONF.DB_GRPS_DRAS002_SCHEMA_READ", "CONSUMER_REPORTING.DB_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 = "FACTS_DB_QA_SCHEMA_READWRITE" granted_account_roles = [ "CHARTMETRIC_DB_RAW_DATA_SCHEMA_READ", "DS_CHARTMETRIC_DB_READ", "INTELLIGENCE_DB_PROD_SCHEMA_READWRITE", "INTELLIGENCE_DB_QA_SCHEMA_READWRITE", "ORCHARDAPPREPORTING_DB_ARTRELATIONS_SCHEMA_READ", "ORCHARDAPPREPORTING_DB_PRODDDEXINGESTER_SCHEMA_READ", "ORCHARDAPPREPORTING_DB_READ_ONLY", "OWSCONFLICTMANAGER_DB_QA_SCHEMA_READ", "PROD_DB_QA_YT_REPORTS_API_SCHEMA_READWRITE", "PROD_DB_READ_ONLY", "QA_OWS_ANALYTICS_READ", "QA_OWS_ANALYTICS_READWRITE", "QA_TASK_WAREHOUSE_WAREHOUSE_ACCESS", "ROYALTYACCOUNTING_DB_QA_SCHEMA_READ", "SONYINTERNAL_DB_DEV_SCHEMA_READWRITE", ] granted_database_roles = [ "FACTS.DB_DEV_SCHEMA_MODELS_READWRITE", "FACTS.DB_QA_SCHEMA_MODELS_READWRITE", "FACTS.DB_QA_SCHEMA_READWRITE", "GRPS_APP_REPORTING_NOCONF.DB_PROD_SCHEMA_READ", "GRPS_APP_REPORTING_NOCONF.DB_GRPS_DRAS002_SCHEMA_READ", "QA_CONSUMER_REPORTING.DB_READ", ] }, { name = "FACTS_DEV_ML_READWRITE" granted_account_roles = [ "DEV_ENGINEERING", "DEV_OWS_WAREHOUSE_WAREHOUSE_ACCESS", "FACTS_DB_DEV_REPOSITORY_READWRITE", "FACTS_DB_FEATURE_STORE_ROLE_CONSUMER", "FACTS_DB_FEATURE_STORE_ROLE_PRODUCER", "FACTS_DEV_NOTEBOOKS_CONTAINER_RUNTIME_COMPUTE_POOL_ACCESS", "INTELLIGENCE_DB_READ_WRITE", "SNOWFLAKE_NOTEBOOKS_WAREHOUSE_WAREHOUSE_ACCESS", ] 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", ] }, { name = "FANSIFTER_AD_REPORTING_VIEWS_ACCESS" granted_database_roles = [ "FANSIFTER_APP_REPORTING.DB_PROD_VIEWS_SCHEMA_V_FS_AD_REPORTING_ACCOUNT_DBT_VIEW_READ", "FANSIFTER_APP_REPORTING.DB_PROD_VIEWS_SCHEMA_V_FS_AD_REPORTING_CAMPAIGN_DBT_VIEW_READ", "FANSIFTER_APP_REPORTING.DB_PROD_VIEWS_SCHEMA_V_FS_AD_REPORTING_CAMPAIGN_DATE_DBT_VIEW_READ", "FANSIFTER_APP_REPORTING.DB_PROD_VIEWS_SCHEMA_V_FS_AD_REPORTING_CAMPAIGN_COUNTRY_DBT_VIEW_READ", "FANSIFTER_APP_REPORTING.DB_PROD_VIEWS_SCHEMA_V_FS_AD_REPORTING_CAMPAIGN_COUNTRY_DATE_DBT_VIEW_READ", "FANSIFTER_APP_REPORTING.DB_PROD_VIEWS_SCHEMA_V_FS_AD_REPORTING_AD_SET_DBT_VIEW_READ", "FANSIFTER_APP_REPORTING.DB_PROD_VIEWS_SCHEMA_V_FS_AD_REPORTING_AD_SET_DATE_DBT_VIEW_READ", "FANSIFTER_APP_REPORTING.DB_PROD_VIEWS_SCHEMA_V_FS_AD_REPORTING_AD_SET_COUNTRY_DBT_VIEW_READ", "FANSIFTER_APP_REPORTING.DB_PROD_VIEWS_SCHEMA_V_FS_AD_REPORTING_AD_SET_COUNTRY_DATE_DBT_VIEW_READ", "FANSIFTER_APP_REPORTING.DB_PROD_VIEWS_SCHEMA_V_FS_AD_REPORTING_AD_DBT_VIEW_READ", "FANSIFTER_APP_REPORTING.DB_PROD_VIEWS_SCHEMA_V_FS_AD_REPORTING_AD_DATE_DBT_VIEW_READ", "FANSIFTER_APP_REPORTING.DB_PROD_VIEWS_SCHEMA_V_FS_AD_REPORTING_AD_COUNTRY_DBT_VIEW_READ", "FANSIFTER_APP_REPORTING.DB_PROD_VIEWS_SCHEMA_V_FS_AD_REPORTING_AD_COUNTRY_DATE_DBT_VIEW_READ", ] }, { name = "FANSIFTER_ANALYST" granted_account_roles = [ "FANSIFTER_APP_REPORTING_DB_PROD_SCHEMA_READ", "FANSIFTER_APP_REPORTING_DB_QA_SCHEMA_READ", "DEV_ENGINEERING", ] }, { name = "FANSIFTER_ANALYTIC_POC" granted_account_roles = [ "EMAILPOC_STREAMLIT_ACCESS", ] }, { name = "FANSIFTER_APP_REPORTING_DB_PROD_SCHEMA_FILEUPLOAD_STREAMLIT" granted_database_roles = [ "FANSIFTER_APP_REPORTING.DB_PROD_SCHEMA_FILEUPLOAD_STREAMLIT", ] }, { name = "FANSIFTER_ARTIST_ROSTER_VIEWS_ACCESS" granted_database_roles = [ "FANSIFTER_APP_REPORTING.DB_PROD_VIEWS_SCHEMA_FS_ARTIST_ROSTER_DBT_VIEW_READ", "FANSIFTER_APP_REPORTING.DB_PROD_VIEWS_SCHEMA_FS_SME_REP_OWNER_ARTIST_ROSTER_DBT_VIEW_READ", "FANSIFTER_APP_REPORTING.DB_PROD_VIEWS_SCHEMA_FS_SME_IRL_REP_ARTIST_ROSTER_DBT_VIEW_READ", ] }, { name = "FANSIFTER_ARTIST_VIEWS_ACCESS" granted_database_roles = [ "FANSIFTER_APP_REPORTING.DB_PROD_VIEWS_SCHEMA_V_FS_FANS_BY_ARTIST_DBT_VIEW_READ", "FANSIFTER_APP_REPORTING.DB_PROD_VIEWS_SCHEMA_V_FS_FANS_BY_ARTIST_DATE_DBT_VIEW_READ", "FANSIFTER_APP_REPORTING.DB_PROD_VIEWS_SCHEMA_V_FS_FANS_BY_ARTIST_COUNTRY_DBT_VIEW_READ", "FANSIFTER_APP_REPORTING.DB_PROD_VIEWS_SCHEMA_V_FS_FANS_BY_ARTIST_COUNTRY_DATE_DBT_VIEW_READ", ] }, { name = "FANSIFTER_CRM_FANS" granted_account_roles = [ "FANSIFTER_APP_REPORTING_DB_QA_CRM_FANS_SCHEMA_READ", "FANSIFTER_APP_REPORTING_DB_PROD_CRM_FANS_SCHEMA_READ", "CRM_FANRESPONSE_WH_WAREHOUSE_ACCESS", ] granted_database_roles = [ "FANSIFTER_APP_REPORTING.DB_QA_CRM_FANS_SCHEMA_TRIGGERED_SENDS_STREAMLIT", ] }, { name = "FANSIFTER_EMAIL_VIEWS_ACCESS" granted_database_roles = [ "FANSIFTER_APP_REPORTING.DB_PROD_VIEWS_SCHEMA_V_FS_EMAIL_AUTOMATED_VIEW_READ", "FANSIFTER_APP_REPORTING.DB_PROD_VIEWS_SCHEMA_V_FS_EMAIL_CAMPAIGN_VIEW_READ", ] }, { name = "FANSIFTER_ENGINEERING" granted_account_roles = [ "DEV_ENGINEERING", "FANSIFTER_SHOPIFY_ANALYST", "FANSIFTER_APP_REPORTING_DB_READWRITE", "DELPHI_EXPLORATION_DB_READ", "DELPHI_CRM_DATA_DB_READ", "QA_CRM_ECOMMERCE_DATA_DB_READ", "CRM_ECOMMERCE_DATA_DB_READ", "FANSIFTER_PG_REPORTING_DB_QA_OWS_DMP_PUBLIC_SCHEMA_READ", "FANSIFTER_PG_REPORTING_DB_PROD_OWS_DMP_PUBLIC_SCHEMA_READ", "ORCHARD_APP_REPORTING_DB_DELPHI_PROD_SCHEMA_READ", "PREFERENCE_CENTER_DB_CREATE_SCHEMA", "PREFERENCE_CENTER_DB_QA_SCHEMA_READWRITE", "PREFERENCE_CENTER_DB_PROD_SCHEMA_READWRITE", "QA_MARKETING_INTEGRATIONS_DB_READWRITE", "PROD_MARKETING_INTEGRATIONS_DB_READ", "SONGWHIP_APP_REPORTING_DB_READ", "QA_SHOPIFY_INTEGRATIONS_DB_READ", "QA_SHOPIFY_INTEGRATIONS_FIVETRAN", "PROD_SHOPIFY_INTEGRATIONS_DB_READ", "PROD_SHOPIFY_INTEGRATIONS_FIVETRAN", "FANSIFTER_APP_REPORTING_DB_QA_CRM_FANS_SCHEMA_READ", "FANSIFTER_APP_REPORTING_DB_PROD_CRM_FANS_SCHEMA_READ", "EMAILPOC_STREAMLIT_ACCESS", "FANSIFTER_ROSTER_MANAGEMENT_SCHEMA_STREAMLITS_ACCESS", "DEV_DBT_WH_WAREHOUSE_ACCESS", "QA_DBT_WH_WAREHOUSE_ACCESS", "PROD_DBT_WH_WAREHOUSE_ACCESS", "CICD_WH_WAREHOUSE_ACCESS", "QA_PREFERENCE_CENTER_WH_WAREHOUSE_ACCESS", "PROD_PREFERENCE_CENTER_WH_WAREHOUSE_ACCESS", "QA_OWS_WH_WAREHOUSE_ACCESS", "PROD_OWS_WH_WAREHOUSE_ACCESS", "DELPHI_EXPLORATION_DB_SYS_SCHEMA_READ", "QA_FANSIFTER_STREAMLIT_WH_WAREHOUSE_ACCESS", "PROD_FANSIFTER_STREAMLIT_WH_WAREHOUSE_ACCESS", ] granted_database_roles = [ "FAN_LIVE_EVENTS.DB_QA_SCHEMA_READ", "FAN_LIVE_EVENTS.DB_PROD_SCHEMA_READ", "SME_DATA_SCIENCE_AND_ANALYTICS.DB_READ", "FANSIFTER_APP_REPORTING.DB_PROD_STREAMLIT_FANSIFTER_BACKOFFICE_SCHEMA_STREAMLITS_READ", "RESONANCE_ENGINE.DB_CREATE_SCHEMA", "RESONANCE_ENGINE.DB_READ", "RESONANCE_ENGINE.DB_QA_SCHEMA_READWRITE", "RESONANCE_ENGINE.DB_PROD_SCHEMA_READ", "FANSIFTER_SHOPIFY.DB_CREATE_SCHEMA", "FANSIFTER_SHOPIFY.DB_CI_PR_SCHEMA_READWRITE", "FANSIFTER_SHOPIFY.DB_CI_TEST_SCHEMA_READWRITE", "FANSIFTER_SHOPIFY.DB_QA_SCHEMA_READWRITE", "FANSIFTER_SHOPIFY.DB_PROD_SCHEMA_READ", "SME_DATA_SCIENCE_AND_ANALYTICS.DB_QA_SCHEMA_READWRITE", ] }, { name = "FANSIFTER_ENGINEERING_PRIVACY" granted_account_roles = [ "FANSIFTER_ENGINEERING", "SME_MERCH_STREAMLIT_ACCESS", "QA_ETL_WH_WAREHOUSE_ACCESS", "PROD_ETL_WH_WAREHOUSE_ACCESS", "DELPHI_AE_REPORTING_DB_MAIN_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_READWRITE", "DELPHI_CRM_DATA_DB_RAW_SALESFORCE_MARKETING_CLOUD_SCHEMA_READWRITE", "DELPHI_AE_REPORTING_DB_EXP_SCHEMA_READWRITE", "CRM_FANRESPONSE_WH_WAREHOUSE_ACCESS", "DELPHI_CRM_DATA_DB_HIGHTOUCH_AUDIT_SCHEMA_READ", "FANSIFTER_PII_ACCESS", ] granted_database_roles = [ "FAN_LIVE_EVENTS.DB_QA_SCHEMA_READ", "FAN_LIVE_EVENTS.DB_PROD_SCHEMA_READ", "DELPHI_EXPLORATION.DB_EXPLORATION_SANDBOX_SCHEMA_READWRITE", "DELPHI_CHARTMETRIC_MAIN.DB_SYS_SCHEMA_READWRITE", "DELPHI_LINKFIRE.DB_READWRITE", "SHOPIFY_STORES_GLOBAL.DB_READ", ] }, { name = "FANSIFTER_MARKETING_ANALYST" granted_account_roles = [ "EXPLORATION_WH_WAREHOUSE_ACCESS", "FANSIFTER_MARKETING_ANALYST_BASE", ] }, { name = "FANSIFTER_MARKETING_ANALYST_BASE" granted_account_roles = [ "PROD_MARKETING_INTEGRATIONS_DB_READ", "FANSIFTER_APP_REPORTING_DB_PROD_MARKETING_SCHEMA_READ", "MARQUEE_ACCESS", ] }, { name = "FANSIFTER_PII_ACCESS" comment = "Grants access to Fansifter-related PII data in the respective masking policies. This role should be granted to other roles who need PII access. No roles should be granted to this role itself." }, { name = "FANSIFTER_PRIVACY" }, { name = "FANSIFTER_ROSTER_MANAGEMENT_SCHEMA_STREAMLITS_ACCESS" granted_database_roles = [ "FANSIFTER_APP_REPORTING.DB_QA_STREAMLIT_ROSTER_MANAGEMENT_SCHEMA_STREAMLITS_READ", "FANSIFTER_APP_REPORTING.DB_PROD_STREAMLIT_ROSTER_MANAGEMENT_SCHEMA_STREAMLITS_READ", ] }, { name = "FANSIFTER_SHOPIFY_ANALYST" granted_account_roles = [ "FANSIFTER_APP_REPORTING_DB_PROD_SHOPIFY_SCHEMA_READ", "FANSIFTER_APP_REPORTING_DB_QA_SHOPIFY_SCHEMA_READ", "PROD_SHOPIFY_INTEGRATIONS_DB_READ", "QA_SHOPIFY_INTEGRATIONS_DB_READ", "QA_SHOPIFY_INTEGRATIONS_WH_WAREHOUSE_ACCESS", "PROD_SHOPIFY_INTEGRATIONS_WH_WAREHOUSE_ACCESS", ] granted_database_roles = [ "FANSIFTER_APP_REPORTING.DB_QA_SCHEMA_SME_SHOPIFY_STORE_VIEW_READ", "FANSIFTER_APP_REPORTING.DB_PROD_SCHEMA_SME_SHOPIFY_STORE_VIEW_READ", ] }, { name = "FANSIFTER_STREAMLIT_DEPLOYMENT_ROLE" granted_account_roles = [ "CICD_WH_WAREHOUSE_ACCESS", "QA_ETL_WH_WAREHOUSE_ACCESS", "PROD_FANSIFTER_STREAMLIT_WH_WAREHOUSE_ACCESS", "FANSIFTER_APP_REPORTING_DB_PROD_STREAMLIT_FAN_EXPORT_SCHEMA_READWRITE", "FANSIFTER_APP_REPORTING_DB_PROD_STREAMLIT_SME_MERCH_SCHEMA_READWRITE", "FANSIFTER_APP_REPORTING_DB_DEV_RBOMBERG_SCHEMA_READWRITE", "FANSIFTER_APP_REPORTING_DB_QA_STREAMLIT_ROSTER_MANAGEMENT_SCHEMA_READWRITE", "FANSIFTER_APP_REPORTING_DB_PROD_STREAMLIT_ROSTER_MANAGEMENT_SCHEMA_READWRITE", "FANSIFTER_APP_REPORTING_DB_PROD_STREAMLIT_FANSIFTER_BACKOFFICE_SCHEMA_READWRITE", "PREFERENCE_CENTER_DB_QA_SCHEMA_READ", "PREFERENCE_CENTER_DB_PROD_SCHEMA_READ", "FANSIFTER_APP_REPORTING_DB_QA_SCHEMA_READWRITE", "FANSIFTER_APP_REPORTING_DB_PROD_SCHEMA_READWRITE", "FANSIFTER_PG_REPORTING_DB_PROD_OWS_DMP_PUBLIC_SCHEMA_READ", "FACTS_DB_PROD_SCHEMA_READ", "DELPHI_CRM_DATA_DB_RAW_SALESFORCE_SALES_CLOUD_SCHEMA_READ", "DELPHI_CRM_DATA_DB_HIGHTOUCH_AUDIT_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_CONSOLIDATION_DATA_SCHEMA_READ", "FANSIFTER_PII_ACCESS", ] granted_database_roles = [ "FANSIFTER_APP_REPORTING.DB_PROD_SCHEMA_CCPA_FAN_LIST_TABLE_READWRITE", "PREFERENCE_CENTER.DB_PROD_SCHEMA_DELETED_PROFILE_TABLE_READWRITE", ] }, { name = "FIVETRAN_PROD_ROLE" granted_account_roles = [ "FIVETRAN_READER_ROLE", ] }, { name = "FIVETRAN_READER_ROLE" }, { name = "FIVETRAN_SONGWHIP_ROLE" granted_account_roles = [ "SONGWHIP_APP_REPORTING_DB_READWRITE", "FIVETRAN_WAREHOUSE_WAREHOUSE_ACCESS", ] }, { name = "FRAUD_REPORTING_DB_DEPLOYMENT_ROLE" comment = "FRAUD_REPORTING deployment role" granted_account_roles = [ "DEPLOY_WAREHOUSE_WAREHOUSE_ACCESS", "FACTS_DB_PROD_SCHEMA_READ", "FACTS_DB_QA_SCHEMA_READ" ] granted_database_roles = [ "FRAUD_REPORTING.DB_AMAZON_SCHEMA_READWRITE", "FRAUD_REPORTING.DB_READWRITE", "QA_FRAUD_REPORTING.DB_READWRITE", ] }, { name = "GLOBAL_FINANCE" granted_account_roles = [ "GLOBAL_FINANCE_LARGE_WAREHOUSE_WAREHOUSE_ACCESS", "GLOBAL_FINANCE_MEDIUM_WAREHOUSE_WAREHOUSE_ACCESS", "GLOBAL_FINANCE_SMALL_WAREHOUSE_WAREHOUSE_ACCESS", "ANALYST_BASELINE_ROLE", "SME_DATA_INSIGHTS", ] granted_database_roles = [ "SME_ANALYTICS.DB_SHARED_SCHEMA_READWRITE", "SME_ANALYTICS.DB_GLOBAL_FINANCE_SCHEMA_READWRITE", ] }, { name = "GRPS_APP_REPORTING_DB_READ" grant_to_sysadmin = false granted_database_roles = [ "GRPS_APP_REPORTING.DB_READ", ] }, { name = "GRPS_APP_REPORTING_NOCONF_DB_DEPLOY" comment = "Role for database deployments to the GRPS_APP_REPORTING_NOCONF db " grant_to_sysadmin = false granted_account_roles = [ "DEPLOY_WAREHOUSE_WAREHOUSE_ACCESS", ] granted_database_roles = [ "GRPS_APP_REPORTING_NOCONF.DB_PROD_SCHEMA_READWRITE", "GRPS_APP_REPORTING_NOCONF.DB_GRPS_DDEX001_SCHEMA_READWRITE", "GRPS_APP_REPORTING_NOCONF.DB_GRPS_DRAS002_SCHEMA_READWRITE", "GRPS_APP_REPORTING_NOCONF.DB_GRPS_DRPS001_SCHEMA_READWRITE", "GRPS_APP_REPORTING_NOCONF.DB_GRPS_DSWB001_SCHEMA_READWRITE", "GRPS_APP_REPORTING.DB_READ", ] }, { name = "GRPS_APP_REPORTING_NOCONF_READ" comment = "Role for read-only privilege to GRPS_APP_REPORTING_NOCONF database" granted_account_roles = [ "SME_SUPPLYCHAIN_SANDBOX", "DEV_OWS_WAREHOUSE_WAREHOUSE_ACCESS", "DEV_ENGINEERING", ] granted_database_roles = [ "GRPS_APP_REPORTING_NOCONF.DB_READ", "GRPS_APP_REPORTING_NOCONF.DB_PROD_SCHEMA_READ", "GRPS_APP_REPORTING_NOCONF.DB_GRPS_DDEX001_SCHEMA_READ", "GRPS_APP_REPORTING_NOCONF.DB_GRPS_DRAS002_SCHEMA_READ", "GRPS_APP_REPORTING_NOCONF.DB_GRPS_DRPS001_SCHEMA_READ", "GRPS_APP_REPORTING_NOCONF.DB_GRPS_DSWB001_SCHEMA_READ", ] }, { name = "GRPS_INGESTOR_DB_PROD_SCHEMA_DEPLOYMENT_ROLE" comment = "GRPS_INGESTOR PROD deployment role" account_level_grants = [ "EXECUTE TASK", ] granted_account_roles = [ "DEPLOY_WAREHOUSE_WAREHOUSE_ACCESS", "PROD_ETL_WAREHOUSE_WAREHOUSE_ACCESS", ] granted_database_roles = [ "GRPS_APP_REPORTING_NOCONF.DB_GRPS_DRAS002_SCHEMA_READ", "GRPS_APP_REPORTING_NOCONF.DB_GRPS_DRPS001_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", "DATA_APPS.DB_READ", ] }, { name = "GRPS_INGESTOR_DB_QA_SCHEMA_DEPLOYMENT_ROLE" comment = "GRPS_INGESTOR QA deployment role" account_level_grants = [ "EXECUTE TASK", ] granted_account_roles = [ "DEPLOY_WAREHOUSE_WAREHOUSE_ACCESS", "QA_ETL_WAREHOUSE_WAREHOUSE_ACCESS", ] granted_database_roles = [ "GRPS_APP_REPORTING_NOCONF.DB_GRPS_DRAS002_SCHEMA_READ", "GRPS_APP_REPORTING_NOCONF.DB_GRPS_DRPS001_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", "DATA_APPS.DB_READ", ] }, { name = "HIGHTOUCH_ROLE" owner = "SECURITYADMIN" }, { name = "INSIGHTS_TEAM_QA_FACTS_READWRITE" granted_account_roles = [ "QA_ETL_WAREHOUSE_WAREHOUSE_ACCESS", ] granted_database_roles = [ "FACTS.DB_QA_SCHEMA_READWRITE", ] }, { name = "JENKINS_CLI_ROLE" account_level_grants = [ "EXECUTE TASK", ] granted_account_roles = [ "CICD_WH_WAREHOUSE_ACCESS", "CRM_ECOMMERCE_DATA_DB_READWRITE", "DELPHI_AE_REPORTING_DB_READWRITE", "DELPHI_CRM_DATA_DB_READWRITE", "DELPHI_EXPLORATION_DB_CREATE_SCHEMA", "DELPHI_EXPLORATION_DB_READWRITE", "FANSIFTER_PG_REPORTING_DB_QA_OWS_DMP_PUBLIC_SCHEMA_READ", "FANSIFTER_PG_REPORTING_DB_PROD_OWS_DMP_PUBLIC_SCHEMA_READ", "FANSIFTER_APP_REPORTING_DB_QA_SCHEMA_READWRITE", "FANSIFTER_APP_REPORTING_DB_PROD_SCHEMA_READWRITE", "FANSIFTER_APP_REPORTING_DB_QA_SHOPIFY_SCHEMA_READ", "FANSIFTER_APP_REPORTING_DB_PROD_SHOPIFY_SCHEMA_READ", "FANSIFTER_APP_REPORTING_DB_QA_CRM_FANS_SCHEMA_READWRITE", "FANSIFTER_APP_REPORTING_DB_PROD_CRM_FANS_SCHEMA_READWRITE", "FANSIFTER_APP_REPORTING_DB_PROD_STREAMLIT_FAN_EXPORT_SCHEMA_READWRITE", "ORCHARD_APP_REPORTING_DB_DELPHI_PROD_SCHEMA_READ", "QA_CRM_ECOMMERCE_DATA_DB_READWRITE", "QA_ETL_WH_WAREHOUSE_ACCESS", "QA_OWS_WH_WAREHOUSE_ACCESS", "PREFERENCE_CENTER_DB_QA_SCHEMA_READWRITE", "PREFERENCE_CENTER_DB_PROD_SCHEMA_READWRITE", "PROD_ETL_WH_WAREHOUSE_ACCESS", "PROD_OWS_WH_WAREHOUSE_ACCESS", "CRM_ECOMMERCE_ROLE", "CRM_FANRESPONSE_WH_WAREHOUSE_ACCESS", "QA_SHOPIFY_INTEGRATIONS_FIVETRAN", "FIVETRAN_SONGWHIP_ROLE", "MASKING_ADMIN", "DELPHI_PUBLIC_DATA_MAIN_DB_READWRITE", "DELPHI_PUBLIC_DATA_RAW_DB_READWRITE", "QA_FANSIFTER_FAN_DELETION_WH_WAREHOUSE_ACCESS", "PROD_FANSIFTER_FAN_DELETION_WH_WAREHOUSE_ACCESS", "EXPLORATION_SYS_PROD_WH_WAREHOUSE_ACCESS", "EXPLORATION_SYS_PROD_HL_WH_WAREHOUSE_ACCESS", "QA_KAFKA_CONNECT_FS", "PROD_KAFKA_CONNECT_FS", "DELPHI_EXPLORATION_DB_SYS_SCHEMA_READWRITE", "LUMINATE_SHARE_READ", "ORCHARD_FACTS", "FACTS_DB_QA_SCHEMA_READ", "FACTS_DB_PROD_SCHEMA_READ", "SWF_DELPHI_ADS_DATA", "FIVETRAN_PROD_ROLE", ] granted_database_roles = [ "FAN_LIVE_EVENTS.DB_QA_SCHEMA_READWRITE", "FAN_LIVE_EVENTS.DB_PROD_SCHEMA_READWRITE", "APP_ENABLEMENT.DB_READWRITE", "DELPHI_ADS_DATA.DB_READWRITE", "DELPHI_CHARTMETRIC_ETL.DB_READWRITE", "DELPHI_CHARTMETRIC_MAIN.DB_READWRITE", "DELPHI_CHARTMETRIC_RAW.DB_READWRITE", "DELPHI_CHARTS_ETL.DB_READWRITE", "DELPHI_CHARTS_MAIN.DB_READWRITE", "DELPHI_CHARTS_RAW.DB_READWRITE", "DELPHI_LINKFIRE.DB_READWRITE", "DELPHI_PUBLIC_DATA_ETL.DB_READWRITE", "DELPHI_TIKTOK_CHARTMETRIC.DB_READWRITE", "LUMINATE_MODELS.DB_READWRITE", "LUMINATE_MODELS.DB_PROD_SCHEMA_READWRITE", "LUMINATE_MODELS.DB_QA_SCHEMA_READWRITE", "SME_ANALYTICS.DB_READWRITE", "SHOPIFY_STORES_GLOBAL.DB_READWRITE", "PARTNER_REPORTING.DB_READWRITE", "BUSINESS_SOLUTIONS.DB_READWRITE", "FANSIFTER_SHOPIFY.DB_READWRITE", "CONSUMER_REPORTING.DB_READ", "QA_CONSUMER_REPORTING.DB_READ", ] }, { name = "KAFKA_DATA_HIGHWAY_TEAM" granted_account_roles = [ "DELPHI_CRM_DATA_DB_READWRITE", "KAFKA_DATA_HIGHWAY_WH_WAREHOUSE_ACCESS", "FANSIFTER_APP_REPORTING_DB_QA_CRM_FANS_SCHEMA_READWRITE", "FANSIFTER_APP_REPORTING_DB_PROD_CRM_FANS_SCHEMA_READ", "FANSIFTER_CRM_FANS", "PROD_ETL_WH_WAREHOUSE_ACCESS", "QA_ETL_WH_WAREHOUSE_ACCESS", "PREFERENCE_CENTER_DB_QA_SCHEMA_READWRITE", "PREFERENCE_CENTER_DB_PROD_SCHEMA_READ", "FANSIFTER_APP_REPORTING_DB_QA_SHOPIFY_SCHEMA_READWRITE", "FANSIFTER_APP_REPORTING_DB_PROD_SHOPIFY_SCHEMA_READ", "QA_CRM_ECOMMERCE_DATA_DB_READWRITE", "CRM_ECOMMERCE_DATA_DB_READ", "FANSIFTER_APP_REPORTING_DB_PROD_SCHEMA_READ", "FANSIFTER_APP_REPORTING_DB_QA_SCHEMA_READWRITE", "DELPHI_EXPLORATION_DB_READ", "ORCHARD_APP_REPORTING_DB_DELPHI_PROD_SCHEMA_READ", "SONGWHIP_APP_REPORTING_DB_READ", "PROD_OWS_PREFERENCE_CENTER", "FANSIFTER_ENGINEERING_PRIVACY", "FANSIFTER_PII_ACCESS", "QA_KAFKA_CONNECT_FORMRESPONSE", "PROD_KAFKA_CONNECT_FORMRESPONSE", ] granted_database_roles = [ "FANSIFTER_APP_REPORTING.DB_QA_CRM_FANS_SCHEMA_dev-kafka-data-highway-s3-stage_STAGE_USAGE", "FAN_LIVE_EVENTS.DB_QA_SCHEMA_READ", "FAN_LIVE_EVENTS.DB_PROD_SCHEMA_READ", ] }, { name = "L1SUPPORT" granted_account_roles = [ "EXPLORATION_USER", "DELPHI_EXPLORATION_DB_APPS_ETL_SCHEMA_READ", ] }, { name = "L2SUPPORT" }, { name = "LOOKERADMIN" granted_account_roles = [ "FACTS_DB_PROD_SCHEMA_READ", "INTELLIGENCE_DB_DBT_PROD_SCHEMA_READ", ] granted_database_roles = [ "AWAL.DB_AWAL_TRUST_AND_SAFETY_SCHEMA_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 = "LUMINATE_SHARE_READ" comment = "Luminate data share read" granted_database_roles = [ "LUMINATE_MODELS.DB_PROD_SCHEMA_READ", ] }, { name = "MARKETING_INTEGRATIONS_FIVETRAN" granted_account_roles = [ "MARKETING_INTEGRATIONS_DB_READWRITE", "MARKETING_INTEGRATIONS_WAREHOUSE_ACCESS", ] }, { name = "MARKETING_ROI_ANALYST" granted_account_roles = [ "MARKETING_ROI_PROJECT_DB_READWRITE", "EXPLORATION_USER", "EXPLORATION_AD_PLUS", ] }, { name = "MARQUEE_ACCESS" granted_database_roles = [ "DELPHI_EXPLORATION.DB_EXP_SCHEMA_V_SPOTIFY_MARQUEE_CAMPAIGN_LEVEL_VIEW_READ", "DELPHI_EXPLORATION.DB_EXP_SCHEMA_V_SPOTIFY_MARQUEE_SEGMENT_LEVEL_VIEW_READ", "DELPHI_EXPLORATION.DB_EXP_SCHEMA_V_SPOTIFY_MARQUEE_CAMPAIGN_LEVEL_V2_VIEW_READ", "DELPHI_EXPLORATION.DB_EXP_SCHEMA_V_SPOTIFY_MARQUEE_SEGMENT_LEVEL_V2_VIEW_READ", ] }, { name = "MASKING_ADMIN" comment = "Role for managing and applying dynamic data masking policies" }, { name = "MOMENTS_PIPELINE_ROLE" granted_account_roles = [ "INTELLIGENCE_DB_DBT_PROD_PROJECT_MOMENTS_SCHEMA_READWRITE", "PROD_MOMENTS_WAREHOUSE_ACCESS", ] }, { name = "MONITOR_ADMIN" owner = "SECURITYADMIN" }, { name = "MONITOR_USAGE_ROLE" account_level_grants = [ "MONITOR USAGE", ] granted_account_roles = [ "DEV_OWS_WAREHOUSE_WAREHOUSE_ACCESS", "DEV_PERFORMANCE_WAREHOUSE_WAREHOUSE_ACCESS", ] }, { name = "OPERATIONS" granted_account_roles = [ "OPERATIONS_REPORTING_WAREHOUSE_WAREHOUSE_ACCESS", "ORCHARDAPPREPORTING_DB_ARTRELATIONS_SCHEMA_READ", "ORCHARDAPPREPORTING_DB_DIRECTDELIVERY_SCHEMA_READ", "ORCHARDAPPREPORTING_DB_OWSTRACK_SCHEMA_READ", "ROYALTYACCOUNTING_DB_PROD_SCHEMA_READ", ] granted_database_roles = [ "FACTS.DB_PROD_SCHEMA_READ", "ORCHARD_APP_REPORTING_V2.DB_ART_RELATIONS_PROD_ART_RELATIONS_LOG_SCHEMA_READ", "ORCHARD_APP_REPORTING_V2.DB_PPB_COLLECTIONS_PPB_COLLECTIONS_SCHEMA_READ", "ORCHARD_APP_REPORTING_V2.DB_PROD_OWS01_SALES_GOALS_SCHEMA_READ", "ORCHARD_APP_REPORTING_V2.DB_PROD_OWS01_YOUTUBE_OWNERSHIP_SCHEMA_READ", "ORCHARD_APP_REPORTING_V2.DB_PROD_OWS02_OWS_STORE_AVAILABILITY_SCHEMA_READ", "ORCHARD_APP_REPORTING_V2.DB_PROD_OWS02_OWS_TIMED_RELEASE_SCHEDULE_SCHEMA_READ", "ORCHARD_APP_REPORTING_V2.DB_PROD_OWS_ASSETS_OWS_ASSETS_SCHEMA_READ", "ORCHARD_APP_REPORTING_V2.DB_PROD_OWS_PRICING_PRICING_SCHEMA_READ", "ORCHARD_APP_REPORTING_V2.DB_PROD_OWS_PRODUCT_STORE_MAPPING_OWS_PRODUCT_STORE_MAPPING_SCHEMA_READ", "ORCHARD_APP_REPORTING_V2.DB_PROD_OWS_VIDEO_OWS_VIDEO_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 = "ORCHARD_ANALYTICS" granted_account_roles = [ "ANALYST_BASELINE_ROLE", "FANSIFTER_AD_REPORTING_VIEWS_ACCESS", "ORCHARD_ANALYTICS_SMALL_WAREHOUSE_WAREHOUSE_ACCESS", "ORCHARD_ANALYTICS_MEDIUM_WAREHOUSE_WAREHOUSE_ACCESS", "ORCHARD_ANALYTICS_LARGE_WAREHOUSE_WAREHOUSE_ACCESS", ] granted_database_roles = [ "SME_ANALYTICS.DB_SHARED_SCHEMA_READWRITE", "SME_ANALYTICS.DB_ORCHARD_ANALYTICS_SCHEMA_READWRITE", ] }, { name = "ORCHARD_ANALYTICS_TABLEAU_ROLE" granted_account_roles = [ "DEV_ANALYTICS_ORCHARD_WAREHOUSE_ACCESS", "INTELLIGENCE_DB_READ_ONLY", "PROD_ANALYTICS_ORCHARD_TABLEAU_WAREHOUSE_ACCESS", ] }, { name = "ORCHARD_BIZ_BROWSE" granted_account_roles = [ "ORCHARDAPPREPORTING_DB_ARTRELATIONS_SCHEMA_READ", ] }, { 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 = "ORG_LISTING_PROVIDER" owner = "SECURITYADMIN" grant_to_sysadmin = false }, { name = "PARTNERIZE_USER" }, { name = "PDEGO_AOMA_INTERNAL_RESTRICTED" comment = "PDEGO AOMA_APP_REPORTING DB access role for Internal Tech team" granted_account_roles = [ "DEV_ENGINEERING", "PROD_AOMA_REPORTING_SERVICE_ROLE", "QA_AOMA_REPORTING_SERVICE_ROLE", ] granted_database_roles = [ "AMP_APP_REPORTING.DB_READ", "AOMA_APP_REPORTING.DB_READ", "AOMA_APP_REPORTING.DB_AOMA_VIEWS_SCHEMA_READWRITE", "AOMA_APP_REPORTING.DB_AMP_VIEWS_SCHEMA_READWRITE", "AOMA_REPORTING.DB_AOMA_SCHEMA_READWRITE", "AOMA_REPORTING.DB_AOMA_QA_SCHEMA_READWRITE", ] }, { name = "PDEGO_AOMA_DELIVERY" comment = "PDEGO AOMA delivery data role" granted_database_roles = [ "AOMA_DELIVERY_APP_REPORTING.DB_READ", ] }, { name = "PDEGO_AOMA_REL_MGR" comment = "PDEGO AOMA rel_mgr data role" granted_database_roles = [ "GLOBAL_DS_APP_REPORTING.DB_READ", ] }, { name = "PDE_SONGWHIP_ENGINEER" granted_account_roles = [ "EXPLORATION_WH_WAREHOUSE_ACCESS", "SONGWHIP_APP_REPORTING_DB_READ", "PROD_SIGMA_WAREHOUSE_WAREHOUSE_ACCESS", "PDE_SIGMA_WAREHOUSE_WAREHOUSE_ACCESS", ] granted_database_roles = [ "FANSIFTER_APP_REPORTING.DB_PROD_SCHEMA_EVENT_SONGWHIP_FAN_CONSENT_TABLE_READ", "FANSIFTER_APP_REPORTING.DB_PROD_SCHEMA_EVENT_SONGWHIP_FAN_CONSENT_DOUBLE_OPT_IN_TABLE_READ", "FANSIFTER_APP_REPORTING.DB_PROD_SCHEMA_EVENT_SONGWHIP_PRESAVE_PROCESSED_TABLE_READ", "FANSIFTER_APP_REPORTING.DB_PROD_SCHEMA_FANS_BY_ARTIST_ACCOUNT_DBT_TABLE_READ", "FANSIFTER_APP_REPORTING.DB_QA_SCHEMA_EVENT_SONGWHIP_FAN_CONSENT_TABLE_READ", "FANSIFTER_APP_REPORTING.DB_QA_SCHEMA_EVENT_SONGWHIP_FAN_CONSENT_DOUBLE_OPT_IN_TABLE_READ", "FANSIFTER_APP_REPORTING.DB_QA_SCHEMA_EVENT_SONGWHIP_PRESAVE_PROCESSED_TABLE_READ", "FANSIFTER_APP_REPORTING.DB_QA_SCHEMA_FANS_BY_ARTIST_ACCOUNT_DBT_TABLE_READ", ] }, { name = "PERMISSIONS_PLATFORM_DB_PROD_SCHEMA_DB_DEPLOY" account_level_grants = [ "EXECUTE TASK", ] granted_account_roles = [ "PERMISSIONS_PLATFORM_DB_PROD_SCHEMA_READWRITE", "PROD_OWS_WAREHOUSE_WAREHOUSE_ACCESS", "PROD_ETL_WAREHOUSE_WAREHOUSE_ACCESS", ] }, { name = "PERMISSIONS_PLATFORM_DB_QA_SCHEMA_DB_DEPLOY" account_level_grants = [ "EXECUTE TASK", ] granted_account_roles = [ "PERMISSIONS_PLATFORM_DB_QA_SCHEMA_READWRITE", "QA_OWS_WAREHOUSE_WAREHOUSE_ACCESS", "QA_ETL_WAREHOUSE_WAREHOUSE_ACCESS", ] }, { name = "PERMISSIONS_TEST" }, { name = "PHYSICAL_REPORTING" granted_account_roles = [ "PHYSICAL_REPORTING_SMALL_WAREHOUSE_WAREHOUSE_ACCESS", "PHYSICAL_REPORTING_MEDIUM_WAREHOUSE_WAREHOUSE_ACCESS", "PHYSICAL_REPORTING_LARGE_WAREHOUSE_WAREHOUSE_ACCESS", ] granted_database_roles = [ "SONY_INTERNAL.DB_PROD_SCHEMA_PRODUCT_MASTER_TABLE_READ", "SONY_INTERNAL.DB_PROD_SCHEMA_ARTISTS_DIM_TABLE_READ", "SONY_INTERNAL.DB_PROD_SCHEMA_PHY_AUDIT_CURRENT_PERIOD_TABLE_READ", "SONY_INTERNAL.DB_PROD_SCHEMA_PHY_AUDIT_GDS_AGENT_TABLE_READ", "SONY_INTERNAL.DB_PROD_SCHEMA_PHY_AUDIT_GDS_ARTICLE_TABLE_READ", "SONY_INTERNAL.DB_PROD_SCHEMA_PHY_AUDIT_GDS_ARTICLE_STATUS_TABLE_READ", "SONY_INTERNAL.DB_PROD_SCHEMA_PHY_AUDIT_GDS_CAMPAIGN_HEADER_TABLE_READ", "SONY_INTERNAL.DB_PROD_SCHEMA_PHY_AUDIT_GDS_COMMERCIAL_CONDITIONS_TABLE_READ", "SONY_INTERNAL.DB_PROD_SCHEMA_PHY_AUDIT_GDS_CONFIGURATION_TABLE_READ", "SONY_INTERNAL.DB_PROD_SCHEMA_PHY_AUDIT_GDS_CUSTOMER_TABLE_READ", "SONY_INTERNAL.DB_PROD_SCHEMA_PHY_AUDIT_GDS_DISTRIBUTION_CENTER_TABLE_READ", "SONY_INTERNAL.DB_PROD_SCHEMA_PHY_AUDIT_GDS_ORDER_STATUS_TABLE_READ", "SONY_INTERNAL.DB_PROD_SCHEMA_PHY_AUDIT_GDS_PACKAGING_CODE_TABLE_READ", "SONY_INTERNAL.DB_PROD_SCHEMA_PHY_AUDIT_GDS_PRODUCT_TABLE_READ", "SONY_INTERNAL.DB_PROD_SCHEMA_PHY_AUDIT_GDS_REASON_CODE_TABLE_READ", "SONY_INTERNAL.DB_PROD_SCHEMA_PHY_AUDIT_INTERFACE_CONTROL_TABLE_READ", "SONY_INTERNAL.DB_PROD_SCHEMA_PHY_AUDIT_OPEN_ORDERS_TABLE_READ", "SONY_INTERNAL.DB_PROD_SCHEMA_PHY_AUDIT_REPERTOIRE_TABLE_READ", "SONY_INTERNAL.DB_PROD_SCHEMA_PHY_AUDIT_REPORTING_PERIOD_TABLE_READ", "SONY_INTERNAL.DB_PROD_SCHEMA_PHY_AUDIT_SAP_INVENTORY_TABLE_READ", "SONY_INTERNAL.DB_PROD_SCHEMA_PHY_AUDIT_SAP_PROFIT_CENTER_TABLE_READ", "SONY_INTERNAL.DB_PROD_SCHEMA_PHY_AUDIT_SELLING_COMPANY_TABLE_READ", "SONY_INTERNAL.DB_PROD_SCHEMA_PHY_AUDIT_BILLING_HISTORY_TABLE_READ", "SONY_INTERNAL.DB_PROD_SCHEMA_STAGING_PHY_AUDIT_CURRENT_PERIOD_TABLE_READ", "SONY_INTERNAL.DB_PROD_SCHEMA_STAGING_PHY_AUDIT_GDS_AGENT_TABLE_READ", "SONY_INTERNAL.DB_PROD_SCHEMA_STAGING_PHY_AUDIT_GDS_ARTICLE_TABLE_READ", "SONY_INTERNAL.DB_PROD_SCHEMA_STAGING_PHY_AUDIT_GDS_ARTICLE_STATUS_TABLE_READ", "SONY_INTERNAL.DB_PROD_SCHEMA_STAGING_PHY_AUDIT_GDS_CAMPAIGN_HEADER_TABLE_READ", "SONY_INTERNAL.DB_PROD_SCHEMA_STAGING_PHY_AUDIT_GDS_COMMERCIAL_CONDITIONS_TABLE_READ", "SONY_INTERNAL.DB_PROD_SCHEMA_STAGING_PHY_AUDIT_GDS_CONFIGURATION_TABLE_READ", "SONY_INTERNAL.DB_PROD_SCHEMA_STAGING_PHY_AUDIT_GDS_CUSTOMER_TABLE_READ", "SONY_INTERNAL.DB_PROD_SCHEMA_STAGING_PHY_AUDIT_GDS_DISTRIBUTION_CENTER_TABLE_READ", "SONY_INTERNAL.DB_PROD_SCHEMA_STAGING_PHY_AUDIT_GDS_ORDER_STATUS_TABLE_READ", "SONY_INTERNAL.DB_PROD_SCHEMA_STAGING_PHY_AUDIT_GDS_PACKAGING_CODE_TABLE_READ", "SONY_INTERNAL.DB_PROD_SCHEMA_STAGING_PHY_AUDIT_GDS_PRODUCT_TABLE_READ", "SONY_INTERNAL.DB_PROD_SCHEMA_STAGING_PHY_AUDIT_GDS_REASON_CODE_TABLE_READ", "SONY_INTERNAL.DB_PROD_SCHEMA_STAGING_PHY_AUDIT_INTERFACE_CONTROL_TABLE_READ", "SONY_INTERNAL.DB_PROD_SCHEMA_STAGING_PHY_AUDIT_OPEN_ORDERS_TABLE_READ", "SONY_INTERNAL.DB_PROD_SCHEMA_STAGING_PHY_AUDIT_REPERTOIRE_TABLE_READ", "SONY_INTERNAL.DB_PROD_SCHEMA_STAGING_PHY_AUDIT_REPORTING_PERIOD_TABLE_READ", "SONY_INTERNAL.DB_PROD_SCHEMA_STAGING_PHY_AUDIT_SAP_INVENTORY_TABLE_READ", "SONY_INTERNAL.DB_PROD_SCHEMA_STAGING_PHY_AUDIT_SAP_PROFIT_CENTER_TABLE_READ", "SONY_INTERNAL.DB_PROD_SCHEMA_STAGING_PHY_AUDIT_SELLING_COMPANY_TABLE_READ", "SONY_INTERNAL.DB_PROD_SCHEMA_STAGING_PHY_AUDIT_BILLING_HISTORY_TABLE_READ", ] }, { name = "PHYSICAL_REPORTING_DB_PROD_SCHEMA_READ" granted_database_roles = [ "PHYSICAL_REPORTING.DB_PROD_SCHEMA_READ", ] }, { name = "PHYSICAL_REPORTING_DB_PROD_SCHEMA_READWRITE" granted_database_roles = [ "PHYSICAL_REPORTING.DB_PROD_SCHEMA_READWRITE", ] }, { name = "PHYSICAL_REPORTING_DB_QA_SCHEMA_READ" granted_database_roles = [ "PHYSICAL_REPORTING.DB_QA_SCHEMA_READ", ] }, { name = "PHYSICAL_REPORTING_DB_QA_SCHEMA_READWRITE" granted_database_roles = [ "PHYSICAL_REPORTING.DB_QA_SCHEMA_READWRITE", ] }, { name = "PHYSICAL_REPORTING_PROD_SCHEMA_READWRITE_DB_DEPLOY" granted_account_roles = [ "PHYSICAL_REPORTING_DB_PROD_SCHEMA_READWRITE", "DEPLOY_WAREHOUSE_WAREHOUSE_ACCESS", ] }, { name = "PHYSICAL_REPORTING_QA_SCHEMA_READWRITE_DB_DEPLOY" granted_account_roles = [ "PHYSICAL_REPORTING_DB_QA_SCHEMA_READWRITE", "DEPLOY_WAREHOUSE_WAREHOUSE_ACCESS", ] }, { name = "PLAYLISTS_STRATEGY" comment = "System created role for partner elt integration." }, { 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 = "PROD_AMPLITUDE" granted_account_roles = [ "PROD_AMPLITUDE_WH_WAREHOUSE_ACCESS", "FANSIFTER_APP_REPORTING_DB_PROD_SCHEMA_READ", ] }, { name = "PROD_AUTH0_ACCESS_INTEGRATION_USAGE" }, { 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_CODA_SEARCH_SVC" comment = "Service role for the Coda search service (PROD)." granted_account_roles = [ "PROD_OWS_WAREHOUSE_WAREHOUSE_ACCESS", "BUSINESS_SYSTEMS_SALESFORCE_DATA_DB_READ", "FANSIFTER_DB_PROD_SCHEMA_READ", "INTEGRATION_DB_READ_ONLY", "PERMISSIONS_PLATFORM_DB_PROD_SCHEMA_READ", "ROYALTYACCOUNTING_DB_PROD_SCHEMA_READ", "ROYALTY_ACCOUNTING_REPORTING_DB_PROD_SCHEMA_READ", "S3_INTEGRATIONS_DB_PROD_SCHEMA_READ", ] granted_database_roles = [ "AWAL.DB_AWAL_TRUST_AND_SAFETY_SCHEMA_READ", "DATA_APPS.DB_READ", "FACTS.DB_PROD_SCHEMA_READ", "FACTS.DB_PROD_SCHEMA_CORTEX_SEARCH_SERVICES_READ", "GRPS_INGESTOR.DB_PROD_SCHEMA_READ", "ORCHARD_APP_REPORTING_V2.DB_PROD_DIRECT_DELIVERY_MAXWELL_LOGGING_SCHEMA_READ", "ORCHARD_APP_REPORTING_V2.DB_PROD_HIVE_MODEL_REPORTING_SCHEMA_READ", "ORCHARD_APP_REPORTING_V2.DB_PROD_OWS_COLLABORATOR_OWS_COLLABORATOR_SCHEMA_READ", "PHYSICAL_REPORTING.DB_PROD_SCHEMA_READ", "ROYALTY_ACCOUNTING.ROYALTYACCOUNTING_DB_UAT_SCHEMA_READ", "SME_SUPPLYCHAIN_SANDBOX.DB_READ", ] }, { name = "PROD_CODA_SVC" comment = "Service role for the Coda application (PROD)." granted_account_roles = [ "PROD_OWS_WAREHOUSE_WAREHOUSE_ACCESS", "BUSINESS_SYSTEMS_SALESFORCE_DATA_DB_READ", "FANSIFTER_DB_PROD_SCHEMA_READ", "INTEGRATION_DB_READ_ONLY", "PERMISSIONS_PLATFORM_DB_PROD_SCHEMA_READ", "ROYALTYACCOUNTING_DB_PROD_SCHEMA_READ", "ROYALTY_ACCOUNTING_REPORTING_DB_PROD_SCHEMA_READ", "S3_INTEGRATIONS_DB_PROD_SCHEMA_READ", ] granted_database_roles = [ "AWAL.DB_AWAL_TRUST_AND_SAFETY_SCHEMA_READ", "DATA_APPS.DB_READ", "FACTS.DB_PROD_SCHEMA_READ", "FACTS.DB_PROD_SCHEMA_CORTEX_SEARCH_SERVICES_READ", "GRPS_INGESTOR.DB_PROD_SCHEMA_READ", "ORCHARD_APP_REPORTING_V2.DB_PROD_DIRECT_DELIVERY_MAXWELL_LOGGING_SCHEMA_READ", "ORCHARD_APP_REPORTING_V2.DB_PROD_HIVE_MODEL_REPORTING_SCHEMA_READ", "ORCHARD_APP_REPORTING_V2.DB_PROD_OWS_COLLABORATOR_OWS_COLLABORATOR_SCHEMA_READ", "PHYSICAL_REPORTING.DB_PROD_SCHEMA_READ", "ROYALTY_ACCOUNTING.ROYALTYACCOUNTING_DB_UAT_SCHEMA_READ", "SME_SUPPLYCHAIN_SANDBOX.DB_READ", ] }, { name = "PROD_CONFLICT_MANAGER_ES_SYNC_DB_PASSWORD" granted_account_roles = [ "FACTS_DB_PROD_SCHEMA_READWRITE", "OWSCONFLICTMANAGER_DB_PROD_SCHEMA_READ", ] }, { name = "PROD_DATABRICKS_ROLE" granted_account_roles = [ "DEV_ENGINEERING", "SWF_SME_ANALYTICS_INGEST_DATA_BACKLOAD_WAREHOUSE_ACCESS", ] }, { name = "PROD_DATADOG_INTEGRATION" granted_account_roles = [ "CICD_WH_WAREHOUSE_ACCESS", "DATADOG", "FACTS_DB_PROD_SCHEMA_READ", "ORCHARDAPPREPORTING_DB_ARTRELATIONS_SCHEMA_READ", "PROD_DATADOG_WAREHOUSE_WAREHOUSE_ACCESS", "ROYALTYACCOUNTING_DB_QA_SCHEMA_READ", "SNOWFLAKE_USAGE", ] }, { 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 = "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", # compute pool "ORCHARD_BI_COMPUTE_POOL_COMPUTE_POOL_ACCESS", ] granted_database_roles = [ "FRAUD_REPORTING.DB_DEEZER_SCHEMA_READ", "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", "CONFLICT_REPORTING.DB_TIKTOK_SCHEMA_READ", ] }, { name = "PROD_DB_QA_YT_REPORTS_API_SCHEMA_READWRITE" granted_account_roles = [ "QA_ETL_WAREHOUSE_WAREHOUSE_ACCESS", ] }, { name = "PROD_DELETE_SME_PRODUCT_STREAMLIT" granted_account_roles = [ "CHARTMETRIC_DB_RAW_DATA_SCHEMA_READ", ] granted_database_roles = [ "DATA_APPS.DB_PROD_SCHEMA_DELETE_SME_PRODUCT_STREAMLIT", ] }, { name = "PROD_ETL_BANDSINTOWN_ROLE" granted_account_roles = [ "PROD_ETL_WH_WAREHOUSE_ACCESS", "PREFERENCE_CENTER_DB_PROD_SCHEMA_READ", ] granted_database_roles = [ "FAN_LIVE_EVENTS.DB_PROD_SCHEMA_READWRITE", ] }, { name = "PROD_ETL_DELPHI_CRM_ROLE" granted_account_roles = [ "PROD_ETL_WH_WAREHOUSE_ACCESS", "DELPHI_CRM_DATA_DB_READWRITE", ] }, { name = "PROD_ETL_SEATED_ROLE" granted_account_roles = [ "PROD_ETL_WH_WAREHOUSE_ACCESS", ] granted_database_roles = [ "FAN_LIVE_EVENTS.DB_PROD_SCHEMA_READWRITE", ] }, { name = "PROD_ETL_SETLIVE_ROLE" granted_account_roles = [ "PROD_ETL_WH_WAREHOUSE_ACCESS", ] granted_database_roles = [ "FAN_LIVE_EVENTS.DB_PROD_SCHEMA_READWRITE", ] }, { name = "PROD_ETL_SPOTIFY_FOLLOWERS_ROLE" granted_account_roles = [ "PROD_SWF_ETL_WAREHOUSE_WAREHOUSE_ACCESS", ] granted_database_roles = [ "PARTNER_REPORTING.DB_SPOTIFY_SCHEMA_READWRITE", ] }, { name = "PROD_ETL_TICKETEK_ROLE" granted_account_roles = [ "PROD_ETL_WH_WAREHOUSE_ACCESS", ] granted_database_roles = [ "FAN_LIVE_EVENTS.DB_PROD_SCHEMA_READWRITE", ] }, { 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_FANSIFTER_DBT" granted_account_roles = [ "FANSIFTER_APP_REPORTING_DB_PROD_SCHEMA_READWRITE", "FANSIFTER_APP_REPORTING_DB_PROD_SHOPIFY_SCHEMA_READ", "FANSIFTER_APP_REPORTING_DB_PROD_MARKETING_SCHEMA_READWRITE", "FANSIFTER_APP_REPORTING_DB_QA_CRM_FANS_SCHEMA_READ", "FANSIFTER_APP_REPORTING_DB_PROD_CRM_FANS_SCHEMA_READ", "FANSIFTER_APP_REPORTING_DB_PROD_VIEWS_SCHEMA_READWRITE", "DELPHI_EXPLORATION_DB_MAIN_SCHEMA_READ", "DELPHI_CRM_DATA_DB_RAW_SALESFORCE_SALES_CLOUD_SCHEMA_READ", "DELPHI_CRM_DATA_DB_RAW_SALESFORCE_MARKETING_CLOUD_SCHEMA_READ", "QA_CRM_ECOMMERCE_DATA_DB_READ", "CRM_ECOMMERCE_DATA_DB_READ", "FANSIFTER_PG_REPORTING_DB_QA_OWS_DMP_PUBLIC_SCHEMA_READ", "FANSIFTER_PG_REPORTING_DB_PROD_OWS_DMP_PUBLIC_SCHEMA_READ", "ORCHARD_APP_REPORTING_DB_DELPHI_PROD_SCHEMA_READ", "FACTS_DB_PROD_SCHEMA_READ", "PROD_MARKETING_INTEGRATIONS_DB_READ", "SONGWHIP_APP_REPORTING_DB_READ", "PREFERENCE_CENTER_DB_PROD_SCHEMA_READ", "DELPHI_EXPLORATION_DB_SYS_SCHEMA_READ", "FANSIFTER_DB_PROD_SCHEMA_READWRITE", "PROD_SHOPIFY_INTEGRATIONS_DB_READ", "PROD_DBT_WH_WAREHOUSE_ACCESS", "PROD_ETL_WH_WAREHOUSE_ACCESS", ] granted_database_roles = [ "FAN_LIVE_EVENTS.DB_PROD_SCHEMA_READ", "FAN_LIVE_EVENTS.DB_QA_SCHEMA_READ", "FANSIFTER_SHOPIFY.DB_PROD_SCHEMA_READWRITE", ] }, { name = "PROD_FIVETRAN" granted_account_roles = [ "FACTS_DB_PROD_SCHEMA_READ", ] }, { name = "PROD_FIVETRAN_AMP" grant_to_sysadmin = false granted_account_roles = [ "PROD_FIVETRAN_WAREHOUSE_WAREHOUSE_ACCESS", ] granted_database_roles = [ "AMP_APP_REPORTING.DB_READWRITE", ] }, { name = "PROD_FIVETRAN_AOMA" grant_to_sysadmin = false granted_account_roles = [ "PROD_FIVETRAN_WAREHOUSE_WAREHOUSE_ACCESS", ] granted_database_roles = [ "AOMA_APP_REPORTING.DB_READWRITE", ] }, { name = "PROD_FIVETRAN_AOMA_DELIVERY" grant_to_sysadmin = false granted_account_roles = [ "PROD_FIVETRAN_WAREHOUSE_WAREHOUSE_ACCESS", ] granted_database_roles = [ "AOMA_DELIVERY_APP_REPORTING.DB_READWRITE", ] }, { name = "PROD_FIVETRAN_EOM" grant_to_sysadmin = false granted_account_roles = [ "PROD_FIVETRAN_WAREHOUSE_WAREHOUSE_ACCESS", ] granted_database_roles = [ "EOM_APP_REPORTING.DB_READWRITE", ] }, { name = "PROD_FIVETRAN_GLOBAL_DS" grant_to_sysadmin = false granted_account_roles = [ "PROD_FIVETRAN_WAREHOUSE_WAREHOUSE_ACCESS", ] granted_database_roles = [ "GLOBAL_DS_APP_REPORTING.DB_READWRITE", ] }, { name = "PROD_FIVETRAN_GRPS" grant_to_sysadmin = false granted_account_roles = [ "PROD_FIVETRAN_WAREHOUSE_WAREHOUSE_ACCESS", ] granted_database_roles = [ "GRPS_APP_REPORTING.DB_READWRITE", ] }, { name = "PROD_FIVETRAN_ROYALTYSHARE" grant_to_sysadmin = false granted_account_roles = [ "PROD_FIVETRAN_WAREHOUSE_WAREHOUSE_ACCESS", ] granted_database_roles = [ "ROYALTYSHARE.DB_READWRITE", ] }, { name = "PROD_HIVE_MODEL_REPORTING" granted_account_roles = [ "PROD_OWS_WAREHOUSE_WAREHOUSE_ACCESS", ] granted_database_roles = [ "ORCHARD_APP_REPORTING_V2.DB_PROD_HIVE_MODEL_REPORTING_SCHEMA_prod-assets-s3-stage_STAGE_USAGE", "ORCHARD_APP_REPORTING_V2.DB_PROD_HIVE_MODEL_REPORTING_SCHEMA_READWRITE", "ORCHARD_APP_REPORTING_V2.DB_PROD_OWS_ASSETS_OWS_ASSETS_SCHEMA_HIVE_SEGMENT_TABLE_READ", "ORCHARD_APP_REPORTING_V2.DB_PROD_OWS_ASSETS_OWS_ASSETS_SCHEMA_HIVE_TASK_TABLE_READ", ] }, { name = "PROD_INSIGHTS_PLAYLIST_PAGES_GSHEETS_SYNC_TASK_ROLE" comment = "Task role for syncing playlist pages from GSheets into FACTS PROD schema" account_level_grants = [ "EXECUTE TASK", ] granted_account_roles = [ "PROD_TASK_WAREHOUSE_WAREHOUSE_ACCESS", "CHARTMETRIC_DB_RAW_DATA_SCHEMA_READ", ] granted_database_roles = [ "ORCHARD_APP_REPORTING_V2.DB_PROD_INSIGHTS_PLAYLIST_PAGES_GSHEETS_SYNC_SCHEMA_READ", "FACTS.DB_PROD_SCHEMA_READWRITE", ] }, { name = "PROD_KAFKA_CONNECT_FORMRESPONSE" granted_account_roles = [ "DELPHI_CRM_DATA_DB_READWRITE", "PROD_ETL_WH_WAREHOUSE_ACCESS", "FANSIFTER_APP_REPORTING_DB_PROD_CRM_FANS_SCHEMA_READWRITE", ] }, { name = "PROD_KAFKA_CONNECT_FS" granted_account_roles = [ "FANSIFTER_APP_REPORTING_DB_PROD_SCHEMA_READWRITE", "PROD_ETL_WH_WAREHOUSE_ACCESS", ] granted_database_roles = [ "RESONANCE_ENGINE.DB_PROD_SCHEMA_READWRITE", ] }, { 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 = "PROD_KAFKA_CONNECT_TRIGGERED_SENDS" granted_account_roles = [ "DELPHI_CRM_DATA_DB_READWRITE", "FANSIFTER_APP_REPORTING_DB_PROD_CRM_FANS_SCHEMA_READWRITE", "PROD_ETL_WH_WAREHOUSE_ACCESS", ] }, { name = "PROD_LAMBDA_AUDIENCE" granted_account_roles = [ "FANSIFTER_APP_REPORTING_DB_PROD_SCHEMA_READWRITE", "PREFERENCE_CENTER_DB_PROD_SCHEMA_READ", "PROD_ETL_WH_WAREHOUSE_ACCESS", ] }, { name = "PROD_LAMBDA_CONTENT_DELETE_PRODUCT_INTEGRATION_USAGE" }, { 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 = "PROD_LAMBDA_D2C_SHOPIFY_ONBOARDING" comment = "Prod service role for lambda-d2c-shopify-onboarding. Jira: D2C-146" granted_account_roles = [ "CRM_ECOMMERCE_DATA_DB_READ", "FACTS_DB_PROD_SCHEMA_READ", "FANSIFTER_APP_REPORTING_DB_PROD_SHOPIFY_SCHEMA_READ", "ORCHARD_APP_REPORTING_V2_READ", "PROD_OWS_WAREHOUSE_WAREHOUSE_ACCESS", ] granted_database_roles = [ "SHOPIFY_STORES_GLOBAL.DB_D2C_OPERATIONS_SCHEMA_READWRITE", # Read on the per-store data schemas (where Fivetran lands SHOP etc.); without # this the sync lambda can't see synced tables and stores wedge at pending_sync. "SHOPIFY_STORES_GLOBAL.DB_READ", ] }, { name = "PROD_LAMBDA_FAN_DELETION_ROLE" granted_account_roles = [ "PROD_FANSIFTER_FAN_DELETION_WH_WAREHOUSE_ACCESS", "FANSIFTER_APP_REPORTING_DB_PROD_CRM_FANS_SCHEMA_READWRITE", ] }, { name = "PROD_LAMBDA_FAN_SUBSCRIPTION_PREFERENCE_SFORCE_UPDATES" comment = "Lambda role for syncing fan subscription preference updates to Salesforce in PROD." granted_account_roles = [ "PREFERENCE_CENTER_DB_PROD_SCHEMA_READ", "DELPHI_CRM_DATA_DB_RAW_SALESFORCE_SALES_CLOUD_SCHEMA_READ", "PROD_ETL_WH_WAREHOUSE_ACCESS", ] }, { name = "PROD_LAMBDA_MCC" granted_account_roles = [ "QA_ETL_WAREHOUSE_WAREHOUSE_ACCESS", "PROD_DB_MCC_SCHEMA_READWRITE", ] }, { name = "PROD_LAMBDA_SR_ACK_PROCESSOR" granted_account_roles = [ "FACTS_DB_PROD_SCHEMA_READWRITE", ] }, { name = "PROD_LUMINATE_DBT_SCHEDULER_ROLE" granted_account_roles = [ "PROD_LUMINATE_DBT_SCHEDULER_WH_WAREHOUSE_ACCESS", "PROD_LUMINATE_DBT_SCHEDULER_LIGHT_WH_WAREHOUSE_ACCESS", "PROD_LUMINATE_DBT_SCHEDULER_HEAVY_WH_WAREHOUSE_ACCESS", "PROD_ETL_WH_WAREHOUSE_ACCESS", "LUMINATE_SHARE_READ", ] granted_database_roles = [ "LUMINATE_MODELS.DB_READWRITE", "LUMINATE_MODELS.DB_PROD_SCHEMA_READWRITE", "LUMINATE_MODELS.DB_QA_SCHEMA_READWRITE", ] }, { name = "PROD_MARKETING_INTEGRATIONS_FIVETRAN" granted_account_roles = [ "PROD_MARKETING_INTEGRATIONS_DB_READWRITE", "PROD_MARKETING_INTEGRATIONS_WH_WAREHOUSE_ACCESS", ] }, { name = "PROD_MARTECH_SNOWFLAKE_SALESFORCE_NODE_ROLE" granted_account_roles = [ "AE_CRM_USER", "CRM_ECOMMERCE_ROLE", "PROD_MARTECH_SNOWFLAKE_SALESFORCE_NODE_WH_WAREHOUSE_ACCESS", "QA_SHOPIFY_INTEGRATIONS_DB_READWRITE", "DELPHI_CRM_DATA_DB_READWRITE", "SONGWHIP_APP_REPORTING_DB_READ", "FANSIFTER_APP_REPORTING_DB_READ", "ORCHARD_APP_REPORTING_DB_READ", "FANSIFTER_APP_REPORTING_DB_QA_CRM_FANS_SCHEMA_READ", ] granted_database_roles = [ "FANSIFTER_APP_REPORTING.DB_QA_CRM_FANS_SCHEMA_TRIGGERED_SENDS_STREAMLIT", ] }, { name = "PROD_NEO4J" granted_account_roles = [ "AWAL_SAX_DB_DEV_SCHEMA_READWRITE", "CHARTMETRIC_DB_RAW_DATA_SCHEMA_READ", "FACTS_DB_PROD_SCHEMA_READ", "ORCHARDAPPREPORTING_DB_PROD_DB_DEPLOY_ACCESS", "PROD_SWF_CHARTMETRIC_CHARTS_ETL", "PROD_SWF_CHARTMETRIC_SOCIALS_BACKFILL_ETL", "PROD_SWF_CHARTMETRIC_TRACKS_ETL", "PROD_SWF_YOUTUBE_NEO4J_ETL", "ROYALTYACCOUNTING_DB_PROD_SCHEMA_READ", "ROYALTYACCOUNTING_DB_PROD_SCHEMA_READWRITE", "ROYALTYACCOUNTING_DB_QA_SCHEMA_READ", "ROYALTYACCOUNTING_DB_QA_SCHEMA_READWRITE", ] }, { name = "PROD_OWS_ANALYTICS" granted_account_roles = [ "FACTS_DB_PROD_SCHEMA_READWRITE", "PROD_INSIGHTS_PLAYLISTS_WAREHOUSE_WAREHOUSE_ACCESS", "PROD_INSIGHTS_WAREHOUSE_WAREHOUSE_ACCESS", "CORTEX_USER_ROLE" ] granted_database_roles = [ "FACTS.DB_PROD_SCHEMA_CORTEX_SEARCH_SERVICES_READ" ] }, { name = "PROD_OWS_COLLABORATOR" granted_account_roles = [ "FACTS_DB_PROD_SCHEMA_READ", "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_OWS_DMP" granted_account_roles = [ "FACTS_DB_PROD_SCHEMA_READ", "FANSIFTER_APP_REPORTING_DB_PROD_SCHEMA_READWRITE", "FANSIFTER_APP_REPORTING_DB_PROD_SHOPIFY_SCHEMA_READ", "FANSIFTER_DB_PROD_SCHEMA_READWRITE", "FANSIFTER_PG_REPORTING_DB_PROD_OWS_DMP_PUBLIC_SCHEMA_READ", "MARKETING_INTEGRATIONS_DB_FACEBOOK_ADS_SCHEMA_READ", "ORCHARD_APP_REPORTING_DB_DELPHI_PROD_SCHEMA_READ", "PREFERENCE_CENTER_DB_PROD_SCHEMA_READ", "PROD_ETL_WH_WAREHOUSE_ACCESS", "PROD_OWS_WAREHOUSE_WAREHOUSE_ACCESS", "PROD_OWS_WH_WAREHOUSE_ACCESS", "PROD_SHOPIFY_INTEGRATIONS_DB_READWRITE", "PROD_SHOPIFY_INTEGRATIONS_FIVETRAN", "PROD_SHOPIFY_INTEGRATIONS_WH_WAREHOUSE_ACCESS", ] granted_database_roles = [ "FANSIFTER_SHOPIFY.DB_PROD_SCHEMA_READ", ] }, { name = "PROD_OWS_EMAIL_CAMPAIGNS" granted_account_roles = [ "FANSIFTER_APP_REPORTING_DB_PROD_SCHEMA_READWRITE", "PROD_OWS_WH_WAREHOUSE_ACCESS", "PROD_ETL_WH_WAREHOUSE_ACCESS", "PREFERENCE_CENTER_DB_PROD_SCHEMA_READ", "DELPHI_CRM_DATA_DB_RAW_SALESFORCE_SALES_CLOUD_SCHEMA_READ", ] granted_database_roles = [ "FANSIFTER_SHOPIFY.DB_PROD_SCHEMA_READ", ] }, { name = "PROD_OWS_GRID_GENERATOR" granted_account_roles = [ "PROD_OWS_WH_WAREHOUSE_ACCESS", ] granted_database_roles = [ "DELPHI_EXPLORATION.DB_EXP_SCHEMA_V_GRAS_PRODUCT_VIEW_READ", "DELPHI_EXPLORATION.DB_EXP_SCHEMA_V_GRAS_TRACK_VIEW_READ", "DELPHI_EXPLORATION.DB_EXP_SCHEMA_V_GRAS_PRODUCT_TRACK_VIEW_READ", ] }, { name = "PROD_OWS_PREFERENCE_CENTER" granted_account_roles = [ "PREFERENCE_CENTER_DB_PROD_SCHEMA_READWRITE", "PROD_PREFERENCE_CENTER_WH_WAREHOUSE_ACCESS", ] }, { name = "PROD_OWS_SOUND_RECORDINGS" granted_account_roles = [ "FACTS_DB_PROD_SCHEMA_READWRITE", "PROD_ETL_WAREHOUSE_WAREHOUSE_ACCESS", ] }, { name = "PROD_OWS_TEXT_CAMPAIGNS" granted_account_roles = [ "FANSIFTER_APP_REPORTING_DB_PROD_SCHEMA_READWRITE", "PROD_OWS_WH_WAREHOUSE_ACCESS", ] }, { name = "PROD_SWF_AMAZON_DATAPULSE_ETL_ROLE" granted_account_roles = [ "PROD_ETL_WAREHOUSE_WAREHOUSE_ACCESS", ] granted_database_roles = [ "FRAUD_REPORTING.DB_AMAZON_SCHEMA_READWRITE", "CONSUMER_REPORTING.DB_AMAZON_SCHEMA_READWRITE", ] }, { name = "PROD_PARTNER_REPORTS_FIVETRAN_ROLE" granted_account_roles = [ "FIVETRAN_WAREHOUSE_WAREHOUSE_ACCESS", ] granted_database_roles = [ "PARTNER_REPORTING.DB_READWRITE", ] }, { name = "PROD_PAYMENT_SEARCH_ROLE" comment = "Role with access only to PROD PAYMENT_DATA_SEARCH Cortex Search Service" granted_account_roles = [ "ROYALTYACCOUNTING_DB_PROD_SCHEMA_READ", "PROD_CORTEX_SEARCH_WAREHOUSE_WAREHOUSE_ACCESS", ] }, { name = "PROD_PODCAST_ROLE" granted_account_roles = [ "DEV_OWS_WAREHOUSE_WAREHOUSE_ACCESS", ] 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", ] }, { 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 = "PROD_QA_AUTOMATION" granted_account_roles = [ "PROD_QA_AUTOMATION_WAREHOUSE_WAREHOUSE_ACCESS", ] granted_database_roles = [ "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 = "PROD_REVENUE_FILE_INGESTION_ROLE" comment = "REVENUE_FILE_INGESTION (formerly SlaughterHouse) PROD role for PHP application" granted_account_roles = [ "PROD_REVENUE_FILE_INGESTION_WH_WAREHOUSE_ACCESS", ] granted_database_roles = [ "ORCHARD_APP_REPORTING_V2.DB_ART_RELATIONS_PROD_ART_RELATIONS_SCHEMA_READ", "REVENUE_FILE_INGESTION.DB_PROD_SCHEMA_READWRITE", ] }, { name = "PROD_RDS_REFRESH" granted_account_roles = [ "ROYALTYACCOUNTING_DB_PROD_SCHEMA_READ", "ROYALTYACCOUNTING_DB_DEV_SCHEMA_READWRITE", "ROYALTYACCOUNTING_DB_QA_SCHEMA_READWRITE", ] 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", ] }, { name = "PROD_SFN_GRPS_INGESTER_ROLE" comment = "Task role grps-ingester stepfunction" granted_account_roles = [ "PROD_ETL_WAREHOUSE_WAREHOUSE_ACCESS", ] granted_database_roles = [ "GRPS_APP_REPORTING_NOCONF.DB_GRPS_DRAS002_SCHEMA_READ", "GRPS_APP_REPORTING_NOCONF.DB_GRPS_DRPS001_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", "SONY_INTERNAL.DB_DEV_SCHEMA_READ", "GRPS_INGESTOR.DB_PROD_SCHEMA_READWRITE", ] }, { name = "PROD_SHOPIFY_GLOBAL_DBT_SCHEDULER_ROLE" granted_account_roles = [ "PROD_SHOPIFY_GLOBAL_DBT_SCHEDULER_WH_WAREHOUSE_ACCESS", "PROD_ETL_WH_WAREHOUSE_ACCESS", "CRM_ECOMMERCE_DATA_DB_READ", "PROD_SHOPIFY_INTEGRATIONS_DB_READ", "FANSIFTER_APP_REPORTING_DB_READ", "ORCHARD_APP_REPORTING_DB_READ", "ORCHARD_APP_REPORTING_V2_READ", "ORCHARD_FACTS", ] granted_database_roles = [ "SHOPIFY_STORES_GLOBAL.DB_READWRITE", ] }, { name = "PROD_SHOPIFY_INTEGRATIONS_FIVETRAN" granted_account_roles = [ "FANSIFTER_APP_REPORTING_DB_PROD_SHOPIFY_SCHEMA_READWRITE", "PROD_SHOPIFY_INTEGRATIONS_DB_READWRITE", "PROD_SHOPIFY_INTEGRATIONS_WH_WAREHOUSE_ACCESS", ] granted_database_roles = [ "FANSIFTER_APP_REPORTING.DB_PROD_SCHEMA_SHOPIFY_STORE_ASSOCIATION_TABLE_READ", ] }, { name = "PROD_SIGMA_DB_READ_WRITE" granted_account_roles = [ "PROD_SIGMA_WAREHOUSE_WAREHOUSE_ACCESS", ] granted_database_roles = [ "SIGMA.DB_PROD_SCHEMA_READWRITE", ] }, { name = "PROD_SIGMA_SERVICE_ROLE" granted_account_roles = [ "CHARTMETRIC_DB_RAW_DATA_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_READ", "DELPHI_AE_REPORTING_DB_READ", "DELPHI_CRM_DATA_DB_READ", "DELPHI_EXPLORATION_DB_READ", "DS_CHARTMETRIC_DB_READ", "FACTS_DB_PROD_SCHEMA_READ", "FANSIFTER_APP_REPORTING_DB_READ", "FANSIFTER_PG_REPORTING_DB_PROD_OWS_DMP_PUBLIC_SCHEMA_READ", "INTEGRATION_DB_READ_ONLY", "INTELLIGENCE_DB_DBT_PROD_SCHEMA_READ", "INTELLIGENCE_DB_READ_ONLY", "LUMINATE_SHARE_READ", "ORCHARDAPPREPORTING_DB_ARTRELATIONS_SCHEMA_READ", "ORCHARDAPPREPORTING_DB_READ_ONLY", "ORCHARD_APP_REPORTING_DB_READ", "ORCHARD_APP_REPORTING_V2_READ", "ORCHARD_FACTS", "ORCHARD_FANSIFTER_DB_READ", "PREFERENCE_CENTER_DB_PROD_SCHEMA_READ", "PROD_MARKETING_INTEGRATIONS_DB_READ", "PROD_SHOPIFY_INTEGRATIONS_DB_READ", "PROD_SIGMA_WAREHOUSE_WAREHOUSE_ACCESS", "ROYALTYACCOUNTING_DB_PROD_SCHEMA_READ", "ROYALTYACCOUNTING_DB_QA_SCHEMA_READ", "SME_GERMANY_READ", "SNOWFLAKE_USAGE", "SONGWHIP_APP_REPORTING_DB_READ", "SONYINTERNAL_DB_DEV_SCHEMA_READ", "SONYINTERNAL_DB_PROD_SCHEMA_READ", "SONYINTERNAL_DB_QA_SCHEMA_READ", "SONY_INTERNAL_DEV", "STMT_DB_READ_ONLY", ] granted_database_roles = [ "DELPHI_ADS_DATA.DB_READ", "DELPHI_LINKFIRE.DB_LINKFIRE_SCHEMA_READ", "DELPHI_LINKFIRE.DB_RAW_SCHEMA_READ", "SIGMA.DB_PROD_SCHEMA_READWRITE", "SME_DATA_SCIENCE_AND_ANALYTICS.DB_READ", "SME_ANALYTICS.DB_READWRITE", "FAN_LIVE_EVENTS.DB_QA_SCHEMA_READ", "FAN_LIVE_EVENTS.DB_PROD_SCHEMA_READ", "SHOPIFY_STORES_GLOBAL.DB_READ", "SMF_APP_REPORTING.DB_READWRITE", "SONGWHIP_APP_REPORTING.DB_SONGWHIP_FAN_COLLECTION_SCHEMA_SONGWHIP_FAN_RESPONSES_DYNAMIC_DYNAMIC_TABLE_READ", "SONGWHIP_APP_REPORTING.DB_SONGWHIP_PAGES_SCHEMA_SONGWHIP_FAN_COLLECTION_PAGES_MASTER_DYNAMIC_TABLE_READ", "GRPS_APP_REPORTING_NOCONF.DB_GRPS_DRPS001_SCHEMA_READ", "MARKETSHARE_REPORTING.DB_READ", ] }, { name = "PROD_SME_ANALYTICS_DDEX_INGESTER_SERVICE_ROLE" granted_account_roles = [ "FACTS_DB_PROD_SCHEMA_READWRITE", ] granted_database_roles = [ "ORCHARD_APP_REPORTING_V2.DB_ART_RELATIONS_PROD_ART_RELATIONS_SCHEMA_READ", "GRPS_APP_REPORTING_NOCONF.DB_GRPS_DRAS002_SCHEMA_READ", ] }, { name = "PROD_SNOWFLAKE_ETL" granted_account_roles = [ "PROD_ETL_WAREHOUSE_WAREHOUSE_ACCESS", "STMTDB_DB_PROD_SCHEMA_READWRITE", ] }, { name = "PROD_SOUND_RECORDINGS_TAKEDOWN" comment = "Role for sound recordings takedown service (PROD)" granted_account_roles = [ "PROD_OWS_WAREHOUSE_WAREHOUSE_ACCESS", "INTELLIGENCE_DB_DBT_PROD_SCHEMA_READ", "ROYALTY_ACCOUNTING_REPORTING_DB_PROD_SCHEMA_READ", ] granted_database_roles = [ "ORCHARD_APP_REPORTING_V2.DB_ART_RELATIONS_PROD_ART_RELATIONS_SCHEMA_READ", "FACTS.DB_PROD_SCHEMA_READ", ] }, { name = "PROD_STARS_SALES_PROCESSING" comment = "Role to give STARS access to read data from views for single supply chain" granted_account_roles = [ "PROD_SALES_PROCESSING_WH_WAREHOUSE_ACCESS" ] granted_database_roles = [ "SALES_PROCESSING.DB_PROD_SCHEMA_READ", ] }, { name = "PROD_STREAMLIT_FANSIFTER_BACKOFFICE_STREAMLIT_VIEWER" comment = "Role for accessing Fansifter Backoffice Streamlt app" granted_database_roles = [ "FANSIFTER_APP_REPORTING.DB_PROD_STREAMLIT_FANSIFTER_BACKOFFICE_SCHEMA_STREAMLITS_READ", ] }, { name = "PROD_SWF_COLLABORATOR_REPORT" granted_account_roles = [ "FACTS_DB_PROD_SCHEMA_READ", "FACTS_DB_QA_SCHEMA_READ", "FACTS_DB_QA_SCHEMA_READWRITE", "ROYALTYACCOUNTING_DB_PROD_SCHEMA_READ", "ROYALTYACCOUNTING_DB_QA_SCHEMA_READ", "S3_INTEGRATIONS_DB_PROD_SCHEMA_READ", ] }, { name = "PROD_SWF_TIKTOK_ETL_ROLE" granted_account_roles = [ "PROD_ETL_WAREHOUSE_WAREHOUSE_ACCESS", "FACTS_DB_PROD_SCHEMA_READWRITE", ] granted_database_roles = [ "CONSUMER_REPORTING.DB_TIKTOK_SCHEMA_READWRITE", ] }, { name = "QA_SWF_TIKTOK_ETL_ROLE" granted_account_roles = [ "QA_ETL_WAREHOUSE_WAREHOUSE_ACCESS", "FACTS_DB_QA_SCHEMA_READWRITE", ] granted_database_roles = [ "QA_CONSUMER_REPORTING.DB_TIKTOK_SCHEMA_READWRITE", ] }, { name = "PROD_SWF_PELOTON_ETL_ROLE" granted_account_roles = [ "PROD_ETL_WAREHOUSE_WAREHOUSE_ACCESS", ] granted_database_roles = [ "CONSUMER_REPORTING.DB_PELOTON_SCHEMA_READWRITE", ] }, { name = "QA_SWF_PELOTON_ETL_ROLE" granted_account_roles = [ "QA_ETL_WAREHOUSE_WAREHOUSE_ACCESS", ] granted_database_roles = [ "QA_CONSUMER_REPORTING.DB_PELOTON_SCHEMA_READWRITE", ] }, { name = "PROD_SWF_TIKTOK_OPENESCROW_ETL_ROLE" granted_account_roles = [ "PROD_ETL_WAREHOUSE_WAREHOUSE_ACCESS", ] granted_database_roles = [ "CONFLICT_REPORTING.DB_TIKTOK_SCHEMA_READWRITE", ] }, { name = "QA_SWF_TIKTOK_OPENESCROW_ETL_ROLE" granted_account_roles = [ "QA_ETL_WAREHOUSE_WAREHOUSE_ACCESS", ] granted_database_roles = [ "QA_CONFLICT_REPORTING.DB_TIKTOK_SCHEMA_READWRITE", ] }, { name = "PROD_SWF_TIKTOK_ASSET_MAPPING_REPORT_ETL_ROLE" granted_account_roles = [ "PROD_ETL_WAREHOUSE_WAREHOUSE_ACCESS", ] granted_database_roles = [ "CONSUMER_REPORTING.DB_TIKTOK_SCHEMA_READWRITE", ] }, { name = "QA_SWF_TIKTOK_ASSET_MAPPING_REPORT_ETL_ROLE" granted_account_roles = [ "QA_ETL_WAREHOUSE_WAREHOUSE_ACCESS", ] granted_database_roles = [ "QA_CONSUMER_REPORTING.DB_TIKTOK_SCHEMA_READWRITE", ] }, { name = "PROD_SWF_DEEZER_ETL_ROLE" granted_account_roles = [ "PROD_ETL_WAREHOUSE_WAREHOUSE_ACCESS", "FACTS_DB_PROD_SCHEMA_READWRITE", ] granted_database_roles = [ "FRAUD_REPORTING.DB_DEEZER_SCHEMA_READWRITE", ] }, { name = "PROD_SWF_GFK_PHYSICAL" granted_account_roles = [ "PROD_ETL_WH_WAREHOUSE_ACCESS", ] granted_database_roles = [ "GFK.DB_GSA_SCHEMA_READWRITE", ] }, { name = "PROD_SWF_GFK_STREAMING" granted_account_roles = [ "PROD_ETL_WH_WAREHOUSE_ACCESS", ] granted_database_roles = [ "GFK.DB_GSA_SCHEMA_READWRITE", ] }, { name = "PROD_SWF_PHYSICAL_REPORTING_ETL" granted_account_roles = [ "PHYSICAL_REPORTING_DB_PROD_SCHEMA_READWRITE", "PROD_ETL_WAREHOUSE_WAREHOUSE_ACCESS", ] }, { name = "PROD_VSR_SERVICE" comment = "Functional role for the Virtual Sales Rep prod service account (INT-2683)" granted_database_roles = [ "VIRTUALSALESREP.DB_PROD_SCHEMA_READWRITE", "SONY_INTERNAL.DB_PROD_SCHEMA_READ", ] }, { 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 = "QA_AE_CRM_USER" granted_account_roles = [ "AE_CRM_USER", ] }, { name = "QA_ANALYTICS_TASK_ROLE" account_level_grants = [ "EXECUTE TASK", ] granted_account_roles = [ "DEV_OWS_WH_WAREHOUSE_ACCESS", "QA_LUMINATE_DBT_SCHEDULER_WH_WAREHOUSE_ACCESS", "QA_LUMINATE_DBT_SCHEDULER_LIGHT_WH_WAREHOUSE_ACCESS", "LUMINATE_SHARE_READ", ] granted_database_roles = [ "DEV_DBT.DB_READWRITE", "LUMINATE_MODELS.DB_DEV_SCHEMA_READ", ] }, { name = "QA_AUTH0_ACCESS_INTEGRATION_USAGE" }, { name = "QA_BFF_MOBILE" granted_account_roles = [ "FACTS_DB_QA_SCHEMA_READ", "APOLLO_DB_DEV_SCHEMA_READ", "CHARTMETRIC_DB_RAW_DATA_SCHEMA_READ", ] }, { name = "QA_CHARTMETRIC_TIKTOK_USER" granted_account_roles = [ "CHARTMETRIC_TIKTOK_USER", ] }, { name = "QA_CHARTMETRIC_USER" granted_account_roles = [ "CHARTMETRIC_USER", ] }, { name = "QA_CODA_SEARCH_SVC" comment = "Service role for the Coda search service (QA)." granted_account_roles = [ "SNOWFLAKE_USAGE", "QA_OWS_WAREHOUSE_WAREHOUSE_ACCESS", "BUSINESS_SYSTEMS_SALESFORCE_DATA_DB_READ", "FANSIFTER_DB_PROD_SCHEMA_READ", "INTEGRATION_DB_READ_ONLY", "PERMISSIONS_PLATFORM_DB_PROD_SCHEMA_READ", "ROYALTYACCOUNTING_DB_PROD_SCHEMA_READ", "ROYALTY_ACCOUNTING_REPORTING_DB_PROD_SCHEMA_READ", "S3_INTEGRATIONS_DB_PROD_SCHEMA_READ", "S3_INTEGRATIONS_DB_QA_SCHEMA_READ", ] granted_database_roles = [ "AWAL.DB_AWAL_TRUST_AND_SAFETY_SCHEMA_READ", "DATA_APPS.DB_READ", "FACTS.DB_PROD_SCHEMA_READ", "FACTS.DB_QA_SCHEMA_READ", "FACTS.DB_PROD_SCHEMA_CORTEX_SEARCH_SERVICES_READ", "FACTS.DB_QA_SCHEMA_CORTEX_SEARCH_SERVICES_READ", "GRPS_INGESTOR.DB_PROD_SCHEMA_READ", "ORCHARD_APP_REPORTING_V2.DB_PROD_DIRECT_DELIVERY_MAXWELL_LOGGING_SCHEMA_READ", "ORCHARD_APP_REPORTING_V2.DB_PROD_HIVE_MODEL_REPORTING_SCHEMA_READ", "ORCHARD_APP_REPORTING_V2.DB_PROD_OWS_COLLABORATOR_OWS_COLLABORATOR_SCHEMA_READ", "PHYSICAL_REPORTING.DB_PROD_SCHEMA_READ", "PHYSICAL_REPORTING.DB_QA_SCHEMA_READ", "ROYALTY_ACCOUNTING.ROYALTYACCOUNTING_DB_UAT_SCHEMA_READ", "SME_SUPPLYCHAIN_SANDBOX.DB_READ", ] }, { name = "QA_CODA_SVC" comment = "Service role for the Coda application (QA)." granted_account_roles = [ "SNOWFLAKE_USAGE", "QA_OWS_WAREHOUSE_WAREHOUSE_ACCESS", "BUSINESS_SYSTEMS_SALESFORCE_DATA_DB_READ", "FANSIFTER_DB_PROD_SCHEMA_READ", "INTEGRATION_DB_READ_ONLY", "PERMISSIONS_PLATFORM_DB_PROD_SCHEMA_READ", "ROYALTYACCOUNTING_DB_PROD_SCHEMA_READ", "ROYALTY_ACCOUNTING_REPORTING_DB_PROD_SCHEMA_READ", "S3_INTEGRATIONS_DB_PROD_SCHEMA_READ", "S3_INTEGRATIONS_DB_QA_SCHEMA_READ", ] granted_database_roles = [ "AWAL.DB_AWAL_TRUST_AND_SAFETY_SCHEMA_READ", "DATA_APPS.DB_READ", "FACTS.DB_PROD_SCHEMA_READ", "FACTS.DB_QA_SCHEMA_READ", "FACTS.DB_PROD_SCHEMA_CORTEX_SEARCH_SERVICES_READ", "FACTS.DB_QA_SCHEMA_CORTEX_SEARCH_SERVICES_READ", "GRPS_INGESTOR.DB_PROD_SCHEMA_READ", "ORCHARD_APP_REPORTING_V2.DB_PROD_DIRECT_DELIVERY_MAXWELL_LOGGING_SCHEMA_READ", "ORCHARD_APP_REPORTING_V2.DB_PROD_HIVE_MODEL_REPORTING_SCHEMA_READ", "ORCHARD_APP_REPORTING_V2.DB_PROD_OWS_COLLABORATOR_OWS_COLLABORATOR_SCHEMA_READ", "PHYSICAL_REPORTING.DB_PROD_SCHEMA_READ", "PHYSICAL_REPORTING.DB_QA_SCHEMA_READ", "ROYALTY_ACCOUNTING.ROYALTYACCOUNTING_DB_UAT_SCHEMA_READ", "SME_SUPPLYCHAIN_SANDBOX.DB_READ", ] }, { name = "QA_CONFLICT_MANAGER_ES_SYNC_DB_PASSWORD" granted_account_roles = [ "FACTS_DB_QA_SCHEMA_READWRITE", "OWSCONFLICTMANAGER_DB_QA_SCHEMA_READ", ] }, { name = "QA_ETL_BANDSINTOWN_ROLE" granted_account_roles = [ "QA_ETL_WH_WAREHOUSE_ACCESS", "PREFERENCE_CENTER_DB_QA_SCHEMA_READ", ] granted_database_roles = [ "FAN_LIVE_EVENTS.DB_QA_SCHEMA_READWRITE", ] }, { name = "QA_ETL_SEATED_ROLE" granted_account_roles = [ "QA_ETL_WH_WAREHOUSE_ACCESS", ] granted_database_roles = [ "FAN_LIVE_EVENTS.DB_QA_SCHEMA_READWRITE", ] }, { name = "QA_ETL_SETLIVE_ROLE" granted_account_roles = [ "QA_ETL_WH_WAREHOUSE_ACCESS", ] granted_database_roles = [ "FAN_LIVE_EVENTS.DB_QA_SCHEMA_READWRITE", ] }, { name = "QA_ETL_SPOTIFY_FOLLOWERS_ROLE" granted_account_roles = [ "QA_SWF_ETL_WAREHOUSE_WAREHOUSE_ACCESS", ] granted_database_roles = [ "QA_PARTNER_REPORTING.DB_SPOTIFY_SCHEMA_READWRITE", ] }, { name = "QA_ETL_TICKETEK_ROLE" granted_account_roles = [ "QA_ETL_WH_WAREHOUSE_ACCESS", ] granted_database_roles = [ "FAN_LIVE_EVENTS.DB_QA_SCHEMA_READWRITE", ] }, { name = "QA_EXPLORATION_ADV_USER" granted_account_roles = [ "EXPLORATION_ADV_USER", ] }, { name = "QA_EXPLORATION_AD_PLUS" granted_account_roles = [ "EXPLORATION_AD_PLUS", ] }, { name = "QA_EXPLORATION_SYS_USER" granted_account_roles = [ "EXPLORATION_SYS_USER", ] }, { name = "QA_EXPLORATION_USER" granted_account_roles = [ "EXPLORATION_USER", ] }, { name = "QA_FANSIFTER_DBT" granted_account_roles = [ "FANSIFTER_APP_REPORTING_DB_QA_SCHEMA_READWRITE", "FANSIFTER_APP_REPORTING_DB_QA_SHOPIFY_SCHEMA_READ", "FANSIFTER_APP_REPORTING_DB_QA_MARKETING_SCHEMA_READWRITE", "FANSIFTER_APP_REPORTING_DB_CI_PR_SCHEMA_READWRITE", "FANSIFTER_APP_REPORTING_DB_CI_TEST_SCHEMA_READWRITE", "FANSIFTER_APP_REPORTING_DB_QA_CRM_FANS_SCHEMA_READ", "FANSIFTER_APP_REPORTING_DB_PROD_CRM_FANS_SCHEMA_READ", "FANSIFTER_APP_REPORTING_DB_QA_VIEWS_SCHEMA_READWRITE", "DELPHI_EXPLORATION_DB_MAIN_SCHEMA_READ", "DELPHI_CRM_DATA_DB_RAW_SALESFORCE_SALES_CLOUD_SCHEMA_READ", "DELPHI_CRM_DATA_DB_RAW_SALESFORCE_MARKETING_CLOUD_SCHEMA_READ", "QA_CRM_ECOMMERCE_DATA_DB_READ", "CRM_ECOMMERCE_DATA_DB_READ", "FANSIFTER_PG_REPORTING_DB_QA_OWS_DMP_PUBLIC_SCHEMA_READ", "FANSIFTER_PG_REPORTING_DB_PROD_OWS_DMP_PUBLIC_SCHEMA_READ", "ORCHARD_APP_REPORTING_DB_DELPHI_PROD_SCHEMA_READ", "FACTS_DB_PROD_SCHEMA_READ", "QA_MARKETING_INTEGRATIONS_DB_READ", "SONGWHIP_APP_REPORTING_DB_READ", "PREFERENCE_CENTER_DB_QA_SCHEMA_READ", "DELPHI_EXPLORATION_DB_SYS_SCHEMA_READ", "FANSIFTER_DB_PROD_SCHEMA_READWRITE", "QA_SHOPIFY_INTEGRATIONS_DB_READ", "QA_DBT_WH_WAREHOUSE_ACCESS", "QA_ETL_WH_WAREHOUSE_ACCESS", ] granted_database_roles = [ "FAN_LIVE_EVENTS.DB_QA_SCHEMA_READ", "FAN_LIVE_EVENTS.DB_PROD_SCHEMA_READ", "FANSIFTER_SHOPIFY.DB_CI_PR_SCHEMA_READWRITE", "FANSIFTER_SHOPIFY.DB_CI_TEST_SCHEMA_READWRITE", "FANSIFTER_SHOPIFY.DB_QA_SCHEMA_READWRITE", ] }, { name = "QA_INSIGHTS_PLAYLIST_PAGES_GSHEETS_SYNC_TASK_ROLE" comment = "Task role for syncing playlist pages from GSheets into FACTS QA schema" account_level_grants = [ "EXECUTE TASK", ] granted_account_roles = [ "QA_TASK_WAREHOUSE_WAREHOUSE_ACCESS", "CHARTMETRIC_DB_RAW_DATA_SCHEMA_READ", ] granted_database_roles = [ "ORCHARD_APP_REPORTING_V2.DB_QA_INSIGHTS_PLAYLIST_PAGES_GSHEETS_SYNC_SCHEMA_READ", "FACTS.DB_QA_SCHEMA_READWRITE", ] }, { name = "QA_KAFKA_CONNECT_FORMRESPONSE" granted_account_roles = [ "DELPHI_CRM_DATA_DB_READWRITE", "QA_ETL_WH_WAREHOUSE_ACCESS", "FANSIFTER_APP_REPORTING_DB_QA_CRM_FANS_SCHEMA_READWRITE", ] }, { name = "QA_KAFKA_CONNECT_FS" granted_account_roles = [ "FANSIFTER_APP_REPORTING_DB_QA_SCHEMA_READWRITE", "QA_ETL_WH_WAREHOUSE_ACCESS", ] granted_database_roles = [ "RESONANCE_ENGINE.DB_QA_SCHEMA_READWRITE", ] }, { 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 = "QA_KAFKA_CONNECT_SNOWFLAKE_SINK_SR_FINGERPRINT" granted_account_roles = [ "FACTS_DB_QA_SCHEMA_READWRITE", "QA_ETL_WAREHOUSE_WAREHOUSE_ACCESS", ] }, { name = "QA_KAFKA_CONNECT_TRIGGERED_SENDS" granted_account_roles = [ "DELPHI_CRM_DATA_DB_READWRITE", "FANSIFTER_APP_REPORTING_DB_QA_CRM_FANS_SCHEMA_READWRITE", "QA_ETL_WH_WAREHOUSE_ACCESS", ] }, { name = "QA_LAMBDA_AUDIENCE" granted_account_roles = [ "FANSIFTER_APP_REPORTING_DB_QA_SCHEMA_READWRITE", "PREFERENCE_CENTER_DB_QA_SCHEMA_READ", "QA_ETL_WH_WAREHOUSE_ACCESS", ] }, { name = "QA_LAMBDA_CONTENT_DELETE_PRODUCT_INTEGRATION_USAGE" }, { name = "QA_LAMBDA_CONTENT_REVIEW_QUEUE_CLEANUP" granted_account_roles = [ "ORCHARDAPPREPORTING_DB_ARTRELATIONS_SCHEMA_READWRITE", "ORCHARDAPPREPORTING_DB_PROD_CONTENT_REVIEW_SCHEMA_READWRITE", ] }, { name = "QA_LAMBDA_D2C_SHOPIFY_ONBOARDING" comment = "QA service role for lambda-d2c-shopify-onboarding. Jira: D2C-146" granted_account_roles = [ "CRM_ECOMMERCE_DATA_DB_READ", "FACTS_DB_QA_SCHEMA_READ", "FANSIFTER_APP_REPORTING_DB_PROD_SHOPIFY_SCHEMA_READ", "ORCHARD_APP_REPORTING_V2_READ", "QA_OWS_WAREHOUSE_WAREHOUSE_ACCESS", ] granted_database_roles = [ "SHOPIFY_STORES_GLOBAL.DB_QA_D2C_OPERATIONS_SCHEMA_READWRITE", # Read on the per-store data schemas (where Fivetran lands SHOP etc.); without # this the sync lambda can't see synced tables and stores wedge at pending_sync. "SHOPIFY_STORES_GLOBAL.DB_READ", ] }, { name = "QA_LAMBDA_FAN_DELETION_ROLE" granted_account_roles = [ "QA_FANSIFTER_FAN_DELETION_WH_WAREHOUSE_ACCESS", "FANSIFTER_APP_REPORTING_DB_QA_CRM_FANS_SCHEMA_READWRITE", ] }, { name = "QA_LAMBDA_FAN_SUBSCRIPTION_PREFERENCE_SFORCE_UPDATES" comment = "Lambda role for syncing fan subscription preference updates to Salesforce in QA." granted_account_roles = [ "PREFERENCE_CENTER_DB_QA_SCHEMA_READ", "DELPHI_CRM_DATA_DB_RAW_SALESFORCE_SALES_CLOUD_SCHEMA_READ", "QA_ETL_WH_WAREHOUSE_ACCESS", ] }, { name = "QA_LAMBDA_PRODUCT_TRANSFER_UPDATE_DIM_TABLES" comment = "Role for QA lambda-product-transfer-update-dim-tables to update Snowflake dimension tables after a product transfer." granted_account_roles = [ "FACTS_DB_QA_SCHEMA_READWRITE", "QA_OWS_WAREHOUSE_WAREHOUSE_ACCESS", ] granted_database_roles = [ "ORCHARD_APP_REPORTING_V2.DB_QA_ROYALTY_ACCOUNTING_ROYALTY_ACCOUNTING_SCHEMA_STATEMENT_PERIOD_TABLE_READ", ] }, { name = "PROD_LAMBDA_PRODUCT_TRANSFER_UPDATE_DIM_TABLES" comment = "Role for PROD lambda-product-transfer-update-dim-tables to update Snowflake dimension tables after a product transfer." granted_account_roles = [ "FACTS_DB_PROD_SCHEMA_READWRITE", "PROD_OWS_WAREHOUSE_WAREHOUSE_ACCESS", ] granted_database_roles = [ "ORCHARD_APP_REPORTING_V2.DB_PROD_ROYALTY_ACCOUNTING_ROYALTY_ACCOUNTING_SCHEMA_STATEMENT_PERIOD_TABLE_READ", ] }, { name = "QA_LAMBDA_SR_ACK_PROCESSOR" granted_account_roles = [ "FACTS_DB_QA_SCHEMA_READWRITE", ] }, { name = "QA_LUMINATE_DBT_SCHEDULER_ROLE" granted_account_roles = [ "LUMINATE_SHARE_READ", "QA_LUMINATE_DBT_SCHEDULER_WH_WAREHOUSE_ACCESS", "QA_LUMINATE_DBT_SCHEDULER_LIGHT_WH_WAREHOUSE_ACCESS", "QA_LUMINATE_DBT_SCHEDULER_HEAVY_WH_WAREHOUSE_ACCESS", "QA_ETL_WH_WAREHOUSE_ACCESS", ] granted_database_roles = [ "LUMINATE_MODELS.DB_QA_SCHEMA_READWRITE", "LUMINATE_MODELS.DB_QA_DBT_STAGE_SCHEMA_READWRITE", "LUMINATE_MODELS.DB_PROD_SCHEMA_READ", ] }, { name = "QA_LUMINATE_MODELS_ISRC_UPC_MAPPING_TASK" account_level_grants = [ "EXECUTE TASK", ] granted_account_roles = [ "QA_ETL_WH_WAREHOUSE_ACCESS", "ORCHARD_FACTS", ] granted_database_roles = [ "LUMINATE_MODELS.DB_QA_SCHEMA_READWRITE", ] }, { name = "QA_MARKETING_INTEGRATIONS_FIVETRAN" granted_account_roles = [ "QA_MARKETING_INTEGRATIONS_DB_READWRITE", "QA_MARKETING_INTEGRATIONS_WH_WAREHOUSE_ACCESS", ] }, { name = "QA_OWS_ANALYTICS" granted_account_roles = [ "CORTEX_USER_ROLE", "FACTS_DB_PROD_SCHEMA_READ", "FACTS_DB_QA_SCHEMA_READWRITE", "QA_INSIGHTS_WAREHOUSE_WAREHOUSE_ACCESS", ] granted_database_roles = [ "FACTS.DB_QA_SCHEMA_CORTEX_SEARCH_SERVICES_READ", ] }, { name = "QA_OWS_COLLABORATOR" granted_account_roles = [ "FACTS_DB_QA_SCHEMA_READ", "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 = [ "FACTS_DB_PROD_SCHEMA_READ", "FANSIFTER_APP_REPORTING_DB_QA_SCHEMA_READWRITE", "FANSIFTER_APP_REPORTING_DB_QA_SHOPIFY_SCHEMA_READ", "FANSIFTER_DB_QA_SCHEMA_READWRITE", "FANSIFTER_PG_REPORTING_DB_QA_OWS_DMP_PUBLIC_SCHEMA_READ", "MARKETING_INTEGRATIONS_DB_FACEBOOK_ADS_SCHEMA_READ", "ORCHARD_APP_REPORTING_DB_DELPHI_PROD_SCHEMA_READ", "PREFERENCE_CENTER_DB_QA_SCHEMA_READ", "QA_ETL_WH_WAREHOUSE_ACCESS", "QA_OWS_WAREHOUSE_WAREHOUSE_ACCESS", "QA_OWS_WH_WAREHOUSE_ACCESS", "QA_SHOPIFY_INTEGRATIONS_DB_READWRITE", "QA_SHOPIFY_INTEGRATIONS_FIVETRAN", "QA_SHOPIFY_INTEGRATIONS_WH_WAREHOUSE_ACCESS", ] granted_database_roles = [ "FANSIFTER_SHOPIFY.DB_QA_SCHEMA_READ", ] }, { name = "QA_OWS_EMAIL_CAMPAIGNS" granted_account_roles = [ "FANSIFTER_APP_REPORTING_DB_QA_SCHEMA_READWRITE", "QA_OWS_WH_WAREHOUSE_ACCESS", "QA_ETL_WH_WAREHOUSE_ACCESS", "PREFERENCE_CENTER_DB_QA_SCHEMA_READ", "DELPHI_CRM_DATA_DB_RAW_SALESFORCE_SALES_CLOUD_SCHEMA_READ", ] granted_database_roles = [ "FANSIFTER_SHOPIFY.DB_QA_SCHEMA_READ", ] }, { name = "QA_OWS_GRID_GENERATOR" granted_account_roles = [ "QA_OWS_WH_WAREHOUSE_ACCESS", ] granted_database_roles = [ "DELPHI_EXPLORATION.DB_EXP_SCHEMA_V_GRAS_PRODUCT_VIEW_READ", "DELPHI_EXPLORATION.DB_EXP_SCHEMA_V_GRAS_TRACK_VIEW_READ", "DELPHI_EXPLORATION.DB_EXP_SCHEMA_V_GRAS_PRODUCT_TRACK_VIEW_READ", ] }, { name = "QA_OWS_PREFERENCE_CENTER" granted_account_roles = [ "PREFERENCE_CENTER_DB_QA_SCHEMA_READWRITE", "QA_PREFERENCE_CENTER_WH_WAREHOUSE_ACCESS", ] }, { name = "QA_OWS_SOUND_RECORDINGS" granted_account_roles = [ "FACTS_DB_QA_SCHEMA_READ", "FACTS_DB_QA_SCHEMA_READWRITE", "QA_ETL_WAREHOUSE_WAREHOUSE_ACCESS", ] }, { name = "QA_SOUND_RECORDINGS_TAKEDOWN" comment = "Role for sound recordings takedown service (QA)" granted_account_roles = [ "QA_OWS_WAREHOUSE_WAREHOUSE_ACCESS", "INTELLIGENCE_DB_DBT_PROD_SCHEMA_READ", "ROYALTY_ACCOUNTING_REPORTING_DB_PROD_SCHEMA_READ", ] granted_database_roles = [ "ORCHARD_APP_REPORTING_V2.DB_ART_RELATIONS_PROD_ART_RELATIONS_SCHEMA_READ", "FACTS.DB_PROD_SCHEMA_READ", ] }, { name = "QA_OWS_TEXT_CAMPAIGNS" granted_account_roles = [ "FANSIFTER_APP_REPORTING_DB_QA_SCHEMA_READWRITE", "QA_OWS_WH_WAREHOUSE_ACCESS", ] }, { name = "QA_PAYMENT_SEARCH_ROLE" comment = "Role with access only to QA PAYMENT_DATA_SEARCH Cortex Search Service" granted_account_roles = [ "ROYALTYACCOUNTING_DB_QA_SCHEMA_READ", "QA_CORTEX_SEARCH_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 = "QA_QA_AUTOMATION" granted_database_roles = [ "FACTS.DB_QA_SCHEMA_ISRC_AVAILABILITY_TEST_RESULTS_TABLE_READWRITE", ] }, { name = "QA_ROYALTYSHARE_SERVICE_ROLE" granted_account_roles = [ "QA_ROYALTYSHARE_WAREHOUSE_WAREHOUSE_ACCESS", ] granted_database_roles = [ "ROYALTYSHARE.DB_DEV_SCHEMA_READWRITE", "ROYALTYSHARE.DB_QA_SCHEMA_READWRITE", ] }, { name = "QA_REVENUE_FILE_INGESTION_ROLE" comment = "REVENUE_FILE_INGESTION (formerly SlaughterHouse) QA role for PHP application" granted_account_roles = [ "QA_REVENUE_FILE_INGESTION_WH_WAREHOUSE_ACCESS", ] granted_database_roles = [ "ORCHARD_APP_REPORTING_V2.DB_ART_RELATIONS_PROD_ART_RELATIONS_SCHEMA_READ", "REVENUE_FILE_INGESTION.DB_QA_SCHEMA_READWRITE", "REVENUE_FILE_INGESTION.DB_QA_SCHEMA_qa-revenue-file-ingestion-s3-stage_STAGE_USAGE", ] }, { name = "QA_ROYALTY_ACCOUNTING_REFRESH" granted_account_roles = [ "ROYALTYACCOUNTING_DB_PROD_SCHEMA_READ", "ROYALTYACCOUNTING_DB_QA_SCHEMA_READWRITE", ] }, { name = "QA_SFN_GRPS_INGESTER_ROLE" comment = "Task role grps-ingester stepfunction" granted_account_roles = [ "QA_ETL_WAREHOUSE_WAREHOUSE_ACCESS", ] granted_database_roles = [ "GRPS_APP_REPORTING_NOCONF.DB_GRPS_DRAS002_SCHEMA_READ", "GRPS_APP_REPORTING_NOCONF.DB_GRPS_DRPS001_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", "SONY_INTERNAL.DB_DEV_SCHEMA_READ", "GRPS_INGESTOR.DB_QA_SCHEMA_READWRITE", ] }, { name = "QA_SHOPIFY_GLOBAL_DBT_SCHEDULER_ROLE" granted_account_roles = [ "QA_SHOPIFY_GLOBAL_DBT_SCHEDULER_WH_WAREHOUSE_ACCESS", "QA_ETL_WH_WAREHOUSE_ACCESS", "QA_SHOPIFY_INTEGRATIONS_DB_READ", "CRM_ECOMMERCE_DATA_DB_READ", "PROD_SHOPIFY_INTEGRATIONS_DB_READ", "FANSIFTER_APP_REPORTING_DB_READ", "ORCHARD_APP_REPORTING_DB_READ", "ORCHARD_APP_REPORTING_V2_READ", "ORCHARD_FACTS", ] granted_database_roles = [ "SHOPIFY_STORES_GLOBAL.DB_READ", "SHOPIFY_STORES_GLOBAL.DB_QA_SHOPIFY_STORE_SCHEMA_SCHEMA_READWRITE", "SHOPIFY_STORES_GLOBAL.DB_QA_SHOPIFY_STORE_SCHEMA_VIEWS_SCHEMA_READWRITE", ] }, { name = "QA_SHOPIFY_INTEGRATIONS_FIVETRAN" granted_account_roles = [ "FANSIFTER_APP_REPORTING_DB_QA_SHOPIFY_SCHEMA_READWRITE", "QA_SHOPIFY_INTEGRATIONS_DB_READWRITE", "QA_SHOPIFY_INTEGRATIONS_WH_WAREHOUSE_ACCESS", ] granted_database_roles = [ "FANSIFTER_APP_REPORTING.DB_QA_SCHEMA_SHOPIFY_STORE_ASSOCIATION_TABLE_READ", ] }, { name = "QA_SME_ANALYTICS_DDEX_INGESTER_SERVICE_ROLE" granted_account_roles = [ "FACTS_DB_QA_SCHEMA_READWRITE", ] granted_database_roles = [ "ORCHARD_APP_REPORTING_V2.DB_ART_RELATIONS_PROD_ART_RELATIONS_SCHEMA_READ", "GRPS_APP_REPORTING_NOCONF.DB_GRPS_DRAS002_SCHEMA_READ", ] }, { name = "QA_STARS_SALES_PROCESSING" comment = "Role to give STARS access to read data from views for single supply chain sales processing" granted_account_roles = [ "QA_SALES_PROCESSING_WH_WAREHOUSE_ACCESS" ] granted_database_roles = [ "SALES_PROCESSING.DB_QA_SCHEMA_READ", ] }, { name = "QA_SWF_AMAZON_DATAPULSE_ETL_ROLE" granted_account_roles = [ "QA_ETL_WAREHOUSE_WAREHOUSE_ACCESS", ] granted_database_roles = [ "QA_FRAUD_REPORTING.DB_AMAZON_SCHEMA_READWRITE", "QA_CONSUMER_REPORTING.DB_AMAZON_SCHEMA_READWRITE", ] }, { name = "QA_SWF_AMAZON_MUSIC_ETL_ROLE" granted_account_roles = [ "QA_ETL_WAREHOUSE_WAREHOUSE_ACCESS", ] granted_database_roles = [ "QA_CONSUMER_REPORTING.DB_AMAZON_SCHEMA_READWRITE", "ORCHARD_APP_REPORTING_V2.DB_PROD_DDEX_INGESTER_DDEX_INGESTER_SCHEMA_READ", "FACTS.DB_QA_SCHEMA_READWRITE", ] }, { 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 = "QA_SWF_DEEZER_ETL_ROLE" granted_account_roles = [ "QA_ETL_WAREHOUSE_WAREHOUSE_ACCESS", "FACTS_DB_QA_SCHEMA_READWRITE", ] granted_database_roles = [ "QA_FRAUD_REPORTING.DB_DEEZER_SCHEMA_READWRITE", ] }, { name = "QA_SWF_GFK_PHYSICAL" granted_account_roles = [ "QA_ETL_WH_WAREHOUSE_ACCESS", ] granted_database_roles = [ "GFK.DB_QA_GSA_SCHEMA_READWRITE", ] }, { name = "QA_SWF_GFK_STREAMING" granted_account_roles = [ "QA_ETL_WH_WAREHOUSE_ACCESS", ] granted_database_roles = [ "GFK.DB_QA_GSA_SCHEMA_READWRITE", ] }, { name = "QA_SWF_PHYSICAL_REPORTING_ETL" granted_account_roles = [ "PHYSICAL_REPORTING_DB_QA_SCHEMA_READWRITE", "QA_ETL_WAREHOUSE_WAREHOUSE_ACCESS", ] }, { name = "PROD_SWF_SPOTIFY_ETL_ROLE" granted_account_roles = [ "FACTS_DB_PROD_SCHEMA_READWRITE", "PROD_ETL_WAREHOUSE_WAREHOUSE_ACCESS", ] granted_database_roles = [ "CONSUMER_REPORTING.DB_SPOTIFY_SCHEMA_READWRITE", ] }, { name = "QA_SWF_SPOTIFY_ETL_ROLE" granted_account_roles = [ "FACTS_DB_QA_SCHEMA_READWRITE", "PROD_ETL_WAREHOUSE_WAREHOUSE_ACCESS", ] granted_database_roles = [ "ORCHARD_APP_REPORTING_V2.DB_ART_RELATIONS_PROD_ART_RELATIONS_SCHEMA_READ", "ORCHARD_APP_REPORTING_V2.DB_PROD_DDEX_INGESTER_DDEX_INGESTER_SCHEMA_READ", "QA_CONSUMER_REPORTING.DB_SPOTIFY_SCHEMA_READWRITE", ] }, { name = "PROD_SWF_APPLE_MUSIC_ETL_ROLE" granted_account_roles = [ "FACTS_DB_PROD_SCHEMA_READWRITE", "PROD_ETL_WAREHOUSE_WAREHOUSE_ACCESS", ] granted_database_roles = [ "CONSUMER_REPORTING.DB_APPLE_SCHEMA_READWRITE", ] }, { name = "QA_SWF_APPLE_MUSIC_ETL_ROLE" granted_account_roles = [ "FACTS_DB_QA_SCHEMA_READWRITE", "QA_ETL_WAREHOUSE_WAREHOUSE_ACCESS", ] granted_database_roles = [ "QA_CONSUMER_REPORTING.DB_APPLE_SCHEMA_READWRITE", ] }, { 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 = "QA_VSR_SERVICE" comment = "Functional role for the Virtual Sales Rep QA service account (INT-2683)" granted_database_roles = [ "VIRTUALSALESREP.DB_QA_SCHEMA_READWRITE", "SONY_INTERNAL.DB_QA_SCHEMA_READ", "SONY_INTERNAL.DB_PROD_SCHEMA_READ", ] }, { name = "QUICKSIGHT_ADMIN" account_level_grants = [ "EXECUTE TASK", "APPLY MASKING POLICY", ] granted_account_roles = [ "CICD_WH_WAREHOUSE_ACCESS", "EXPLORATION_SYS_PROD_WH_WAREHOUSE_ACCESS", "EXPLORATION_SYS_PROD_HL_WH_WAREHOUSE_ACCESS", "AE_REPORTING_PROD_WH_WAREHOUSE_ACCESS", "DELPHI_AE_REPORTING_DB_READWRITE", "DELPHI_EXPLORATION_DB_CREATE_SCHEMA", "DELPHI_EXPLORATION_DB_READWRITE", "DELPHI_CRM_DATA_DB_READ", "DELPHI_AE_REPORTING_DB_MAIN_SCHEMA_READWRITE", "DELPHI_AE_REPORTING_DB_SYS_SCHEMA_READWRITE", "DELPHI_EXPLORATION_DB_MAIN_SCHEMA_READWRITE", "DELPHI_EXPLORATION_DB_SYS_SCHEMA_READWRITE", ] }, { name = "RCA_ROLE" granted_account_roles = [ "TEAM_DEV_BA_WH_WAREHOUSE_ACCESS", ] }, { name = "READER" }, { name = "RENEGADE_STORES" granted_account_roles = [ "CRM_ECOMMERCE_DATA_DB_SHOPIFY_UK_RENEGADE_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_SHOPIFY_DE_RENEGADE_EU_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_SHOPIFY_AU_NZ_RENEGADE_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_SHOPIFY_US_COLUMBIA_RENEGADE_SCHEMA_READ", ] }, { name = "REPLICATOR" owner = "SECURITYADMIN" }, { name = "REPORTINGDB_DIM_ETL" granted_account_roles = [ "PROD_ETL_WH_WAREHOUSE_ACCESS", "QA_ETL_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_REPORTING_DB_LARGE_WAREHOUSE_WAREHOUSE_ACCESS", ] granted_database_roles = [ "LUMINATE_MODELS.DB_PROD_SCHEMA_READWRITE", ] }, { name = "REPORTING_DB_TEAM" granted_account_roles = [ "DEV_ENGINEERING", "ANALYST_BASELINE_ROLE", "SME_ANALYTICS_REPORTING_DB_LARGE_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_REPORTING_DB_MEDIUM_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_REPORTING_DB_SMALL_WAREHOUSE_WAREHOUSE_ACCESS", "SME_DATA_INSIGHTS", "TEAM_BA_ROLE", ] granted_database_roles = [ "SME_ANALYTICS.DB_SHARED_SCHEMA_READWRITE", "SME_ANALYTICS.DB_READ", "SME_ANALYTICS.DB_REPORTING_DB_SCHEMA_READWRITE", ] }, { name = "ROYALTYSHARE_DB_READ" granted_account_roles = [ "DEV_PERFORMANCE_WAREHOUSE_WAREHOUSE_ACCESS", ] granted_database_roles = [ "ROYALTYSHARE.DB_READ", ] }, { 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", "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_QA_SCHEMA_DB_DEPLOY" granted_account_roles = [ "ROYALTY_ACCOUNTING_REPORTING_DB_QA_SCHEMA_READWRITE", "ROYALTYACCOUNTING_DB_QA_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 = "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", "ROYALTYSHARE.DB_ROYALTYSHARE_C_CLEOPATRA_RECORDS_SCHEMA_ARTIST_ROYALTIES_STAGE_USAGE", "ROYALTYSHARE.DB_ROYALTYSHARE_C_RSTEST_SCHEMA_ARTIST_ROYALTIES_STAGE_USAGE", ] }, { 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 = "SALESFORCE_CA_READ" 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", ] granted_database_roles = [] }, { name = "SEGMENT" granted_account_roles = [ "SEGMENT_WH_WAREHOUSE_ACCESS", "FANSIFTER_APP_REPORTING_DB_PROD_SEGMENT_SCHEMA_READ", "FANSIFTER_APP_REPORTING_DB_QA_SEGMENT_SCHEMA_READ", ] }, { name = "SFMC_ALERTS_ROLE" granted_account_roles = [ "SFMC_ALERTS_WH_WAREHOUSE_ACCESS", "DELPHI_CRM_DATA_DB_RAW_SALESFORCE_MARKETING_CLOUD_SCHEMA_READ", ] }, { name = "SHOPIFY_GLOBAL_STORES_ROLE" granted_account_roles = [ "SHOPIFY_GLOBAL_STORES_MEDIUM_WAREHOUSE_WAREHOUSE_ACCESS", ] granted_database_roles = [ "SHOPIFY_STORES_GLOBAL.DB_READWRITE", ] }, { name = "SME_ANALYTICS_5020RECORDS" granted_account_roles = [ "ANALYST_BASELINE_ROLE", "SME_ANALYTICS_5020RECORDS_SMALL_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_5020RECORDS_MEDIUM_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_5020RECORDS_LARGE_WAREHOUSE_WAREHOUSE_ACCESS", ] granted_database_roles = [ "SME_ANALYTICS.DB_SHARED_SCHEMA_READWRITE", "SME_ANALYTICS.DB_5020RECORDS_SCHEMA_READWRITE", ] }, { name = "SME_ANALYTICS_ALAMO" granted_account_roles = [ "ANALYST_BASELINE_ROLE", "SME_DATA_INSIGHTS", "DELPHI_EXPLORATION_DB_CHARTMETRIC_SCHEMA_READ", "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_ARISTA" account_level_grants = [ "EXECUTE TASK", ] granted_account_roles = [ "ANALYST_BASELINE_ROLE", "SME_ANALYTICS_ARISTA_COMPUTE_POOL_COMPUTE_POOL_ACCESS", "SME_ANALYTICS_ARISTA_LARGE_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_ARISTA_MEDIUM_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_ARISTA_SMALL_WAREHOUSE_WAREHOUSE_ACCESS", "SME_DATA_INSIGHTS", ] granted_database_roles = [ "SME_ANALYTICS.DB_SHARED_SCHEMA_READWRITE", "SME_ANALYTICS.DB_ARISTA_SCHEMA_READWRITE", ] }, { name = "SME_ANALYTICS_AUSTRALIA" account_level_grants = [ "EXECUTE TASK", ] granted_account_roles = [ "ANALYST_BASELINE_ROLE", "SME_ANALYTICS_AU_SMALL_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_AU_MEDIUM_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_AU_LARGE_WAREHOUSE_WAREHOUSE_ACCESS", ] granted_database_roles = [ "SME_ANALYTICS.DB_SHARED_SCHEMA_READWRITE", "SME_ANALYTICS.DB_AU_SCHEMA_READWRITE", ] }, { name = "SME_ANALYTICS_BENELUX" granted_account_roles = [ "DELPHI_EXPLORATION_DB_CHARTMETRIC_SCHEMA_READ", "FANSIFTER_AD_REPORTING_VIEWS_ACCESS", "ANALYST_BASELINE_ROLE", "SME_ANALYTICS_BENELUX_COMPUTE_POOL_COMPUTE_POOL_ACCESS", "SME_ANALYTICS_BX_LARGE_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_BX_MEDIUM_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_BX_SMALL_WAREHOUSE_WAREHOUSE_ACCESS", "SME_DATA_INSIGHTS", ] granted_database_roles = [ "DELPHI_CRM_DATA.DB_RAW_SALESFORCE_SALES_CLOUD_SCHEMA_V_FORM_C_VIEW_READ", "DELPHI_CRM_DATA.DB_RAW_SALESFORCE_SALES_CLOUD_SCHEMA_V_MAILING_LIST_C_VIEW_READ", "DELPHI_CRM_DATA.DB_RAW_SALESFORCE_SALES_CLOUD_SCHEMA_V_SUBSCRIPTION_C_VIEW_READ", "DELPHI_CRM_DATA.DB_RAW_SALESFORCE_SALES_CLOUD_SCHEMA_V_FAN_C_VIEW_READ", "DELPHI_CRM_DATA.DB_RAW_SALESFORCE_SALES_CLOUD_SCHEMA_V_FORM_RESPONSE_C_VIEW_READ", "DELPHI_CRM_DATA.DB_RAW_SALESFORCE_SALES_CLOUD_SCHEMA_V_SUBSCRIPTION_HISTORY_C_VIEW_READ", "DELPHI_CRM_DATA.DB_RAW_SALESFORCE_SALES_CLOUD_SCHEMA_V_TLA_C_VIEW_READ", "DELPHI_CRM_DATA.DB_RAW_SALESFORCE_SALES_CLOUD_SCHEMA_V_ARTIST_C_VIEW_READ", "SME_ANALYTICS.DB_SHARED_SCHEMA_READWRITE", "SME_ANALYTICS.DB_BX_SCHEMA_READWRITE", "FANSIFTER_APP_REPORTING.DB_DEV_MMACHADO_SCHEMA_AD_REPORTING_CAMPAIGN_DBT_BENELUX_DYNAMIC_TABLE_READ", ] }, { name = "SME_ANALYTICS_BRAZIL" granted_account_roles = [ "DELPHI_EXPLORATION_DB_CHARTMETRIC_SCHEMA_READ", "FANSIFTER_AD_REPORTING_VIEWS_ACCESS", "ANALYST_BASELINE_ROLE", "SME_ANALYTICS_BR_LARGE_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_BR_MEDIUM_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_BR_SMALL_WAREHOUSE_WAREHOUSE_ACCESS", "SME_DATA_INSIGHTS", ] granted_database_roles = [ "DELPHI_EXPLORATION.DB_EXP_SCHEMA_V_LINKFIRE_RAW_DATA_VIEW_READ", "SME_ANALYTICS.DB_SHARED_SCHEMA_READWRITE", "SME_ANALYTICS.DB_BR_SCHEMA_READWRITE", ] }, { name = "SME_ANALYTICS_CANADA" granted_account_roles = [ "ANALYST_BASELINE_ROLE", "SME_ANALYTICS_CA_LARGE_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_CA_MEDIUM_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_CA_SMALL_WAREHOUSE_WAREHOUSE_ACCESS", "SME_DATA_INSIGHTS", ] granted_database_roles = [ "SME_ANALYTICS.DB_SHARED_SCHEMA_READWRITE", "SME_ANALYTICS.DB_CA_SCHEMA_READWRITE", ] }, { name = "SME_ANALYTICS_CHINA" granted_account_roles = [ "ANALYST_BASELINE_ROLE", "SME_ANALYTICS_CN_LARGE_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_CN_MEDIUM_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_CN_SMALL_WAREHOUSE_WAREHOUSE_ACCESS", "SME_DATA_INSIGHTS", # compute pool "SME_ANALYTICS_CHINA_COMPUTE_POOL_COMPUTE_POOL_ACCESS", ] granted_database_roles = [ "SME_ANALYTICS.DB_SHARED_SCHEMA_READWRITE", "SME_ANALYTICS.DB_CN_SCHEMA_READWRITE", ] }, { name = "SME_ANALYTICS_COLOMBIA" granted_account_roles = [ "ANALYST_BASELINE_ROLE", "SME_ANALYTICS_CO_LARGE_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_CO_MEDIUM_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_CO_SMALL_WAREHOUSE_WAREHOUSE_ACCESS", "SME_DATA_INSIGHTS", ] granted_database_roles = [ "SME_ANALYTICS.DB_SHARED_SCHEMA_READWRITE", "SME_ANALYTICS.DB_CO_SCHEMA_READWRITE", ] }, { name = "SME_ANALYTICS_CORE_SALES_MARKETING_SYSTEMS" granted_account_roles = [ "ANALYST_BASELINE_ROLE", "SME_ANALYTICS_CORE_SALES_MARKETING_SYSTEMS_SMALL_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_CORE_SALES_MARKETING_SYSTEMS_MEDIUM_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_CORE_SALES_MARKETING_SYSTEMS_LARGE_WAREHOUSE_WAREHOUSE_ACCESS", ] granted_database_roles = [ "SME_ANALYTICS.DB_SHARED_SCHEMA_READWRITE", "SME_ANALYTICS.DB_CORE_SALES_MARKETING_SYSTEMS_SCHEMA_READWRITE", ] }, { name = "SME_ANALYTICS_CRM_UK" granted_account_roles = [ "SME_ANALYTICS_UK", "DELPHI_EXPLORATION_DB_CHARTMETRIC_SCHEMA_READ", "DELPHI_EXPLORATION_DB_CRM_ECOMMERCE_READ", "DELPHI_AE_REPORTING_DB_EXP_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_CONSOLIDATION_DATA_SCHEMA_READ", "DELPHI_EXPLORATION_DB_STREAMS_READ", "DELPHI_EXPLORATION_DB_BRANDWATCH_READ", "DELPHI_EXPLORATION_DB_AE_READ", "DELPHI_EXPLORATION_DB_AD_DATA_SCHEMA_READ", "SME_ANALYTICS_UK_SMALL_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_UK_MEDIUM_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_UK_LARGE_WAREHOUSE_WAREHOUSE_ACCESS", "CRM_ECOMMERCE_DATA_DB_SHOPIFY_UK_NOTHING_BUT_THIEVES_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_SHOPIFY_UK_GEORGE_MICHAEL_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_SHOPIFY_UK_BRING_ME_THE_HORIZON_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_SHOPIFY_UK_LITTLE_MIX_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_SHOPIFY_UK_GEORGE_EZRA_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_SHOPIFY_UK_THE_SCRIPT_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_SHOPIFY_UK_MANIC_STREET_PREACHERS_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_SHOPIFY_UK_BAD_BOY_CHILLER_CREW_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_SHOPIFY_UK_JOY_CROOKES_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_SHOPIFY_UK_TOM_GRENNAN_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_SHOPIFY_UK_LONDON_GRAMMAR_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_SHOPIFY_UK_DECLAN_MCKENNA_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_SHOPIFY_UK_TEMS_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_SHOPIFY_UK_KOFFEE_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_SHOPIFY_UK_BAKAR_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_SHOPIFY_UK_BERWYN_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_SHOPIFY_UK_PRIMAL_SCREAM_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_SHOPIFY_UK_JUDAS_PRIEST_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_SHOPIFY_UK_SADE_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_SHOPIFY_UK_YOUNG_T_AND_BUGSEY_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_SHOPIFY_UK_JAKE_BUGG_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_SHOPIFY_UK_PINK_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_SHOPIFY_UK_PALOMA_FAITH_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_SHOPIFY_UK_HEADIE_ONE_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_SHOPIFY_UK_MINISTRY_OF_SOUND_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_SHOPIFY_UK_CALVIN_HARRIS_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_SHOPIFY_UK_LOVE_REGENERATOR_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_SHOPIFY_UK_REX_ORANGE_COUNTY_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_SHOPIFY_UK_JAMES_VINCENT_MCMORROW_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_SHOPIFY_UK_FREDO_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_SHOPIFY_UK_BLACK_BUTTER_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_SHOPIFY_UK_JAMES_ARTHUR_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_SHOPIFY_UK_LAST_CHRISTMAS_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_SHOPIFY_UK_LOL_SURPRISE_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_SHOPIFY_UK_BOB_DYLAN_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_SHOPIFY_UK_GEORGE_MICHAEL_US_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_SHOPIFY_UK_DECLAN_MCKENNA_EU_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_SHOPIFY_UK_THE_SCRIPT_EU_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_SHOPIFY_UK_KASABIAN_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_SHOPIFY_UK_SIGALA_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_SHOPIFY_UK_ARCADE_FIRE_2_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_SHOPIFY_UK_CAT_BURNS_2_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_SHOPIFY_UK_PIP_MILLETT_2_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_SHOPIFY_UK_HARRYS_HOUSE_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_SHOPIFY_UK_STEPS_2_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_SHOPIFY_UK_OZZY_OSBOURNE_2_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_SHOPIFY_UK_TATE_MCRAE_2_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_SHOPIFY_UK_FIRST_AID_KIT_2_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_SHOPIFY_UK_NOAH_CYRUS_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_SHOPIFY_UK_MIMI_WEBB_2_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_SHOPIFY_UK_SCOUTING_FOR_GIRLS_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_SHOPIFY_UK_WHAM_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_SHOPIFY_UK_MICHAEL_JACKSON_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_SHOPIFY_UK_DAFT_PUNK_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_SHOPIFY_UK_RUSS_MILLIONS_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_SHOPIFY_UK_GALEN_PAUL_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_SHOPIFY_UK_EVERYONE_YOU_KNOW_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_SHOPIFY_UK_PERRIE_EDWARDS_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_SHOPIFY_UK_JAKE_BUGG_2_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_SHOPIFY_UK_CENTRAL_CEE_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_SHOPIFY_UK_BRADLEY_SIMPSON_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_SHOPIFY_UK_LISA_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_SHOPIFY_UK_MYLES_SMITH_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_SHOPIFY_UK_QUEEN_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_SHOPIFY_UK_ADDISON_RAE_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_SHOPIFY_UK_DOJA_CAT_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_SHOPIFY_UK_TAME_IMPALA_SCHEMA_READ", "SME_FAN_EXPORT_STREAMLIT_ACCESS", "FANSIFTER_AD_REPORTING_VIEWS_ACCESS", "FANSIFTER_ARTIST_VIEWS_ACCESS", "FANSIFTER_EMAIL_VIEWS_ACCESS", ] granted_database_roles = [ "DELPHI_CRM_DATA.DB_RAW_SALESFORCE_SALES_CLOUD_SCHEMA_V_FORM_C_VIEW_READ", "DELPHI_CRM_DATA.DB_RAW_SALESFORCE_SALES_CLOUD_SCHEMA_V_MAILING_LIST_C_VIEW_READ", "DELPHI_CRM_DATA.DB_RAW_SALESFORCE_SALES_CLOUD_SCHEMA_V_SUBSCRIPTION_C_VIEW_READ", "DELPHI_CRM_DATA.DB_RAW_SALESFORCE_SALES_CLOUD_SCHEMA_V_FAN_C_VIEW_READ", "DELPHI_CRM_DATA.DB_RAW_SALESFORCE_SALES_CLOUD_SCHEMA_V_FORM_RESPONSE_C_VIEW_READ", "DELPHI_CRM_DATA.DB_RAW_SALESFORCE_SALES_CLOUD_SCHEMA_V_SUBSCRIPTION_HISTORY_C_VIEW_READ", "DELPHI_CRM_DATA.DB_RAW_SALESFORCE_SALES_CLOUD_SCHEMA_V_TLA_C_VIEW_READ", "DELPHI_CRM_DATA.DB_RAW_SALESFORCE_SALES_CLOUD_SCHEMA_V_ARTIST_C_VIEW_READ", "SME_ANALYTICS.DB_SHARED_SCHEMA_READWRITE", "SME_ANALYTICS.DB_CRM_UK_SCHEMA_READWRITE", "FANSIFTER_APP_REPORTING.DB_PROD_SCHEMA_FILEUPLOAD_STREAMLIT", "FANSIFTER_APP_REPORTING.DB_PROD_STREAMLIT_FAN_EXPORT_SCHEMA_FAN_DATA_EXPORT_STREAMLIT", "SMF_APP_REPORTING.DB_SMF_FAN_RESPONSES_SCHEMA_SMF_FAN_RESPONSES_UK_DYNAMIC_TABLE_READ", "SHOPIFY_STORES_GLOBAL.DB_SHOPIFY_GLOBAL_SCHEMA_VIEWS_SCHEMA_READ", ] }, { name = "SME_ANALYTICS_CRM_UK_COLUMBIA" granted_account_roles = [ "SME_ANALYTICS_UK", "FANSIFTER_AD_REPORTING_VIEWS_ACCESS", "FANSIFTER_ARTIST_VIEWS_ACCESS", "FANSIFTER_EMAIL_VIEWS_ACCESS", "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_CRM_UK_COLUMBIA_SCHEMA_READWRITE", ] }, { name = "SME_ANALYTICS_DENMARK" account_level_grants = [ "EXECUTE TASK", ] granted_account_roles = [ "ANALYST_BASELINE_ROLE", "DELPHI_EXPLORATION_DB_CHARTMETRIC_SCHEMA_READ", "DELPHI_EXPLORATION_DB_STREAMS_READ", "DELPHI_EXPLORATION_DB_BRANDWATCH_READ", "SME_ANALYTICS_DK_SMALL_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_DK_MEDIUM_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_DK_LARGE_WAREHOUSE_WAREHOUSE_ACCESS", # compute pool "SME_ANALYTICS_DENMARK_COMPUTE_POOL_COMPUTE_POOL_ACCESS", ] granted_database_roles = [ "DELPHI_EXPLORATION.DB_EXP_SCHEMA_V_LINKFIRE_RAW_DATA_VIEW_READ", "SME_ANALYTICS.DB_SHARED_SCHEMA_READWRITE", "SME_ANALYTICS.DB_DK_SCHEMA_READWRITE", ] }, { name = "SME_ANALYTICS_EPIC" granted_account_roles = [ "ANALYST_BASELINE_ROLE", "SME_ANALYTICS_EPIC_LARGE_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_EPIC_MEDIUM_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_EPIC_SMALL_WAREHOUSE_WAREHOUSE_ACCESS", "SME_DATA_INSIGHTS", ] granted_database_roles = [ "SME_ANALYTICS.DB_SHARED_SCHEMA_READWRITE", "SME_ANALYTICS.DB_EPIC_SCHEMA_READWRITE", ] }, { name = "SME_ANALYTICS_FINLAND" granted_account_roles = [ "DELPHI_EXPLORATION_DB_BRANDWATCH_READ", "DELPHI_EXPLORATION_DB_CHARTMETRIC_SCHEMA_READ", "DELPHI_EXPLORATION_DB_STREAMS_READ", "FANSIFTER_AD_REPORTING_VIEWS_ACCESS", "ANALYST_BASELINE_ROLE", "SME_ANALYTICS_FINLAND_COMPUTE_POOL_COMPUTE_POOL_ACCESS", "SME_ANALYTICS_FI_LARGE_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_FI_MEDIUM_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_FI_SMALL_WAREHOUSE_WAREHOUSE_ACCESS", "SME_DATA_INSIGHTS", ] granted_database_roles = [ "DELPHI_CRM_DATA.DB_RAW_SALESFORCE_SALES_CLOUD_SCHEMA_V_FORM_C_VIEW_READ", "DELPHI_CRM_DATA.DB_RAW_SALESFORCE_SALES_CLOUD_SCHEMA_V_MAILING_LIST_C_VIEW_READ", "DELPHI_CRM_DATA.DB_RAW_SALESFORCE_SALES_CLOUD_SCHEMA_V_SUBSCRIPTION_C_VIEW_READ", "DELPHI_CRM_DATA.DB_RAW_SALESFORCE_SALES_CLOUD_SCHEMA_V_FAN_C_VIEW_READ", "DELPHI_CRM_DATA.DB_RAW_SALESFORCE_SALES_CLOUD_SCHEMA_V_FORM_RESPONSE_C_VIEW_READ", "DELPHI_CRM_DATA.DB_RAW_SALESFORCE_SALES_CLOUD_SCHEMA_V_SUBSCRIPTION_HISTORY_C_VIEW_READ", "DELPHI_CRM_DATA.DB_RAW_SALESFORCE_SALES_CLOUD_SCHEMA_V_TLA_C_VIEW_READ", "DELPHI_CRM_DATA.DB_RAW_SALESFORCE_SALES_CLOUD_SCHEMA_V_ARTIST_C_VIEW_READ", "SME_ANALYTICS.DB_SHARED_SCHEMA_READWRITE", "SME_ANALYTICS.DB_FI_SCHEMA_READWRITE", ] }, { name = "SME_ANALYTICS_FRANCE" granted_account_roles = [ "DELPHI_EXPLORATION_DB_AD_DATA_SCHEMA_READ", "DELPHI_EXPLORATION_DB_BRANDWATCH_READ", "DELPHI_EXPLORATION_DB_CHARTMETRIC_SCHEMA_READ", "DELPHI_EXPLORATION_DB_STREAMS_READ", "FANSIFTER_AD_REPORTING_VIEWS_ACCESS", "ANALYST_BASELINE_ROLE", "SME_ANALYTICS_FRANCE_COMPUTE_POOL_COMPUTE_POOL_ACCESS", "SME_ANALYTICS_FR_LARGE_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_FR_MEDIUM_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_FR_SMALL_WAREHOUSE_WAREHOUSE_ACCESS", "SME_DATA_INSIGHTS", ] granted_database_roles = [ "DELPHI_CRM_DATA.DB_RAW_SALESFORCE_SALES_CLOUD_SCHEMA_V_FORM_C_VIEW_READ", "DELPHI_CRM_DATA.DB_RAW_SALESFORCE_SALES_CLOUD_SCHEMA_V_MAILING_LIST_C_VIEW_READ", "DELPHI_CRM_DATA.DB_RAW_SALESFORCE_SALES_CLOUD_SCHEMA_V_SUBSCRIPTION_C_VIEW_READ", "DELPHI_CRM_DATA.DB_RAW_SALESFORCE_SALES_CLOUD_SCHEMA_V_FAN_C_VIEW_READ", "DELPHI_CRM_DATA.DB_RAW_SALESFORCE_SALES_CLOUD_SCHEMA_V_FORM_RESPONSE_C_VIEW_READ", "DELPHI_CRM_DATA.DB_RAW_SALESFORCE_SALES_CLOUD_SCHEMA_V_SUBSCRIPTION_HISTORY_C_VIEW_READ", "DELPHI_CRM_DATA.DB_RAW_SALESFORCE_SALES_CLOUD_SCHEMA_V_TLA_C_VIEW_READ", "DELPHI_CRM_DATA.DB_RAW_SALESFORCE_SALES_CLOUD_SCHEMA_V_ARTIST_C_VIEW_READ", "SME_ANALYTICS.DB_SHARED_SCHEMA_READWRITE", "SME_ANALYTICS.DB_FR_SCHEMA_READWRITE", "SME_ANALYTICS_FRANCE.DB_READWRITE", "SME_ANALYTICS_FRANCE.DB_CREATE_SCHEMA", "DELPHI_EXPLORATION.DB_EXP_SCHEMA_V_LINKFIRE_RAW_DATA_VIEW_READ", ] }, { name = "SME_ANALYTICS_GERMANY" granted_account_roles = [ "SME_ANALYTICS_GSA", ] }, { name = "SME_ANALYTICS_GSA" account_level_grants = [ "EXECUTE TASK", ] granted_account_roles = [ "ANALYST_BASELINE_ROLE", "DELPHI_EXPLORATION_DB_AE_READ", "DELPHI_EXPLORATION_DB_CHARTMETRIC_SCHEMA_READ", "DELPHI_EXPLORATION_DB_STREAMS_READ", "DELPHI_EXPLORATION_DB_BRANDWATCH_READ", "DELPHI_EXPLORATION_DB_AD_DATA_SCHEMA_READ", "DELPHI_EXPLORATION_DB_LINKFIRE_SCHEMA_READ", "FANSIFTER_AD_REPORTING_VIEWS_ACCESS", "FANSIFTER_EMAIL_VIEWS_ACCESS", "SME_DATA_INSIGHTS", "SME_GERMANY_READ", "SME_ANALYTICS_GSA_SMALL_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_GSA_MEDIUM_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_GSA_LARGE_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_GSA_COMPUTE_POOL_COMPUTE_POOL_ACCESS", ] granted_database_roles = [ "DELPHI_EXPLORATION.DB_LINKFIRE_APPLE_MUSIC_SCHEMA_V_LINKFIRE_APPLE_MUSIC_ADD_DAILY_CH_VIEW_READ", "DELPHI_EXPLORATION.DB_LINKFIRE_APPLE_MUSIC_SCHEMA_V_LINKFIRE_APPLE_MUSIC_ADD_MONTHLY_CH_VIEW_READ", "DELPHI_EXPLORATION.DB_LINKFIRE_APPLE_MUSIC_SCHEMA_V_LINKFIRE_APPLE_MUSIC_ADD_WEEKLY_CH_VIEW_READ", "DELPHI_EXPLORATION.DB_LINKFIRE_APPLE_MUSIC_SCHEMA_V_LINKFIRE_APPLE_MUSIC_PLAY_DAILY_CH_VIEW_READ", "DELPHI_EXPLORATION.DB_LINKFIRE_APPLE_MUSIC_SCHEMA_V_LINKFIRE_APPLE_MUSIC_PLAY_MONTHLY_CH_VIEW_READ", "DELPHI_EXPLORATION.DB_LINKFIRE_APPLE_MUSIC_SCHEMA_V_LINKFIRE_APPLE_MUSIC_PLAY_WEEKLY_CH_VIEW_READ", "DELPHI_CRM_DATA.DB_RAW_SALESFORCE_SALES_CLOUD_SCHEMA_V_FORM_C_VIEW_READ", "DELPHI_CRM_DATA.DB_RAW_SALESFORCE_SALES_CLOUD_SCHEMA_V_MAILING_LIST_C_VIEW_READ", "DELPHI_CRM_DATA.DB_RAW_SALESFORCE_SALES_CLOUD_SCHEMA_V_SUBSCRIPTION_C_VIEW_READ", "DELPHI_CRM_DATA.DB_RAW_SALESFORCE_SALES_CLOUD_SCHEMA_V_FAN_C_VIEW_READ", "DELPHI_CRM_DATA.DB_RAW_SALESFORCE_SALES_CLOUD_SCHEMA_V_FORM_RESPONSE_C_VIEW_READ", "DELPHI_CRM_DATA.DB_RAW_SALESFORCE_SALES_CLOUD_SCHEMA_V_SUBSCRIPTION_HISTORY_C_VIEW_READ", "DELPHI_CRM_DATA.DB_RAW_SALESFORCE_SALES_CLOUD_SCHEMA_V_TLA_C_VIEW_READ", "DELPHI_CRM_DATA.DB_RAW_SALESFORCE_SALES_CLOUD_SCHEMA_V_ARTIST_C_VIEW_READ", "DELPHI_EXPLORATION.DB_EXP_SCHEMA_V_LINKFIRE_RAW_DATA_VIEW_READ", "DELPHI_EXPLORATION.DB_LINKFIRE_APPLE_MUSIC_SCHEMA_V_LINKFIRE_APPLE_MUSIC_PLAY_DAILY_GSA_VIEW_READ", "DELPHI_EXPLORATION.DB_LINKFIRE_APPLE_MUSIC_SCHEMA_V_LINKFIRE_APPLE_MUSIC_PLAY_WEEKLY_GSA_VIEW_READ", "DELPHI_EXPLORATION.DB_LINKFIRE_APPLE_MUSIC_SCHEMA_V_LINKFIRE_APPLE_MUSIC_PLAY_MONTHLY_GSA_VIEW_READ", "DELPHI_EXPLORATION.DB_LINKFIRE_APPLE_MUSIC_SCHEMA_V_LINKFIRE_APPLE_MUSIC_ADD_DAILY_GSA_VIEW_READ", "DELPHI_EXPLORATION.DB_LINKFIRE_APPLE_MUSIC_SCHEMA_V_LINKFIRE_APPLE_MUSIC_ADD_WEEKLY_GSA_VIEW_READ", "DELPHI_EXPLORATION.DB_LINKFIRE_APPLE_MUSIC_SCHEMA_V_LINKFIRE_APPLE_MUSIC_ADD_MONTHLY_GSA_VIEW_READ", "SME_ANALYTICS.DB_SHARED_SCHEMA_READWRITE", "SME_ANALYTICS.DB_GSA_SCHEMA_READWRITE", "SME_ANALYTICS.DB_CH_SCHEMA_READWRITE", "SME_ANALYTICS_GSA.DB_READWRITE", "SME_ANALYTICS_GSA.DB_CREATE_SCHEMA", "SMF_APP_REPORTING.DB_SMF_FAN_RESPONSES_SCHEMA_SMF_FAN_RESPONSES_GSA_DYNAMIC_TABLE_READ", ] }, { name = "SME_ANALYTICS_GSA_DEAL_CALCULATOR_STREAMLIT_VIEWER" comment = "Viewer role for streamlit app SME_ANALYTICS_GSA.DEAL_CALCULATOR" granted_database_roles = [ "SME_ANALYTICS_GSA.DB_DEAL_CALCULATOR_SCHEMA_STREAMLITS_READ", ] }, { name = "SME_ANALYTICS_GSA_DISCOGS_DASH_STREAMLIT_VIEWER" comment = "Viewer role for streamlit app SME_ANALYTICS_GSA.DISCOGS_DASH" granted_database_roles = [ "SME_ANALYTICS_GSA.DB_DISCOGS_DASH_SCHEMA_STREAMLITS_READ", ] }, { name = "SME_ANALYTICS_GSA_SPOTIFY_CAMPAIGN_EVALUATION_STREAMLIT_VIEWER" comment = "Viewer role for streamlit app SME_ANALYTICS_GSA.SPOTIFY_CAMPAIGN_EVALUATION" granted_database_roles = [ "SME_ANALYTICS_GSA.DB_SPOTIFY_CAMPAIGN_EVALUATION_SCHEMA_STREAMLITS_READ", ] }, { name = "SME_ANALYTICS_GSA_MARKETING_SPENDS_STREAMLIT_VIEWER" comment = "Viewer role for streamlit app SME_ANALYTICS_GSA.MARKETING_SPENDS" granted_database_roles = [ "SME_ANALYTICS_GSA.DB_MARKETING_SPENDS_SCHEMA_STREAMLITS_READ", ] }, { name = "SME_ANALYTICS_INDIA" granted_account_roles = [ "ANALYST_BASELINE_ROLE", "SME_ANALYTICS_IN_LARGE_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_IN_MEDIUM_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_IN_SMALL_WAREHOUSE_WAREHOUSE_ACCESS", "SME_DATA_INSIGHTS", ] granted_database_roles = [ "SME_ANALYTICS.DB_SHARED_SCHEMA_READWRITE", "SME_ANALYTICS.DB_INDIA_SCHEMA_READWRITE", "SME_ANALYTICS.DB_SEA_SCHEMA_READWRITE", ] }, { name = "SME_ANALYTICS_INDONESIA" granted_account_roles = [ "ANALYST_BASELINE_ROLE", "SME_ANALYTICS_ID_SMALL_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_ID_MEDIUM_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_ID_LARGE_WAREHOUSE_WAREHOUSE_ACCESS", ] granted_database_roles = [ "SME_ANALYTICS.DB_SHARED_SCHEMA_READWRITE", "SME_ANALYTICS.DB_ID_SCHEMA_READWRITE", "SME_ANALYTICS.DB_SEA_SCHEMA_READWRITE", ] }, { name = "SME_ANALYTICS_INSIGHTS_REPORTING" account_level_grants = [ "EXECUTE TASK", ] granted_account_roles = [ "DELPHI_EXPLORATION_DB_AE_READ", "DELPHI_EXPLORATION_DB_BRANDWATCH_READ", "DELPHI_EXPLORATION_DB_CHARTMETRIC_SCHEMA_READ", "DELPHI_EXPLORATION_DB_STREAMS_READ", "FANSIFTER_AD_REPORTING_VIEWS_ACCESS", "ANALYST_BASELINE_ROLE", "ORCHARD_FACTS", "SME_ANALYTICS_INSIGHTS_LARGE_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_INSIGHTS_MEDIUM_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_INSIGHTS_SMALL_WAREHOUSE_WAREHOUSE_ACCESS", "SME_DATA_INSIGHTS", # compute pool "SME_ANALYTICS_INSIGHTS_REPORTING_COMPUTE_POOL_COMPUTE_POOL_ACCESS", ] granted_database_roles = [ "SME_INSIGHTS_REPORTING.DB_PROD_SCHEMA_READWRITE", "SME_INSIGHTS_REPORTING.DB_SANDBOX_SCHEMA_READWRITE", "SME_ANALYTICS.DB_SHARED_SCHEMA_READWRITE", "SME_ANALYTICS.DB_INSIGHTS_SCHEMA_READWRITE", "SME_ANALYTICS.DB_AU_SCHEMA_READ", "SMF_APP_REPORTING.DB_SMF_FAN_RESPONSES_SCHEMA_SMF_FAN_RESPONSES_INSIGHTS_DYNAMIC_TABLE_READ", "FACTS.DB_PROD_SCHEMA_V_TIKTOK_BY_ISRC_COUNTRY_DAILY_VIEW_READ", ] }, { name = "SME_ANALYTICS_INT_MKTG" granted_account_roles = [ "CRM_ECOMMERCE_DATA_DB_CONSOLIDATION_DATA_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_SHOPIFY_AU_NZ_ADDISON_RAE_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_SHOPIFY_AU_NZ_DOJA_CAT_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_SHOPIFY_AU_NZ_RENEGADE_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_SHOPIFY_AU_NZ_TAME_IMPALA_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_SHOPIFY_COR_MEGAN_MORONEY_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_SHOPIFY_DE_RENEGADE_EU_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_SHOPIFY_UK_ADDISON_RAE_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_SHOPIFY_UK_DOJA_CAT_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_SHOPIFY_UK_RENEGADE_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_SHOPIFY_UK_TAME_IMPALA_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_SHOPIFY_US_ARISTA_DAMIANO_DAVID_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_SHOPIFY_US_COLUMBIA_ADDISON_RAE_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_SHOPIFY_US_COLUMBIA_DOMINIC_FIKE_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_SHOPIFY_US_COLUMBIA_JENNIE_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_SHOPIFY_US_COLUMBIA_MALCOLM_TODD_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_SHOPIFY_US_COLUMBIA_RENEGADE_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_SHOPIFY_US_COLUMBIA_TAME_IMPALA_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_SHOPIFY_US_COLUMBIA_THE_KID_LAROI_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_SHOPIFY_US_EPIC_GIVEON_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_SHOPIFY_US_EPIC_TYLA_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_SHOPIFY_US_RCA_DOJA_CAT_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_SHOPIFY_US_RCA_LIZZY_MCALPINE_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_SHOPIFY_US_RCA_SZA_SCHEMA_READ", "DELPHI_AE_REPORTING_DB_EXP_SCHEMA_READ", "DELPHI_EXPLORATION_DB_BRANDWATCH_READ", "DELPHI_EXPLORATION_DB_STREAMS_READ", "DELPHI_PUBLIC_DATA_MAIN_DB_CHARTS_SPOTIFY_SCHEMA_READ", "FANSIFTER_ARTIST_ROSTER_VIEWS_ACCESS", "FANSIFTER_MARKETING_ANALYST_BASE", "ANALYST_BASELINE_ROLE", "SME_ANALYTICS_INT_MKTG_LARGE_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_INT_MKTG_MEDIUM_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_INT_MKTG_SMALL_WAREHOUSE_WAREHOUSE_ACCESS", "SME_DATA_INSIGHTS", ] granted_database_roles = [ "DELPHI_PUBLIC_DATA_ETL.DB_CHARTS_SPOTIFY_SCHEMA_READ", "DELPHI_CRM_DATA.DB_RAW_SALESFORCE_SALES_CLOUD_SCHEMA_V_FORM_C_VIEW_READ", "DELPHI_CRM_DATA.DB_RAW_SALESFORCE_SALES_CLOUD_SCHEMA_V_MAILING_LIST_C_VIEW_READ", "DELPHI_CRM_DATA.DB_RAW_SALESFORCE_SALES_CLOUD_SCHEMA_V_SUBSCRIPTION_C_VIEW_READ", "DELPHI_CRM_DATA.DB_RAW_SALESFORCE_SALES_CLOUD_SCHEMA_V_FAN_C_VIEW_READ", "DELPHI_CRM_DATA.DB_RAW_SALESFORCE_SALES_CLOUD_SCHEMA_V_FORM_RESPONSE_C_VIEW_READ", "DELPHI_CRM_DATA.DB_RAW_SALESFORCE_SALES_CLOUD_SCHEMA_V_SUBSCRIPTION_HISTORY_C_VIEW_READ", "DELPHI_CRM_DATA.DB_RAW_SALESFORCE_SALES_CLOUD_SCHEMA_V_TLA_C_VIEW_READ", "DELPHI_CRM_DATA.DB_RAW_SALESFORCE_SALES_CLOUD_SCHEMA_V_ARTIST_C_VIEW_READ", "SME_ANALYTICS.DB_SHARED_SCHEMA_READWRITE", "SME_ANALYTICS.DB_INT_MKTG_SCHEMA_READWRITE", "FANSIFTER_APP_REPORTING.DB_PROD_SCHEMA_FILEUPLOAD_STREAMLIT" ] }, { name = "SME_ANALYTICS_ITALY" account_level_grants = [ "EXECUTE TASK", ] granted_account_roles = [ "ANALYST_BASELINE_ROLE", "DELPHI_EXPLORATION_DB_AD_DATA_SCHEMA_READ", "SME_ANALYTICS_IT_SMALL_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_IT_MEDIUM_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_IT_LARGE_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_ITALY_COMPUTE_POOL_COMPUTE_POOL_ACCESS", ] granted_database_roles = [ "SME_ANALYTICS.DB_SHARED_SCHEMA_READWRITE", "SME_ANALYTICS.DB_IT_SCHEMA_READWRITE", ] }, { name = "SME_ANALYTICS_LATINIBERIA" account_level_grants = [ "EXECUTE TASK", ] granted_account_roles = [ "DELPHI_EXPLORATION_DB_AE_READ", "DELPHI_EXPLORATION_DB_STREAMS_READ", "SME_ANALYTICS_LATINIBERIA_LARGE_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_LATINIBERIA_MEDIUM_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_LATINIBERIA_SMALL_WAREHOUSE_WAREHOUSE_ACCESS", "SME_DATA_INSIGHTS", "ANALYST_BASELINE_ROLE", "FANSIFTER_ARTIST_ROSTER_VIEWS_ACCESS", "FANSIFTER_AD_REPORTING_VIEWS_ACCESS", "FANSIFTER_EMAIL_VIEWS_ACCESS", # compute pool "SME_ANALYTICS_LATINIBERIA_COMPUTE_POOL_COMPUTE_POOL_ACCESS", ] granted_database_roles = [ "SME_ANALYTICS.DB_SHARED_SCHEMA_READWRITE", "SME_ANALYTICS.DB_LATINIBERIA_SCHEMA_READWRITE", "SME_ANALYTICS_LATINIBERIA.DB_CREATE_SCHEMA", "SME_ANALYTICS_LATINIBERIA.DB_READWRITE", "DELPHI_EXPLORATION.DB_EXP_SCHEMA_V_LINKFIRE_RAW_DATA_VIEW_READ", "SMF_APP_REPORTING.DB_SMF_FAN_RESPONSES_SCHEMA_SMF_FAN_RESPONSES_LATIN_US_DYNAMIC_TABLE_READ", "SONGWHIP_APP_REPORTING.DB_SONGWHIP_FAN_RESPONSES_SCHEMA_SONGWHIP_FAN_RESPONSES_LATIN_US_DYNAMIC_TABLE_READ", "SME_ANALYTICS.DB_AU_SCHEMA_STREAMLITS_READ", ] }, { name = "SME_ANALYTICS_LATINIBERIA_ENGINEERING" # This role is restricted. Need approval to assign users to this role. account_level_grants = [ "EXECUTE TASK", ] granted_account_roles = [ "ANALYST_BASELINE_ROLE", "SME_DATA_INSIGHTS", "SME_ANALYTICS_LATINIBERIA_ENGINEERING_COMPUTE_POOL_COMPUTE_POOL_ACCESS", "SME_ANALYTICS_LATINIBERIA_SMALL_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_LATINIBERIA_MEDIUM_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_LATINIBERIA_LARGE_WAREHOUSE_WAREHOUSE_ACCESS", ] granted_database_roles = [ "SME_ANALYTICS_LATINIBERIA.DB_READ", "SME_ANALYTICS_LATINIBERIA_ENGINEERING.DB_CREATE_SCHEMA", "SME_ANALYTICS_LATINIBERIA_ENGINEERING.DB_READWRITE", "SME_ANALYTICS.DB_SHARED_SCHEMA_READWRITE", ] }, { name = "SME_ANALYTICS_LEGACY" granted_account_roles = [ "EXPLORATION_WH_WAREHOUSE_ACCESS", ] granted_database_roles = [ "DELPHI_CRM_DATA.DB_RAW_SALESFORCE_SALES_CLOUD_SCHEMA_V_FORM_C_VIEW_READ", "DELPHI_CRM_DATA.DB_RAW_SALESFORCE_SALES_CLOUD_SCHEMA_V_MAILING_LIST_C_VIEW_READ", "DELPHI_CRM_DATA.DB_RAW_SALESFORCE_SALES_CLOUD_SCHEMA_V_SUBSCRIPTION_C_VIEW_READ", "DELPHI_CRM_DATA.DB_RAW_SALESFORCE_SALES_CLOUD_SCHEMA_V_FAN_C_VIEW_READ", "DELPHI_CRM_DATA.DB_RAW_SALESFORCE_SALES_CLOUD_SCHEMA_V_FORM_RESPONSE_C_VIEW_READ", "DELPHI_CRM_DATA.DB_RAW_SALESFORCE_SALES_CLOUD_SCHEMA_V_SUBSCRIPTION_HISTORY_C_VIEW_READ", "DELPHI_CRM_DATA.DB_RAW_SALESFORCE_SALES_CLOUD_SCHEMA_V_TLA_C_VIEW_READ", "DELPHI_CRM_DATA.DB_RAW_SALESFORCE_SALES_CLOUD_SCHEMA_V_ARTIST_C_VIEW_READ", ] }, { name = "SME_ANALYTICS_MASTERWORKS" granted_account_roles = [ "ANALYST_BASELINE_ROLE", "SME_ANALYTICS_MASTERWORKS_SMALL_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_MASTERWORKS_MEDIUM_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_MASTERWORKS_LARGE_WAREHOUSE_WAREHOUSE_ACCESS", # compute pool "SME_ANALYTICS_MASTERWORKS_COMPUTE_POOL_COMPUTE_POOL_ACCESS", ] granted_database_roles = [ "SME_ANALYTICS.DB_SHARED_SCHEMA_READWRITE", "SME_ANALYTICS.DB_MASTERWORKS_SCHEMA_READWRITE", ] }, { name = "SME_ANALYTICS_MEXICO" granted_account_roles = [ "ANALYST_BASELINE_ROLE", "SME_ANALYTICS_MX_LARGE_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_MX_MEDIUM_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_MX_SMALL_WAREHOUSE_WAREHOUSE_ACCESS", "SME_DATA_INSIGHTS", ] granted_database_roles = [ "SME_ANALYTICS.DB_SHARED_SCHEMA_READWRITE", "SME_ANALYTICS.DB_MX_SCHEMA_READWRITE", ] }, { name = "SME_ANALYTICS_NORWAY" granted_account_roles = [ "ANALYST_BASELINE_ROLE", "SME_ANALYTICS_NO_LARGE_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_NO_MEDIUM_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_NO_SMALL_WAREHOUSE_WAREHOUSE_ACCESS", "SME_DATA_INSIGHTS", ] granted_database_roles = [ "SME_ANALYTICS.DB_SHARED_SCHEMA_READWRITE", "SME_ANALYTICS.DB_NO_SCHEMA_READWRITE", ] }, { name = "SME_ANALYTICS_PHILIPPINES" granted_account_roles = [ "DELPHI_EXPLORATION_DB_CHARTMETRIC_SCHEMA_READ", "FANSIFTER_AD_REPORTING_VIEWS_ACCESS", "ANALYST_BASELINE_ROLE", "SME_ANALYTICS_PH_LARGE_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_PH_MEDIUM_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_PH_SMALL_WAREHOUSE_WAREHOUSE_ACCESS", "SME_DATA_INSIGHTS", ] granted_database_roles = [ "SME_ANALYTICS.DB_SHARED_SCHEMA_READWRITE", "SME_ANALYTICS.DB_PH_SCHEMA_READWRITE", "SME_ANALYTICS.DB_SEA_SCHEMA_READWRITE", ] }, { name = "SME_ANALYTICS_POLAND" granted_account_roles = [ "DELPHI_EXPLORATION_DB_CHARTMETRIC_SCHEMA_READ", "ANALYST_BASELINE_ROLE", "SME_ANALYTICS_PL_LARGE_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_PL_MEDIUM_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_PL_SMALL_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_POLAND_COMPUTE_POOL_COMPUTE_POOL_ACCESS", "SME_DATA_INSIGHTS", ] granted_database_roles = [ "SME_ANALYTICS.DB_SHARED_SCHEMA_READWRITE", "SME_ANALYTICS.DB_PL_SCHEMA_READWRITE", ] }, { name = "SME_ANALYTICS_RECORDSCO" granted_account_roles = [ "ANALYST_BASELINE_ROLE", "SME_ANALYTICS_RECORDSCO_SMALL_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_RECORDSCO_MEDIUM_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_RECORDSCO_LARGE_WAREHOUSE_WAREHOUSE_ACCESS", ] granted_database_roles = [ "SME_ANALYTICS.DB_SHARED_SCHEMA_READWRITE", "SME_ANALYTICS.DB_RECORDSCO_SCHEMA_READWRITE", ] }, { name = "SME_ANALYTICS_ROBOTS_HUMANS" granted_account_roles = [ "DELPHI_EXPLORATION_DB_STREAMS_READ", "DELPHI_EXPLORATION_DB_CHARTMETRIC_SCHEMA_READ", "ANALYST_BASELINE_ROLE", "SME_ANALYTICS_ROBOTS_HUMANS_SMALL_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_ROBOTS_HUMANS_MEDIUM_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_ROBOTS_HUMANS_LARGE_WAREHOUSE_WAREHOUSE_ACCESS", ] granted_database_roles = [ "SME_ANALYTICS.DB_SHARED_SCHEMA_READWRITE", "SME_ANALYTICS.DB_ROBOTS_HUMANS_SCHEMA_READWRITE", ] }, { name = "SME_ANALYTICS_SOMLIVRE" granted_account_roles = [ "ANALYST_BASELINE_ROLE", "SME_ANALYTICS_SOMLIVRE_LARGE_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_SOMLIVRE_MEDIUM_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_SOMLIVRE_SMALL_WAREHOUSE_WAREHOUSE_ACCESS", "SME_DATA_INSIGHTS", ] granted_database_roles = [ "SME_ANALYTICS.DB_SHARED_SCHEMA_READWRITE", "SME_ANALYTICS.DB_SOMLIVRE_SCHEMA_READWRITE", ] }, { name = "SME_ANALYTICS_SOUTH_AFRICA" granted_account_roles = [ "ANALYST_BASELINE_ROLE", "SME_ANALYTICS_SOUTH_AFRICA_SMALL_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_SOUTH_AFRICA_MEDIUM_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_SOUTH_AFRICA_LARGE_WAREHOUSE_WAREHOUSE_ACCESS", # compute pool "SME_ANALYTICS_SOUTH_AFRICA_COMPUTE_POOL_COMPUTE_POOL_ACCESS", ] granted_database_roles = [ "SME_ANALYTICS.DB_SHARED_SCHEMA_READWRITE", "SME_ANALYTICS.DB_SOUTH_AFRICA_SCHEMA_READWRITE", "SME_DATA_SCIENCE_AND_ANALYTICS.DB_PUBLIC_SCHEMA_READ", ] }, { name = "SME_ANALYTICS_SOUTH_KOREA" granted_account_roles = [ "ANALYST_BASELINE_ROLE", "SME_ANALYTICS_KR_SMALL_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_KR_MEDIUM_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_KR_LARGE_WAREHOUSE_WAREHOUSE_ACCESS", ] granted_database_roles = [ "SME_ANALYTICS.DB_SHARED_SCHEMA_READWRITE", "SME_ANALYTICS.DB_KR_SCHEMA_READWRITE", ] }, { name = "SME_ANALYTICS_SPAIN" granted_account_roles = [ "ANALYST_BASELINE_ROLE", "SME_ANALYTICS_ES_LARGE_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_ES_MEDIUM_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_ES_SMALL_WAREHOUSE_WAREHOUSE_ACCESS", "SME_DATA_INSIGHTS", # compute pool "SME_ANALYTICS_SPAIN_COMPUTE_POOL_COMPUTE_POOL_ACCESS", ] granted_database_roles = [ "SME_ANALYTICS.DB_SHARED_SCHEMA_READWRITE", "SME_ANALYTICS.DB_ES_SCHEMA_READWRITE", ] }, { name = "SME_ANALYTICS_STRATEGY_INVESTMENTS" granted_account_roles = [ "ANALYST_BASELINE_ROLE", "SME_ANALYTICS_STRATEGY_INVESTMENTS_COMPUTE_POOL_COMPUTE_POOL_ACCESS", "SME_ANALYTICS_STRATEGY_INVESTMENTS_LARGE_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_STRATEGY_INVESTMENTS_MEDIUM_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_STRATEGY_INVESTMENTS_SMALL_WAREHOUSE_WAREHOUSE_ACCESS", "SME_DATA_INSIGHTS", ] granted_database_roles = [ "SME_ANALYTICS.DB_SHARED_SCHEMA_READWRITE", "SME_ANALYTICS.DB_STRATEGY_INVESTMENTS_SCHEMA_READWRITE", ] }, { name = "SME_ANALYTICS_SWEDEN" granted_account_roles = [ "ANALYST_BASELINE_ROLE", "SME_ANALYTICS_SE_LARGE_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_SE_MEDIUM_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_SE_SMALL_WAREHOUSE_WAREHOUSE_ACCESS", "SME_DATA_INSIGHTS", # compute pool "SME_ANALYTICS_SWEDEN_COMPUTE_POOL_COMPUTE_POOL_ACCESS", ] granted_database_roles = [ "SME_ANALYTICS.DB_SHARED_SCHEMA_READWRITE", "SME_ANALYTICS.DB_SE_SCHEMA_READWRITE", ] }, { name = "SME_ANALYTICS_TAIWAN" granted_account_roles = [ "ANALYST_BASELINE_ROLE", "SME_ANALYTICS_TW_SMALL_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_TW_MEDIUM_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_TW_LARGE_WAREHOUSE_WAREHOUSE_ACCESS", ] granted_database_roles = [ "SME_ANALYTICS.DB_SHARED_SCHEMA_READWRITE", "SME_ANALYTICS.DB_TW_SCHEMA_READWRITE", ] }, { name = "SME_ANALYTICS_TURKEY" granted_account_roles = [ "ANALYST_BASELINE_ROLE", "SME_ANALYTICS_TR_SMALL_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_TR_MEDIUM_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_TR_LARGE_WAREHOUSE_WAREHOUSE_ACCESS", ] granted_database_roles = [ "SME_ANALYTICS.DB_SHARED_SCHEMA_READWRITE", "SME_ANALYTICS.DB_TR_SCHEMA_READWRITE", ] }, { name = "SME_ANALYTICS_UAE" granted_account_roles = [ "ANALYST_BASELINE_ROLE", "SME_ANALYTICS_AE_SMALL_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_AE_MEDIUM_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_AE_LARGE_WAREHOUSE_WAREHOUSE_ACCESS", ] granted_database_roles = [ "SME_ANALYTICS.DB_SHARED_SCHEMA_READWRITE", "SME_ANALYTICS.DB_AE_SCHEMA_READWRITE", ] }, { name = "SME_ANALYTICS_UK" granted_account_roles = [ "ANALYST_BASELINE_ROLE", "SME_ANALYTICS_UK_COMPUTE_POOL_COMPUTE_POOL_ACCESS", "SME_ANALYTICS_UK_LARGE_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_UK_MEDIUM_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_UK_SMALL_WAREHOUSE_WAREHOUSE_ACCESS", "SME_DATA_INSIGHTS", ] granted_database_roles = [ "SME_ANALYTICS.DB_SHARED_SCHEMA_READWRITE", "SME_ANALYTICS.DB_UK_SCHEMA_READWRITE", "SME_ANALYTICS.DB_AU_SCHEMA_STREAMLITS_READ", ] }, { name = "SME_ANALYTICS_US_COLUMBIA" granted_account_roles = [ "DELPHI_EXPLORATION_DB_CHARTMETRIC_SCHEMA_READ", "ANALYST_BASELINE_ROLE", "SME_ANALYTICS_US_COLUMBIA_LARGE_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_US_COLUMBIA_MEDIUM_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_US_COLUMBIA_SMALL_WAREHOUSE_WAREHOUSE_ACCESS", "SME_DATA_INSIGHTS", # compute pool "SME_ANALYTICS_US_COLUMBIA_COMPUTE_POOL_COMPUTE_POOL_ACCESS", ] granted_database_roles = [ "SME_ANALYTICS.DB_SHARED_SCHEMA_READWRITE", "SME_ANALYTICS.DB_US_COLUMBIA_SCHEMA_READWRITE", ] }, { name = "SME_ANALYTICS_US_NASHVILLE" account_level_grants = [ "EXECUTE TASK", ] granted_account_roles = [ "ANALYST_BASELINE_ROLE", "SME_ANALYTICS_US_NASHVILLE_LARGE_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_US_NASHVILLE_MEDIUM_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_US_NASHVILLE_SMALL_WAREHOUSE_WAREHOUSE_ACCESS", "SME_DATA_INSIGHTS", # compute pool "SME_ANALYTICS_US_NASHVILLE_COMPUTE_POOL_COMPUTE_POOL_ACCESS", ] granted_database_roles = [ "SME_ANALYTICS.DB_SHARED_SCHEMA_READWRITE", "SME_ANALYTICS.DB_US_NASHVILLE_SCHEMA_READWRITE", ] }, { name = "SME_ANALYTICS_US_RCA" account_level_grants = [ "EXECUTE TASK", ] granted_account_roles = [ "DELPHI_EXPLORATION_DB_AD_DATA_SCHEMA_READ", "DELPHI_EXPLORATION_DB_AE_READ", "DELPHI_EXPLORATION_DB_BRANDWATCH_READ", "DELPHI_EXPLORATION_DB_CHARTMETRIC_SCHEMA_READ", "DELPHI_EXPLORATION_DB_STREAMS_READ", "DELPHI_PUBLIC_DATA_MAIN_PLAYLISTS_READ", "ANALYST_BASELINE_ROLE", "SME_ANALYTICS_US_RCA_LARGE_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_US_RCA_MEDIUM_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_US_RCA_SMALL_WAREHOUSE_WAREHOUSE_ACCESS", "SME_DATA_INSIGHTS", # compute pool "SME_ANALYTICS_US_RCA_COMPUTE_POOL_COMPUTE_POOL_ACCESS", ] granted_database_roles = [ "FANSIFTER_APP_REPORTING.DB_PROD_SCHEMA_FANS_BY_ARTIST_ACCOUNT_VIEW_READ", "FANSIFTER_APP_REPORTING.DB_PROD_SCHEMA_FANS_BY_ARTIST_ACCOUNT_COUNTRY_VIEW_READ", "FANSIFTER_APP_REPORTING.DB_QA_SCHEMA_FANS_BY_ARTIST_ACCOUNT_VIEW_READ", "FANSIFTER_APP_REPORTING.DB_QA_SCHEMA_FANS_BY_ARTIST_ACCOUNT_COUNTRY_VIEW_READ", "SME_ANALYTICS.DB_SHARED_SCHEMA_READWRITE", "SME_ANALYTICS.DB_US_RCA_SCHEMA_READWRITE", "DELPHI_EXPLORATION.DB_EXP_SCHEMA_V_LINKFIRE_RAW_DATA_VIEW_READ", ] }, { name = "SME_ANALYTICS_US_REVENUE" granted_account_roles = [ "ANALYST_BASELINE_ROLE", "SME_ANALYTICS_US_REVENUE_LARGE_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_US_REVENUE_MEDIUM_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_US_REVENUE_SMALL_WAREHOUSE_WAREHOUSE_ACCESS", "SME_DATA_INSIGHTS", "PROD_DB_YTREPORTSAPI_SCHEMA_READ", ] granted_database_roles = [ "SME_ANALYTICS.DB_SHARED_SCHEMA_READWRITE", "SME_ANALYTICS.DB_US_REVENUE_SCHEMA_READWRITE", ] }, { name = "SME_ASIA_PARTNER_DEV" granted_account_roles = [ "ANALYST_BASELINE_ROLE", "SME_ASIA_PARTNER_DEV_SMALL_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ASIA_PARTNER_DEV_MEDIUM_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ASIA_PARTNER_DEV_LARGE_WAREHOUSE_WAREHOUSE_ACCESS", ] granted_database_roles = [ "SME_ANALYTICS.DB_SHARED_SCHEMA_READWRITE", "SME_ANALYTICS.DB_SME_ASIA_PARTNER_DEV_SCHEMA_READWRITE", ] }, { name = "SME_CONTENT_PROTECTION" comment = "SME_Content_Protection role" granted_database_roles = [ "ORCHARD_APP_REPORTING_V2.DB_PROD_OWS_ASSETS_OWS_ASSETS_SCHEMA_HIVE_SEGMENT_TABLE_READ", "ORCHARD_APP_REPORTING_V2.DB_PROD_OWS_ASSETS_OWS_ASSETS_SCHEMA_HIVE_TASK_TABLE_READ", "ORCHARD_APP_REPORTING_V2.DB_PROD_OWS_ASSETS_OWS_ASSETS_SCHEMA_ASSET_FINAL_TABLE_READ", "ORCHARD_APP_REPORTING_V2.DB_PROD_OWS_ASSETS_OWS_ASSETS_SCHEMA_ASSET_UPLOAD_TABLE_READ", "ORCHARD_APP_REPORTING_V2.DB_ART_RELATIONS_PROD_ART_RELATIONS_SCHEMA_SUBACCOUNT_TABLE_READ", "ORCHARD_APP_REPORTING_V2.DB_ART_RELATIONS_PROD_ART_RELATIONS_SCHEMA_TRACK_TABLE_READ", "ORCHARD_APP_REPORTING_V2.DB_ART_RELATIONS_PROD_ART_RELATIONS_SCHEMA_RELEASES_TABLE_READ", "ORCHARD_APP_REPORTING_V2.DB_ART_RELATIONS_PROD_ART_RELATIONS_SCHEMA_PROJECT_TABLE_READ", "ORCHARD_APP_REPORTING_V2.DB_ART_RELATIONS_PROD_ART_RELATIONS_SCHEMA_VENDOR_TABLE_READ", "SME_ANALYTICS.DB_BLA_SCHEMA_READWRITE", ] }, { name = "SME_DATA_INSIGHTS" granted_account_roles = [ "CHARTMETRIC_DB_RAW_DATA_SCHEMA_READ", ] 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_CURRENCY_TABLE_READ", "FACTS.DB_PROD_SCHEMA_DIM_DEVICE_TABLE_READ", "FACTS.DB_PROD_SCHEMA_DIM_FEED_TABLE_READ", "FACTS.DB_PROD_SCHEMA_DIM_FORMAT_TABLE_READ", "FACTS.DB_PROD_SCHEMA_DIM_GENRE_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_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_SUBACCOUNT_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_TRANSACTIONTYPE_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_VIEW_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_VIEW_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_VIEW_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_TIKTOK_VIEW_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", "FACTS.DB_PROD_SCHEMA_DIM_ARTIST_TABLE_READ", "FACTS.DB_PROD_SCHEMA_DIM_STORE_TABLE_READ", "FACTS.DB_PROD_SCHEMA_V_STREAMS_BY_TRACK_COUNTRY_FEED_DISTRIBUTOR_DAILY_VIEW_READ", "FACTS.DB_PROD_SCHEMA_DIM_CALENDAR_TABLE_READ", "FACTS.DB_PROD_SCHEMA_V_STREAMS_BY_PLAYLIST_COUNTRY_FEED_DISTRIBUTOR_DAILY_VIEW_READ", ] }, { name = "SME_DATA_SCIENCE_AND_ANALYTICS" account_level_grants = [ "EXECUTE TASK", ] granted_account_roles = [ "DELPHI_EXPLORATION_DB_AD_DATA_SCHEMA_READ", "DELPHI_EXPLORATION_DB_AE_READ", "DELPHI_EXPLORATION_DB_BRANDWATCH_READ", "DELPHI_EXPLORATION_DB_CHARTMETRIC_SCHEMA_READ", "DELPHI_EXPLORATION_DB_STREAMS_READ", "DELPHI_PUBLIC_DATA_MAIN_DB_CHARTS_APPLE_SCHEMA_READ", "DELPHI_PUBLIC_DATA_MAIN_DB_CHARTS_SPOTIFY_SCHEMA_READ", "DELPHI_PUBLIC_DATA_MAIN_DB_PLAYLISTS_SCHEMA_READ", "DS_CHARTMETRIC_DB_READ", "FANSIFTER_AD_REPORTING_VIEWS_ACCESS", "ANALYST_BASELINE_ROLE", "PROD_SIGMA_DB_READ_WRITE", "SME_ANALYTICS_DATA_SCIENCE_LARGE_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_DATA_SCIENCE_MEDIUM_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_DATA_SCIENCE_SMALL_WAREHOUSE_WAREHOUSE_ACCESS", "SME_DATA_INSIGHTS", "SME_DATA_SCIENCE_AND_ANALYTICS_COMPUTE_POOL_COMPUTE_POOL_ACCESS", ] granted_database_roles = [ "SME_DATA_SCIENCE_AND_ANALYTICS.DB_CREATE_SCHEMA", "SME_DATA_SCIENCE_AND_ANALYTICS.DB_READWRITE", "SME_ANALYTICS.DB_SHARED_SCHEMA_READWRITE", "SME_ANALYTICS.DB_DATA_SCIENCE_SCHEMA_READWRITE", "SME_DATA_SCIENCE_AND_ANALYTICS.DB_QA_SCHEMA_READWRITE", "SME_DATA_SCIENCE_AND_ANALYTICS.DB_PROD_SCHEMA_READWRITE", "DELPHI_EXPLORATION.DB_EXP_SCHEMA_V_LINKFIRE_RAW_DATA_VIEW_READ", "FRAUD_REPORTING.DB_READ", "BEATDAPP.DB_PROD_SCHEMA_READ", ] }, { name = "SME_DATA_SCIENCE_AND_ANALYTICS_FIRST_35_ACCESS" granted_database_roles = [ "SME_DATA_SCIENCE_AND_ANALYTICS.DB_FIRST_35_SCHEMA_READ", ] }, { name = "SME_DIGITAL_OPS" granted_account_roles = [ "ANALYST_BASELINE_ROLE", "SME_DATA_INSIGHTS", "SME_DIGITAL_OPS_LARGE_WAREHOUSE_WAREHOUSE_ACCESS", "SME_DIGITAL_OPS_MEDIUM_WAREHOUSE_WAREHOUSE_ACCESS", "SME_DIGITAL_OPS_SMALL_WAREHOUSE_WAREHOUSE_ACCESS", ] granted_database_roles = [ "SME_ANALYTICS.DB_SHARED_SCHEMA_READWRITE", "SME_ANALYTICS.DB_SME_DIGITAL_OPS_SCHEMA_READWRITE", ] }, { name = "SME_FAN_EXPORT_STREAMLIT_ACCESS" granted_database_roles = [ "FANSIFTER_APP_REPORTING.DB_PROD_STREAMLIT_FAN_EXPORT_SCHEMA_FAN_DATA_EXPORT_STREAMLIT", ] }, { name = "SME_GDB_BUSINESS_DEVELOPMENT" granted_account_roles = [ "ANALYST_BASELINE_ROLE", "SME_GDB_BUSINESS_DEVELOPMENT_SMALL_WAREHOUSE_WAREHOUSE_ACCESS", "SME_GDB_BUSINESS_DEVELOPMENT_MEDIUM_WAREHOUSE_WAREHOUSE_ACCESS", "SME_GDB_BUSINESS_DEVELOPMENT_LARGE_WAREHOUSE_WAREHOUSE_ACCESS", ] granted_database_roles = [ "SME_ANALYTICS.DB_SHARED_SCHEMA_READWRITE", "SME_ANALYTICS.DB_GDB_BUSINESS_DEVELOPMENT_SCHEMA_READWRITE", "FRAUD_REPORTING.DB_READ", "BEATDAPP.DB_PROD_SCHEMA_READ", ] }, { name = "SME_GERMANY_READ" comment = "Read-only access for Sony Germany Team" granted_database_roles = [ "DELPHI_EXPLORATION.DB_LINKFIRE_APPLE_MUSIC_SCHEMA_V_LINKFIRE_APPLE_MUSIC_PLAY_DAILY_GSA_VIEW_READ", "DELPHI_EXPLORATION.DB_LINKFIRE_APPLE_MUSIC_SCHEMA_V_LINKFIRE_APPLE_MUSIC_PLAY_WEEKLY_GSA_VIEW_READ", "DELPHI_EXPLORATION.DB_LINKFIRE_APPLE_MUSIC_SCHEMA_V_LINKFIRE_APPLE_MUSIC_PLAY_MONTHLY_GSA_VIEW_READ", "DELPHI_EXPLORATION.DB_LINKFIRE_APPLE_MUSIC_SCHEMA_V_LINKFIRE_APPLE_MUSIC_ADD_DAILY_GSA_VIEW_READ", "DELPHI_EXPLORATION.DB_LINKFIRE_APPLE_MUSIC_SCHEMA_V_LINKFIRE_APPLE_MUSIC_ADD_WEEKLY_GSA_VIEW_READ", "DELPHI_EXPLORATION.DB_LINKFIRE_APPLE_MUSIC_SCHEMA_V_LINKFIRE_APPLE_MUSIC_ADD_MONTHLY_GSA_VIEW_READ", ] }, { name = "SME_GERMANY_WRITE" comment = "Write access for Fivetran connectors (Sony Germany Team)" }, { name = "SME_GLOBAL_TECH" granted_account_roles = [ "ANALYST_BASELINE_ROLE", "SME_DATA_INSIGHTS", "SME_GLOBAL_TECH_LARGE_WAREHOUSE_WAREHOUSE_ACCESS", "SME_GLOBAL_TECH_MEDIUM_WAREHOUSE_WAREHOUSE_ACCESS", "SME_GLOBAL_TECH_SMALL_WAREHOUSE_WAREHOUSE_ACCESS", ] granted_database_roles = [ "SME_ANALYTICS.DB_SHARED_SCHEMA_READWRITE", "SME_ANALYTICS.DB_GLOBAL_TECH_SCHEMA_READWRITE", ] }, { name = "SME_MERCH_STREAMLIT_ACCESS" granted_account_roles = [ "PROD_ETL_WH_WAREHOUSE_ACCESS", ] granted_database_roles = [ "FANSIFTER_APP_REPORTING.DB_PROD_STREAMLIT_SME_MERCH_SCHEMA_SME_MERCH_STREAMLIT", ] }, { name = "SME_PROD_DIM_TABLE_READ" comment = "SME role for DIM Tables Read" granted_database_roles = [ "FACTS.DB_PROD_SCHEMA_DIM_GENRE_TABLE_READ", ] }, { name = "SME_REPERTOIRE_MANAGEMENT" granted_account_roles = [ "ANALYST_BASELINE_ROLE", "SME_DATA_INSIGHTS", "SME_REPERTOIRE_MANAGEMENT_LARGE_WAREHOUSE_WAREHOUSE_ACCESS", "SME_REPERTOIRE_MANAGEMENT_MEDIUM_WAREHOUSE_WAREHOUSE_ACCESS", "SME_REPERTOIRE_MANAGEMENT_SMALL_WAREHOUSE_WAREHOUSE_ACCESS", ] granted_database_roles = [ "SME_ANALYTICS.DB_SHARED_SCHEMA_READWRITE", "SME_ANALYTICS.DB_SME_REPERTOIRE_MANAGEMENT_SCHEMA_READWRITE", ] }, { name = "SME_SNOWFLAKE_DEV" granted_account_roles = [ "FACTS_DB_READ_ONLY", "PROD_DB_READ_ONLY", "SME_DEV_WAREHOUSE_WAREHOUSE_ACCESS", ] }, { name = "SME_SUPPLYCHAIN_SANDBOX" granted_database_roles = [ "SME_SUPPLYCHAIN_SANDBOX.DB_READWRITE", ] }, { name = "SNOWFLAKE_DOCUMENTATION_SHARE_READ" comment = "SNOWFLAKE_DOCUMENTATION data share" }, { 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 = "SNOWFLAKE_ROLE" owner = "SECURITYADMIN" }, { name = "SNOWFLAKE_SUPPORT" granted_account_roles = [ "PROD_VAPI", ] }, { name = "SNOWFLAKE_TEAM" granted_account_roles = [ "DEV_ENGINEERING", "DEV_OWS_WH_WAREHOUSE_ACCESS", "EXPLORATION_USER", "LUMINATE_SHARE_READ", "PROD_INSIGHTS_PLAYLISTS_WAREHOUSE_WAREHOUSE_ACCESS", ] granted_database_roles = [ "SME_ANALYTICS.DB_READ", "USAGE_MONITORING.DB_USAGE_SCHEMA_READWRITE", ] }, { name = "SONY_INTEGRATIONS_ADMIN" granted_account_roles = [ "DEV_OWS_WAREHOUSE_WAREHOUSE_ACCESS", "DEV_PERFORMANCE_WAREHOUSE_WAREHOUSE_ACCESS", ] granted_database_roles = [ "GRPS_APP_REPORTING_NOCONF.DB_GRPS_DDEX001_SCHEMA_READ", ] }, { name = "SONY_INTERNAL_DEV" granted_account_roles = [ "SONY_INTERNAL_WH_WAREHOUSE_ACCESS", "SONYINTERNAL_DB_DEV_SCHEMA_READWRITE", ] granted_database_roles = [ "GRPS_APP_REPORTING_NOCONF.DB_GRPS_DRAS002_SCHEMA_READ", ] }, { name = "SONY_INTERNAL_PROD" granted_account_roles = [ "PRICING_DB_PROD_SCHEMA_READ", "SONYINTERNAL_DB_PROD_SCHEMA_READ", "SONYINTERNAL_DB_PROD_SCHEMA_READWRITE", "SONY_INTERNAL_WH_WAREHOUSE_ACCESS", ] 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", "SONY_INTERNAL.DB_PROD_SCHEMA_READWRITE", "GRPS_APP_REPORTING_NOCONF.DB_GRPS_DRAS002_SCHEMA_READ", ] }, { name = "SONY_INTERNAL_QA" granted_account_roles = [ "SONYINTERNAL_DB_QA_SCHEMA_READ", "SONYINTERNAL_DB_QA_SCHEMA_READWRITE", "SONY_INTERNAL_WH_WAREHOUSE_ACCESS", ] 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", "SONY_INTERNAL.DB_QA_SCHEMA_READWRITE", "GRPS_APP_REPORTING_NOCONF.DB_GRPS_DRAS002_SCHEMA_READ", ] }, { name = "SONY_MUSIC_PUBLISHING_ANALYST" granted_account_roles = [ "SONY_MUSIC_PUBLISHING_ANALYST_WH_WAREHOUSE_ACCESS", ] granted_database_roles = [ "DELPHI_EXPLORATION.DB_CHARTMETRIC_SCHEMA_V_ACR_CHANNEL_VIEW_READ", "DELPHI_EXPLORATION.DB_CHARTMETRIC_SCHEMA_V_ACR_TRACK_VIEW_READ", "DELPHI_EXPLORATION.DB_CHARTMETRIC_SCHEMA_V_ACR_TRACK_STAT_VIEW_READ", "DELPHI_EXPLORATION.DB_CHARTMETRIC_SCHEMA_READ", ] }, { name = "SONY_PUBLISHING_ROLE" comment = "The role for Sony Publishing Team data access" }, { name = "SWF_DELPHI_ADS_DATA" granted_account_roles = [ "ADS_DATA_PROD_WH_WAREHOUSE_ACCESS", "FIVETRAN_PROD_ROLE", ] granted_database_roles = [ "DELPHI_ADS_DATA.DB_RAW_SPOTIFY_MARQUEE_SCHEMA_READWRITE", ] }, { name = "TADAS_DEV_READWRITE" granted_account_roles = [ "DEV_ENGINEERING", "DEV_OWS_WAREHOUSE_WAREHOUSE_ACCESS", ] granted_database_roles = [ "TADAS.DB_DEV_SCHEMA_READWRITE", ] }, { name = "TEAM_BA_ROLE" granted_account_roles = [ "APP_ENABLEMENT_READER", "CHARTMETRIC_USER", "CRM_ADMIN_USER", "DELPHI_EXPLORATION_DB_READWRITE", "DELPHI_AE_REPORTING_DB_READWRITE", "EXPLORATION_ADV_USER", "EXPLORATION_AD_PLUS", "EXPLORATION_SYS_USER", "FIVETRAN_PROD_ROLE", "L2SUPPORT", "TEAM_DEV_BA_WH_WAREHOUSE_ACCESS", "TEAM_QA_WH_WAREHOUSE_ACCESS", "CRM_FANRESPONSE_WH_WAREHOUSE_ACCESS", ] }, { name = "TECH_INTEGRATIONS_ADMIN" granted_account_roles = [ "DEV_OWS_WAREHOUSE_WAREHOUSE_ACCESS", "SONY_INTERNAL_WH_WAREHOUSE_ACCESS", ] granted_database_roles = [ "SONY_INTERNAL.DB_READ", "SONY_INTERNAL.DB_DEV_SCHEMA_READWRITE", "SONY_INTERNAL.DB_QA_SCHEMA_READWRITE", "SONY_INTERNAL.DB_PROD_SCHEMA_READWRITE", "INTEGRATION.INTEGRATION_DB_READ_WRITE", "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", "GRPS_APP_REPORTING_NOCONF.DB_GRPS_DRAS002_SCHEMA_READ", "VIRTUALSALESREP.DB_DEV_SCHEMA_READWRITE", "VIRTUALSALESREP.DB_QA_SCHEMA_READWRITE", "VIRTUALSALESREP.DB_PROD_SCHEMA_READWRITE", ] }, { name = "TEMP_STATEMENTDB_SERVICE_ROLE" granted_account_roles = [ "TEMP_STATEMENTDB_WAREHOUSE_WAREHOUSE_ACCESS", ] granted_database_roles = [ "TEMP_STATEMENTDB.DB_READWRITE", ] }, { 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 = "UAT_LAMBDA_ROYALTY_ACCOUNTING" granted_account_roles = [ "ROYALTYACCOUNTING_DB_UAT_SCHEMA_READWRITE", "UAT_ABACUS_WH_WAREHOUSE_ACCESS", "ROYALTY_ACCOUNTING_REPORTING_DB_UAT_SCHEMA_READWRITE", ] 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 = "UAT_PAYMENT_SEARCH_ROLE" comment = "Role with access only to UAT PAYMENT_DATA_SEARCH Cortex Search Service" granted_account_roles = [ "ROYALTYACCOUNTING_DB_UAT_SCHEMA_READ", "UAT_CORTEX_SEARCH_WAREHOUSE_WAREHOUSE_ACCESS", ] }, { name = "UAT_ROYALTY_ACCOUNTING_REFRESH" granted_account_roles = [ "ROYALTYACCOUNTING_DB_PROD_SCHEMA_READ", "ROYALTYACCOUNTING_DB_UAT_SCHEMA_READWRITE", ] }, { name = "YOUTUBE_REPORTING" granted_account_roles = [ "ACCOUNT_REPORTING_READONLY", "PROD_DB_READ_ONLY", ] }, { name = "SME_ANALYTICS_US_PROVIDENT" granted_account_roles = [ "ANALYST_BASELINE_ROLE", "SME_ANALYTICS_US_PROVIDENT_SMALL_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_US_PROVIDENT_MEDIUM_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_US_PROVIDENT_LARGE_WAREHOUSE_WAREHOUSE_ACCESS", ] granted_database_roles = [ "SME_ANALYTICS.DB_SHARED_SCHEMA_READWRITE", "SME_ANALYTICS.DB_US_PROVIDENT_SCHEMA_READWRITE", ] }, { name = "REVENUE_FILE_INGESTION_DB_DEPLOYMENT_ROLE" granted_account_roles = [ "DEPLOY_WAREHOUSE_WAREHOUSE_ACCESS", ] granted_database_roles = [ "REVENUE_FILE_INGESTION.DB_PROD_SCHEMA_READWRITE", "REVENUE_FILE_INGESTION.DB_QA_SCHEMA_READWRITE", ] }, { name = "SALES_PROCESSING_DB_DEPLOYMENT_ROLE" granted_account_roles = [ "DEPLOY_WAREHOUSE_WAREHOUSE_ACCESS", ] #### TODO(https://theorchard.atlassian.net/browse/SSC-8): TEMPORARY - Remove DEV_ENGINEERING.DB_READ access once Abacus provides real SAP profit center data #### This grant allows reading fake test data from dev_engineering.rvstiphout.irl_sap_profit_centers #### Expected removal date: mid August once Abacus has IRL data available granted_database_roles = [ "SALES_PROCESSING.DB_PROD_SCHEMA_READWRITE", "SALES_PROCESSING.DB_QA_SCHEMA_READWRITE", "DEV_ENGINEERING.DB_READ", ] }, { name = "QA_ETL_META_DAILY_ROLE" granted_account_roles = [ "QA_ETL_WH_WAREHOUSE_ACCESS", ] granted_database_roles = [ "QA_CONSUMER_REPORTING.DB_META_SCHEMA_READWRITE", "FACTS.DB_QA_SCHEMA_READWRITE", ] }, { name = "PROD_ETL_META_DAILY_ROLE" granted_account_roles = [ "PROD_ETL_WH_WAREHOUSE_ACCESS", ] granted_database_roles = [ "CONSUMER_REPORTING.DB_META_SCHEMA_READWRITE", "FACTS.DB_PROD_SCHEMA_READWRITE", ] }, { name = "LORELAI_AGENT_DB_DEPLOYMENT_ROLE" account_level_grants = [ "EXECUTE TASK", ] granted_account_roles = [ "DEPLOY_WAREHOUSE_WAREHOUSE_ACCESS", "DEV_PERFORMANCE_WAREHOUSE_WAREHOUSE_ACCESS", "CHARTMETRIC_DB_RAW_DATA_SCHEMA_READ", ] granted_database_roles = [ "LORELAI_AGENT.DB_READWRITE", "ORCHARD_APP_REPORTING_V2.DB_READ", "DEV_ENGINEERING.DB_READ", "FACTS.DB_PROD_SCHEMA_READ", ] }, { name = "CONSUMER_REPORTING_DB_DEPLOYMENT_ROLE" granted_account_roles = [ "DEPLOY_WAREHOUSE_WAREHOUSE_ACCESS", "FACTS_DB_PROD_SCHEMA_READ", "FACTS_DB_QA_SCHEMA_READ", ] granted_database_roles = [ "CONSUMER_REPORTING.DB_READWRITE", "QA_CONSUMER_REPORTING.DB_READWRITE", ] }, { name = "CONFLICT_REPORTING_DB_DEPLOYMENT_ROLE" granted_account_roles = [ "DEPLOY_WAREHOUSE_WAREHOUSE_ACCESS", ] granted_database_roles = [ "CONFLICT_REPORTING.DB_READWRITE", "QA_CONFLICT_REPORTING.DB_READWRITE", ] }, { name = "BUSINESS_SOLUTIONS_READONLY" granted_account_roles = [ "DEV_ENGINEERING", ] granted_database_roles = [ "BUSINESS_SOLUTIONS.DB_READ", ] }, { name = "BUSINESS_SOLUTIONS_READWRITE" granted_database_roles = [ "BUSINESS_SOLUTIONS.DB_READWRITE", "BUSINESS_SOLUTIONS.DB_CREATE_SCHEMA", "GRPS_APP_REPORTING_NOCONF.DB_GRPS_DRPS001_SCHEMA_READ", ] }, { name = "INVOKE_HIVE_AI_DETECTION" granted_account_roles = [ "QA_OWS_WAREHOUSE_WAREHOUSE_ACCESS", "PROD_OWS_WAREHOUSE_WAREHOUSE_ACCESS", ] granted_database_roles = [ "ORCHARD_APP_REPORTING_V2.DB_ART_RELATIONS_PROD_ART_RELATIONS_SCHEMA_READ", "ORCHARD_APP_REPORTING_V2.DB_PROD_OWS_ASSETS_OWS_ASSETS_SCHEMA_ASSET_FINAL_TABLE_READ", "ORCHARD_APP_REPORTING_V2.DB_PROD_OWS_ASSETS_OWS_ASSETS_SCHEMA_ASSET_UPLOAD_TABLE_READ", "ORCHARD_APP_REPORTING_V2.DB_PROD_OWS_ASSETS_OWS_ASSETS_SCHEMA_HIVE_TASK_TABLE_READ", "ORCHARD_APP_REPORTING_V2.DB_PROD_OWS_ASSETS_OWS_ASSETS_SCHEMA_HIVE_SEGMENT_TABLE_READ", ] }, { name = "LATINIBERIA_FORESIGN_ROLE" granted_account_roles = [ "LUMINATE_SHARE_READ", "SME_ANALYTICS_LATINIBERIA_LARGE_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_LATINIBERIA_MEDIUM_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_LATINIBERIA_SMALL_WAREHOUSE_WAREHOUSE_ACCESS", ] }, { name = "SME_ANALYTICS_FRANCE_CAMPAIGNS_STREAMLIT_VIEWER" granted_account_roles = [ "SME_ANALYTICS_FR_SMALL_WAREHOUSE_WAREHOUSE_ACCESS", ] granted_database_roles = [ "SME_ANALYTICS_FRANCE.DB_CAMPAIGNS_ST_SCHEMA_READ", "SME_ANALYTICS_FRANCE.DB_CAMPAIGNS_ST_SCHEMA_STREAMLITS_READ", ] }, { name = "SME_ANALYTICS_EPIC_STREAMLIT_VIEWER" comment = "Viewer role for streamlit apps on schema SME_ANALYTICS.EPIC" granted_database_roles = [ "SME_ANALYTICS.DB_EPIC_SCHEMA_STREAMLITS_READ", ] }, { name = "SDC_REPORTING_DB_LINKFIRE" comment = "role for service user to extract data from snowflake to RDB" granted_account_roles = [ "SME_ANALYTICS_REPORTING_DB_SMALL_WAREHOUSE_WAREHOUSE_ACCESS", ] granted_database_roles = [ "DELPHI_EXPLORATION.DB_EXP_SCHEMA_LINKFIRE_RAW_DATA_TABLE_READ", "REPORTING_DB_SYNC.DB_LINKFIRE_SCHEMA_READWRITE", ] }, { name = "JIRA_FIVETRAN_ROLE" granted_account_roles = [ "PROD_FIVETRAN_WAREHOUSE_WAREHOUSE_ACCESS", ] granted_database_roles = [ "JIRA.DB_READWRITE", ] }, { name = "DATA_PLATFORM" account_level_grants = [ "EXECUTE TASK", ] granted_account_roles = [ "ALL_WAREHOUSE_MONITOR", "ALL_COMPUTE_POOL_MONITOR", "ALL_DB_READ", "ALL_STREAMLIT_USAGE", "DEV_ENGINEERING", ] }, { name = "ALL_WAREHOUSE_MONITOR" comment = "MONITOR privileges for all warehouses" }, { name = "ALL_COMPUTE_POOL_MONITOR" comment = "MONITOR privileges for all compute pools" }, { name = "ALL_DB_READ" comment = "Database read privilege for all databases" }, { name = "ALL_STREAMLIT_USAGE" comment = "Streamlit usage privilege for all databases" }, { name = "SWF_ANALYTICS_INGEST_DATA_BACKLOAD_EXEC_ROLE" comment = "Swf analytics ingest data backload exec role" granted_database_roles = [ "FACTS.DB_PROD_SCHEMA_BACKLOAD_TASKS_TABLE_READWRITE", "FACTS.DB_QA_SCHEMA_BACKLOAD_TASKS_TABLE_READWRITE", ] }, { name = "REVENUE_FILE_INGESTION_FIVETRAN_ROLE" granted_account_roles = [ "REVENUE_FILE_INGESTION_FIVETRAN_WH_WAREHOUSE_ACCESS", ] granted_database_roles = [ "REVENUE_FILE_INGESTION.DB_READWRITE", ] }, { name = "PDEGO_AOMA_REPORTING" comment = "PDEGO Role for AOMA_REPORTING Database" granted_database_roles = [ "AOMA_REPORTING.DB_READ", ] }, { name = "QA_REPORTING_DB_MARKETSHARE_ROLE" granted_account_roles = [ "SME_ANALYTICS_REPORTING_DB_MEDIUM_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_REPORTING_DB_SMALL_WAREHOUSE_WAREHOUSE_ACCESS", ] granted_database_roles = [ "QA_MARKETSHARE_REPORTING.DB_SPOTIFY_SCHEMA_READWRITE", "QA_MARKETSHARE_REPORTING.DB_YOUTUBE_SCHEMA_READWRITE", "QA_MARKETSHARE_REPORTING.DB_APPLE_SCHEMA_READWRITE", "QA_MARKETSHARE_REPORTING.DB_AMAZON_SCHEMA_READWRITE", ] }, { name = "PROD_REPORTING_DB_MARKETSHARE_ROLE" granted_account_roles = [ "SME_ANALYTICS_REPORTING_DB_MEDIUM_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_REPORTING_DB_SMALL_WAREHOUSE_WAREHOUSE_ACCESS", ] granted_database_roles = [ "MARKETSHARE_REPORTING.DB_SPOTIFY_SCHEMA_READWRITE", "MARKETSHARE_REPORTING.DB_YOUTUBE_SCHEMA_READWRITE", "MARKETSHARE_REPORTING.DB_APPLE_SCHEMA_READWRITE", "MARKETSHARE_REPORTING.DB_AMAZON_SCHEMA_READWRITE", ] }, { name = "SME_ANALYTICS_FRANCE_PHYSICAL_ST_STREAMLITS_VIEWER" granted_database_roles = [ "SME_ANALYTICS_FRANCE.DB_PHYSICAL_ST_SCHEMA_STREAMLITS_READ", ] }, { name = "PARTNER_DEV_POC" granted_account_roles = [ "ANALYST_BASELINE_ROLE", "SME_DATA_INSIGHTS", ] granted_database_roles = [ "MARKETSHARE_REPORTING.DB_SPOTIFY_SCHEMA_READ", "MARKETSHARE_REPORTING.DB_APPLE_SCHEMA_READ", "MARKETSHARE_REPORTING.DB_YOUTUBE_SCHEMA_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_AMAZON_MARKET_SHARE_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_AMAZON_MARKET_SHARE_V2_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_AMAZON_UNLIMITED_MARKET_SHARE_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_ITUNES_MARKET_SHARE_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_SPOTIFY_MARKET_SHARE_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_SPOTIFY_MARKET_SHARE_V2_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_SPOTIFY_MARKET_SHARE_WEEK_ENDING_TABLE_READ", "FACTS.DB_PROD_SCHEMA_STAGING_RAW_YOUTUBE_RED_MARKET_SHARE_TABLE_READ", ] }, { name = "AOMA_REPORTING_DB_DEPLOYMENT_ROLE" granted_account_roles = [ "DEPLOY_WAREHOUSE_WAREHOUSE_ACCESS", "PROD_AOMA_REPORTING_SERVICE_ROLE", "QA_AOMA_REPORTING_SERVICE_ROLE", ] granted_database_roles = [ "AOMA_REPORTING.DB_PROD_SCHEMA_READWRITE", "AOMA_REPORTING.DB_AOMA_SCHEMA_READWRITE", "AOMA_APP_REPORTING.DB_READ", ] }, { name = "SME_ANALYTICS_FRANCE_BACK_ST_STREAMLITS_VIEWER" granted_database_roles = [ "SME_ANALYTICS_FRANCE.DB_BACK_ST_SCHEMA_STREAMLITS_READ", ] }, { name = "ROYALTYSHARE_DB_DEPLOYMENT_ROLE" granted_account_roles = [ "DEPLOY_WAREHOUSE_WAREHOUSE_ACCESS", ] granted_database_roles = [ "ROYALTYSHARE.DB_PROD_SCHEMA_READWRITE", "ROYALTYSHARE.DB_QA_SCHEMA_READWRITE", "ROYALTYSHARE.DB_DEV_SCHEMA_READWRITE", ] }, { name = "QA_AOMA_REPORTING_SERVICE_ROLE" comment = "PDEGO AOMA_REPORTING DB QA service role for dynamic tables, views and RAPs" granted_account_roles = [ "QA_ETL_WAREHOUSE_WAREHOUSE_ACCESS", ] granted_database_roles = [ "AOMA_REPORTING.DB_AOMA_QA_SCHEMA_READWRITE", "AOMA_APP_REPORTING.DB_READ", ] }, { name = "PROD_AOMA_REPORTING_SERVICE_ROLE" comment = "PDEGO AOMA_REPORTING DB PROD service role for dynamic tables, views and RAPs" granted_account_roles = [ "PROD_ETL_WAREHOUSE_WAREHOUSE_ACCESS", ] granted_database_roles = [ "AOMA_REPORTING.DB_PROD_SCHEMA_READWRITE", "AOMA_REPORTING.DB_AOMA_SCHEMA_READWRITE", "AOMA_APP_REPORTING.DB_READ", ] }, { name = "COMMON_REPORTING_DB_DEPLOY" granted_account_roles = [ "DEPLOY_WAREHOUSE_WAREHOUSE_ACCESS", ] granted_database_roles = [ "COMMON_REPORTING.DB_READWRITE", ] }, { name = "QA_COMMON_REPORTING_DB_DEPLOY" granted_account_roles = [ "DEPLOY_WAREHOUSE_WAREHOUSE_ACCESS", ] granted_database_roles = [ "QA_COMMON_REPORTING.DB_READWRITE", ] }, { name = "PROD_GET_PLAYLIST_BATCHES_FROM_SNOWFLAKE_SERVICE_USER_ROLE" granted_account_roles = [ "PROD_ETL_WAREHOUSE_WAREHOUSE_ACCESS", ], granted_database_roles = [ "FACTS.DB_PROD_SCHEMA_READ", ] }, { name = "PROD_DIM_GRPS_RELEASE_SERVICE_ROLE" granted_account_roles = [ "PROD_ETL_WH_WAREHOUSE_ACCESS", ] granted_database_roles = [ "COMMON_REPORTING.DB_READWRITE", "FACTS.DB_PROD_SCHEMA_READWRITE", "GRPS_APP_REPORTING_NOCONF.DB_GRPS_DRAS002_SCHEMA_READ", ] }, { name = "QA_DIM_GRPS_RELEASE_SERVICE_ROLE" granted_account_roles = [ "QA_ETL_WH_WAREHOUSE_ACCESS", ] granted_database_roles = [ "QA_COMMON_REPORTING.DB_READWRITE", "FACTS.DB_QA_SCHEMA_READWRITE", "FACTS.DB_PROD_SCHEMA_READ", "GRPS_APP_REPORTING_NOCONF.DB_GRPS_DRAS002_SCHEMA_READ", ] } ]