Skip to content

Improve TIMESTAMP_TZ support #1093

Closed
Closed
@rampage644

Description

@rampage644

Following query fails with 000200: DataFusion error: This feature is not implemented: Unsupported SQL type Custom(ObjectName([Identifier(Ident { value: "TIMESTAMP_TZ", quote_style: None, span: Span(Location(1,302)..Location(1,314)) })]), [])

create or replace transient table EMBUCKET.google_analytics_360.ga360_session_hit_custom_dimension_source
    

    
    as (WITH source AS (

	SELECT *
	FROM EMBUCKET.google_analytics_360_fivetran.session_hit_custom_dimension

), renamed AS (

    SELECT
      --Keys
      visit_id::FLOAT                              AS visit_id,
      visitor_id::VARCHAR                          AS visitor_id,

      --Info
      visit_start_time::TIMESTAMP_TZ               AS visit_start_time,
      hit_number::NUMBER                           AS hit_number,
      index::FLOAT                                 AS dimension_index,
      value::VARCHAR                               AS dimension_value,
      _fivetran_synced::TIMESTAMP_TZ               AS fivetran_synced

    FROM source

)



SELECT *
FROM renamed
    )
;

Metadata

Metadata

Labels

Type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions