IssueWhen connecting to Firebird using custom SQL, the following error might occur: "Firebird Database Error 335544396 "column is not defined in table"
ResolutionReview the fields that the custom SQL is bringing in to make sure any of them are not a BLOB field, or any other unsupported data types.If the field needs to be brought into Tableau Desktop: Adjust the custom SQL using a CAST() statement to change the BLOB into a string. From http://www.firebirdfaq.org/faq250/ : DECLARE VARIABLE c1 VARCHAR(32000); SELECT SUBSTRING(blob1 FROM 1 FOR 32000) FROM t1 INTO c1; Custom SQL is not typically something we can edit, and the format may change depending on the DB (if it is not Firebird) Change the BLOB into a string within the database itself.
CauseTableau Desktop has found an unsupported data type in the custom SQL and is unable to bring in data as a result.
Did this article resolve the issue? Thank you for providing your feedback on the effectiveness of the article. Click here to return to our Support page. Open new Case Open a new case Continue Searching Click here to go to our Support page. Knowledge Base Get detailed answers and how-to step-by-step instructions for your issues and technical questions. Community Find and share solutions with our active community through forums, user groups and ideas. Product Help Browse a complete list of product manuals and guides. Available online, offline and PDF formats. Training and Tutorials Learn how to master Tableau’s products with our on-demand, live or class room training.