Hi, I’m joining data from Google Analytics 4 and Oracle. I’m attempting to pull the data from GA4 into Oracle using DB Writer, but it keeps telling me the data type is too small for one of the columns. The problem is that there is no data type definition and the mapping only maps by data type and has no way to define the string length. Seems like it should be straight forward based on the node description, but it doesn’t appear to pick up the data type from GA4 and create the table using the same data types. I tried creating the table first using db table creator, but then it won’t map an integer value to from GA4 to an int data type. [image] [image] [image] Maybe I should do the whole thing in python, but thought this would be faster.

DB Writer Caching Data Type

takbb October 16, 2023, 11:59pm 3

Hi @kevinnay , can you not put a Column Renamer or a Table Manipulator node between the Google Analytics Query and the DB Writer to rename the columns ?

Also yes the data type mapping isn’t perfect but does this post help at all?

1 Like