I want to do this simple query to a REMOTE TABLE in GBQ, converting a string to decimal and filtering by timestamp:SELECT
ORDER_ID,
CAST(AMOUNT_STRING AS DECIMAL(18,2)) AS AMOUNT_DEC,
FROM <GBQ>
WHERE UPDATED_AT_TS > CAST('2024-01-01 00:00:00.000000...
In the Data Integration Monitor we can create statistics of the remote sources, but is there any way to see the results in DSP?I can't get access to the tables where the data is supposed to be stored.In "SYS". "DATA_STATISTICS" there are the fields t...
You are using DSP as a Data Fabric to load multiple data sources, and all works great, and you can enjoy life (you know, teleworking from some heavenly place) ... until something goes wrong. You receive an email that a Data Flow has failed. That SFTP...
Hello, I have a question about what happens when an error occurs during a data load in SAP Datasphere. If we use a data flow to perform a load to a DSP Local Table, do all the processed data operate within a database transaction, and if it fails, is ...
I have been contributing to the Datashpere community for a few years now. As one of the users of the first version od DSP, having participated in betas such as Data Flows, I have tried to help all those who had doubts about the product, and of course...
Hi esther598, Let me be frank, my question is very specific, how to access the data that creates the statistics, and these answers from ChatGPT, besides not answering my question, wastes our time.I hope that the community managers, do something about...
I answer myself.SYS.M_DATA_STATISTICS -> results are in a LargeString field, in json format.UPDATED: at least for Google Big Query data sources, the MAX VALUE and MIN VALUE statistics are wrong or I don't undestand the results MAX and MIN VALUES in ...
Hello, @kevin_yang @Sven_Knöpfler We opened an incident about REMOTE TABLES and GBQ, and the solution proposed is to update de GBQ Driver???To me this answer is very surprising.As far as I know, and as reflected in the SAP documentation, the ODBC dri...
Ok, then you must share the Currency Conversion Views (SAP.CURRENCY.VIEW.TCURV, ... TCURX,etc) used in the Currency Conversion function with the consumer space.This is share the views from PROPAGATION to REPORTING.Regards,
Yes to allow DSP (cloud) to access your SQL Server (on-prem) you need a "tunnel" to allow connection between both worlds. So you need SCC installed in a local server. It can be on the SQL Server, although I prefer to have it on another intermediate s...