Skip to content

[improve]: create_materialized_view_w_flattened_json_column: column duplication management #157

Open
@ArturoDiez

Description

@ArturoDiez

Check your idea has not already been reported

Edit function_name and the short idea description in title above

  • I wrote the correct function name and a short idea description in the title above

Tell us everything

I found great use to the create_materialized_view_w_flattened_json_column function, really straightforward and useful to manage JSONs in BQ.

I came with an issue tho, there were some table that I would have duplicated columns, because one column that was in the initial table was also at the first nest level of the JSON with the first name (generally the same data also, so deleting one of them was the objective). It would be really nice if there was any way to manage it, since managing the flattened_json_column function directly is kinda tricky.

Metadata

Metadata

Assignees

No one assigned

    Labels

    improve-bigfunctionSuggest an improvement for an existing BigFunction

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions