Transpose Tool In Db Keeps Giving 'Transpose Not Yet Implemented'

[sxa445]

I am trying to use the in_db transpose tool but I keep getting the error 'Transpose Not Yet Implemented' after I've completed all the configurations for it. 

[alexnajm · Accepted solution]

For production workflows, it is not an officially supported tool (that's why it is in the Laboratory tool palette) so I'd recommend streaming the data out and using a regular Transpose tool. You are likely getting errors because the database you are connecting to doesn't support that function.

[sxa445]

is there another way to transpose in db without the Transpose tool if my current Big Query database doesn't support it? 

[alexnajm]

No - if the database doesn't support it, the database can't do it. It's worth exploring your database's language to see if there's a way, but it says on the documentation that "Transpose In-DB supports only 64-bit SQL Server and Oracle data sources":  Transpose In-DB Tool

[sxa445]

Alright, thank you Castor! 

[apathetichell]

my recommendation would be to use connect-in-db (or preferably dynamic input in-db) and set up the transpose (unpivot) in your sql:

using the iris-data set:

SELECT * FROM `my_test_db.iris-data`

UNPIVOT(length FOR type IN (sepal_length, sepal_width, petal_length, petal_width));

would transpose your data with unlisted columns as key columns, sepal_length as the Value column and type as the Name column.