Forum Discussion

trindadsth's avatar
trindadsth
New Member
26 days ago
Solved

publicly available data

I am taking a class on Fabric and we are copying publicly available data into our warehouse using the SQL endpoint. We are using these two tables. 'https://worldwideimp.blob.core.windows.net/sampl...
Warehouse
v-saisrao-msft's avatar
v-saisrao-msft
Community Support
21 days ago

Hi trindadsth,

Have you had a chance to review the solution shared by ShivekMaharaj? If the issue persists, feel free to reply so we can help further.

 

Thank you.

trindadsth's avatar
trindadsth
New Member
21 days ago

Yes, I tried that solution and it was still the low counts.  I finally found the new URLs for the data.  It actually was moved.  thanks

 

COPY INTO [dbo].[dimension_city] FROM 'https://fabrictutorialdata.blob.core.windows.net/sampledata/WideWorldImportersDW/parquet/full/dimension_city' WITH (FILE_TYPE = 'PARQUET');

 

COPY INTO [dbo].[fact_sale] FROM 'https://fabrictutorialdata.blob.core.windows.net/sampledata/WideWorldImportersDW/parquet/full/fact_sale' WITH (FILE_TYPE = 'PARQUET');

  • v-saisrao-msft's avatar
    v-saisrao-msft
    Community Support
    20 days ago

    HI trindadsth,

    Thanks for confirming. Glad you found the updated URLs and resolved the issue after the data was moved. The new COPY INTO paths should load the expected data correctly. So Accept your reply as the solution, as it will be helpful for other community members facing the same issue.

     

    Thank you.