SQL Transformations error. Please report this error to Cognite. Job id: 91084409-b4e9-4e7c-b872-d1d26dcc2459 (cogniteId: 43334402) SQL Transformations error. Please report this error to Cognite. Job id: 7b2d398b-4234-46a9-a377-95400ae3af48 (cogniteId: 43334400) SQL Transformations error. Please report this error to Cognite. Job id: ff2d0960-b2df-4031-a48a-d2bc4b03e3c5 (cogniteId: 43334372)
Invalid config: Wrong type for field "queries.destination" - got "{'database': 'xxxx:xx:xxxx:xx', 'table': 'xxxx'}" of type dict instead of RawDestinationConfig, EventsDestinationConfig, AssetsDestinationConfig, TimeseriesDestinationConfig, SequenceDestinationConfig, FilesDestinationConfig
(RAW Table : As above which has total 179 columns #41 contains numeric data 138 contains text data)I have ingested data in raw table….now I want to get only data of 41 columns which has number data type ?how this can be done in the transformation?similar query I want to run for remained 138 columns which has “Text” data type?
How to unpivot any existing raw table?I want to transpose columns to rowshere I am aware about stack can be used, but i dont want to give hard coded columns names... how this can be done run time (Without passing any hardcoded value of column name in stack command?)How to get run time columns count & how this columns can be passed in stack? Table1:id p1 p2 p3 1 2.0 3.0 4.0 2 10.0 15.0 20.0 select id, stack(3, 'p1', p1, 'p2', p2, 'p3', p3) as (property,value)from `db1`.`Table1`
Do we have any api in cognite which will help to show preview data of transformations?
Request with id 1912a13b-f4d1-9e0d-a7df-056276ca269e to https://westeurope-1.cognitedata.com/api/v1/projects/****/timeseries/data failed with status 400: Expected numeric value for data point.how to get to know that for which external id this error is shown?
Could you please suggest how to limit source?
I have also added limit parameter in sql query...some how limit parameter was not getting recognized
Incremental load version should be LongType or TimestampType. | code: 400 | X-Request-ID: XXXXXX
Does DB_extractor yaml config support execution of store procedures? If yes how to do that?
SHOW COLUMNS IN `RawDBName`.`RAWTablename`;its throwing an errorTable or view not found: `RawDBName`.`RAWTablename`; line 1 pos 16; 'ShowColumns [col_name#28876297]
Already have an account? Login
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.
Check the
documentation
Ask the
Community
Take a look
at
Academy
Cognite
Status
Page
Contact
Cognite Support
