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 sources

Data sources

Data sources

69 Topics
206 Replies

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

69 Topics

Most replies

Recently active Most views Newest first

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.

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?

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

Mia W.New Participant

asked in Data sources

Import data from Jira to GoodData

Is it possible to import data from Jira to GoodData?

FinnWNew Participant

asked in Data sources

Snowflake - getting "No active warehouse selected in the current session" error

Hello, I was trying to load my data to GoodData from Snowflake - created the connection, the model, but when trying to set the Automatic Data Distribution, I am getting following error: 2020-07-20T16:00:40.109+0200 [ERROR]: Fail to load projects "[puceqi1sg2z2cxcxsxs2k6brq5vn5uh3]". Reason: Unable to unload: PreparedStatementCallback; SQL [COPY INTO @STAGE__20200720__8pwvUFfC/out_customer__20200720__j7O2j5sS__ FROM (SELECT "a__country" AS "a__country","cp__customerid" AS "cp__customerid" FROM "out_customer") FILE_FORMAT=(type=CSV NULL_IF=('') FIELD_OPTIONALLY_ENCLOSED_BY='"' compression='GZIP') OVERWRITE=true HEADER=true MAX_FILE_SIZE=100000000]; No active warehouse selected in the current session. Select an active warehouse with the 'use warehouse' command.; nested exception is net.snowflake.client.jdbc.SnowflakeSQLException: No active warehouse selected in the current session. Select an active warehouse with the 'use warehouse' command.: No active warehouse selected in the c

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.

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.

Simone HaasNew Participant

asked in Data sources

Data location

In which region /data center are my data stored?

Sumit AgarwalNew Participant

asked in Data sources

Data loading from mysql

Need to load data from MySQL RDS. pls let me know how I can do that.

JamesParticipating Frequently

asked in Data sources

Are Geo Charts Available in the Free / Growth Version?

I have added geo data using the latitude;longitude format, but I don’t seem to be able to use it for a geo chart. Is this feature available in the free version? In the modeller I am only able to set the field as Text.

SimonbeeNew Participant

posted in Data sources

Loading Apache Spark CSV data from S3 with ADD

I’m just getting started with Gooddata and have successfully loaded CSV files from an S3 bucket with ADD, after a bit of fiddling to get my filenames matching my model name etc. (This article was very helpful, thanks!). I can see the data populating in my model and view it in a dashboard - so far, so good...However the data I really want to load is being written by Apache Spark (on AWS EMR) as a CSV file that is written in “append” mode, so the structure of the file in S3 looks like this:[aws-bucket] |- [analytivcs-data] |- hourly-data-dump.csv |- part-00000-00231726-b34a-454f-b534-bd9e492ab361-c000.csv |- part-00000-00a86ed4-a0b1-4c45-909c-49753c6ce877-c000.csv |- part-00000-00c9ebc7-550e-4632-b909-1aa88cd86b8e-c000.csv … There are potentially hundreds of the part-00000-xxx files written by Spark. I control the name of the “folder” hourly-data-dump.csv but not the files within

LenaKnown Participant

asked in Data sources

Data distribution worker failed. Reason: No suitable target projects found to load data.

Hi there,I’m facing an issue that “Data distribution worker failed. Reason: No suitable target projects found to load data.” in service workspace when loading data to all clients.Could you help me take a look? I have no idea on this. Thank you!

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

DonnieNew Participant

asked in Data sources

Debugging Big Query Integration

I’m trying to link Good Data with Google Big Query. I can connect to Big Query and create the LDM and publish, but when I try to load the data I’m seeing the following errors in the log during the “download and integrate” step:Project "xxx123" was not integrated Data distribution worker failed. Reason: All projects failed to load.I’m pretty sure I’m missing something silly.

Tom HarrisNew Participant

asked in Data sources

Getting data into GoodData from multiple applications

Hello. I am looking around to choose an analytic platform for our customers. The use case is that we have several applications from which we need to take data and use them to build the analytics for the customers. What capabilities GoodData platform has to get the data in? I do not have one data source, but we have several applications running on our servers and in public cloud. Thank you. Tom

Rick FlaggNew Participant

asked in Data sources

Best Practice For Importing Date FIelds

I’ve been working in GoodData setting up multiple insights and a KPI dashboard. I have a question about handling dates that I’ve not found an answer to.My data has an order completion date (ship date) that is either in the form MM/DD/YYYY or MMM YYYY (eg. FEB 2021) or YYYY/MM/DD. I have tried all three formats when importing the data. When I import the data, I have the attribute marked as text. I wish to produce a line chart based on month and year of the shipments showing the total value of the orders shipped. When I setup the insight, I get the dates in alphabetic sequence (Apr 18, Apr 19, Apr 20, Aug 18, Aug, 19, Aug 20 etc.). What do I need to do to get GoodData to see these values as dates and report by month?

Rick FlaggNew Participant

asked in Data sources

Reviewing Data After CSV Import

When importing data from a CSV file, there is a step to review the first 50 lines of the data file prior to uploading the full file. Is there a facility to review the “raw” data AFTER importing and without creating a new insight?

Tom HarrisNew Participant

asked in Data sources

LCM and ADD

Hello.I am trying to understand the concepts of Automated Data Distribution (ADD) and Life Cycle Management (LCM) and I am not quite sure if I understands them well. Could you elaborate on the features and how they cooperate, if at all?Thank you,Tom

Rick FlaggNew Participant

asked in Data sources

Creating a New Data Field

I have a workspace with several datasets; dataset 1 and dataset 2. each dataset has a dollar value fact that I’m plotting. I’d like to provide an insight that splits the sum of dataset 1 value and dataset 2 value. Is this possible in GoodData or does my model need to calculate the totals outside of GoodData and inport into another dataset?

haint73New Participant

asked in Data sources

How can i change data source with docker community edittion

I download and run docker run -i -t -p 3000:3000 -p 54320:5432 -v gd-volume:/data gooddata/gooddata-cn-ce:latest. But i can not change data source because i have no choice to select data source. Can you help me !

Mason PriceNew Participant

asked in Data sources

What is the private key in the BigQuery data source setting?

I was following your tutorial on how to connect to GoodData here: https://help.gooddata.com/doc/en/getting-started-with-gooddata/getting-started-with-bigquery-and-gooddata/load-sample-data-from-bigquery-into-gooddata and it just says to fill in the required fields, but I'm not sure what to put in the "Private key" field and where to obtain the key in general. Any advice, please?

Mason PriceNew Participant

asked in Data sources

SQL script for BigQuery output stage

Where am I supposed to put the SQL script to create an output stage when trying to connect GoodData to Google BigQuery?

Philip OwensNew Participant

asked in Data sources

More components in Data integration console?

When I want to deploy a new process in the Data integration console, the list box shows only one component called Automatic Data Distribution. How can I add more components?

Cody PearceNew Participant

asked in Data sources

Size of data - Snowflake vs Workspace

Hello. I would like to ask if we copy 1 GB of the data from Snowflake, Is it equivalent to 1GB in GoodData? Thank you. Cody

Simone HaasNew Participant

asked in Data sources

Data retention

One more question - if I delete the workspace and my data, is it permanently gone from your servers or do you keep some backup copies - and if so, for how long?

1
2
3

Page 2 / 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