clone all AWS Glue tables to another database

clone-tables.ts

import { Glue } from 'aws-sdk'

const glue = new Glue()

const SourceDatabaseName = "tmp"
const TargetDatabaseName = "ris-reporting"

// begin async
;(async () => {

    // get tables
    const tables = await glue.getTables({
        DatabaseName: SourceDatabaseName,
        MaxResults: 100,
    }).promise()

    // copy each
    const names = tables.TableList.map( async (table) => {

        // copy 1
        await glue.createTable({
            DatabaseName: TargetDatabaseName,
            TableInput: {
                Name: table.Name,
                Description: table.Description,
                Owner: table.Owner,
                LastAccessTime: table.LastAccessTime,
                LastAnalyzedTime: table.LastAnalyzedTime,
                Retention: table.Retention,
                StorageDescriptor: table.StorageDescriptor,
                PartitionKeys: table.PartitionKeys,
                ViewOriginalText: table.ViewOriginalText,
                ViewExpandedText: table.ViewExpandedText,
                TableType: table.TableType,
                Parameters: table.Parameters,
                TargetTable: table.TargetTable,
            },
        }).promise()

        return table.Name

    })

    // done
    console.log("done", { names })

})()