Daniel Luo
08/27/2024, 8:40 PMloaders:
- name: target-snowflake
variant: meltanolabs
pip_url: meltanolabs-target-snowflake
config:
load_method: upsert
validate_records: true
stream_maps:
hist-SecurityReference:
FixedCouponPct: "Fixed Coupon(%)"
"Fixed Coupon(%)": __NULL__
The error that I'm getting is
singer_sdk.exceptions.MapExpressionError: Failed to parse expression Fixed Coupon(%). cmd_type=elb consumer=True job_name=default:tap-mssql-analytics-to-target-snowflake:hist-SecurityReference name=target-snowflake producer=False run_id=c0275c25-09cb-4da5-b4d6-549a1b7aebb3 stdio=stderr string_id=target-snowflake
I've tried using single quotes, and no quotes as well.Edgar Ramírez (Arch.dev)
08/28/2024, 1:13 AMFixedCouponPct: "record['Fixed Coupon(%)']"
?Daniel Luo
08/28/2024, 1:29 PMFixedCouponPct: _['Fixed Coupon(%)']
Fixed Coupon(%): __NULL__