Destination MSSSQL: Failure to Normalize

airbytehq / airbyte

The leading data integration platform for ETL / ELT data pipelines from APIs, databases & files to data warehouses, data lakes & data lakehouses. Both self-hosted and Cloud-hosted.

https://airbyte.com

Other

15.58k stars 4.01k forks source link

Destination MSSSQL: Failure to Normalize #24773

Open docelmo opened 1 year ago

docelmo commented 1 year ago

Environment

Airbyte version: .42
OS Version / Instance: AWS EC2
Deployment: docker
Source Connector and version:
Destination Connector and version: MSSQL Destination 0.1.22
Step where error happened: Normalization

Current Behavior

Tell us what happens.

MSSQL fails with NVARCHAR(MAX) not being able to be used.

Expected Behavior

Tell us what should happen.

Normalization completes.

Logs

Steps to Reproduce

Move data into MSSQL

docelmo commented 1 year ago

I worked with Marcos Marx on this issue. He helped me with a work around for now.