Philip Asp
04/29/2024, 2:35 PMThe analytical objects cannot be deployed, because they contain errors. See the full list below.
[e] in ./analytics\datasets\F_INVOICES_V2.yaml 322:20
320| sources:
321| - source_column: CLIENT_ID
322| data_type: INT
323| target: D_CLIENTS.CLIENT_ID
324| - dataset: D_DEBTORS_SCD
Source column data type "INT" is not allowed here. Possible data types for use are "NUMERIC".
at C:\Users\PhilipAsp\dev_gd_master\analytics\datasets\F_INVOICES_V2.yaml:322:20
[e] in ./analytics\datasets\F_INVOICES_V2.yaml 373:16
371| - filter_id: wdf__client_id
372| source_column: CLIENT_ID
373| data_type: INT
374|
375|
Source column data type "INT" is not allowed here. Possible data types for use are "NUMERIC".
The thing is that we have the same reference in other datasets and it does not give the error for those datasets. The only difference I can find is that the dataset that throw the error is a SQL Query dataset.
I tried casting the CLIENT_ID field to INT, but that did not solve the issue.
sql: "select ADMIN_FEE_NET,\r
\ ADMIN_FEE_VAT,\r
\ CAST(CLIENT_ID AS INT) CLIENT_ID,\r
Any suggestions?Moises Morales
04/29/2024, 2:57 PM