Things I've tried:
I have checked the pipeline's JSON and none of the columns have a space in them.
I added in the "physicalType: "UTF8" to the JSON as it was missing beforehand.
The schemas for the source dataset, sink dataset, and copy activity are all imported schemas - none of them are hardcoded.
I've tried unchecking and re-checking the "Enable Partition Discovery" on the Source dataset in the Copy Activity
Other things to note: the source is a blob container. The sink is a table in Azure SQL.
IMAGE 1: Error
IMAGE 2: Original Copy Activity Mapping
IMAGE 3: Updated Copy Activity Mapping after editing the JSON
IMAGE 4: Added physicalType to JSON
IMAGE 5: Source File Structure
I'm sure it's simple, but I've run into this error before and ended up dropping that column. But for this, I'd love to be able to keep the time_period column in this Copy Activity.
Thanks in advance!