Hubert-Dudek
Databricks MVP

You can specify the directory and select the files you want to import. Copy into is increment by default so it will append the data. Here is a code example:

COPY INTO table1 FROM 'folder location'
FILEFORMAT = CSV
FILES = ('1.csv', '2.csv')


My blog: https://databrickster.medium.com/