/**
* Databricks Node - Version 1
* Discriminator: resource=databricksSql, operation=executeQuery
*/
interface Credentials {
databricksApi: CredentialReference;
databricksOAuth2Api: CredentialReference;
}
/** Execute SQL queries on data warehouses. Learn more. */
export type DatabricksV1DatabricksSqlExecuteQueryParams = {
resource: 'databricksSql';
operation: 'executeQuery';
authentication?: 'accessToken' | 'oAuth2' | Expression;
/**
* The SQL warehouse to use
* @default {"mode":"list","value":""}
*/
warehouseId?: { __rl: true; mode: 'list' | 'id' | 'url'; value: string; cachedResultName?: string };
/**
* SQL query to execute
*/
query?: string | Expression | PlaceholderValue;
/**
* Named parameters for the query. Reference them in your SQL as <code>:name</code>, e.g. <code>WHERE ID = :user_id</code>.
* @default {}
*/
queryParameters?: {
/** Parameter
*/
parameters?: Array<{
/** Parameter name, referenced in the query as :name
*/
name?: string | Expression | PlaceholderValue;
/** Value
*/
value?: string | Expression | PlaceholderValue;
/** Leave unset to treat the value as a string
*/
type?: '' | 'BOOLEAN' | 'DATE' | 'DOUBLE' | 'FLOAT' | 'INT' | 'LONG' | 'STRING' | 'TIMESTAMP' | Expression;
}>;
};
};
export type DatabricksV1DatabricksSqlExecuteQueryNode = {
type: 'n8n-nodes-base.databricks';
version: 1;
credentials?: Credentials;
config: NodeConfig;
};