I'm having some trouble figuring out the correct s...
# singer-targets
d
I'm having some trouble figuring out the correct syntax for a stream map within tap_snowflake. My understanding is that this should be supported within the meltanolabs variant since it's based on the SDK. I'm trying to rename a column. Here is my config:
Copy code
loaders:
    - 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
Copy code
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.
1
e
How about
FixedCouponPct: "record['Fixed Coupon(%)']"
?
d
That worked. I revisited documentation and realized it was mentioned under a different section here. I was just looking at this one.
Thanks, I was able to simplify the quotes. The result:
Copy code
FixedCouponPct: _['Fixed Coupon(%)']
            Fixed Coupon(%): __NULL__
🙌 1