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 GoodData11
AnalyticsDashboards and Reports149 Metrics and MAQL100
Data modeling & IntegrationData models35 Data sources66
Development & AdministrationGoodData.UI37 Administration82 Solution architecture13 SDKs and APIs28

Ask your question
Login

Community
Data modeling & Integration
Data sources

Data sources

Data sources

66 Topics
197 Replies

When you subscribe we will email you when there is a new topic in this category

66 Topics

Recently active

Most replies Most views Newest first

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

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.

Patrik BraborecCommunity Manager

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

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.

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.

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 TeamModerator

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?

LoganNew Participant

asked in Data sources

Best way to connect Notion to GoodData

Hi everyone, I love the Notion software and databasing tool. Does anyone have a good way to connect Notion and GoodData? Thanks in advanced for any guidance you can offer

giripurnamaNew Participant

asked in Data sources

Data load has been more than 1 hour

Hi, I want to ask for help with the problem of loading data, it's been more than 1 hour but the data is still running? may i ask you to check it? following ID my workspace:kg4pyyy9wyp6levdzrknvwef1ud0rif4PROCESS_ID = d90c146b-0ba3-4c09-b453-526193202263Request id: "data_load_jOWEXaRQXN_5msKfezQb1:iQu8MnjgLtJFWgQn:JXCGBvOCYh2xFIX8" Thank you

ofercNew Participant

asked in Data sources

Self-hosted solution for AWS ECS & MongoDB

Greetings, From the documentation I couldn’t understand if we are able to use GoodData self-hosted solution with compute in AWS ECS and storage in MongoDB.If it is possible I will be glad to get references to relevant documentation, otherwise to understand if there are plans to support it and ETAs Thanks,Ofer.

greglindstromNew Participant

asked in Data sources

BigQuery and loading data

We are new to GoodData and would like to use our connection to BigQuery tables as our data source. Will we still need to 'load' data into GoodData or can the data remain in BigQuery?

Robin BoltonNew Participant

asked in Data sources

Data in MongoDB

Hello, we store our data in MongoDB database which isn't part of supported sources.We can't replace the database for another, can you advise how else to upload data to GoodData platform?Thank you,Robin

sherryGoodData Employee

asked in Data sources

the analytics shows old data even after s3 connection was scheduled and ran successfully

I wonder if the mapping is incorrect, causing the dataset not to update. I’ve read the dataset mapping fields documentation but still unsure whether the dataset fields are correctly mappedworkspace id: trw9as5a7ve3ifxH\5tp6dbanxw17vlyrc

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.

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.

Roey SagieNew Participant

asked in Data sources

How do I use google bigquery table with LIST field (STRING REPEATED)

I tries to load data from Google Bigquery table:The process was failed and the log there is this error:com.google.cloud.bigquery.FieldValueList is in unnamed module of loader 'app'; java.lang.String is in module java.base of loader 'bootstrap'The bigquery table has a filed of type STRING REPEATEDSTRING REPEATED

Josh CollinsNew Participant

asked in Data sources

How fast does data typically transfer from BigQuery to GoodData?

While working through optimizing our data loads, I’m needing to confirm, generally speaking, how what transfer speed does GoodData see during data loads. Thanks!

Bálint BalinaNew Participant

asked in Data sources

Modeler schema size limit?

Hi,Our team is about to integrate gooddata platform into our application. I was trying to build a proof of concept project, but failed to scan the postgresql dataschema.The UI crashes immediately in chrome, with out of memory. In firefox it keeps running with around 9GB memory usage, but frozen even after 30 minutes. Is there a limitation to the number of tables in the schema? Our schema contains 300+ tables currently.Is this a bug, or am I doing something wrong? If so, please suggest me a work around.Steps:- run gooddata/gooddata-cn-ce:latest locally with docker- connect custom datasource via API (POST /api/entities/dataSources)- click connect data on workspace- after a few seconds the google chrome tab crashes with OOMIf I scan only the views, everything works fine. I tried to scan parts of the schema with different prefixes, but that did not load any tables, if I did specify any prefix.Regards,Bálint Balina

1
2
3

Page 1 / 3

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