I'm using GCP's dataprep to join several csv files with the same column structure, treat some data and then write to a BigQuery database.
I have to record this data in BigQuery. Can I include this data from the dataprep and append them in a BigQuery table?
Yes, you can include your data from DataPrep and append them in a BigQuery table.
Before running the job, in the "Run Job on DataFlow" section:
Now, when you run the Job, this will append your data.
The following documentation can be useful.