Data modeling & Integration
Data modeling & Integration
Using Timestamps In GoodData
There’s great documentation around using dates, but does GoodData have any support for date_time types? This would be really useful for continued drill down beyond day level, into the hour/minute. This would be particularly useful dealing with a data set like IoT sensor readings.Has anyone any suggestions for workarounds, or am I missing something?Thanks James
Target model is invalid: A data set must have either a fact or an anchor with a label or a valid grain?
Hi, I’m running into a problem when trying to creating a simple data model. I have two entities named Comment and Tags and a mapping table with foreign keys comment_id and tag_id pointing to both tables.When I try to publish the data model, I’m getting an error message that says:“Target model is invalid, a dataset must have either a fact or an anchor with a label or a valid grain.” Can you tell me what am I doing wrong? Also, what is fact, anchor, label, and grain?Thanks!
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
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?
Already have an account? Login
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
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.