Skip to main content
Solved

How to write data from Multiple Snowflkae Tables to Multiple text files (separate file for each table) on Local Server?

  • March 20, 2023
  • 1 reply
  • 34 views
N
Fan

I have scenario to write data from multiple DB tables on daily basis to file server. Each table supposed  to generate separate file on Local Server

Best answer by Bikram

@Nilesh 

 

In Streamsets Data collector :

 

You can use multiple consumers processor to fetch data from multiple tables if the tables are under the one schema and add filer to send which table data to send to local server.

 

Below is the pipeline for your reference.

 

 

 

 

 

 

View original
Did this topic help you find an answer to your question?

Bikram
Headliner
Forum|alt.badge.img+1
  • BikramHeadliner
  • Headliner
  • March 20, 2023

@Nilesh 

 

In Streamsets Data collector :

 

You can use multiple consumers processor to fetch data from multiple tables if the tables are under the one schema and add filer to send which table data to send to local server.

 

Below is the pipeline for your reference.

 

 

 

 

 

 

1 Attachments

Reply


Terms & Conditions