Hi everyone! The problem I’m having i’m creating several staging tables after flattening them from a json format to a relational table format. now, say, i have in each table ~100 columns, some of them are strings and i’m converting instances where there is empty string to null. since the adapter.…

get_columns_in_relation macro but using CTE instead of a Relation object

scfrouws November 17, 2024, 7:02pm 2

You seem to have the same problem as this tread, I am trying to find a solution, although not very performant most likely. I will post it there.

Topic		Replies	Views
A partial workaround for dbt_utils.star not working with CTEs Show and Tell jinja , dbt-utils	0	10187	July 6, 2020
Using get_column_values with CTEs Help jinja , dbt-utils	2	22698	July 21, 2020
Macros: Obtain Column List for Non-Relation Output Help jinja	2	2683	November 20, 2024
adapter.get_columns_in_relation() returning a list of empty strings Help	0	454	July 10, 2024
Is there an equivalent of `get_columns_in_relation` that works is aware of evolving schema? Help	3	2355	June 26, 2024