Loops through an array of tables, and exports each one to its own neatly named SQL file

Export-SQLTablesToFiles.ps1

<# Table Export #>
$someTables = @"
TBL_A_FOO
TBL_B_BAR
TBL_C_BAZ
TBL_D_QUX
TBL_E_QUUX
TBL_F_CORGE
"@.split("`n").TrimEnd("`r")

$dbName = 'Tarfful'
$instanceName = 'Kashyyyk'

# Get current timestamp
$timestamp = (Get-Date).ToString("yyyyMMddHHmmss")

# Loop through each table and export data
foreach ($table in $someTables) {
    $fileName = "${instanceName}-${timestamp}-script-${table}.sql"
    $filePath = Join-Path -Path "z:\Wookiee" -ChildPath $fileName

    # Define the splatted parameters for Get-DbaDbTable
    $tableParams = @{
        SqlInstance = $instanceName
        Database    = $dbName
        Table       = $table
    }

    # Define the splatted parameters for Export-DbaDbTableData
    $exportParams = @{
        FilePath = $filePath
        NoPrefix = $true
    }

    # Execute the commands with splatted parameters
    Get-DbaDbTable @tableParams | Export-DbaDbTableData @exportParams
}