Snowflake Integration [GOT CREATED]

stutray · October 28, 2020, 9:51am

Hi all,

Are there any plans to add Snowflake integration?

Thanks

RicardoE105 · October 28, 2020, 5:59pm

@stutray Welcome to the community.

The more votes it has, the more chances of being created.

Can you please tell us what functionality you would require exactly? To be sure that if this node gets created, it does already what you need it to do.

stutray · October 29, 2020, 10:42am

Hi Ricardo,

Thanks for the reply.

It would be great to be able to connect to Snowflake and read data to push into MySql for example.

Snowflake has official drivers for odbc, jdbc, node, python, net and more.

Snowflake connections

stutray · December 1, 2020, 11:52am

Hi Ricarcdo,

Is there anything I can do to help get this created?

Many Thanks, Stu

RicardoE105 · December 3, 2020, 2:00am

@stutray working on this

stutray · December 3, 2020, 4:19pm

Thanks Ricardo, Happy to assist with testing if needed.

RicardoE105 · December 4, 2020, 3:47pm

Got created. Can you please test it and provide feedback. Thanks.

stutray · December 7, 2020, 2:28pm

Thanks for this. Looks like we’re missing the file Snowflake.node.js ?

RicardoE105 · December 7, 2020, 9:28pm

Not sure what you mean.

github.com

n8n-io/n8n/blob/98fb09eefb7a98081c7599b4d03e646970da9267/packages/nodes-base/nodes/Snowflake/Snowflake.node.ts

import { 
	IExecuteFunctions,
} from 'n8n-core';

import {
	IDataObject,
	INodeExecutionData,
	INodeType,
	INodeTypeDescription,
} from 'n8n-workflow';

import {
	connect,
	copyInputItems,
	destroy,
	execute,
} from './GenericFunctions';

import * as snowflake from 'snowflake-sdk';

This file has been truncated. show original

stutray · December 8, 2020, 8:44am

I got an error with unable to find Snowflake.node.js. Could you advise on the correct way to install this feature, I just copied the additional files but this doesn’t seem to work. Thanks

jan · December 8, 2020, 8:51am

n8n is written in TypeScript. So all files have to be build first. So to “generate” the Snowflake.node.js out of the Snowflake.node.ts you have to run npm run build in the packages/nodes-base folder.

stutray · December 8, 2020, 10:20am

Thanks for the heads-up but i’m still having issues. Error is “local package.json exists but node_modules missing”. I must be doing something wrong. Is it possible to provide a step-by-step ?

jan · December 10, 2020, 10:55am

Got released with [email protected]

So should now be easy to run.

stutray · December 15, 2020, 7:55am

Thanks for adding Snowflake and for pushing to 0.97.0.
All seems to work well and I shall continue testing.

victorpantoja · November 10, 2021, 2:00pm

Hi all!

Sorry to bringing back this old topic. I have just started to work with Snowflake and we need to simulate a webhook / trigger, that is, we need to be notified when new data comes. I know this is not possible as Snowflake doesn’t have such concept.

Do you have any suggestions?

Best,
Victor