To GoodData homepage

Topics started by John Doe

3 Topics

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
J
3 years ago
J
John DoeNew Participant
asked in Data sources

Snowflake Data Load Erro "Mapping Validation Failed, See Log for More Details"

I’ve created a simple data table in Snowflake to test a single column import of data after successfully connecting the Data Model but still getting an error:2021-02-26T22:55:22.219+0100 [INFO]: Data distribution worker started 2021-02-26T22:55:22.219+0100 [INFO]: Request id: "data_load_1h4PkxFpZ8_RUH4bf9GoD:Q3tKkCkN9cVTUIzM:n31986nQVtgWoWAZ" 2021-02-26T22:55:22.219+0100 [INFO]: Data source: "603911cc1a4f3c4043bcd9f7" 2021-02-26T22:55:22.219+0100 [INFO]: Additional parameters: {GDC_DATALOAD_DATASETS=[{"dataset":"dataset.call_center","uploadMode":"FULL"}], PROCESS_ID=e7e79a92-fbb4-4101-81f2-e7a42ee9bad9} 2021-02-26T22:55:22.219+0100 [INFO]: Synchronization mode: selected datasets (default) 2021-02-26T22:55:22.433+0100 [INFO]: Synchronized datasets: [dataset.call_center] 2021-02-26T22:55:24.735+0100 [ERROR]: Mapping validation failed. 2021-02-26T22:55:24.736+0100 [INFO]: ====================== Mapping Validation ====================== The dataset dataset.call_center does not exist =======

1
Moises Morales
GoodData Employee
3 years ago
J
John DoeNew Participant
asked in Data sources

No Facts Or Dates for CSV Import

I’ve imported a CSV file with attributes, dates and numbers but GoodData is only recognizing attributes and not giving me the option to select some of those columns as numbers.I’ve tried it with various CSV imports but all of them continue to product the same results. Anyone experience that and found a fix?

3
Moises Morales
GoodData Employee
3 years ago
Welcome to the GoodData Community!Cookie settings