How can I configure an ETL action if the preview only returns the first 10K rows?

I'm trying to create my first ETL, and join two tables. However since the preview only returns the first 10k rows, it does not return any results.  That prevents me from continuing to define the subsequent ETL actions, since there is no data on which to execute those actions.

 

How do I proceed?

 

ETL Actions.pdf

Best Answer

  • CantStopTheHopp
    Accepted Answer

    Looks like you've got your "Join Data" and "Select Columns" actions reversed. You have to select columns from each of your input data sets first, then you can join them.