packages/common/prisma/migrations/20240409101800_function_aws_resource/migration.sql [35:48]:
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
    region             text;
    tags               text;
    taggable           text;
BEGIN
    FOR cloudquery_table IN
        -- Find all base tables (no views allowed)
        SELECT DISTINCT table_name
        FROM information_schema.tables
        WHERE table_type = 'BASE TABLE'
        -- find the intersection of tables that have an account_id or request_account_id column
        INTERSECT
        SELECT DISTINCT table_name
        FROM information_schema.columns
        WHERE table_name LIKE 'aws_%s'
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -



packages/common/prisma/migrations/20240412103300_aws_resources/migration.sql [74:87]:
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
    region             text;
    tags               text;
    taggable           text;
BEGIN
    FOR cloudquery_table IN
            -- Find all base tables (no views allowed)
            SELECT DISTINCT table_name
            FROM information_schema.tables
            WHERE table_type = 'BASE TABLE'
            -- find the intersection of tables that have an ARN column
            INTERSECT
            SELECT DISTINCT table_name
            FROM information_schema.columns
            WHERE table_name LIKE 'aws_%s'
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -



