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

  • 20 March 2023
  • 1 reply

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 20 March 2023, 21:24

View original

1 reply

Userlevel 5
Badge +1



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.