nodes/generated

Interface GoogleBigQueryV2NodeParameters

Source
interface GoogleBigQueryV2NodeParameters {
    authentication?: "oAuth2" | "serviceAccount";
    dataMode?: "define" | "autoMap";
    datasetId?: { mode: "id" | "list"; value: string };
    fieldsUi?: {
        values: { fieldId?: string; fieldValue?: string }[];
    };
    operation?: "executeQuery"
    | "insert";
    options?:
        | {
            defaultDataset?: string;
            dryRun?: boolean;
            includeSchema?: boolean;
            location?: string;
            maximumBytesBilled?: string;
            maxResults?: number;
            queryParameters?: {
                namedParameters: {
                    name?: string;
                    value?: string;
                }[];
            };
            rawOutput?: boolean;
            returnAsNumbers?: boolean;
            timeoutMs?: number;
            useLegacySql?: boolean;
        }
        | {
            batchSize?: number;
            ignoreUnknownValues?: boolean;
            skipInvalidRows?: boolean;
            templateSuffix?: string;
            traceId?: string;
        };
    projectId?: {
        mode: "id"
        | "list"
        | "url";
        value: string;
    };
    sqlQuery?: string;
    tableId?: { mode: "id"
    | "list"; value: string };
}

Properties§

Source§

readonly authentication?: "oAuth2" | "serviceAccount"

Default: "oAuth2"

Source§

readonly dataMode?: "define" | "autoMap"

Whether to insert the input data this node receives in the new row Default: "autoMap"

Source§

readonly datasetId?: { mode: "id" | "list"; value: string }

Default: {"mode":"list","value":""}

Source§

readonly fieldsUi?: { values: { fieldId?: string; fieldValue?: string }[] }

Default: {} Type options: {"multipleValueButtonText":"Add Field","multipleValues":true}

Source§

readonly operation?: "executeQuery" | "insert"

Default: "executeQuery"

Source§

readonly options?:
    | {
        defaultDataset?: string;
        dryRun?: boolean;
        includeSchema?: boolean;
        location?: string;
        maximumBytesBilled?: string;
        maxResults?: number;
        queryParameters?: {
            namedParameters: { name?: string; value?: string }[];
        };
        rawOutput?: boolean;
        returnAsNumbers?: boolean;
        timeoutMs?: number;
        useLegacySql?: boolean;
    }
    | {
        batchSize?: number;
        ignoreUnknownValues?: boolean;
        skipInvalidRows?: boolean;
        templateSuffix?: string;
        traceId?: string;
    }

Default: {}

Source§

readonly projectId?: { mode: "id" | "list" | "url"; value: string }

Projects to which you have been granted any project role Default: {"mode":"list","value":""}

Source§

readonly sqlQuery?: string

SQL query to execute, you can find more information here. Standard SQL syntax used by default, but you can also use Legacy SQL syntax by using optinon 'Use Legacy SQL'. Type options: {"editor":"sqlEditor"}

Source§

readonly tableId?: { mode: "id" | "list"; value: string }

Default: {"mode":"list","value":""}