Redshift Fix for segment_web_page_views

fleetio / dbt-segment

Data models for Segment built using dbt (getdbt.com).

https://hub.getdbt.com/dbt-labs/segment/latest/

Apache License 2.0

10 stars 7 forks source link

Redshift Fix for segment_web_page_views #17

Closed lindseywatts closed 8 months ago

lindseywatts commented 8 months ago

Description & motivation

When running in Redshift, due to the hard-coded source_name column, "ERROR: failed to find conversion function from unknown to text" is thrown. When changing this column to be cast as text, the issue is resolved.

Checklist

[x] I have verified that these changes work locally
[x] I have updated the README.md (if applicable)
[x] I have added tests & descriptions to my models (and macros if applicable)

0adamjones commented 8 months ago

@lindseywatts Looks like you put selec instead of select in your edit, can you make 1 more commit to correct that?

lindseywatts commented 8 months ago

Hi @0adamjones, sorry about that. Corrected!

lindseywatts commented 8 months ago

Fun! Thanks @0adamjones. Any idea when your next release will be that will pull this in? Thanks again!

0adamjones commented 8 months ago

@lindseywatts Should be live now!

AgustinBanchio commented 7 months ago

Hi, I'm getting this error on BigQuery:

Could it be related to this latest addition?