Update-SFDocuments.ps1

function Update-SFDocuments ()
{
    [CmdletBinding()]
    param (
        [Parameter(Mandatory)] [String]$SFObjectTypes,
        [Parameter(Mandatory)] [String]$SFRole,
        [Parameter(Mandatory)] [String]$SFWarehouse,
        [Parameter()] [String]$WorksheetsPath,
        [Parameter()] [String]$DashboardsPath,
        [Parameter()] [String]$FiltersPath,
        [Parameter()] [String]$SFDatabase,
        [Parameter()] [String]$SFSchema,
        [Parameter()] [String]$OutputDirectory
    )

    if ($SFObjectTypes.Trim().ToLower() -eq "all") {
        if (-Not ($WorksheetsPath, $DashboardsPath, $FiltersPath)) {
            Write-Host "Please supply a path for each object type (-WorksheetsPath, -DashboardsPath, -FiltersPath)" -ForegroundColor Yellow
            break
        }

        $tmp_filters = Get-ChildItem $FiltersPath
        if ($tmp_filters) {
            Write-Host "`r`nFound Files at $FiltersPath" -ForegroundColor Cyan
            echo "`r"
            echo $tmp_filters.NAME
            echo "`r`n"
        }
        else {
            Write-Host "`r`nNo files found at $FiltersPath" -ForegroundColor Yellow
        }
        
        $tmp_dashboards = Get-ChildItem $DashboardsPath
        if ($tmp_dashboards) {
            Write-Host "`r`nFound files at $DashboardsPath" -ForegroundColor Cyan
            echo "`r"
            echo $tmp_dashboards.Name
            echo "`r`n"
        }
        else {
            Write-Host "`r`nNo files found at $DashboardsPath" -ForegroundColor Yellow
        }
    
        $tmp_worksheets = Get-ChildItem $WorksheetsPath
        if ($tmp_worksheets) {
            Write-Host "Found files at $WorksheetsPath" -ForegroundColor Cyan
            echo "`r"
            echo $tmp_worksheets.Name
            echo "`r`n"
        }
        else {
            Write-Host "`r`nNo files found at $WorksheetsPath" -ForegroundColor Yellow
        }

        Invoke-Command -ScriptBlock {
            Update-Filters -FiltersPath $FiltersPath -SFRole $SFRole  -SFWarehouse $SFWarehouse 
            echo "`r`n"
            Update-Dashboards -DashboardsPath $DashboardsPath -SFRole $SFRole  -SFWarehouse $SFWarehouse
            echo "`r`n"
            Update-Worksheets -WorksheetsPath $WorksheetsPath -SFRole $SFRole  -SFWarehouse $SFWarehouse
            echo "`r`n"
        }
    } else {

        $objs = $SFObjectTypes -Split ',' 

        # Begin for loop through array
        foreach ($_ in $objs) {
                $obj = $_.Trim().ToLower()

                Write-Host "`r`nSearching for $obj files.`r`n" -ForegroundColor Magenta

                if($obj -eq "filters") {
                    if (-Not ($FiltersPath)) {
                        echo "Please supply a path for -FiltersPath argument. Skipping."
                        continue
                    }
                    $tmp_filters = Get-ChildItem $FiltersPath
                    if ($tmp_filters) {
                        Write-Host "`r`nFound Files at $FiltersPath" -ForegroundColor Cyan
                        echo "`r"
                        $tmp_filters.Name
                        echo "`r`n"
                    }
                    else {
                        Write-Host "`r`nNo files found at $FiltersPath. Skipping." -ForegroundColor Yellow
                        continue
                    }
                    Invoke-Command -ScriptBlock { Update-Filters -FiltersPath $FiltersPath -SFRole $SFRole  -SFWarehouse $SFWarehouse }
                    echo "`r`n"
                }

                elseif ($obj -eq "dashboards") {
                    if (-Not ($DashboardsPath)) {
                        echo "Please supply a path for -DashboardsPath argument. Skipping."
                        continue
                    }
                    $tmp_dashboards = Get-ChildItem $DashboardsPath
                    if ($tmp_dashboards) {
                        Write-Host "`r`nFound files at $DashboardsPath" -ForegroundColor Cyan
                        echo "`r"
                        echo $tmp_dashboards.Name
                        echo "`r`n"
                    }
                    else {
                        Write-Host "`r`nNo files Found at $DashboardsPath. Skipping." -ForegroundColor Yellow
                        continue
                    }

                    Invoke-Command -ScriptBlock { Update-Dashboards -DashboardsPath $DashboardsPath -SFRole $SFRole  -SFWarehouse $SFWarehouse }
                }

                elseif ($obj -eq "worksheets") {
                    if (-Not ($WorksheetsPath)) {
                        echo "Please supply a path for -WorksheetsPath argument. Skipping."
                        continue
                    }
                    $tmp_worksheets = Get-ChildItem $WorksheetsPath
                    if ($tmp_worksheets) {
                        Write-Host "`r`nFound files at $WorksheetsPath" -ForegroundColor Cyan
                        echo "`r"
                        echo $tmp_worksheets.Name
                        echo "`r`n"
                    }
                    else {
                        Write-Host "`r`nNo files found at $WorksheetsPath" -ForegroundColor Yellow
                        continue
                    }

                    Invoke-Command -ScriptBlock { Update-Worksheets -WorksheetsPath $WorksheetsPath -SFRole $SFRole  -SFWarehouse $SFWarehouse }
                } 
                else {
                    Write-Host "$obj not a valid object. Use 'Filters, Dashboards, Worksheets, a combination of the three in a comma seperated list, or All.'`r`n" -ForegroundColor Magenta
                    continue
                }
            }
    }

    <#
    .SYNOPSIS
    Update Snowflake context for Filters, Dashboards, or Worksheets files together or separately. 

    .DESCRIPTION
    This function allows the user to update the Snowflake context, such as Role, Virtual Warehouse, Database, or Schema 
    in the exported Filter, Dashboard, or Worksheet files together or separately. 
    Please refer to the examples for syntax. If a Role is not provided, ACCOUNTADMIN will be the designated Role.

    .PARAMETER SFObjectTypes
    Specifies the object type being updated. 
    Filter, Dashboard, Worksheet, or or any combination of the three can be entered.
    Choose All to update Filters, Dashboards, and Worksheets with one command. 
    Casing, ordering, and spaces are not important for this argument. 'filter,dashboard,worksheet' = 'Worksheet, Dashboard, Filter'

    Do not enter All in combination with any of the other selections or duplicate objects/files will be created.

    .PARAMETER FiltersPath
    Specifies the path to the directory where the filters are located. Case sensitive.

    .PARAMETER DashboardsPath
    Specifies the path to the directory where the dashboards are located. Case sensitive.

    .PARAMETER WorksheetsPath
    Specifies the path to the directory where the worksheets are located. Case sensitive.

    .PARAMETER SFRole
    Specifies the Snowflake Role required to run the specific object. Default is ACCOUNTADMIN.

    .PARAMETER SFWarehouse
    Specifies the Snowflake Warehouse required to run the specific object. An error will display if no warehouse is designated.

    .PARAMETER OutputDirectory
    A relative or fully qualified path where files will be placed.

    .INPUTS
    None. You cannot pipe objects to Update-Documents.

    .OUTPUTS
    set-content. Update-Documents updates the JSON values of the Snowflake context in order to ensure the respective object works appropriately.
    
    .EXAMPLE
    ---------------- All ----------------
    Update-Documents -SFObjectTypes 'All' -FiltersPath <path-to-filters-dir>  -DashboardsPath <path-to-dashboards-dir> -WorksheetsPath <path-to-worksheets-dir> -SFRole THISMEANSEVERYTHINGWORKS  -SFWarehouse SUPERNEWWAREHOUSE

    .EXAMPLE
    ---------------- Filters ----------------
    Update-Documents -SFObjectTypes 'Filters' -FiltersPath <path-to-filters-dir> -SFRole THISMEANSEVERYTHINGWORKS  -SFWarehouse SUPERNEWWAREHOUSE

    .EXAMPLE
    ---------------- Dashboard ----------------
    Update-Documents -SFObjectTypes 'Dashboards' -DashboardsPath <path-to-dashboards-dir> -SFRole THISMEANSEVERYTHINGWORKS  -SFWarehouse SUPERNEWWAREHOUSE

    .EXAMPLE
    ---------------- Worksheet ----------------
    Update-Documents -SFObjectTypes 'Worksheets' -WorksheetsPath <path-to-worksheets-dir> -SFRole THISMEANSEVERYTHINGWORKS  -SFWarehouse SUPERNEWWAREHOUSE

    .EXAMPLE
    ---------------- Mix of assets ----------------
    Update-Documents -SFObjectTypes 'dashboards, filters, worksheets' -FiltersPath <path-to-filters-dir> -DashboardsPath <path-to-dashboards-dir> -WorksheetsPath <path-to-worksheets-dir> -SFWarehouse SUPERNEWWAREHOUSE

    #>
}


function Update-Filters ()
{
    if($FiltersPath) {
        # Update Filters files
        foreach ($f in $tmp_filters){
            $fparam = Get-Content $f.FullName | ConvertFrom-JSON
            $fname = $f.Name
            $fparam.update | % { #Manual Filter Update
                if($fparam.Type -eq 'manual'){
                    Write-Host 'Updating MANUAL FILTER values for' -ForegroundColor Cyan 
                    Write-Host $f.Name -ForegroundColor Green
                    $fparam.Role = $SFRole
                    $fparam.Warehouse = $SFWarehouse
                    $fparam.Configuration.context.role = $SFRole
                    $fparam.Configuration.context.warehouse = $SFWarehouse
                    $fparam.Database = $SFDatabase
                    $fparam.Schema = $SFSchema
                    $fparam.Configuration.context.database = $SFSchema
                    $fparam.Configuration.context.schema = $SFSchema
                    $fparam.FileSystemSafeName = ""
                    $fparam.AccountName = ""
                    $fparam.AccountFullName = ""
                    $fparam.AccountUrl = ""
                    $fparam.OrganizationID = ""
                    $fparam.Region = ""
                    }
                #Query Filter Update
                elseif($fparam.Type -eq 'query') {
                    Write-Host 'Updating QUERY FILTER values for' -ForegroundColor Cyan
                    Write-Host $f.Name -ForegroundColor Yellow
                    $fparam.Worksheet.OwnerUserID = ""
                    $fparam.Worksheet.OwnerUserName = ""
                    $fparam.Worksheet.Role = $SFRole
                    $fparam.Worksheet.Warehouse = $SFWarehouse
                    $fparam.Worksheet.FileSystemSafeName = ""
                    $fparam.Worksheet.AccountName = ""
                    $fparam.Worksheet.AccountFullName = ""
                    $fparam.Worksheet.AccountUrl = ""
                    $fparam.Worksheet.OrganizationID = ""
                    $fparam.Worksheet.Region = ""
                    $fparam.Worksheet.Database = $SFDatabase
                    $fparam.Worksheet.Schema = $SFSchema
                    $fparam.Role = $SFRole
                    $fparam.Warehouse = $SFWarehouse
                    $fparam.Configuration.context.role = $SFRole
                    $fparam.Configuration.context.warehouse = $SFWarehouse
                    $fparam.Database = $SFDatabase
                    $fparam.Schema = $SFSchema
                    $fparam.Configuration.context.database = $SFDatabase
                    $fparam.Configuration.context.schema = $SFSchema
                    $fparam.FileSystemSafeName = ""
                    $fparam.AccountName = ""
                    $fparam.AccountFullName = ""
                    $fparam.AccountUrl = ""
                    $fparam.OrganizationID = ""
                    $fparam.Region = ""
                    }
            }
            if ($OutputDirectory) {
                if (-Not (Test-Path $OutputDirectory/filters)) {
                    # Create the directory if not exists
                    New-Item $OutputDirectory/filters -ItemType Directory
                    Write-Host "Created path $OutputDirectory/filters"
                    $fparam | ConvertTo-JSON -depth 10| Out-File -FilePath $OutputDirectory/filters/$fname
                } else {
                    $fparam | ConvertTo-JSON -depth 10| Out-File -FilePath $OutputDirectory/filters/$fname
                }
            }
            else {
                $fparam | ConvertTo-JSON -depth 10| set-content $f.FullName
            }
        }
    }
    else { Write-Host "-FiltersPath was not entered"}    
}


function Update-Dashboards () 
{
    if($DashboardsPath) {
        # Update DASHBOARD files
            foreach ($f in $tmp_dashboards){
                $fparam = Get-Content $f.FullName | ConvertFrom-JSON
                $fname = $f.Name
                $fparam.update | % {
                    Write-Host 'Updating DASHBOARD values for' -ForegroundColor Cyan
                    Write-Host $f.Name -ForegroundColor Yellow
                    $fparam.OwnerUserID = ""
                    $fparam.OwnerUserName = ""
                    $fparam.URL = ""
                    $fparam.Role = $SFRole
                    $fparam.Warehouse = $SFWarehouse
                    $fparam.Database = $SFDatabase
                    $fparam.Schema = $SFSchema
                    $fparam.Database = $SFDatabase
                    $fparam.Schema = $SFSchema
                    $fparam.FileSystemSafeName = ""
                    $fparam.AccountName = ""
                    $fparam.AccountFullName = ""
                    $fparam.AccountUrl = ""
                    $fparam.OrganizationID = ""
                    $fparam.Region = ""
                    $fparam.Contents.context.role = $SFRole
                    $fparam.Contents.context.warehouse = $SFWarehouse
                    $fparam.Contents.context.database = $SFDatabase
                    $fparam.Contents.context.schema = $SFSchema
                    $fparam.URL = ""
                    foreach ($worksheet in $fparam.Worksheets) {
                        $worksheet.OwnerUserID = ""
                        $worksheet.OwnerUserName = ""
                        $worksheet.URL = ""
                        $worksheet.Role = $SFRole
                        $worksheet.Warehouse = $SFWarehouse
                        $worksheet.Database = $SFDatabase
                        $worksheet.Schema = $SFSchema
                        $worksheet.FileSystemSafeName = ""
                        $worksheet.AccountName = ""
                        $worksheet.AccountFullName = ""
                        $worksheet.AccountUrl = ""
                        $worksheet.OrganizationID = ""
                        $worksheet.Region = ""
                        $worksheet.URL = ""
                        #CHARTS
                        foreach ($chart in $fparam.Worksheets.Charts) {
                            $chart.AccountName = ""
                            $chart.AccountFullName = ""
                            $chart.AccountUrl = ""
                            $chart.OrganizationID = ""
                            $chart.Region = ""
                        }
                    }

                }

            if ($OutputDirectory) {
                if (-Not (Test-Path $OutputDirectory/dashboards)) {
                    # Create the directory if not exists
                    New-Item $OutputDirectory/dashboards -ItemType Directory
                    Write-Host "Created path $OutputDirectory/dashboards"
                    $fparam | ConvertTo-JSON -depth 10| Out-File -FilePath $OutputDirectory/dashboards/$fname
                }
                else {
                $fparam | ConvertTo-JSON -depth 10| Out-File -FilePath $OutputDirectory/dashboards/$fname
                }
            } else {
            $fparam | ConvertTo-JSON -depth 10| Set-Content $f.FullName
            }
        }
    }
    else { Write-Host "-DashboardsPath was not entered"} 
}


function Update-Worksheets ()
{
    if($WorksheetsPath) {
        # Update WORKSHEET files
        foreach ($f in $tmp_worksheets){
            $fparam = Get-Content $f.FullName | ConvertFrom-JSON
            $fname = $f.Name
            $fparam.update | % {
                Write-Host 'Updating WORKSHEET values for' -ForegroundColor Cyan
                Write-Host $f.Name -ForegroundColor Yellow
                $fparam.OwnerUserID = ""
                $fparam.OwnerUserName = ""
                $fparam.Role = $SFRole
                $fparam.Warehouse = $SFWarehouse
                $fparam.Database = $SFDatabase
                $fparam.Schema = $SFSchema
                $fparam.FileSystemSafeName = ""
                $fparam.AccountName = ""
                $fparam.AccountFullName = ""
                $fparam.AccountUrl = ""
                $fparam.OrganizationID = ""
                $fparam.Region = ""
                $fparam.URL = ""
            }
            if ($OutputDirectory) {
                if (-Not (Test-Path $OutputDirectory/worksheets)) {
                    # Create the directory if not exists
                    New-Item $OutputDirectory/worksheets -ItemType Directory
                    Write-Host "Created path $OutputDirectory/worksheets"
                    $fparam | ConvertTo-JSON -depth 10| Out-File -FilePath $OutputDirectory/worksheets/$fname
                } else {
                    $fparam | ConvertTo-JSON -depth 10| Out-File -FilePath $OutputDirectory/worksheets/$fname
                }
            }
            else {
            $fparam | ConvertTo-JSON -depth 10| set-content $f.FullName
            }
        }
    }
    else { Write-Host "-WorksheetsPath was not entered"}    
}