#!/bin/bash -x

# Uncomment to use these variables or export custom variables.
#export ORCD_AWS_PROD=437795906767
#export SME_CATALOG_ID="250735107403"
#export SME_DATABASE="facebook_main_db"

declare -a data_team=(
    # "aadamu"
    # "amccown"
    # "aoshomoji"
    # "buvarov"
    # "cbeesley"
    # "cvallecilla"
    # "efedorov"
    # "etaranenko"
    # "fasadullayev"
    # "fumar"
    # "iburilo"
    #"kshrayber"
    # "mmurha"
    # "oefanova"
    # "oshainoha"
    # "rpashchenko"
     "rroy"
    # "rtorres"
    # "ssavva"
    # "rshield"
    # "prod-swf-feed-ingestion"
    # "prod-swf-insta-reels-user"
    )

declare -a facebook_main_db=(
    '"fact_consumption_daily"'
    '"fact_events_consumption"'
    '"fact_events_platform_totals"'
    '"dim_product_lines"'
    '"weekly_top_1k"'
    '"fact_events_pmv"'
    '"dim_facebook_product"'
    '"fact_events_production_agg"'
    '"dim_partner_info"'
    '"fact_events_consumption_agg"'
    '"fact_production_daily"'
    '"fact_events_pmv_aggregates"'
    '"dim_source_types"'
    '"fact_events_production"'
    )

for iam_users in "${!data_team[@]}"
    do
      for tables in "${!facebook_main_db[@]}"
        do
          /usr/local/bin/aws lakeformation grant-permissions --principal DataLakePrincipalIdentifier=arn:aws:iam::$ORCD_AWS_PROD:user/${data_team[iam_users]} --permissions "SELECT" --resource '{ "Table": {"CatalogId":"'$SME_CATALOG_ID'", "DatabaseName":"'$SME_DATABASE'", "Name":'${facebook_main_db[tables]}'}}'
    done
done