sasikanth
New Contributor
Joined 5 years ago
User Profile
User Widgets
Contributions
Re: Does Snowflake snappack 'Bulk Load' snap support ingesting data on to snow flake managed internal stage?
Hello, mbowen. Thank you for the reply. It is in line with my expectation. Let me prepare a sample data and update here. Earlier, Bulk load snap did not stage files. But it worked for loading data if it is already present in stage. the bulk load snap copied ( COPY INTO) data from internal named staging to snowflake table after I manually staged files ( manual PUT)2.1KViews0likes0CommentsDoes Snowflake snappack 'Bulk Load' snap support ingesting data on to snow flake managed internal stage?
Snowflake has three kinds of stages before loading data on to snowflake dbs. 1/ Supported cloud storage, 2 / Internal snowflake managed named stage 3/ default table/user stage Bulk Load Snap’s documentation says, it does support PUT command. However I found it hard to make the snap work. It is not clear, if the snap does both operations ( PUT first, and followed by COPY INTO) or the pipeline needs two Buld Load snaps in sequence ( PUT snap followed by a COPY INTO snap) The bulk load snap worked (COPY INTO ) if data is already placed in the internal stage. Pls let us know if there is a writer snap that does snowflake PUT operation on to snowflake internal stage.2.7KViews0likes3Comments