search

fivetran / dbt_fivetran_utils

Helper utils for our packages
28 stars 18 forks source link

[FEATURE] - explore/keep eyes on BQ new JSON functions #111

Open fivetran-jamie opened 1 year ago

fivetran-jamie commented 1 year ago

BQ introduced a native JSON data type (ala variants in snowflake maybe?) and some new JSON parsing functions. the ones we leverage in this package are now "legacy" in the docs https://cloud.google.com/bigquery/docs/reference/standard-sql/json_functions

let's keep eyes on this to see if theres any sort of deprecation

fivetran-joemarkiewicz commented 6 months ago

This will become ever more important once the Fivetran connectors start supporting native JSON datatypes in the individual warehouses.