To GoodData homepage

Knowledge base
AnalyticsDashboards and Reports - KB articles8 Metrics and MAQL - KB articles23
Data modeling & IntegrationData models - KB articles9 Data sources - KB articles9
Development & AdministrationGoodData.UI - KB articles12 Administration - KB articles18 Solution architecture - KB articles8 SDKs and APIs - KB articles9
Community
WelcomeAbout GoodData13
AnalyticsDashboards and Reports161 Metrics and MAQL107
Data modeling & IntegrationData models35 Data sources69
Development & AdministrationGoodData.UI38 Administration86 Solution architecture13 SDKs and APIs28

Ask your question
Login

Community
Search

Replies posted by Jan Kos

44 Replies

Newest first

Oldest first

dluParticipating Frequently

asked in Administration

How to verify GoodData.CN installation on AWS EKS?

Hmm, without a valid license, I would rather expect a 403 response when calling the CN apis. Did creating a user went through fine with the call from the documentation?curl -H "Authorization: Bearer $BOOTSTRAP_API_TOKEN" \ -H "Content-type: application/json" -d '{"email": "boss@alpha.example.com", "password": "123456", "displayName": "John Doe"}' --request POST \ $HOST_URL/api/v1/auth/usersAnd did you received a valid response as indicated in the doc page? e.g.{ "email": "boss@alpha.example.com", "password": null, "displayName": "John Doe", "authenticationId": "CiQ0YWFiZmIzNy03MTNiLTQyNWYtODZhMy0yNmFlNmM1ZjYwNDMSBWxvY2Fs"}If the above went fine the next step is to map the user to the organization as outlined in the doc page earlier.It leads to https://www.gooddata.com/docs/cloud-native/3.3/manage-organization/set-up-authentication/#map-users-to-the-organization page and the value of authenticationId received is used to map the user to the organization."404 NOT_FOUND \"U

dluParticipating Frequently

asked in Administration

How to verify GoodData.CN installation on AWS EKS?

Hi,I located your messages, it was automatically marked as spam. I unmarked it and the messages appeared in the thread above.Thank you for the error message and logs. Are you using custom-snippet annotation somewhere? The error message:[ERROR ] name=xxx-yyy-org k8sType=organizations action=createOrg durationMillis=267 message=admission webhook "validate.nginx.ingress.kubernetes.io" denied the request: nginx.ingress.kubernetes.io/configuration-snippet annotation cannot be used. Snippet directives are disabled by the Ingress administrator state=error Means that creating ingress resource for organization could not be created because snippet annotations are not allowed by default. You can try to remove “nginx.ingress.kubernetes.io/configuration-snippet” annotation if you are using it somewhere or snippet annotations needs to be explicitly enabled in ingress nginx deployment e.g. by adding:values: controller: allowSnippetAnnotations: trueIf the suggestion doesn’t work would you m

dluParticipating Frequently

asked in Administration

How to verify GoodData.CN installation on AWS EKS?

Hi,I’m sorry, I was on vacation, let me review the provided details and I’ll get back to you as soon as possible.Jan

dluParticipating Frequently

asked in Administration

How to verify GoodData.CN installation on AWS EKS?

Hello,So far, I can’t tell if there is a problem with nginx ingress controller but after a quick review of details provided, I don’t see any significant issues. But it looks like the ingress resource for the new organization didn’t get created, thus the 404 response. The ingress resource should be automatically created together with creating a new organization. Could you please let me know what steps did you take to recreate the organization? Might be worth checking the organization controller pods logs if there are some details regarding org. creation.Could you also please provideyaml file with organization configuration used during creating the org? output from kubectl describe of the org.? customized values yaml file used for CN installation - https://www.gooddata.com/docs/cloud-native/3.3/deploy-and-install/cloud-native/helm-chart-installation/#HelmChartInstallation-PrepareCustomizedvaluesyamlforGoodDataCN (beware to omit any sensitive information)$BOOTSTRAP_API_TOKEN is a master t

dluParticipating Frequently

asked in Administration

How to verify GoodData.CN installation on AWS EKS?

Yes, DNS should be used when creating org. as it is the access point to CN application. When creating an organization, the organization controller will create the org itself and creating an org should as well create a corresponding ingress. Can you check if ingress corresponding to created organization is present? e.g. with kubectl get ingress -A

dluParticipating Frequently

asked in Administration

How to verify GoodData.CN installation on AWS EKS?

Unfortunately, we don’t have any tutorials on university about GoodData.CN backed management or installation. We have deployment architecture page to describe individual services a bit closer and the section about GoodData.CN you were already exploring.Checking GoodData specific pods in the kubernetes cluster wouldn’t differ from checking any other pods running in kubernetes. Widely used tool is kubectl and for example kubectl describe pod -n <namespace> <pod-name>would give you some pod’s status, events, errors within k8s infrastructure, or kubectl logs <pod-name>to get pod’s logs.Standard tools and commands for managing k8s cluster would apply.

dluParticipating Frequently

asked in Administration

How to verify GoodData.CN installation on AWS EKS?

HOSTNAME in your created organization (“x.y.example.com” in this case) needs to be a fully qualified hostname, it needs to be resolvable and accessed from the internet. It is the entry point where the whole CN application is available.The hostname should have DNS record pointing to public facing IPs of your load balancer serving as an entry point to the kubernetes cluster. You would need to decide how you’ll be handling DNS records - you either manage DNS manually completely on your side or you can manage DNS with “external-dns”. For example, internally we are using Route 53 service on AWS. Please review - https://www.gooddata.com/docs/cloud-native/3.3/deploy-and-install/cloud-native/considerations/dns-configuration/Together with is you’ll need to set up TLS configuration and certificates. Please refer to deployment considerations - especially “Domains and Certificates Management”, “TLS Configuration”, “Cert-manager Integration with Let's Encrypt” pages.However for a quick test and ver

dluParticipating Frequently

asked in Administration

How to verify GoodData.CN installation on AWS EKS?

Hello,GoodData CN.CE license works solely with the Container Edition of CN application - https://www.gooddata.com/docs/cloud-native/3.3/deploy-and-install/community-edition/. Running k8s/Helm version of CN application requires dedicated license. I’ve already highlighted your question to your Account Owner to discuss with you what are your options.In theory you should be able to install k8s application together with third party systems (Pulsar, Nginx). But without a valid license, API would throw errors. As you describing, assuming installing the GoodData.CN with helm went without errors? After the instalation, there should be various CN services pods running in gooddata-cn namespace. Are there any pods that are not up and running?Was there any errors during creating an organization? You can check if the organization is created by runningkubectl -n gooddata-cn get organd creating organization should as well create an ingress resource according to configuration.$HOST_URL should be the ho

scott.jacobsenParticipating Frequently

asked in SDKs and APIs

Does GD.CN support backchannel logout?

Hi Scott,Unfortunately Back-Channel Logout isn’t currently supported by GoodData Cloud. You can try to experiment with /logout endpoint.https://example.cloud.gooddata.com/logout But the logout endpoint resulting in redirection 302 status code currently configured to root GD Cloud root home URL.I will share your use case with our product team for consideration for future development.-Jan

davidhParticipating Frequently

asked in Data models

Display view

Hi David,I’m truly sorry, you followup question slipped under our radar.Displaying tables and views in LDM modeller shouldn’t be a problem as I didn’t have a problem during my testing. Have you tried setting up a new user with required permissions mentioned above and still unable to see the views?If you are still unable see the views after, can you please share what are the exact permissions applied to the user? Also what version is your Postgres DB on?Thank you.-Jan

hankaKnown Participant

asked in Data models

Custom date fields and performance

Hi Hanka,Every workspace, even if they are within the same segment works on top of a separate database on the backed. So for example if optimal performance on the c1 workspace would be affected because of many custom date fields and significant amount of data, performance of other customer workspaces wouldn’t be affected.-Jan

umernasirrKnown Participant

asked in Data sources

Issues with connecting to Snowflake DB

Hi Umer,I’ve adjusted the thread.The parameter can be set on session level, have you tried checking that?-Jan

umernasirrKnown Participant

asked in Data sources

Issues with connecting to Snowflake DB

Hi Umer,Thanks for the details. The issue is when GoodData is establishing connection to the datasource, a test functionality is triggered as one of the necessary steps that executes SELECT 'success' as "result"statement in datasource and instead of column name "result" the database returns "RESULT". This check is case sensitive and we are expecting "result" in lower case. I believe it comes from the fact that you have QUOTED_IDENTIFIERS_IGNORE_CASE parameter set to true on the account/database/user. You should be able to connect to the Snowflake if you disable the parameter. We are discussing internally how we’ll be handling case sensitivity when establishing connection to datasources.-Jan

umernasirrKnown Participant

asked in Data sources

Issues with connecting to Snowflake DB

This is certainly strange error. If you try to connect to the datasource from the Logical Data Model in Data section, do you still see the error? Can you give mi approx. timestamp (with timezone) when you tried to connect to the datasource and encountered the error? I will check our logs.Thanks.

umernasirrKnown Participant

asked in Data sources

Issues with connecting to Snowflake DB

Hi Umer,Can you please send us a trace ID of the error you are seeing from the browser dev tools?Thank you.Jan

davidhParticipating Frequently

asked in Data models

Display view

Hi David,I tried to connect to Postgres datasource with my custom schema and I can see views without an issues given that my user has usage granted on the schema.I would suggest you try to compare the permissions for your user on the public schema and on your custom schema to see where it differs. Also try to check permissions on the views within your custom schema for your user.-Jan

davidhParticipating Frequently

asked in Data models

Display view

Hi David,Have you specified the correct schema as pointed on step 5. in the mentioned doc page? If you have the correct schema specified on the datasource, can you please confirm if the user/role used on the user has especially those four access rights?GRANT CONNECT ON DATABASE {database_name} TO ROLE {role_name};GRANT USAGE ON SCHEMA {schema_name} TO ROLE {role_name};GRANT SELECT ON ALL TABLES IN SCHEMA {schema_name} TO ROLE {role_name};GRANT SELECT ON ALL VIEWS IN SCHEMA {schema_name} TO ROLE {role_name};Jan

romanzdkNew Participant

asked in Metrics and MAQL

GoodData - fixed value over time

Hi Roman,If the last value you mean MAX value you can use BY ALL IN ALL OTHER DIMENSIONS to lock the aggregation level. Metric could look like this SELECT MAX(Value) BY ALL IN ALL OTHER DIMENSIONS.-Jan

ofercNew Participant

asked in Data sources

Self-hosted solution for AWS ECS & MongoDB

To add a little context. You would be able to run GoodData.CN community edition on AWS ECS with some limitations (no multi tenancy, no high availability, etc.). Running production version of GoodData.CN relies on Kubernetes (K8S) API that is currently missing in ECS so you wouldn't be currently able to run Kubernetes-ready workload on ECS.- Jan

ofercNew Participant

asked in Data sources

Self-hosted solution for AWS ECS & MongoDB

Hi Ofer,Direct connection to MongoDB isn't currently supported in GoodData.CN. But you can make it work by connecting your MongoDB instance to one of our supported datasource managers (Apache Drill / Dreamio) and connect the datasource manager to GoodData.CN.https://www.gooddata.com/developers/cloud-native/doc/cloud/connect-data/data-source-managers/Deploying GoodData.CN on AWS ECS should be possible. However GoodData.CN is more suitable for AWS EKS deployment and for full production deployment AWS EKS is recommended. Fell free to check more details about deployment here:https://www.gooddata.com/developers/cloud-native/doc/cloud/deploy-and-install/cloud-native/environment/aws/Jan

jpavlikParticipating Frequently

asked in Administration

Federated authentication, institutional sign-in

Hi Jiri,That is something we would need to discuss internally. Can you please share with us more details why would you need GoodData to register in eduGAIN?Thank youJan

greglindstromNew Participant

asked in Data sources

BigQuery and loading data

Exactly, in case of GoodData.CN you simply connect to BigQuery datasource and GoodData.CN analytical engine queries data directly from your database and are not loaded into GoodData.Jan

greglindstromNew Participant

asked in Data sources

BigQuery and loading data

That would be GoodData platform. Connection to BigQuery can definitely be utilized and data are uploaded to the platform during data loading process.Jan

greglindstromNew Participant

asked in Data sources

BigQuery and loading data

Hello Greg,Which of our products are you using? Is it our GoodData platform? Or is it our GoodData Cloud Native solution?Jan

alejandro.riveraInspiring

asked in SDKs and APIs

Filter out future empty values

Hi Alejandro,There shouldn't be an issue with your metric. Empty value has its own object identifier and any additional empty values loaded will automatically be located under this object identifier, therefore it'll filter out future empty values - considering empty values are always uniform in your source data. For example:ID Gender 1 Male 2 Female 3 4 NULL In the above table a have basically two kind of empty values. The “blank field” and “NULL”. Both of these are “empty values” in GoodData but both would have its own identifier and would show as separate “empty value” in the metric editorIt is a best practise to stick to one type of NULL value in a source data.

1
2

Page 1 / 2

Powered by Gainsight

Welcome to the GoodData Community!Cookie settings

Sign up

Already have an account? Login

Social Login

or

Username (also your display name - please use John Doe rather than john.doe) *

E-mail address (if you already use GoodData, we encourage you to use the same e-mail address you use for the GoodData platform) *

Full Name

(Private)

Only you and moderators can see this information

*

Company

(Private)

Only you and moderators can see this information

*

I use the following GoodData products

(Private)

Only you and moderators can see this information

GoodData Platform GoodData Cloud GoodData.CN

Password *

I have read and agree to the GoodData Community and University Terms of Use and Privacy Policy.

loginBox.register.email_repeat

Login to the community

Sign in with your community account. This is different than your login to your GoodData account. Don't have a community login? Create an account

Social Login

or

Username or Email

Password

Remember me

Forgot password?

Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.

Username or e-mail

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

OK

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.

OK