To GoodData homepage

Data sources

Data sources

  • 57 Topics
  • 178 Replies

57 Topics

F
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

2
F
2 years ago
itzzyaseen
itzzyaseenNew Participant
asked 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

6
Martin Burian
Community Manager
13 days ago
M
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?

1
Martin Burian
Community Manager
2 years ago
D
dasteinParticipating Frequently
asked in Data sources

Can't initialize BigQuery connection - "Headless Exception" error

We’re on the final steps of setting up GoodData.CN, using BigQuery as our data source.Everything has been going according to the documentation, up until the JDBC driver part. It does seem to load, but now we’re getting the following errors:when testing the connection via API:  { "error": "Could not initialize connection to data source; caused by java.sql.SQLException: [JDBC Driver]null; caused by java.awt.HeadlessException", "successful": false}   in the front end:  scan error={\"detail\":\"Could not initialize connection to data source with id = sandbox-analytics-01; caused by java.sql.SQLException: [JDBC Driver]null; caused by java.awt.HeadlessException\",\"status\":400,\"title\":\"Bad Request\",\"traceId\":\"c61e3d6f6bdc4b5c\"}"   and in the k8s pod:  {"ts":"2021-08-23 14:03:55.725","level":"ERROR","logger":"com.zaxxer.hikari.pool.HikariPool","thread":"DefaultDispatcher-worker-2","traceId":"1d81ad1e182ebdab","spanId":"e2268e780ca7b1da","userId":"admin","orgId":"syn","msg":"H

18
J
1 year ago
S
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

2
S
2 years ago
J
John DoeNew Participant
asked in Data sources

Snowflake "All Projects Failed to Load" Error

I’ve connected Snowflake’s test data to GoodData, added the model and tried to load the data but getting an error that says “All Projects Failed to Load” error everytime I try to upload the data. Here is the error code:2021-02-26T17:33:08.304+0100 [ERROR]: Fail to load projects "[clr5mf5skkcnvxg3nez8a5zevd9urahu]". Reason: Unable to unload: StatementCallback; bad SQL grammar [CREATE OR REPLACE STAGE STAGE__20210226__GhFKNxK2 COPY_OPTIONS = ( on_error='skip_file' )]; nested exception is net.snowflake.client.jdbc.SnowflakeSQLException: SQL execution error: Creating stage on shared database 'SNOWFLAKE_SAMPLE_DATA' is not allowed.: SQL execution error: Creating stage on shared database 'SNOWFLAKE_SAMPLE_DATA' is not allowed.2021-02-26T17:33:08.310+0100 [INFO]: ====================== End of downloading and integrating data ======================2021-02-26T17:33:08.311+0100 [ERROR]: Data distribution worker failed. Reason: All projects failed to load.Has anyone experienced that and w

3
A
2 years ago
R
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

2
Joseph Heun
GoodData Employee
9 months ago
R
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

1
Julius Kos
GoodData Employee
1 year ago
S
sethjbrParticipating Frequently
asked in Data sources

New Data button vs. Load Button

In the January 15th dashboard release, the “Load” button for the Good Data dashboard was changed to “Data” and now there isn’t any way to see my previous uploads from CSV to my dashboard and when I try using the new “Load” function, I get error messages that the data already exists and can’t be updated or replaced. It looks like I need to rebuild everything, including all my insights, from scratch to make this work again. Am I the only one here that was uploading from CSV files to the dashboard and having insights attached to those CSV uploads in the past but now have issues with uploading after the January 15th software release? Thanks,Seth

14
Andrey
GoodData Employee
2 years ago
C
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

1
Joseph Heun
GoodData Employee
2 years ago
S
Simone HaasNew Participant
asked in Data sources

Data location

In which region /data center are my data stored? 

2
Michael Ullock
GoodData Employee
2 years ago
T
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

2
T
2 years ago
J
JamesParticipating Frequently
asked in Data sources

Are there any plans to add integration to Amazon Timestream?

It’s only just been given general availability this week, but Amazon Timestream would be a great data source to be able to work with in GoodData. https://www.businesswire.com/news/home/20200930006011/en/AWS-Announces-General-Availability-of-Amazon-Timestream Is it likely that you’d add support in the Growth Plan for this?  

3
Pavel
2 years ago
M
Mia W.New Participant
asked in Data sources

Import data from Jira to GoodData

Is it possible to import data from Jira to GoodData?

2
Lukas Kouril
2 years ago
A
aleks2022New Participant
asked in Data sources

GD Cloud Native Docker - connectivity issue (timeout)

I installed Cloud Native GoodData, Community edition. I followed instructions from here: https://hub.docker.com/r/gooddata/gooddata-cn-ce/I am able to run the docker container and access the application. I was also able to add demo-ds datasource, scan it and create some model out of it.However, when I try to connect to either to an on premise Postgres database or a Snowflake instance, the connection to those datasources are always timing out. Any suggestions how to get around it?Thank you, Aleks

7
R
GoodData Employee
1 year ago
C
Cody PearceNew Participant
asked in Data sources

On-premise databases in Growth plan

What on-premise databases are we able to work with the Growth version?

3
Lukas Kouril
2 years ago
T
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

2
James Roettger
2 years ago
S
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
Zuzana Bednarova
GoodData Employee
2 years ago
J
JamesParticipating Frequently
asked in Data sources

Publishing Data Model: CSV Data Validation Failed

Hi I’ve imported a CSV, and the model looks right, but then I click on Publish I get a message saying Data Validation Failed. Is there anywhere that I can get more detailed messages for the failure? When I used the Load screen to load up the CSV I did get reasons as to why the publish would have failed, but it seems disjointed. I had hoped to deal with all my data work in the Data Integration Console, and not need to hop around so much ThanksJames ​​​​​​​

3
Joseph Heun
GoodData Employee
2 years ago
T
tibiNew Participant
asked in Data sources

GD.CN running the same, long running query in multiple parallel sessions

We have noticed that GD.CN initiates 20+ parallel sessions to Vertica, trying to return the entire dataset, while we are not actively running anything. As these sessions trying to return an entire dataset, they are running for hours.Does anybody nkow why is this happening and how to prevent it?

5
D
GoodData Employee
1 year ago
A
adhira93New Participant
asked in Data sources

IP white listing and finding what my data center is

I want to let GoodData pull data from our database but I don’t want to open the port to the entire world. I found this page about IP white listing but I’m not sure how to find out which set of IP addresses applies to me.According to the data centers documentation page, I should be using host on Mac to figure out “data colocation”. I’m using windows but I was able to find out that my GoodData hostname points to secure.gooddata.com (not secure-na3.na.gooddata.com or secure.eu.gooddata.com). Can you please confirm which data center it is?

1
Moises Morales
GoodData Employee
2 years ago
M
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?

1
Martin Burian
Community Manager
2 years ago
A
Ajeet RaiNew Participant
asked in Data sources

BigQuery : Data distribution worker failed. Reason: All projects failed to load.

I’m able to load small dataset from the Bigquery warehouse but getting this error for a larger dataset after 5 hours of data loading process. Please help. ====================== Downloading and integrating data ======================2021-06-11T22:00:52.703+0200 [ERROR]: Fail to load projects "[m96k12g0j5jvcn249c4ggj9h8gte2vla]". Reason: Error processing taskId=82223a5d660230b15f266f142fade45a005b5416d04e7842000000d5 status=ERROR messages=TaskMessages:{empty=false,messageBodies=[task exceeded maximum processing time],messages=[TaskMessage:{classValue=task.error.timeout,fromValue=gcfw,time=DateTime:{...}}]}2021-06-11T22:00:52.716+0200 [INFO]: ====================== End of downloading and integrating data ======================2021-06-11T22:00:52.719+0200 [ERROR]: Data distribution worker failed. Reason: All projects failed to load.

4
J
GoodData Employee
1 year ago
J
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.   

2
J
2 years ago
P
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?

1
Joseph Heun
GoodData Employee
2 years ago
Welcome to the GoodData Community!Cookie settings