duckdb-async also works

import { Database } from "duckdb-async";

async function main() {
    try {
        // Initialize DuckDB with config
        console.log('Connecting to DuckDB...');
        const db = await Database.create('cache.db', {
            allow_unsigned_extensions: 'true'
        });
        
        // Create table if not exists
        console.log('Ensuring local table exists...');
        await db.exec(`
            CREATE TABLE IF NOT EXISTS metrics (
                task_name VARCHAR,
                task_idx BIGINT,
                task_config JSON,
                model_config JSON,
                compute_config VARCHAR,
                metrics JSON,
                run_date VARCHAR,
                num_instances BIGINT,
                processing_time DOUBLE,
                workspace VARCHAR,
                experiment_id VARCHAR,
                eval_sha VARCHAR,
                task_hash VARCHAR,
                model_hash VARCHAR
            );
        `);
        console.log('Table created successfully!');

        // Install and load bigquery extension
        console.log('Setting up bigquery extension...');
        await db.exec('INSTALL bigquery FROM community;');
        await db.exec('LOAD bigquery;');

        // Get total count first
        console.log('Counting total rows to copy...');
        const countResult = await db.all(`
            SELECT COUNT(*) as total_count 
            FROM bigquery_scan('testestes.deletable.model_evaluations');
        `);
        
        const total_to_copy = Number(countResult[0].total_count);
        console.log(`Found ${total_to_copy.toLocaleString()} rows to copy`);

        
    } catch (error) {
        console.error('Error:', error);
        process.exit(1);
    }
}

main();

Aborted (core dumped) with hafenkran/duckdb-bigquery with nodejs API #104

Description

Metadata

Assignees

Labels

Type

Projects

Milestone

Relationships

Development

Issue actions

Aborted (core dumped) with `hafenkran/duckdb-bigquery` with nodejs API #104