To GoodData homepage

Topics started by Chanan

2 Topics

C
ChananParticipating Frequently
asked in Data sources

Why are column names with __ invalid?

Hello,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=3I 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.

4
jacek
GoodData Employee
2 years ago
C
ChananParticipating Frequently
asked in Data sources

Snowflake Datasource

I am trying to connect to snowflake.In snowflake I have a database called DATACLOUD. If I do describe warehouses I have only one called COMPUTE_WHSo I created a datasource with the following jdbcjdbc:snowflake://<my account info here>.snowflakecomputing.com/?warehouse=COMPUTE_WH&db=DATACLOUDBut when I hit scan it says: “There are no tables in the schema”I assume my jdbc url is wrong, but I have no idea what the issue is.

10
C
2 years ago
Welcome to the GoodData Community!Cookie settings