How do I resolve a UnicodeDecodeError when using Sling?

[dagsir[bot]]

Hey there, i'm trying to use dagster-embeded-elt, but whenever I try to run the asset, I'm getting this error

source = SlingSourceConnection(
    type="sqlserver",
    host="host",
    port=1433,
    database="database",
    user="user",
    password=quote_plus('password'),
)

target = SlingTargetConnection(
    type="s3",
    bucket=os.getenv('S3_ENV'),
    access_key_id=os.getenv("S3_ENV"),
    secret_access_key=os.getenv("S3_ENV")
)
sling = SlingResource(source_connection=source, target_connection=target)

asset_def = build_sling_asset(
    asset_spec=AssetSpec("elt_dagster"),
    source_stream="TABLE",
    target_object="<s3://bucket/dagster-elt/table/>",
    target_options={'file_max_rows': 100000, 'format': "parquet"},
    mode=SlingMode.FULL_REFRESH
)

Am I doing anything wrong?

---

The question was originally asked in Dagster Slack.

[PedramNavid]

Hi!

Could you provide a few more details? This looks like an encoding issue.

What platform are you running on, e.g. Mac, Windows, Linux.
What version of Python are you using?
What language are you set to on your machine?

[IsmaelRDeMelo]

Windows
Python 3.9
pt-br

[PedramNavid]

Thanks @IsmaelRDeMelo! Should be fixed by this: #18055