BigQuery fix cast issue in segment_web_page_views

[Klimmy]

Description & motivation

This solves the issue #18 (compatibility with BigQuery). I replaced cast with dbt.safe_cast macro for cross-database support.

Environment where it's been tested:

• Python==3.12.3
• dbt==1.7.14
• dbt-snowflake==1.7.3
• dbt-bigquery==1.7.8
• dbt-labs/dbt_utils==1.1.1

I tested it against Snowflake and BigQuery. I don't currently have access to Segment data, so I tested this specific line on non-segment data. The result is as expected, though — it generates a string column with 'segment_page_views_table' value.

Checklist

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

[Klimmy]

Hey @0adamjones, do you think you can review this one?

[Klimmy]

Hey folks, @jmhollinger, @lindseywatts, @blake-im-lyka, @robsberg, real sorry for bothering, but here is the small fix waiting for the review. It will make this package compatible with BigQuery. Could you help with reviewing it?

[0adamjones]

Hey @Klimmy so sorry! Didn't see this until just now. I'm going to review this now.

[AgustinBanchio]

Hi, has this been released into a new version? We are facing this same issue

[0adamjones]

@AgustinBanchio Hey there! Sorry for the trouble, I forgot to put out the new release. Check out 0.4.0!