Can I Configure the Connector to Sync Additional Metadata Columns?

Question

Can I configure my connector to include additional metadata columns for each file, such as a timestamp or the folder name?

Environment

Connector: SFTP

Answer

No, we don't support including metadata columns in your sync other than those we sync by default. However, there are two ways you can manually add these columns to your destination tables:

• Create a transformation that runs after each sync completes, adding additional columns and metadata to the applicable tables.
• Create a view that includes the columns we sync and the additional columns you want to include, then query the view after each sync to get the applicable data.