Forum Discussion
cjarvis
2 years agoFrequent Visitor
Can't refresh dataset with merged table from different data sources (incompatible credentials?)
I have a need to merge tables from two data warehouses. I load a table from Teradata into one (supported credential types: Database, Windows), and another table from Snowflake (supported credential t...
aj1973
Community Champion
2 years agoOk good I love testing.
Just one last try please. Format both columns of the 2 tables to Numbers and try again. Of course the merged Columns has to be Format Number as well.
cjarvis
2 years agoFrequent Visitor
The first few characters of the column are letters, so I needed to remove those before changing the data type - here is the example from the Teradata query.
The column in the merged query became a number by default. The same error resulted.