我们可以使用Snowflake元数据表SYS.DATABASES和SYS.TABLES来在Snowflake中完成此任务。以下是此任务的代码示例：

CREATE OR REPLACE PROCEDURE LIST_TABLES_WITH_EMPTY_ROW() RETURNS VARCHAR LANGUAGE JAVASCRIPT AS $$ var DATABASE_NAMES = []; var TABLE_NAMES = []; var EMPTY_ROWS = []; var ROW_COUNT;

// Get list of database names var GET_DATABASE_NAMES = snowflake.createStatement({sqlText: SELECT "NAME" FROM "ACCOUNT_USAGE"."DATABASES"}).execute(); while (GET_DATABASE_NAMES.next()) { DATABASE_NAMES.push(GET_DATABASE_NAMES.getColumnValue('NAME')); }

// Loop over each database and table and check for empty rows for (var i=0; iSELECT "NAME", "SCHEMA_NAME" FROM "ACCOUNT_USAGE"."TABLES" WHERE "DATABASE_NAME" = '${DATABASE_NAMES[i]}'}).execute(); while (GET_TABLE_NAMES.next()) { TABLE_NAMES.push({"database_name": DATABASE_NAMES[i], "schema_name": GET_TABLE_NAMES.getColumnValue('SCHEMA_NAME'), "table_name": GET_TABLE_NAMES.getColumnValue('NAME')});

    var GET_ROW_COUNT = snowflake.createStatement({sqlText: `SELECT COUNT(*) FROM "${DATABASE_NAMES[i]}"."${GET_TABLE_NAMES.getColumnValue('SCHEMA_NAME')}"."${GET_TABLE_NAMES.getColumnValue('NAME')}"`}).execute();
    ROW_COUNT = GET_ROW_COUNT.next();
    if (ROW_COUNT === 0) {
        EMPTY_ROWS.push({"database_name": DATABASE_NAMES[i], "schema_name": GET_TABLE_NAMES.getColumnValue('SCHEMA_NAME'), "table_name": GET_TABLE_NAMES.getColumnValue('NAME')});
    }
}

}

// Output results if (EMPTY_ROWS.length > 0) { return Tables with empty rows: ${JSON.stringify(EMPTY_ROWS)}; } else { return No tables with empty rows found.; } $$;

在Snowflake中执行这个存储过程后，它将输出所有具有空行的表的名称。