Empty strings are treated as null when syncing from Snowflake to Postgres, causing failures on non-null constraints

[nicklausroach]

Issue Description

• Description of the issue: After upgrading to v1.2.14, our syncs from Snowflake to Postgres are failing. This seems to be due to empty strings in a field being treated as nulls, resulting in a failure when hitting our non-null constraints.

• Sling version (sling --version): 1.2.14

• Operating System (linux, mac, windows): linux

• Replication Configuration: Generated by custom Dagster resource

• Log Output (please run command with -d):

fatal:
~ Error executing: insert into "public"."usage_metrics_daily_jobs_aggregated" ("organization_id", "agent_type", "job_name", "repository_name", "job_day", "materializations", "step_duration_mins", "steps", "run_duration_mins", "runs", "steps_credits") select "organization_id", "agent_type", "job_name", "repository_name", "job_day"::date as "job_day", "materializations", "step_duration_mins", "steps", "run_duration_mins", "runs", "steps_credits" from "public"."usage_metrics_daily_jobs_aggregated_tmp"
pq: null value in column "repository_name" of relation "usage_metrics_daily_jobs_aggregated" violates not-null constraint

[flarco]

Thanks for reporting.

[flarco]

Should be good now with 9644af3
Closing.