To GoodData homepage

Replies posted by Chanan

6 Replies

C
ChananParticipating Frequently
asked in Data sources

Why are column names with __ invalid?

No, the columns in question all start with __ - such as __COMPANYID

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

Snowflake Datasource

Thanks! Now I understand, schema in the body is instead of schema in the jdbc url. That worked.

10
C
2 years ago
C
ChananParticipating Frequently
asked in Data sources

Snowflake Datasource

I am not sure what you mean by change my schema to public (my tables are in public). The GoodData API does not allow using schema in the JDBC url. So how do I do that exactly?

10
C
2 years ago
C
ChananParticipating Frequently
asked in Data sources

Snowflake Datasource

Is this the info you are looking for? 

10
C
2 years ago
C
ChananParticipating Frequently
asked in Data sources

Snowflake Datasource

This is the API request i used to create the datasource:{      "data": {          "attributes": {              "name": "datacloud-ds",              "url": "jdbc:snowflake://<my account>.snowflakecomputing.com:443/?warehouse=COMPUTE_WH&db=DATACLOUD",              "schema": "datacloud",              "type": "SNOWFLAKE",              "username": "<my user>",              "password": "<my password>"          },          "id": "datacloud-ds",          "type": "dataSource"      }  }I am creating the above datasource in the api, then in the UI I click the scan button in the LDM screen. I know my account info and credentials are correct, because if I put wrong information in, I get an error back in the Gooddata UI when I hit scan. So, GoodData is connecting to my snowflake account. I have 3 tables in that account / database. I am able to see them in snowflake and query them to get data.

10
C
2 years ago
C
ChananParticipating Frequently
asked in Data sources

Snowflake Datasource

Hi,Looks like port 443 is the default so i didnt include. Just to be sure i did now, but it didnt help.Schema is not an allowed keyword according to Gooddata:{    "detail": "InvalidParameters: Invalid parameters keys: [schema]",    "status": 400,    "title": "Bad Request",    "traceId": "454e5db758b1e3b2"}

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