search

snowplow / snowplow-rdb-loader

Stores Snowplow enriched events in Redshift, Snowflake and Databricks
Other
31 stars 17 forks source link

Fix pattern matching on known exception for alter table failures #1283

Closed istreeter closed 1 year ago

istreeter commented 1 year ago

We catch and ignore a particular exception here. But it 5.6.1 we changed slightly the exception message and now the pattern match stopped working. It caused a couple of loading errors like:

Load failed and will not be retried: [Amazon](500310) Invalid operation: cannot alter column "xyz" of relation "com_example_foo_2", target column size should be different; = SqlState: 0A000: [Amazon](500310) Invalid operation: cannot alter column "xyz" of relation "com_example_foo_2", target column size should be different;