I have a data model in snowflake that I am trying to import into GoodData. The tables have a few columns that have names like __companyId (two underscores in front of the word comapnyId)
When I try to import it in the UI I get a message “Connection failed. Unknown error” - but if I look in the logs I can see the error:
com.gooddata.tiger.metadata.service.ldm.model.GenerateLdmNamingException, message=Column name is not aligned with naming conventions name=__COMPANYID separator=__ numOfParts=2 expectedNumOfParts=3
I will rename the columns in my data so I can move on, but I would like to know why “__” is invalid in a column name. We use that type of column name quite a lot throughout our data to signify extra data that we added to our data model, so we would like to understand the reasoning behind that.
Best answer by jacekView original