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
Data modeling & Integration

Data modeling & Integration

Data modeling & Integration

104 Topics

Recently active

Most replies Most views Newest first

SuhadaFNew Participant

asked in Data sources

Gooddata with private RDS psql

Hi,I have a private RDS postgres DB that need to connect with good data. I got this link but it seems focused on Amazon Redshift data base. What is the procedure to enable private link for RDS databases?

CRowlettNew Participant

asked in Data sources

Workspace / User Data Filter Predicate Pushdown

Hi GoodData Community --With regard to Workspace / User Data Filters, it’s not clear to me where this filtering takes place. Are these predicates pushed down to the underlying data source or does the SQL execution engine perform this filtering after retrieval?

erik-planeraParticipating Frequently

asked in Data sources

Mongo in embedded analytics?

Hello, I see documentation indicating support for Mongo BI connector. However, I cannot see a way to add that as a data source. How can I configure it?This is specifically for embedded analytics.Thanks,Erik

davidhParticipating Frequently

asked in Data models

Display view

Hi,i am problem with display view from my DB.I configured data source and use non public schema (custom schema name)After connect over data connector to my DB (in Model) - returns back only tables no views. The user has set permission to select from views.If I try the same situation with just the public schema, I see tables and views.Isn't the problem that I have the view in a different schema than the public? Thank you for your answersBest regardsDavid Haškovec

giripurnamaNew Participant

asked in Data sources

How to get data from database Gooddata.CN

Hello,I want to ask about Gooddata CN. I have created goodata.CN and have connected to the database. But the data from the database is not retrieved. Thank You

kaviKnown Participant

asked in Data sources

Failures in CSV Downloader

Hi, After 5th of this month we have noticed schedules which are using XLSX format files as source are failing in CSV Downloader. Is this due to the release End of Life: CSV UploaderRef; https://support.gooddata.com/hc/en-us/articles/21503229759763-GoodData-Platform-October-5-2023 Thanks,Kavi

kaviKnown Participant

asked in Data models

Export the logical data model to PDF file

Hi, Is there a way to export the Export the logical data model to PDF file? If yes, can I know how? Thanks,Kavi

tomas.fraisNew Participant

asked in Data sources

GoodData Cloud - switching the identity provider to AWS Cognito - configuration protection

Hello, My organization has been using GoodData internal / dev identity provider, and we would like to switch to our new AWS Cognito identity provider. We are following the documentation here: https://www.gooddata.com/developers/cloud-native/doc/cloud/manage-organization/set-up-authentication/aws-cognito/ According to the section “Configure Cognito IdP in Organization” we executed the REST API PUT method to “ $HOST_URL/api/v1/entities/admin/organizations/$ORGANIZATION_ID”, however the response is: { "detail": "Can't proceed, OAuth configuration is protected against alteration in the organization.", "status": 409, "title": "Conflict", "traceId": "..."}Could you please advise how to lift this protection?Thank you.

Mark PetersonNew Participant

asked in Data models

Changing default date dimensions

Hi, just wondering what the best way of changing Date Dimensions to allow for different financial reporting periods in Australia. The default in GoodData uses Calendar Year Quarters for example. ie. Jan 2023 is Q1-2023, whereas for financial reporting purposes in Australia Jan 2023 is Q3-FY23. Aside from creating a completely new Date Dimension table, is there a way of working with the default.Thanks.

Patrik BraborecGoodData Employee

published in Data sources

How To Analyze CSV DataTutorial

If you have data in CSV format and want to analyze it, this short article provides a step-by-step guide on how to achieve such analytics.Check open-sourced repository gooddata-csv-analytics.PrerequisitesGoodData account (if you do not have one, you can register your free trial) Installed dbt Core (you can find installation guide in dbt documentation)Step 1: Add CSV to dbt seeds folderIf you use the open-source repository gooddata-csv-analytics, go to the import_csv folder, where you can place your CSV files.dbt comes with an inbuilt csv loader (seeds) to populate your data warehouse with any files you put inside of your project’s seeds folder.Step 2: Edit profiles.ymlThe profiles.yml must contain connection details for your data warehouse (i.e. PostgreSQL). You can find profiles.yml on the following path:$ ~/.dbt/profiles.ymlYou can open it with Visual Studio Code:$ code ~/.dbt/profiles.ymlNow, you can edit your connection details and save them:import_csv: outputs: prod: type:

DarinaNew Participant

asked in Data sources

Why did GoodData rearrange the columns in my .csv file?

Hi there! I’ve uploaded a .csv file to my workspace and when I wanted to update that file, I got an error. I downloaded the .csv template and it turns out that all the columns are now arranged in an alphabetical order.So if the columns in my original .csv were "p_id","j_id","a_at","l_at","l_type","s","last_l"the columns in the template are now "a_at","j_id","last_l","l_at","l_type","p_id","s" - i.e., ordered alphabetically.Is that the reason why I am getting the error “Load data from file failed. We could not read data from the file. Make sure that the data corresponds with the structure in the header, and try again.”? If so, how can I prevent/revert this?

kaviKnown Participant

asked in Data sources

When I'm trying to run the ADS Integrator I'm getting an error called Error Code: 404 Not Found

Hi,High PriorityWhen I'm trying to run the ADS Integrator I'm getting an error called Error Code: 404 Not Found.Can any one please help me out on this.Thanks,Kavi

Preetham ThangammaKnown Participant

asked in Data models

How to show only time in datetime in Good data

Hello,Please do let me know in the date time column named loss time in the attached image, how can i display only the time in Good data. Thank you

hankaKnown Participant

asked in Data models

Dates and time zones

Hello!I was reading docs regarding custom time zones as well as custom time dimensions, and I’m still not sure how to deal best with users different time zones and proper display of dates.Most of our users are in Pacific Standard Time zone, however, our data are stored in UTC format. Because by default there’s no support for timestamps, we’re sending only dates to GoodData. But this causes some dates are displayed differently in GoodData and in the main application. For example Apr 21, 2023 - 6:13pm Pacific time displayed in the app is already 22/04/2023 in GoodData (as it’s UTC).One solution I see is to normalize dates from UTC to timezone that should be used in a given workspace for data upload. That would work well if all workspace users were in the same time zone.Would there be any good solution that could work for a workspace that can be used by users in different time zones? So they could see base date displayed in their desired zone? I don’t see how custom time dimension could h

DarinaNew Participant

asked in Data sources

Permanently deleting the whole dataset

Hello! I need to permanently delete a dataset (a previously uploaded .csv file). How do I make that happen?Is the red "Delete" button in the "Manage" -> "Data Sets" -> <data set> section (see screenshot below) sufficient for this purpose? Or is there another way to do it?

jamesjenkinsKnown Participant

asked in Data sources

Connecting Google BigQuery Dataset to GoodData

I have created a dataset in BigQuery and am trying to work out how to connect this to a model in GoodData. I have authorised the correct permissions on service keys and connected them ok, however I keep getting the error “Refresh data source failed. Server-side problem. Contact Support” whenever I try to add the data source. Any help is appreciated.

hankaKnown Participant

asked in Data models

CSV data upload and big datasets

Hi,My workspaces are populated by ADD bricks that load CSV files stored on S3. As there’s a limit on headers amount in CSV files, which is 250, and not only dataset fields count but also relations to date and other datasets, or additional labels, how can I handle the situation where I’d need more fields? For example if I need a dataset “projects” that already has 200 fact fields, 40 relations to custom date fields, and I’d need to add additional 20 custom fact fields, is there some way to either use more than 1 CSV file to upload data for this dataset or split it to have 2 fact datasets, but use them as if they were one in the reports? Best,Hanna

umernasirrKnown Participant

asked in Data sources

There are no tables in the database while connecting to Snowflake DB

Hey GoodData team, I am trying to connect to snowflake from GoodData as a data source. I have successfully connected the two, but not getting any tables in our schema. What could be the problem here, I’ve tried the following Schema Names while connecting: `OP_DEV, PUBLIC, INFORMATION_SCHEMA, op_dev, public, information_schema ` All of them show the same error “There are no tables in the database”. Could you help me out on this, as we’ve been trying to get GoodData and snowflake running for a while now, thank you.

hankaKnown Participant

asked in Data models

LDM changelog/revisions

Hi!As our LDM is evolving, sometimes, especially in case any errors occur, it would be handy to see historical changes that were made in the model. Is it already available in any way? If not, are there any options that could help automating the process of building some kind of a changelog, like triggering some callback on release brick for example? Best,Hanna

hankaKnown Participant

asked in Data models

Custom date fields and performance

Hello,I want to give our customers a possibility to use custom date fields and as I know that date dimensions consume disk space and if there are too many of them it might have an impact on performance, I’d like to understand better the breadth of possible impact.In our product we have few segments that define basic LDM variations and inside them customer workspaces. Each customer can freely choose how many of available custom date fields they will use, not used will be hidden (marked as deprecated).Considering setup with segments A, B and C, each with a different amount of available custom date fields (let’s say 50, 100 and 150), and customer workspaces where in segment C there is client c1 using many of them and also loading bigger amounts of data, where performance issues can be visible? Will it be on c1 customer workspace only, or maybe on the whole segment, or actually on all segments, for the whole product? Best,Hanna

VirgilNew Participant

asked in Data sources

bigQuery multilevel data (json)

We connected to bigquery where we have the data imported following wayhttps://prnt.sc/bjL3_rN6kTLjactivityLevel 2 statusLevel 2 authorization_dateLevel 2 reception_dateLevel 2 received_dateLevel 2 controlled_dateLevel 2 refunded_datebut in gooddata we only see level 1 data such as activity which clearly is not working :))https://prnt.sc/IRbYP9g3PmBchow can we drill down?

Documentation TeamCommunity Manager

published in Data sources

Use AWS PrivateLink with GoodData Cloud

We are now able to set up AWS PrivateLink with GoodData Cloud. If you have an AWS account that runs an Amazon Redshift database, you can privately tunnel your data directly to your GoodData analytics.If you want to set up AWS PrivateLink with GoodData, you need to first set up a VPC Endpoint Service on your AWS account. Once you do that, you will get a “service name” that you can provide to us, so that we can finalize setting up your instance of GoodData Cloud to use the private link.This article describes how to set up the VPC Endpoint Service on your AWS account.You need to do the following two steps: Reach out to GoodData support, letting us know you want to set up PrivateLink.We will provide you with your GoodData account ID. You will need this ID for when you are setting up your VPC endpoint. Create a load balancer, see below. Create VPC endpoint service, see below. Pass the name of your VPC endpoint service to us, we will finalize setting up the AWS PrivateLink connection o

umernasirrKnown Participant

asked in Data sources

Issues with connecting to Snowflake DB

Hi GoodData, I are having issues with connecting our Gooddata with snowflake as a data source. Following is the error that pops up whenever I are trying to connect, the credentials are all correct I have verified it multiple times. If I change the credentials, it gives me an error about invalid url.Could you help us out on this issue? Thanks and Regards,Umer Nasir

itzzyaseenNew Participant

posted in Data sources

Failed to obtain JDBC Connection

Background task failed: Failed to obtain JDBC Connection; nested exception is java.sql.SQLException: Cannot create PoolableConnectionFactory (The TCP/IP connection to the host xxx.xx.xx.xx, port 1433 has failed. Error: "connect timed out. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.".): Cannot create PoolableConnectionFactory (The TCP/IP connection to the host xxx.xx.xx.xx, port 1433 has failed. Error: "connect timed out. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.".): The TCP/IP connection to the host xxx.xx.xx.xx, port 1433 has failed. Error: "connect timed out. Verify the connection properties. Make sure that an instance of SQL Server is runn

scott.jacobsenParticipating Frequently

asked in Data sources

Are materialized views supported on the cloud native platform?

I added some materialized views to my postgres database, but they are not available to my cloud native LDM. Are they supported?

1
2
3
4
5

Page 1 / 5

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