account = "DELPHI.us-east-1" 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_QUICKSIGHT", granted_account_roles = [ "DELPHI_AE_REPORTING_DB_MAIN_SCHEMA_READ", "DELPHI_EXPLORATION_DB_MAIN_SCHEMA_READ", "QUICKSIGHT_WH_WAREHOUSE_ACCESS" ] }, { name = "APOLLO_TEAM_ROLE" }, { name = "APP_ENABLEMENT_READER" }, { name = "BILLING_ROLE" }, { name = "CHARTMETRIC_TIKTOK_USER" }, { name = "CHARTMETRIC_USER" }, { 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" ], granted_database_roles = [ "FANSIFTER_APP_REPORTING.DB_QA_CRM_FANS_SCHEMA_TRIGGERED_SENDS_STREAMLIT", ] }, { 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", ] }, { name = "CRM_ECOMMERCE_USER" }, { name = "CRM_FAN_SEGMENTATION_MODEL" }, { name = "DATADOG" }, { name = "PROD_DATADOG_INTEGRATION" granted_account_roles = [ "SNOWFLAKE_USAGE", "CICD_WH_WAREHOUSE_ACCESS", "DATADOG", ], }, { name = "DEV_ENGINEERING", comment = "Generic developer role (managed by Terraform).", granted_account_roles = [ "CRM_ECOMMERCE_DATA_DB_READ", "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", "FANSIFTER_APP_REPORTING_DB_READ", "DS_CHARTMETRIC_DB_READ", "LUMINATE_SHARE_READ", # warehouses "DEV_OWS_WH_WAREHOUSE_ACCESS", "EXPLORATION_WH_WAREHOUSE_ACCESS", "TEAM_DEV_BA_WH_WAREHOUSE_ACCESS", "PDE_SIGMA_WAREHOUSE_WAREHOUSE_ACCESS", "PROD_SIGMA_DB_READ_WRITE", ], 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", "SME_ANALYTICS.DB_DEV_LUMINATE_SCHEMA_READWRITE" ] }, { 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 = "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_SYS_USER", granted_account_roles = [ "EXPLORATION_WH_WAREHOUSE_ACCESS", ] }, { name = "EXPLORATION_USER", granted_account_roles = [ "EXPLORATION_WH_WAREHOUSE_ACCESS", ] }, { name = "FANSIFTER_ANALYST", granted_account_roles = [ "FANSIFTER_APP_REPORTING_DB_PROD_SCHEMA_READ", "FANSIFTER_APP_REPORTING_DB_QA_SCHEMA_READ", "DEV_ENGINEERING", ] }, { 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", "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", ], granted_database_roles = [ "FAN_LIVE_EVENTS.DB_QA_SCHEMA_READ", "FAN_LIVE_EVENTS.DB_PROD_SCHEMA_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", # new "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_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 = "FIVETRAN_PROD_ROLE", granted_account_roles = ["FIVETRAN_READER_ROLE"] }, { name = "FIVETRAN_READER_ROLE" }, { name = "HIGHTOUCH_ROLE", owner = "SECURITYADMIN" }, { name = "JENKINS_CLI_ROLE", 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" ], granted_database_roles = [ "FAN_LIVE_EVENTS.DB_QA_SCHEMA_READWRITE", "FAN_LIVE_EVENTS.DB_PROD_SCHEMA_READWRITE", ] }, { name = "L1SUPPORT", granted_account_roles = [ "EXPLORATION_USER", "DELPHI_EXPLORATION_DB_APPS_ETL_SCHEMA_READ" ] }, { name = "L2SUPPORT" }, { name = "MONITOR_ADMIN", owner = "SECURITYADMIN" }, { name = "PARTNERIZE_USER" }, { name = "PC_HIGHTOUCH_DB_PICKER_ROLE", owner = "SECURITYADMIN" }, { name = "PC_HIGHTOUCH_ROLE", owner = "SECURITYADMIN", comment = "System created role for partner elt integration.", granted_account_roles = ["PC_HIGHTOUCH_DB_PICKER_ROLE"] }, { name = "PLAYLISTS_STRATEGY", comment = "System created role for partner elt integration." }, { name = "PROD_AMPLITUDE", granted_account_roles = [ "PROD_AMPLITUDE_WH_WAREHOUSE_ACCESS", "FANSIFTER_APP_REPORTING_DB_PROD_SCHEMA_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", "PROD_MARKETING_INTEGRATIONS_DB_READ", "SONGWHIP_APP_REPORTING_DB_READ", "PREFERENCE_CENTER_DB_PROD_SCHEMA_READ", "DELPHI_EXPLORATION_DB_SYS_SCHEMA_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", ] }, { name = "PROD_OWS_DMP" granted_account_roles = [ "FANSIFTER_APP_REPORTING_DB_PROD_SCHEMA_READWRITE", "FANSIFTER_APP_REPORTING_DB_PROD_SHOPIFY_SCHEMA_READ", "FANSIFTER_PG_REPORTING_DB_PROD_OWS_DMP_PUBLIC_SCHEMA_READ", "PROD_SHOPIFY_INTEGRATIONS_DB_READWRITE", "PROD_SHOPIFY_INTEGRATIONS_FIVETRAN", # New "PROD_ETL_WH_WAREHOUSE_ACCESS", "PROD_SHOPIFY_INTEGRATIONS_WH_WAREHOUSE_ACCESS", "PROD_OWS_WH_WAREHOUSE_ACCESS", "ORCHARD_APP_REPORTING_DB_DELPHI_PROD_SCHEMA_READ", "PREFERENCE_CENTER_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", ] }, { name = "PROD_OWS_TEXT_CAMPAIGNS" granted_account_roles = [ "FANSIFTER_APP_REPORTING_DB_PROD_SCHEMA_READWRITE", "PROD_OWS_WH_WAREHOUSE_ACCESS", ] }, { 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_SERVICE_ROLE" granted_account_roles = [ "CRM_ECOMMERCE_DATA_DB_READ", "DELPHI_AE_REPORTING_DB_READ", "DELPHI_CRM_DATA_DB_READ", "DELPHI_EXPLORATION_DB_READ", "DS_CHARTMETRIC_DB_READ", "FANSIFTER_APP_REPORTING_DB_READ", "FANSIFTER_PG_REPORTING_DB_PROD_OWS_DMP_PUBLIC_SCHEMA_READ", "LUMINATE_SHARE_READ", "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", "SME_GERMANY_READ", "SONGWHIP_APP_REPORTING_DB_READ", "SNOWFLAKE_USAGE", ] 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", ] }, { name = "PROD_SIGMA_DB_READ_WRITE" granted_account_roles = [ "PROD_SIGMA_WAREHOUSE_WAREHOUSE_ACCESS", ] granted_database_roles = [ "SIGMA.DB_PROD_SCHEMA_READWRITE", ] }, { 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_FIVETRAN" }, { name = "QA_AE_CRM_USER", granted_account_roles = ["AE_CRM_USER"] }, { name = "QA_CHARTMETRIC_TIKTOK_USER", granted_account_roles = ["CHARTMETRIC_TIKTOK_USER"] }, { name = "QA_CHARTMETRIC_USER", granted_account_roles = ["CHARTMETRIC_USER"] }, { 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", "QA_MARKETING_INTEGRATIONS_DB_READ", "SONGWHIP_APP_REPORTING_DB_READ", "PREFERENCE_CENTER_DB_QA_SCHEMA_READ", "DELPHI_EXPLORATION_DB_SYS_SCHEMA_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", ] }, { name = "QA_OWS_DMP" granted_account_roles = [ "FANSIFTER_APP_REPORTING_DB_QA_SCHEMA_READWRITE", "FANSIFTER_APP_REPORTING_DB_QA_SHOPIFY_SCHEMA_READ", "FANSIFTER_PG_REPORTING_DB_QA_OWS_DMP_PUBLIC_SCHEMA_READ", "QA_SHOPIFY_INTEGRATIONS_DB_READWRITE", "QA_SHOPIFY_INTEGRATIONS_FIVETRAN", #New "QA_ETL_WH_WAREHOUSE_ACCESS", "QA_SHOPIFY_INTEGRATIONS_WH_WAREHOUSE_ACCESS", "QA_OWS_WH_WAREHOUSE_ACCESS", "ORCHARD_APP_REPORTING_DB_DELPHI_PROD_SCHEMA_READ", "PREFERENCE_CENTER_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", ] }, { name = "QA_OWS_TEXT_CAMPAIGNS" granted_account_roles = [ "FANSIFTER_APP_REPORTING_DB_QA_SCHEMA_READWRITE", "QA_OWS_WH_WAREHOUSE_ACCESS", ] }, { 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_LAMBDA_AUDIENCE", granted_account_roles = [ "FANSIFTER_APP_REPORTING_DB_QA_SCHEMA_READWRITE", "PREFERENCE_CENTER_DB_QA_SCHEMA_READ", "QA_ETL_WH_WAREHOUSE_ACCESS", ] }, { name = "READER" }, { name = "REPLICATOR", owner = "SECURITYADMIN" }, { 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 = "SNOWFLAKE_ROLE", owner = "SECURITYADMIN" }, { name = "SNOWFLAKE_SUPPORT" }, { 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 = "SONY_PUBLISHING_ROLE", comment = "The role for Sony Publishing Team data access" }, { 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 = "QA_MARKETING_INTEGRATIONS_FIVETRAN" granted_account_roles = [ "QA_MARKETING_INTEGRATIONS_DB_READWRITE", "QA_MARKETING_INTEGRATIONS_WH_WAREHOUSE_ACCESS", ] }, { name = "PROD_MARKETING_INTEGRATIONS_FIVETRAN" granted_account_roles = [ "PROD_MARKETING_INTEGRATIONS_DB_READWRITE", "PROD_MARKETING_INTEGRATIONS_WH_WAREHOUSE_ACCESS", ] }, { name = "MARKETING_ROI_ANALYST", granted_account_roles = [ "MARKETING_ROI_PROJECT_DB_READWRITE", "EXPLORATION_USER", "EXPLORATION_AD_PLUS", ] }, { name = "PROD_PERISCOPE_ROLE", granted_account_roles = [ "DELPHI_CRM_DATA_DB_READ", "CRM_ECOMMERCE_DATA_DB_READ", "DELPHI_EXPLORATION_DB_READ", "FANSIFTER_APP_REPORTING_DB_PROD_SCHEMA_READ", "FANSIFTER_APP_REPORTING_DB_QA_SCHEMA_READ", "FANSIFTER_APP_REPORTING_DB_PROD_CRM_FANS_SCHEMA_READ", "FANSIFTER_APP_REPORTING_DB_QA_CRM_FANS_SCHEMA_READ", "FANSIFTER_PG_REPORTING_DB_PROD_OWS_DMP_PUBLIC_SCHEMA_READ", "ORCHARD_APP_REPORTING_DB_DELPHI_PROD_SCHEMA_READ", "PERISCOPE_WH_WAREHOUSE_ACCESS", "SONGWHIP_APP_REPORTING_DB_READ", "PROD_MARKETING_INTEGRATIONS_DB_READ", ] }, { name = "FIVETRAN_SONGWHIP_ROLE", granted_account_roles = [ "SONGWHIP_APP_REPORTING_DB_READWRITE", "FIVETRAN_WAREHOUSE_WAREHOUSE_ACCESS", ] }, { name = "QA_OWS_PREFERENCE_CENTER", granted_account_roles = [ "PREFERENCE_CENTER_DB_QA_SCHEMA_READWRITE", "QA_PREFERENCE_CENTER_WH_WAREHOUSE_ACCESS", ] }, { name = "PROD_OWS_PREFERENCE_CENTER", granted_account_roles = [ "PREFERENCE_CENTER_DB_PROD_SCHEMA_READWRITE", "PROD_PREFERENCE_CENTER_WH_WAREHOUSE_ACCESS", ] }, { 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 = "KAFKA_DATA_HIGHWAY_TEAM", granted_account_roles = [ "DELPHI_CRM_DATA_DB_READWRITE", // to get write access to QA_RAW_SALESFORCE_SALES_CLOUD. There is no seperate role for qa. "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", // To skip masking_policy_for_profile "FANSIFTER_ENGINEERING_PRIVACY", // To skip PII masking for BANDSINTOWN ] 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 = "SME_SWITZERLAND_ANALYST", granted_account_roles = [ "EXPLORATION_WH_WAREHOUSE_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", ] }, { 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", ], granted_database_roles = [ "FAN_LIVE_EVENTS.DB_QA_SCHEMA_READ", "FAN_LIVE_EVENTS.DB_PROD_SCHEMA_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 = "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 = "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 = "FANSIFTER_PRIVACY" }, { name = "QA_KAFKA_CONNECT_FS", granted_account_roles = [ "FANSIFTER_APP_REPORTING_DB_QA_SCHEMA_READWRITE", "QA_ETL_WH_WAREHOUSE_ACCESS", ] }, { name = "PROD_KAFKA_CONNECT_FS", granted_account_roles = [ "FANSIFTER_APP_REPORTING_DB_PROD_SCHEMA_READWRITE", "PROD_ETL_WH_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 = "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 = "FANSIFTER_ANALYTIC_POC", granted_account_roles = [ "EMAILPOC_STREAMLIT_ACCESS" ] }, { name = "CHARTMETRIC_USER_ANALYTICS", granted_account_roles = [ "DELPHI_EXPLORATION_DB_CHARTMETRIC_SCHEMA_READ", "CHARTMETRIC_ANALYTICS_WH_WAREHOUSE_ACCESS" ] }, { name = "SFMC_ALERTS_ROLE", granted_account_roles = [ "SFMC_ALERTS_WH_WAREHOUSE_ACCESS", "DELPHI_CRM_DATA_DB_RAW_SALESFORCE_MARKETING_CLOUD_SCHEMA_READ", ] }, { name = "PROD_ETL_DELPHI_CRM_ROLE", granted_account_roles = [ "PROD_ETL_WH_WAREHOUSE_ACCESS", "DELPHI_CRM_DATA_DB_READWRITE", ] }, { name = "SME_ANALYTICS_US_RCA", granted_account_roles = [ "EXPLORATION_BASE", "LUMINATE_SHARE_READ", "SME_ANALYTICS_US_RCA_SMALL_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_US_RCA_MEDIUM_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_US_RCA_LARGE_WAREHOUSE_WAREHOUSE_ACCESS", ], granted_database_roles = [ "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", ] }, { name = "SME_ANALYTICS_INT_MKTG", granted_account_roles = [ "FANSIFTER_MARKETING_ANALYST_BASE", "SME_ANALYTICS_INT_MKTG_SMALL_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_INT_MKTG_MEDIUM_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_INT_MKTG_LARGE_WAREHOUSE_WAREHOUSE_ACCESS", "CRM_TEAM_ROLE_BASE", # shopify "CRM_ECOMMERCE_DATA_DB_SHOPIFY_US_COLUMBIA_ADDISON_RAE_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_SHOPIFY_UK_ADDISON_RAE_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_SHOPIFY_AU_NZ_ADDISON_RAE_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_SHOPIFY_US_ARISTA_DAMIANO_DAVID_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_SHOPIFY_US_COLUMBIA_DOMINIC_FIKE_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_SHOPIFY_US_RCA_DOJA_CAT_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_SHOPIFY_UK_DOJA_CAT_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_SHOPIFY_AU_NZ_DOJA_CAT_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_SHOPIFY_US_EPIC_GIVEON_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_SHOPIFY_US_COLUMBIA_JENNIE_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_SHOPIFY_US_RCA_LIZZY_MCALPINE_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_SHOPIFY_US_COLUMBIA_MALCOLM_TODD_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_SHOPIFY_COR_MEGAN_MORONEY_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_SHOPIFY_US_RCA_SZA_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_SHOPIFY_US_COLUMBIA_THE_KID_LAROI_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_SHOPIFY_US_COLUMBIA_TAME_IMPALA_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_SHOPIFY_UK_TAME_IMPALA_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_SHOPIFY_AU_NZ_TAME_IMPALA_SCHEMA_READ", "CRM_ECOMMERCE_DATA_DB_SHOPIFY_US_EPIC_TYLA_SCHEMA_READ", ], 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", ] }, { name = "SME_ANALYTICS_UK", granted_account_roles = [ "FANSIFTER_APP_REPORTING_DB_PROD_VIEWS_SCHEMA_READ", "LUMINATE_SHARE_READ", "DELPHI_EXPLORATION_DB_CHARTMETRIC_SCHEMA_READ", "CRM_TEAM_ROLE_BASE", # warehouses "SME_ANALYTICS_UK_SMALL_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_UK_MEDIUM_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_UK_LARGE_WAREHOUSE_WAREHOUSE_ACCESS", ], granted_database_roles = [ # crm data "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", # analytics "SME_ANALYTICS.DB_SHARED_SCHEMA_READWRITE", "SME_ANALYTICS.DB_UK_SCHEMA_READWRITE", # streamlit apps access "SME_ANALYTICS.DB_UK_SCHEMA_NIU14T8O9W599N9A_STREAMLIT", "SME_ANALYTICS.DB_UK_SCHEMA_CGRTDIA855I79GSU_STREAMLIT", "SME_ANALYTICS.DB_UK_SCHEMA_P_HO6YDV73KVTQSE_STREAMLIT", "SME_ANALYTICS.DB_UK_SCHEMA_CHVXSXUS4AM3H_ZG_STREAMLIT", "SME_ANALYTICS.DB_UK_SCHEMA_UH1XDU5R06TB47V5_STREAMLIT", "SME_ANALYTICS.DB_UK_SCHEMA_S61374W2I9IB2ZKU_STREAMLIT", # streamlit apps require access to: "DELPHI_EXPLORATION.DB_EXP_SCHEMA_V_AE_ACTIVITY_VIEW_READ", "DELPHI_EXPLORATION.DB_EXP_SCHEMA_V_AE_ACTIVITIES_FEED_VIEW_READ", "DELPHI_EXPLORATION.DB_EXP_SCHEMA_V_AE_MEMBER_COUNTRY_VIEW_READ", "DELPHI_EXPLORATION.DB_EXP_SCHEMA_V_AE_SEGMENT_VIEW_READ", # crm ecommerce "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 = "SME_ANALYTICS_GERMANY", granted_account_roles = [ "FANSIFTER_APP_REPORTING_DB_PROD_VIEWS_SCHEMA_READ", "LUMINATE_SHARE_READ", "DELPHI_EXPLORATION_DB_CHARTMETRIC_SCHEMA_READ", "SME_ANALYTICS_DE_SMALL_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_DE_MEDIUM_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_DE_LARGE_WAREHOUSE_WAREHOUSE_ACCESS", "EXPLORATION_BASE", "EXPLORATION_BASE_AD_PLUS", ], 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_DE_SCHEMA_READWRITE", ] }, { name = "SME_ANALYTICS_FINLAND", granted_account_roles = [ "FANSIFTER_APP_REPORTING_DB_PROD_VIEWS_SCHEMA_READ", "LUMINATE_SHARE_READ", "DELPHI_EXPLORATION_DB_CHARTMETRIC_SCHEMA_READ", "SME_ANALYTICS_FI_SMALL_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_FI_MEDIUM_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_FI_LARGE_WAREHOUSE_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", "SME_ANALYTICS.DB_SHARED_SCHEMA_READWRITE", "SME_ANALYTICS.DB_FI_SCHEMA_READWRITE", ] }, { name = "SME_ANALYTICS_BENELUX", granted_account_roles = [ "FANSIFTER_APP_REPORTING_DB_PROD_VIEWS_SCHEMA_READ", "SME_ANALYTICS_BX_SMALL_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_BX_MEDIUM_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_BX_LARGE_WAREHOUSE_WAREHOUSE_ACCESS", "LUMINATE_SHARE_READ", "DELPHI_EXPLORATION_DB_CHARTMETRIC_SCHEMA_READ", ], 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_FRANCE", granted_account_roles = [ "FANSIFTER_APP_REPORTING_DB_PROD_VIEWS_SCHEMA_READ", "LUMINATE_SHARE_READ", "DELPHI_EXPLORATION_DB_CHARTMETRIC_SCHEMA_READ", "SME_ANALYTICS_FR_SMALL_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_FR_MEDIUM_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_FR_LARGE_WAREHOUSE_WAREHOUSE_ACCESS", "EXPLORATION_BASE", ], 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", ] }, { 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 = "SONY_MUSIC_PUBLISHING_ANALYST", granted_account_roles = [ "SONY_MUSIC_PUBLISHING_ANALYST_WH_WAREHOUSE_ACCESS", "LUMINATE_SHARE_READ", ], 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 = "SME_DENMARK_ANALYST", granted_account_roles = [ "EXPLORATION_WH_WAREHOUSE_ACCESS" ], granted_database_roles = [ "DELPHI_EXPLORATION.DB_EXP_SCHEMA_V_LINKFIRE_RAW_DATA_VIEW_READ", ] }, { name = "CRM_TEAM_ROLE" granted_database_roles = [ "FANSIFTER_APP_REPORTING.DB_PROD_SCHEMA_FILEUPLOAD_STREAMLIT", "DELPHI_EXPLORATION.DB_EXP_SCHEMA_READ", "DELPHI_EXPLORATION.DB_MAIN_SCHEMA_READ" ] 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", ] }, { name = "CRM_TEAM_ROLE_BASE" granted_database_roles = [ "FANSIFTER_APP_REPORTING.DB_PROD_SCHEMA_FILEUPLOAD_STREAMLIT", "DELPHI_EXPLORATION.DB_EXP_SCHEMA_READ", "DELPHI_EXPLORATION.DB_MAIN_SCHEMA_READ" ] 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", ] }, { name = "PROD_OWS_GRID_GENERATOR", 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", ] granted_account_roles = [ "PROD_OWS_WH_WAREHOUSE_ACCESS", ] }, { name = "QA_OWS_GRID_GENERATOR", 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", ] granted_account_roles = [ "QA_OWS_WH_WAREHOUSE_ACCESS", ] }, { name = "FANSIFTER_APP_REPORTING_DB_PROD_SCHEMA_FILEUPLOAD_STREAMLIT", granted_database_roles = [ "FANSIFTER_APP_REPORTING.DB_PROD_SCHEMA_FILEUPLOAD_STREAMLIT", ] }, { name = "SME_MERCH_STREAMLIT_ACCESS" granted_database_roles = [ "FANSIFTER_APP_REPORTING.DB_PROD_STREAMLIT_SME_MERCH_SCHEMA_SME_MERCH_STREAMLIT" ] granted_account_roles = [ "PROD_ETL_WH_WAREHOUSE_ACCESS", ] }, { name = "SME_FAN_EXPORT_STREAMLIT_ACCESS" granted_database_roles = [ "FANSIFTER_APP_REPORTING.DB_PROD_STREAMLIT_FAN_EXPORT_SCHEMA_FAN_DATA_EXPORT_STREAMLIT" ] granted_account_roles = [ "PROD_ETL_WH_WAREHOUSE_ACCESS", ] }, { name = "EMAILPOC_STREAMLIT_ACCESS" granted_database_roles = [ "FANSIFTER_APP_REPORTING.DB_DEV_RBOMBERG_SCHEMA_EMAILPOC_STREAMLIT" ] }, { name = "SME_ANALYTICS_BRAZIL", granted_account_roles = [ "LUMINATE_SHARE_READ", "DELPHI_EXPLORATION_DB_CHARTMETRIC_SCHEMA_READ", "FANSIFTER_APP_REPORTING_DB_PROD_VIEWS_SCHEMA_READ", "SME_ANALYTICS_BR_SMALL_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_BR_MEDIUM_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_BR_LARGE_WAREHOUSE_WAREHOUSE_ACCESS", ], 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 = "ORCHARD_STRATEGY_TEAM_ROLE", granted_account_roles = [ "EXPLORATION_WH_WAREHOUSE_ACCESS", ] }, { name = "SME_DATA_SCIENCE_AND_ANALYTICS", granted_account_roles = [ "FANSIFTER_APP_REPORTING_DB_PROD_VIEWS_SCHEMA_READ", "LUMINATE_SHARE_READ", "DELPHI_EXPLORATION_DB_CHARTMETRIC_SCHEMA_READ", "SME_ANALYTICS_DATA_SCIENCE_SMALL_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_DATA_SCIENCE_MEDIUM_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_DATA_SCIENCE_LARGE_WAREHOUSE_WAREHOUSE_ACCESS", ], granted_database_roles = [ "SME_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", ] }, { 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", ] }, { name = "QA_ETL_TICKETEK_ROLE", granted_account_roles = [ "QA_ETL_WH_WAREHOUSE_ACCESS" ], granted_database_roles = [ "FAN_LIVE_EVENTS.DB_QA_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 = "PDE_SONGWHIP_ENGINEER", granted_account_roles = [ "EXPLORATION_WH_WAREHOUSE_ACCESS", "SONGWHIP_APP_REPORTING_DB_READ", ], 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 = "QA_ETL_BANDSINTOWN_ROLE", granted_account_roles = [ "QA_ETL_WH_WAREHOUSE_ACCESS" ], granted_database_roles = [ "FAN_LIVE_EVENTS.DB_QA_SCHEMA_READWRITE", ] }, { name = "PROD_ETL_BANDSINTOWN_ROLE", granted_account_roles = [ "PROD_ETL_WH_WAREHOUSE_ACCESS" ], granted_database_roles = [ "FAN_LIVE_EVENTS.DB_PROD_SCHEMA_READWRITE", ] }, { name = "SME_ANALYTICS_INSIGHTS_REPORTING", granted_account_roles = [ "FANSIFTER_APP_REPORTING_DB_PROD_VIEWS_SCHEMA_READ", "LUMINATE_SHARE_READ", "DELPHI_EXPLORATION_DB_CHARTMETRIC_SCHEMA_READ", "SME_ANALYTICS_INSIGHTS_SMALL_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_INSIGHTS_MEDIUM_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_INSIGHTS_LARGE_WAREHOUSE_WAREHOUSE_ACCESS", "AE_CRM_USER_BASE", ], granted_database_roles = [ "SME_ANALYTICS.DB_SHARED_SCHEMA_READWRITE", "SME_ANALYTICS.DB_INSIGHTS_SCHEMA_READWRITE", ] }, { name = "SNOWFLAKE_TEAM", granted_account_roles = [ "EXPLORATION_USER" ], granted_database_roles = [ "SME_ANALYTICS.DB_READ", ] }, { name = "SONY_MUSIC_PUBLISHING_LUMINATE", granted_account_roles = [ "SONY_MUSIC_PUBLISHING_ANALYST_WH_WAREHOUSE_ACCESS" ] }, { name = "FANSIFTER_STREAMLIT_DEPLOYMENT_ROLE", granted_account_roles = [ "CICD_WH_WAREHOUSE_ACCESS", "QA_ETL_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" ] }, { 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 = "MASKING_ADMIN", comment = "Role for managing and applying dynamic data masking policies" }, { name = "SME_ANALYTICS_PHILIPPINES", granted_account_roles = [ "FANSIFTER_APP_REPORTING_DB_PROD_VIEWS_SCHEMA_READ", "LUMINATE_SHARE_READ", "DELPHI_EXPLORATION_DB_CHARTMETRIC_SCHEMA_READ", "SME_ANALYTICS_PH_SMALL_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_PH_MEDIUM_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_PH_LARGE_WAREHOUSE_WAREHOUSE_ACCESS", ], granted_database_roles = [ "SME_ANALYTICS.DB_SHARED_SCHEMA_READWRITE", "SME_ANALYTICS.DB_PH_SCHEMA_READWRITE", ] }, { name = "QUICKSIGHT_ADMIN", granted_account_roles = [ "SYSADMIN", ] }, { name = "SME_ANALYTICS_DEV_LUMINATE_READ", granted_database_roles = [ "SME_ANALYTICS.DB_DEV_LUMINATE_SCHEMA_READ", ] }, { name = "LUMINATE_SHARE_READ", comment = "Luminate data share read" }, { name = "SME_ANALYTICS_LATINIBERIA", granted_account_roles = [ "SME_ANALYTICS_LATINIBERIA_SMALL_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_LATINIBERIA_MEDIUM_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_LATINIBERIA_LARGE_WAREHOUSE_WAREHOUSE_ACCESS", "LUMINATE_SHARE_READ", ], granted_database_roles = [ "SME_ANALYTICS.DB_SHARED_SCHEMA_READWRITE", "SME_ANALYTICS.DB_LATINIBERIA_SCHEMA_READWRITE", ] }, { name = "REPORTING_DB_TEAM", granted_account_roles = [ "TEAM_BA_ROLE", "LUMINATE_SHARE_READ", "SME_ANALYTICS_REPORTING_DB_SMALL_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_REPORTING_DB_MEDIUM_WAREHOUSE_WAREHOUSE_ACCESS", "SME_ANALYTICS_REPORTING_DB_LARGE_WAREHOUSE_WAREHOUSE_ACCESS", ], granted_database_roles = [ "SME_ANALYTICS.DB_SHARED_SCHEMA_READWRITE", "SME_ANALYTICS.DB_REPORTING_DB_SCHEMA_READWRITE", ] }, { name = "SME_ANALYTICS_ALAMO", granted_account_roles = [ "LUMINATE_SHARE_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", ] }, ]