Forum Discussion

AnmolGan81's avatar
AnmolGan81
Icon for Advocate II rankAdvocate II
1 year ago
Solved

Synapse Datawarehouse to Fabric Warehouse Data Load

We are trying to load data from synapse to fabric but getting one issue that is related to float data type that we have in target, during the load it is staging the data into one lake, and not able t...
data engineering
  • AnmolGan81's avatar
    AnmolGan81
    11 months ago

    Well we have tested this scenerio by creating tabular mapping and directly loading parquet file from data lake into the lakehouse using ADF and then moving that data into warehouse through stored procedure works; without any staging and it works, somehow staging in onelake does not allow us to move the data into warehouse.

    This will be an actual solution for the problemetic data types, or someone who is directly looking to copy data to test fabric warehouse/lakehouse performance and test one time migration.

AnmolGan81's avatar
AnmolGan81
Icon for Advocate II rankAdvocate II
1 year ago

we are not staging anything here, fabric automatically decides to use staging when loading data from synapse to warehouse, where can we specify it to use double please explain?

BalajiL's avatar
BalajiL
Icon for Resolver I rankResolver I
1 year ago

In your source query cast to double and try 

SELECT CAST(my_float_column AS double) AS my_float_column

  • AnmolGan81's avatar
    AnmolGan81
    Icon for Advocate II rankAdvocate II
    1 year ago

    double does not work for us we get incorrect sytanx error when passing it.

    • AntoineW's avatar
      AntoineW
      Icon for Super User rankSuper User
      1 year ago

      Hello,

       

      try this syntax : TRY_CAST(column_name AS DECIMAL(18,2) AS column_name