transformations-cli with FDM

I tried that as well, but I still the same issue.

Can you give me the uuid string of the request Id?
Should be the one with xxxx in your error log.
I can try to see with auth team why that request is rejected

Hi,

Here is the request id : 099cefef-6bc9-98c0-8122-68076440353c

Hello Niranjan,
I created a working sample I hope helps. I created an FDM targeted transformation in Fusion (version as of the date I wrote this) and used the export CLI button in the upper right. This created the following manifest.  I updated authentication section with the credentials that are required when the transformation itself is going to run.  This auth

# Manifest file downloaded from fusion
externalId: tr-BSEEWell-Header-Asset-FDM-cli
name: BSEE Well Header Asset - FDM - CLI
query: >-
  select
    cast(`API_WELL_NUMBER` as STRING) as externalId,
    cast(`WELL_NAME` as STRING) as name,
    cast(`API_WELL_NUMBER` as STRING) as apiNumber
  from
    `bsee`.`well_header`;
destination:
  view:
    space: space-well-model-simple
    externalId: Well
    version: "1"
  instanceSpace: space-well-model-simple
  type: nodes
ignoreNullFields: true
shared: true
action: upsert
dataSetExternalId: ds-bsee

# this is authentication credentials for Fusion, not the transformation-cli
authentication:
  clientId: mycliendid
  clientSecret: myclientsecret
  tokenUrl: https://login.microsoftonline.com/mytenantid/oauth2/v2.0/token
  # Optional: If idP requires providing the scopes
  cdfProjectName: cdf_project
  scopes:
   - https://api.cognitedata.com/.default

Regarding cognite-transformation-cli itself:

• I”m using a virtual python environment (version 3.10.5)
• I ran pip install cognite-transformations-cli in the above environment and confirmed that the version (transformations-cli --version) of the cli is  2.3.3
• I sourced the following shell script my path:

  #!/bin/sh
  
  export TRANSFORMATIONS_CLIENT_ID=myclientid
  export TRANSFORMATIONS_CLIENT_SECRET=myclientsecret
  export TRANSFORMATIONS_TOKEN_URL=https://login.microsoftonline.com/mytentantid/oauth2/v2.0/token
  export TRANSFORMATIONS_PROJECT=mycdfproject
  export TRANSFORMATIONS_CLUSTER=api
  export TRANSFORMATIONS_SCOPES=https://api.cognitedata.com/.default

• Run env at the command line to ensure you have the correct environment variables set:
• Run transformations-cli list.  This will list all transformations in the target project and will confirm you are correctly authenticated.
• Lastly, run transformations-cli deploy ./my-transformations to deploy your transformations to CDF.  The my-transformation folder contains the .yaml file containing the manifest above.
• Confirm the transformation has been deployed to your CDF project.

Hope this helps!

Jason

Hi @Niranjan Madhukar Karvekar,

Please let us know if you are able to try out Jason’s solution and if you are able to solve the issue. 

Br,
Dilini 

Hi @Dilini Fernando

We have tried the steps mentioned in the Jason’s reply yet getting 401 error.

Sharing X-Request-ID for reference.
 

 Unauthorized | code: 401 | X-Request-ID: 2fc9c103-6de0-9ae2-bb38-f65110f66fed

Regards,

Sonali