Issue with model stg_stripe__invoice_line_items build

[emilefyon]

Hello,

I have an issue when running the build of the model stg_stripe__invoice_line_items :

select
    _airbyte_invoice_line_items_hashid,
    {{ dbt_date.from_unixtimestamp('start') }} as period_start,
    {{ dbt_date.from_unixtimestamp(**'"end"'**) }} as period_end
from {{ var('invoice_line_items_period') }}

I receive the following issue:

No matching signature for function TIMESTAMP_SECONDS for argument types: STRING. Supported signature: TIMESTAMP_SECONDS(INT64) at [15:9]
compiled Code at target/run/airbyte_stripe/models/tmp/stg_stripe__invoice_line_items.sql

When changing the quote to those:

select
    _airbyte_invoice_line_items_hashid,
    {{ dbt_date.from_unixtimestamp('start') }} as period_start,
    {{ dbt_date.from_unixtimestamp(**'`end`'**) }} as period_end
from {{ var('invoice_line_items_period') }}

I then get the following issue:

No matching signature for function TIMESTAMP_SECONDS for argument types: FLOAT64. Supported signature: TIMESTAMP_SECONDS(INT64) at [15:9]
compiled Code at target/run/airbyte_stripe/models/tmp/stg_stripe__invoice_line_items.sql

The datatype in my schema are the following ones:

And I am using the standard Transformation in Airbyte with Normalized tabulart data

Any input would be great :-)

[emilefyon]

It does properly run when running this (I know it's super messy, just wanted to try):

init as (
    select
        _airbyte_invoice_line_items_hashid,
        start,
        cast(`end` as int64) as `end` 
    from {{ var('invoice_line_items_period') }}
),

invoice_line_items_period as (
    select
        _airbyte_invoice_line_items_hashid,
        {{ dbt_date.from_unixtimestamp('start') }} as period_start,
        {{ dbt_date.from_unixtimestamp('`end`') }} as period_end
    from init
),