nodes/generated

Interface SnowflakeNodeParameters

Source


interface SnowflakeNodeParameters {
    authentication?: "oAuth2" | "credentials";
    columns?: string;
    operation?: "update" | "insert" | "executeQuery";
    options?: { queryReplacement?: string };
    query?: string;
    table?: string;
    updateKey?: string;
}

Properties§

§readonly authentication?: "oAuth2" | "credentials"

Default: "credentials"

§readonly columns?: string

Comma-separated list of the properties which should used as columns for the new rows

§readonly operation?: "update" | "insert" | "executeQuery"

Default: "insert"

§readonly options?: { ... }

Default: {}

§readonly query?: string

The SQL query to execute. Use ? (bound in order) or :1, :2, :3 to refer to the 'Query Parameters' set in the options below. Type options: {"editor":"sqlEditor"}

§readonly table?: string

Name of the table in which to insert data to

§readonly updateKey?: string

Name of the property which decides which rows in the database should be updated. Normally that would be "id". Default: "id"